You can solve for the discount rate in Excel in two ways: Find the IRR in Excel by employing the IRR function, then use it as the discount rate that causes NPV to equal zero. Use What-If analysis ...

In Excel, the function SYD depreciates an asset using this ... The DB function uses a fixed rate to calculate the depreciation values. In some cases, the salvage is difficult to reach using ...