Question: FV stands for future value using excel 2. Invest donations in different installments over 12 years First method: Future Value Years 1-6 Future Value Year
FV stands for future value
using excel

2. Invest donations in different installments over 12 years First method: Future Value Years 1-6 Future Value Year 12 Amount 3.0146% (note: "Year 0" = today) EAR of chosen CD in exercise 1 Lump sum donation in Year 0 Annuity donation in Years 1-6 Annuity donation in Years 7-12 Total FV of all donations in year 12 $250,000 $75,000 $150,000 $0 Second method: Same Answer Year Donation Amount 0 $250,000 1 $75,000 2 $75,000 3 $75,000 4 $75,000 5 $75,000 6 $75,000 7 $150,000 8 $150,000 9 $150,000 10 $150,000 11 $150,000 12 $150,000 NPV of cash flows FV of NPV in 12 yrs (hint remember not to include year in the NPV but add it to the NPV of years 1-12)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
