Question: PLEASE SOLVE THIS BY EXCEL AND PLEASE BE DETAILED. THANK YOU! Growing Annuity You are looking to retire in 30 years and want to have

PLEASE SOLVE THIS BY EXCEL AND PLEASE BE DETAILED. THANK YOU!

Growing Annuity You are looking to retire in 30 years and want to have $2.2 million saved for retirement. Since you are self-employed, you take one distribution per year, at the end of the year based on the net earnings of your company; and you are anticipating to earn $83,000 at the end of the current year. You are anticipating that you'll be able to take a 3% increase in distributions each year, and you have estimated that you can earn 9% of the money you invest, on average. If you save a constant percentage of your distributions, what percentage of your pay must you save each year

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!

The company founder hires us as consultants and asks that we oversee the accounting for new equipment purchased on January 1. The founder wants to know the implications of different depreciation...

this counts as one question. please help me. thank you! please help solve for a thumbs up. TY (Annuity payments) You plan to retire in 8 years and buy a house in Oviedo, Florida. The house you are...

You have recently been hired as a consultant for a personal financial planning firm.One of your first projects is creating a retirement plan for a young couple, Ben and Eileen Connelly.They have just...

Greetings, I am under the impression that the correct answer is B=($23,700). I was wondering if you may know how to solve via the Goal Seek Excel Function. Greatly Appreciated! You have recently been...

You have recently been hired as a consultant for a personal financial planning firm. One of your first projects is creating a retirement plan for a young couple, Mark and Leslie Carlysle. They have...

Can you please solve these on Excel and show me how you solved it. Thank you so much. 6) You would like to have $5 million dollars when you retire at age 65. You are 25 years old and you want to make...

Growing Annuity You are looking to retire in 3 0 years and want to have $ 2 . 2 5 million saved for retirement. Since you are self - employed, you take one distribution per year, at the end of the...

Please solve this using excel? (tree plan simple and revised) and show the steps In today's world, there is a growing need for new and innovative drugs, vaccines, biologicals, diagnostics and gene...

HomeSuites is a chain of all-suite, extended-stay hotel properties. The chain has 20 properties with an average of 150 rooms in each property. In year 1, the occupancy rate (the number of rooms...

Explain the organizational archetypes as described by Mintzberg and discuss how organizational structure influences innovation. Summarize Mintzberg's work with archetypes. What key features and...

Interest income is taxable to the bank, with the exception of interest on Blank _ _ _ _ _ _ and tax - exempt income from Blank _ _ _ _ _ _ . Multiple choice question. municipal securities; direct...

Draw a class diagram and its relationship based on the following statements. You can use any UML tool/software to represent your class diagram. Do NOT copy and paste your diagram, use the attachment...