Assignment: Net Present Value
Net present value (NPV) is used to determine the value of a project with future cash inflows or outflows and discount them to the present value. This is challenging because there are different ways to measure the value of future cash flows. A dollar earned in the future is worth different from one earned today. The discount rate in the NPV formula is a way to account for this. Companies have different ways of identifying the discount rate, although a common method is using the interest rate or the expected return of other investment choices with a similar level of risk.
In Excel, there are a few formulas for calculating net present values, each one with a little different twist to adjust for future payment patterns. Please review these formulas and use them in the assignment. One of the assignment questions will need a special feature in Excel, the Goal Seek feature that monitors the variable of interest so that the set goal can be reached. For example, Goal Seek is handy if someone wanted to know how much money he needs to save every year so that 30 years from now he can have $1 million retirement fund, assuming an average rate of return at 8%.
Please recreate the spreadsheet per the PDF file using the shell provided. Be sure to use formulas throughout and answer the questions with number and graphs. Excel has a function called pv (and its cousins npv, xnpv) that is ideal for finding the present values of the two lease options. Please peruse this function in recreating the spreadsheet. You also need to use the Goal Seek feature to find out which interest rate would make the two payment options equal. Having the difference of the two options calculated in C20 helps with this regard.
Attachment:- Assignment-Net-Present-Value.rar