Question: how much does she need to save if she puts money away monthly and equal end of the month amounts to achieve a future value

how much does she need to save if she puts money away monthly and equal end of the month amounts to achieve a future value of $1.5 million in 30 years time (please show how i could enter in excel if possible) thank you!

2. Assume that Donna is 35 years old and has 30 years for saving until she retires. She expects an APR of 12% on her investments. How much does she need to save if she puts money away Monthly in equal end-of-the-month amounts to achieve a future value of 1.5 million dollars in 30 years' time? (5 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!

Assume that Don is 4 5 years old and has 2 0 years for saving until he retires. He expects an APR of 8 . 5 % on his investments. How much does he need to save if he puts money away annually in equal...

USE excel functions of (PV,FV,RATE,PMT,ETC) for these questions and also show the formula used. Q1. Fluttering Duck Caf Inc. just issued zero-coupon bonds with a par value of $1,000. If the bond has...

Categories of bonds classified by issuer could include municipal stocks, Treasury bonds, and foreign bonds. True False Simpson Construction had sales eight years ago of $2,150,000. This year their...

Five years ago Acme, Inc. issued 15 year 10.40% coupon bonds with a $1,000 face value each. Since then interest rates have risen and the yield to maturity on the Acme bonds is now 11.56%. Given this...

Question 9 (3 points) Assume that Ray is 20 years old and has 45 years for saving until he retires. He expects an APR of 6% on his investments. How much does he need to save if he puts money away...

Assume that Ray is 2 7 years old and has 4 2 years for saving until he retires. He expects an APR of 6 . 2 % on his investments. How much does he need to save if he puts money away monthly in equal...

Assume that Don is 45 years old. He expects an APR of 7.7% on his investments. How much does he need to save if he puts money away annually in equal end-of- the-year amounts to achieve a future value...

Please Solve in Excel Assume that Ray is 38 years old and has 27 years for saving until he retires. He expects an APR of 7.5% on his investments. How much does he need to save if he puts money away...

please answer quick. i will upvote Fufure value with periodie rafes. Denise has her heart set on being a millionaire. She decides that at the end of every year, she will put away 34,000 into her "i...

a. How many years must Denise faithfully put away her money to succeed at becoming a millionaire? b. If Denise switches to a monthly savings plan and puts one-twelfth of the $4,000 away each month (...

Prepare a Trial balance in good order from the following ledger balances: 1 Room revenue 2 Food revenue 3 4 Cash Beverage revenue 5 Accounts receivable 6 Prepaid expenses 7 Accounts payable 8 Land 9...

Some marketers feel that the hierarchy of effects models may no longer reflect the characteristics of the consumer decision-making process. Discuss the pros and cons of these arguments.

17. Since the passage of NAFTA our trade defi cit with Mexico has gone and our trade defi cit with Canada has gone . (LO6) a) up, up c) up, down b) down, down d) down, up

P-1) (100 Pts.) A chemical manufacturing company (CMC) has a contract for the procurement of the neccssaly chemicals from four suppliers. The chemicals purchased from Supplier A are priced at $20...

6. Identify seven types of hidden histories.

10. Describe a dialectic perspective in negotiating personal histories.

What is the relationship between humans and nature?