How to do discount rate in excel

Author: mujuj On: 06-Dec-2017
Choice of Discount Rate - Mit

Choice of Discount Rate - Mit

Case with nominal cash flows and using a nominal discount rate. Because the bed cost increases with inflation, you do not pocket inflation as an additional. Launch the Microsoft Excel application. Choose an annual discount rate for your series of cash flows before. Net present value is calculated using a discount rate which may represent an. initial investment from the NPV calculation in Excel by calculating the NPV of.

Present and Future Value Using Excel
Present and Future Value Using Excel

For example, if you get a four-year car loan and make monthly payments, your loan has 4*12 or 48. Rate is the rate of discount over the length of one period. The formula for calculating the discount factor in Excel is the same as the Net Present Value NPV. Factor = 1 / 1 x 1 + Discount Rate ^ Period Number.

How to do discount rate in excel
Rating 4,8 stars - 826 reviews