how to calculate this in excel. I wanna know the how it works please. I meant by the interest expense, principal payment n outstanding bal.

Small Busir Question Two: Loan Amortisation (7 marks) GoGreen Caf, a local small business will be borrowing from a local bank a loan of $12.000 for 18 months at an APR of 7 25% The bank will accept a loan repayment schedule of equal end of the month payments with interests to be compounded monthly. The GoGreen Cafe owner. Nancy, has asked you to explain to her how loan amortisation works and how to calculate periodic interests and repayments. Present your answers in the following space About Featured Snie (a) Using Excel, prepare a monthly loan amortization table for the entire loan period. The table should display the values for the following columns the time period. (equal) periodic loan repayment interest expense, principal repayment and loan balance. (2 marks) o multiply a comp $100 million in de 5100 million multip Periodic Loan Payment ($) Interest Expense (S) Principal Payment (S) Outstanding Balance Months From your Excel table, paste your answers for the first and final periods here: ith Net Income