Via EXCEL

Part 1: Analyze and calculate the following scenarios , including which one would you choose and why, and which financing option is best for your busines:

Investor #1 decided to loan you the $300,000, paying all of the interest (8% per year) and principal in one lump sum at the end of 5 years.Need equation inputs for;

Total Payment

Interest Paid

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. Need equation inputs for the following; Annual Interest Payment- Year 5 Payment - Total Payment- Interest Paid-