Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please answer in excel format 3. Your parents have an investment portfolio of $900,000, and they wish to take out cash flows of $9,000 per
please answer in excel format
3. Your parents have an investment portfolio of $900,000, and they wish to take out cash flows of $9,000 per MONTH as an ordinary annuity. How long (in years) will their portfolio last if the portfolio is invested at an annual rate of 7.50%, APR? (10 points) 4. Which of the following choices will result in a greater future value at age 65? Choice number 1 is to invest $4,000 per year from ages 20 through 26 (a total of seven investments) into an account and then leave it untouched until you are 65 (another 39 years). Choice number 2 is to begin at age 27 and make $3,000 deposits into an investment account every year until you are 65 years old a total of 39 investments). Each account earns an average of 8% per year, APR. (The investments are end-of-year payments.) (10 points) Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started