Question: 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
please answer in excel format 3. Your parents have an investment portfolio

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!