C18 123 A Y E X B Assumptions Loan value Annualised Interest rate Monthly interest rate Tenure fx 1 2 Font 1 2 3 4 5 6 Question 1 C Alignment 1,00,000 15% 1.25% 6 4 5 6 7 With the above loan details, calculate the EMI amount and create the EMI schedule for the loan to fill the below table 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 Payment arrives at end of period Interest is applied on a monthly basis on declining balance D Balance outstanding at start of period 1,00,000 Number E F Styles G Payment received (EMI amounty Principal paid Interest paid Balance outstanding at end of period H Cells