Question: please use excel and show the formulas Instructions: set up an EXCEL worksheet to answer the following questions. You must show your formulas. No credit
Instructions: set up an EXCEL worksheet to answer the following questions. You must show your formulas. No credit if you just crunch out a final answer from your financial calculator. Submit your EXCEL file to Blackboard no later than 11:59 p.m. on 10/5/2021. 1. 2 How much will an investor have at the end of 5 years if s/he deposits $100 in a savings account that pays 3% interest, compounded annually? (4 points) What is the future value of $500 invested at 8% for three years? (4 points) Your rich uncle gives you $250 per year for the next five years, beginning one year from today. You wisely choose to invest this money, and expect to eam 6% annually on your investment. How much money do you have at the end of 5 years? (12 points) Continue from question 3: Use the same interest rate of 6%, calculate the present value of these five payments of $250 at time 0. (12 points) Here is the time line for cash flows mentioned in questions 3 and 4: 4. 0 2 $250 4 $250 S250 $250 $250
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
