please do the following on excel question 3

CAMC Referral Form x 30caf47ec95754666b49785c( X (xero Xero | Manual Journal | Questic X Semester 2 2020 Assessment / X Assignment X + C D @ File | /Users/amanianwar/Downloads/Semester%202%202020%20Assessment%20ACC1AIS%20Final%20Final.pdf Apps Wiley Australia: Fi... were XERO S Individual Assign... ProQuest Ebook C... PromTime Time as loyalty card member TargetBuy Organics purchased? 1 = Yes, 0 = No TargetAmt Number of organic products purchased ID DemAffl DemAge DemCluster DemClusterGroup DemGender DemReg DemTVReg PromClass PromSpend PromTime TargetBuy TargetAmt 000000140 10 76 16 C U Midlands Wales & West Gold 16000 4 0 0 0000000620 49 Midlands Wales & West Gold 6000 0000000868 70 Midlands Wales & West Silver .02 0000001120 65 Midlands Midlands TIn 0.01 DO UT 0000002313 68 Midlands Midlands Tin 0.01 0000002771 72 TI TODOD 7 3 3 7 C 7 3 TC North N West Platinum 20759.81 DOHP 0000003131 74 Midlands East Tin 0.01 OOOHP 0000003328 N East 0000004529 10 62 North Tin 0.01 oo Midlands East Silve 2038.76 0000005886 14 43 Gold 6000 Question 3 - Accounting for liabilities 20 marks On 1 April 2019, Exotica Ltd borrowed $56,870 from the bank at 10% per annum interest. This loan was a secured loan and is was for one year. This loan is repayable in amounts of $5,000 at the end of each month. Required 1. In an excel spreadsheet prepare a journal entry to record the initial mortgage (1 mark). 2. Within the Excel spreadsheet prepare a mortgage schedule for this loan. Round your calculations to two decimal places and the nearest dollar (16 marks) 3. In the Excel spreadsheet, use the mortgage schedule to prepare the journal entries for loan repayments for April and May 2019 (3 marks). An Excel file that includes your calculations should be submitted to the End of the Examination Paper Page 6 of 6 Semester 2 Show all X