A. You have been offered an investment that will pay you 9% per year. If you invest $15,000, how long until you have $45,000?
B. Which do you prefer, $5,500 cash now OR $1,200 each year for 5 years? Assume a discount rate of 10%.
Note: For part B please solve using Excel and show all steps and formulas used.