Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please can someone show me the excel and formulas for this problem? Thank you. 5. Tim is 40 years old and would like to establish

Please can someone show me the excel and formulas for this problem? Thank you.

image text in transcribed

5. Tim is 40 years old and would like to establish a retirement plan. Develop a spreadsheet model that could be used to assist Tim with retirement planning. Your model should include the following input parameters Tim's current age -40 Tim's current total retirement savings = $50,000 Annual rate of return on retirement savings = 10% Tim's current annual salary = $85,000 Tim's expected annual percentage increase in salary = 5% Tim's percent of annual salary contributed to retirement = 6% Tim's expected retirement age = 65 Tim's additional annual (tax free) contribution to retirement = $2,000 a) (10 pts) Prepare a spreadsheet indicating the value of the retirement fund on a yearly basis through the retirement age of 65 b) (5 pts) Prepare a 2-way data table when the rate of return on investments varies from 3% to 5% with 0.5% increment. What is the value of retirement for an expected 5% return on investment and a 5% contribution from salary? increment and contribution from salary varies from 5% to 7% with a 1% c) (3 pts) What should be the annual (tax free) contribution if he desires to retire with $850,000 in savings? (use parameters employed in part (a))

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Auditing Theory And Practice

Authors: Arun Kumar & Rachana Sharma

1st Edition

8171567207, 978-8171567201

More Books

Students also viewed these Accounting questions

Question

What are some issues surrounding the use of punishment?

Answered: 1 week ago