please Help! You borrow money on a self liquidating installement loan (equal payments at the end of each year, each payment is part principal part interest) I also need the excel formulas . Please do it on excel.

You bomow money on a self liquidating instalent loan (equal payments at the end of each year, each payment is part principal part interest Loan $312,000 Interest Rate 13 30% Life years) Date of Loan January 1, 2020 Use the installment method - not straight line Do NOT round any intermediate numbers Do NOT turn this into a monthly problem. What is the annual payment? b) What are the total interest payments? 5 c) After 28 payments have been made, what percentage of the total interest has been paid round to the nearest percentage point? 6 d) Alter 28 payments have been made, what percentage of the total principal has been paid round to the nearest percentage point)? 8 Redo the problem the interest rate is 3.00 20 or a well designed spreadsheet this should take 30 seconds) 22 ) What is the annual payment? 23 ) What are the total interest payments? 24 After 28 payments have been made, what percentage of the total interest has been paid round to the nearest percentage point)? 25 h) After 28 payments have been made what percentage of the total principal has been paid found to the nearest percentage point? Qloan 23-59073 S heet3 + Ready Q W ER TY