Question: Excel Assignment #2, This front page shows the questions. Type your answers on the Answer Sheet of your Excel file. The instructions to complete the
Excel Assignment #2, This front page shows the questions. Type your answers on the Answer Sheet of your Excel file. The instructions to complete the assignment are on pages 2-5 below. Problem #1: Using the appropriate data table one-variable for part a, and two-variable for part b, answer the questions. a. From your one-way table, at what monthly deposit does the "No-investment "retirement amount become greater than $170,000? __________ b. What is your investment retirement account value if your monthly deposit= $550 and Rate of Return = 5.5%? _____________ c. Assuming your rate of return is 5.0%, what is the lowest monthly payment that would ensure you retire with over $850,000? __________ d. If your number of years until retirement increases to 55 and the rate of return drops down to 3.5%, what monthly deposit would you need to have enough for your $2.7M vacation home? ______________
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
