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

	Traditional IRA
	Name		Suvo Banerjee
	Annual Income		$85,000.00
	Employee Percent Invested		7.25%
	Employer_Match		5.50%
	Total Percent Invested		12.75%
	Expected Annual Return		7.50%
	Years Employed		12
	Monthly Contribution
	Employee		$513.54
	Employer		$389.58
	Total		$903.13
	Future Value		$209,918.59
	Years	Future Value	Investment
		$209,918.59	$73,950.00
	5
	10
	15
	20
	25
	30

Answer rating: 100% (QA)

To create a oneinput data table using cell D9 as the column input cell ... View the full answer