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
 |
Investment |
|
Tax
rate (%) |
|
Current
Book value |
|
MARR
(%) |
|
Holding
period of the asset—(example 7 years) |
|
Expected
annual O&M costs over the holding period. |
|
Annual
depreciation amounts over the holding period |
|
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.