Capital Budgeting Present Value Calculator

Equipment Information

Equipment Name

Equipment Cost

Equipment Modifications Cost

Equipment Installation Cost

Equipment Registration, permits and other Costs

Equipment Sales Tax Rate (%)

Equipment Life (years)

Expected Years of Use (years)

Expected Terminal Residual Value

First Year Operational Information

Direct Revenue

Operator Wages

Energy/Fuel Costs

Equipment Maintenance

Other Expenses

Corp Tax Rate (%)

Financial Information

Consumer Index Annual Increase Rate (%)

Discount Rate (%)

Example of making Google Sheet capital budgeting spreadsheet changes.

It will take about 4 seconds for the frame to refresh. If you reload the webpage the Google Sheet changes will show, but your form entries will revert back to the placeholder values.