1 ( Need with excel Formulas ) Loan value100,000 Annualised Interest rate15% Monthly interest rate1.25% Tenure6 WIth the above loan details, calculate the EMI amount and create the EMI schedule for the loan to fill the below table Assumptions : 1Payment arrives at end of period 2Interest is applied on a monthly basis on declining balance Balance outstanding at start of periodPayment received (EMI amount)Principal paidInterest paidBalance outstanding at end of period 1100,000 2 3 4 5 6