Instructions: Use excel to calculate the principle and interest payment on the following loans. Amount of Loan 500,000 800,000 Annual interest rate 4% 6% Loan term in years 15 30 200,000 7.25% 40 Monthly Interest rate Loan term in months Monthly Payment Instructions: Use excel to impute the interest on the following loans Amount of Loan S 1,500 $ Amount to be repaid S 1,575 S Date of Loan 10/1/2020 Date of repayment 10/31/2020 10,000 $ 11,000 $ 03/02/21 03/29/21 25,000 28,000 06/05/21 08/31/21 Imputed interest