Create a table in excel showing net present value calculation for the following scenario. You will have a column with time period, future value, and present value included. You can anticipate that there is a $10,000 investment that will occur today (time =0) that will cause a $2500 increase in profit annually for six years. Assume that there is a relative market interest rate of 10%.

Answer rating: 100% (QA)

Here is the Excel table with the Net Present Value calculatio... View the full answer