Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Suvo also wants to compare the future value of the IRA and the amounts he will invest in five years, 10 years, and so on

  1. Suvo also wants to compare the future value of the IRA and the amounts he will invest in five years, 10 years, and so on up to 30 years. In the range C17:D17, he has already entered formulas to return the future value and his invested amount in the IRA. In the range B17:D23, create a one-input data table using cell D9 as the column input cell to vary the years listed in the range B18:B23 in the formulas that calculate the future value (cell C17) and the investment amount (cell D17).
  2. Next, Suvo wants to calculate the amount of the Traditional IRA at an annual return rate varying from 3.5 percent to 13 percent with his invested amount varying from 6 percent to 9.5 percent. He has already set up the structure for a data table in the range F3:N23, and has entered a formula in cell F3 that references the future value amount in cell D14. Start by decreasing the displayed decimal places in the range F4:F23 to show the annual return percentages with only one decimal place to match the format of the amount invested percentages.

Based on the range F3:N23, create a two-variable data table that uses the annual rate of return (cell D8) as the row input cell and the employee percent invested (cell D5) as the column input cell.

image text in transcribed

B17 1 8 A 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 2 3 4 5 6 Employer Match 7 fxx B Name Annual Income Employee Percent Invested Total Percent Invested. Expected Annual Return. Years Employed Monthly Contribution Employee Employer Total Future Value Years 5 10 15 20 25 30 C Traditional IRA Future Value $209,918.59 D Suvo Banerjee $85,000.00 7.25% 5.50% 0.00% 7.50% 12 $513.54 $389.58 $903.13 $209,918.59 Investment $73,950.00 E F $209,918.59 3.50% 4.00% 4.50% 5.00% 5.50% 6.00% 6.50% 7.00% 7.50% 8.00% 8.50% 9.00% 9.50% 10.00% 10.50% 11.00% 11.50% 12.00% 12.50% 13.00% 6.0% H I K L Annual Return and Percent Invested 6.5% 7.0% 7.5% 8.0% 8.5% M 9.0% N 9.5% B17 1 8 A 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 2 3 4 5 6 Employer Match 7 fxx B Name Annual Income Employee Percent Invested Total Percent Invested. Expected Annual Return. Years Employed Monthly Contribution Employee Employer Total Future Value Years 5 10 15 20 25 30 C Traditional IRA Future Value $209,918.59 D Suvo Banerjee $85,000.00 7.25% 5.50% 0.00% 7.50% 12 $513.54 $389.58 $903.13 $209,918.59 Investment $73,950.00 E F $209,918.59 3.50% 4.00% 4.50% 5.00% 5.50% 6.00% 6.50% 7.00% 7.50% 8.00% 8.50% 9.00% 9.50% 10.00% 10.50% 11.00% 11.50% 12.00% 12.50% 13.00% 6.0% H I K L Annual Return and Percent Invested 6.5% 7.0% 7.5% 8.0% 8.5% M 9.0% N 9.5%

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

Teaching Public Budgeting And Finance

Authors: Meagan M. Jordan, Bruce D. McDonald III

1st Edition

1032146680, 978-1032146683

More Books

Students also viewed these Finance questions