5. Complete the table below that calculates the Future Value of $10,000 invested at 7% per year using periods from 1 to 10 years. The table also illustrates the value today of $10,000 to be received in the future from 1 to 10 years later using a discount rate of 5%. (Note: table is to be completed by appropriately copying the Excel formulas. Using Excel copy/paste functionality it should take just a few seconds to do it).

Number of	Number of	Number of	Number of	Number of	Number of
Periods	(Excel Formula)	(Algebra Formula)		(Excel Formula)	(Algebra Formula)
1	$10,700.00	$10,700.00		$9,523.81	$9,523.81
2	$11,449.00	$11,449.00			$9,070.29
3
4
5
6
7
8
9
10				$6,139.13	$6,139.13