2) Please calculate the following using Microsoft Excel and include cell formulas. Investor #2 offers you the $300,000, paying interest at the rate of 8% per year for 4 years and then a final payment of interest and principal at the end of the 5th year.

Pay interest at the rate of 8% per year for 4 years and then a final payment of interest and principal at the end of the 5th year;
Amount	$300,000
Period (years)	5
Interes rate	8%
Answer
Annual Interest Payment-
Year 5 Payment -
Total Payment-
Interest Paid-