Question: Solve the following A,B,C,D by using Excel formula. Show me your data and interpret your answer a. Harry has just bought a lucky ticket and
Solve the following A,B,C,D by using Excel formula. Show me your data and interpret your answer
a. Harry has just bought a lucky ticket and won $10,000. He wants to finance the future study of his newly born daughter and invests this money in a fund with a maturity of 18 years offering a promising yearly return of 6%. What is the amount available on the 18th birthday of his daughter? 2 point
B. The National Savings Fund promises a monthly interest rate equal to 0.75% return if you deposit 100 per month for 15 consecutive years. What amount will be accumulated after those 15 years? 1.5 point

d. The National Savings Fund promises a monthly interest rate equal to 0.75% return if you deposit 100 per month for 15 consecutive years. What amount will be accumulated after those 15 years? 1.5 point
C. Find the present value of the following cash flow streams at 8% compounded annually. 0 1 2 3 4 5 5 $0 $100 $400 $400 $400 $300
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
