You need to create an excel spreadsheet that answers the following questions. Where stated, make sure you solve the problem “by hand”, i.e. discounting each cash flow, and also using TVM formulas from Excel. All work should be presented in three sheets/tabs (not files). Your sheets should be labeled. Questions 1-4 are in the first tab, questions 5-6 are in the second tab, and question 7 is in a third tab. In all cases, presentation matters!!! Make these professional. Also, all work should be set up in such a way that you could change one parameter and have the formula automatically update, i.e. you need an assumptions section. In other words, you would want to be able to do a basic type of “what-if” analysis. Hard-coding values is bad, formulas are good.

1. Find the FV of $10,000 33 years in the future if the opportunity cost rate is 8% (use Excel formulas and basic PV/FV techniques).

2. Find the PV of $1,000,000 to be delivered in 16 years if the opportunity cost rate is 7% (use Excel formulas and basic PV/FV techniques).

3. Would you prefer the following (you can use just formulas for this problem):

1. An ordinary annuity where you receive $500 each year for 20 years if the opportunity cost is 6%
2. An annuity due where you receive $480 each year for 20 years if the opportunity cost rate is 5.9%

4. What is the net present value of the following stream of cash flows assuming the opportunity cost rate is 12%? Solve NPV using each cash flow and the NPV function in Excel (use Excel formulas and basic PV/FV techniques).

Year 0:           -$10,000

Year 1:            $4,000

Year 2:            -$2,000

Year 3:            $5,000

Year 4:            $3,000

Year 5:            $6,000

Answer rating: 100% (QA)

FV of 10000 33 years in the future if the opportunity co... View the full answer