Spreadsheet Compound Interest and Depreciation Modeling
A company uses a spreadsheet to calculate both compound interest on its investment and depreciation of its equipment. The spreadsheet uses the following formulas: – For compound interest: Future Value = Present Value \(\times\) \((1 + \text{rate})^n\). – For straight-line depreciation: Book Value = Initial Cost – \(n \times \frac{\text{Initial Cost} – \text{Salvage Value}}{\text{Lifespan}}\). Consider […]