Question: Please use excel formula to answer the questions. I will give up after You want to be a millionaire when you retire in 40 years.

Please use excel formula to answer the questions. I will give up after

You want to be a millionaire when you retire in 40 years. How much do you have to save each month if you can earn an annual return of 10.5 percent? How much do you have to save each month if you wait 10 years before you begin your deposits? 20 years? $ Amount needed Years to save Months per year APR Years to wait before beginning Years to wait before beginning Years to wait before beginning 1,000,000 40 12 10.5% 10 20 Complete the following analysis. Do not hard code values in your calculations. All answers should be positive. Monthly deposit if you begin today $ 135.70 Monthly deposit if you wait 10 years Monthly deposit if you wait 20 years

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 Finance Questions!

Please use excel formula as answer. en Number Cells COMuitional Format as Cell Formatting Table Styles Styles Clipboard Editing Font A1 E F G H If you deposit $4,000 at the end of each of the next 20...

^^^ HELP PLEASE \fEXERCISE 4.36. In Example 4.20, use Eq. 4.16 to verify that the fake spheres with a = 2 and a = , have no umbilical points. (4.16) T. EXAMPLE 4.20 (Fake Spheres). We wish to...

>> solve the following please Suppose that you will receive annual payments of $11,000 for a period of 10 years. The first payment will be made 5 years from now. If the interest rate is 5%, what is...

3. You want to retire 40 years from now. You estimate that you will need 2.5 million in order to fund your retirement years. a. If you can earn 5% per year, how much do you need to set aside today in...

Mortgage Analysis You are planning to purchase a house that costs $480,000. You plan to put 20% down and borrow the remainder. Based on your credit score, you believe that you will pay 3.99% on a...

Can someone show me the correct excel formula to answer these questions? 12. Your aunt is about to retire, and she wants to sell some of her stock and buy an annuity that will provide her with income...

Please answer with excel showing how to use excel functions to answer these questions, thank you! a. A firm's dividend per share grew from $1.00 to $1.25 in four years. What was its annual growth...

please use excel functions to solve this question. Problem 5-41 Retirement Savings (L03) A couple will retire in 40 years; they plan to spend about $29,000 a year in retirement, which should last...

ANNUITIES Please use Excel function to answer the following: 1. Suppose you are buying a car with the following information car price: $32,000 Number of monthly payments 48 APR: 6.00% What is the...

Please use excel formula Both Bond Sam and Bond Dave have 6.5 percent coupons, make semiannual payments, and are priced at par value. Bond Sam has 3 years to maturity, whereas Bond Dave has 20 years...

A Verilog testbench code is necessary to test the functionality of the design. Select one: O True O False

Suppose the population defective rate of one product is 2%. Given the product is defective, the quality testing department will have probability 0.98 to label it as defective; for non-defective...

welcome and purpose of presenation the basic of personal finance

On 1 March 2007 DB Limited issued R560 000 15% debentures at R98. The debentures were to be redeemed at par in four equal annual payments starting 28 February 2010. Required: Journalise the above...