Calculating an Economic Service Life
(Problem Description)

To illustrate the approach to develop a Web-based program to create an Excel file, we followed an example[1] to generate a two-part worksheet. The first one is the after-tax salvage value generation, and the second one is the economic service life calculation on after-tax basis. Once again, our objective is to generate an Excel table. The required input data set would be

bullet

Investment

bullet

Tax rate (%)

bullet

Current Book value

bullet

MARR (%)

bullet

Holding period of the assetó(example 7 years)

bullet

Expected annual O&M costs over the holding period.

bullet

Annual depreciation amounts over the holding period

bullet

Expected market (salvage) value of the asset over the holding period.


Step1: Installation of the VB runtime and OLE automation via a link to an MS Web site for download

Step2: Registration of the ActiveX document server on the userís PC, and

Step3: Creation of an actual link to the .vbd file.

Copyright © 2003, Jai Kang