Question: 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

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 LMS

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Adriana owns My Best Friend, a pet grooming boutique. A high-end developer purchased a large tract of land nearby and is constructing luxury condominium townhomes. According to city records, once the...

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...

Attempt four of the five questions Question 1 Beta Shoes Ltd manufactures a shoe brand with a trade name 'Beta Shoe' and also imports a brand 'Marie Claire' for elegant ladies. For the year ended 30...

Question 4 Tanjiro Ltd (35 marks) On 1 January 2019, Tanjiro Ltd acquired 75% of the issued shares of Inosuke Ltd on an ex-div. basis for $5 million. On the acquisition date, the accounts of Inosuke...

Advanced Financial Accounting Question 4 (20 points) On 1 July 2019 Murchison Ltd entered into a contractual arrangement with Pelion Ltd to form a joint operation to manufacture laminated timber...

Question 1 (20 marks) On 1 July, 2019, Harvest Food Ltd (Harvest), a publicly listed company, successfully acquired the entire share capital of Maxam Ltd (Maxam), a food processing company and...

Additional information: 1. Inventory on 31 December 2019 amounted to $83 000. 2. No property or equipment was purchased during the year. 3. The long- term borrowing is from Mukando bank and is...

Three persons A, B and C apply for a job of Manager in a Private Company. Chances of their selection (A, B and C) are in the ratio 1 : 2 : 4. The probabilities that A, B and C can introduce changes...

A box bas 1000 blue 500 ged (50) 5} black balls, 25% balls, 500 of blue balls and 50% of red balls are taken away, then find the percentage of black balls?

17.63 Cp and six-sigma. A process with Cp 2 is sometimes said to have six-sigma quality. Sketch the specification limits and a Normal distribution of individual measurements for such a process when...

Which of the following marketing management concepts is most likely to lead to marketing myopia? customer - driving marketing societal marketing marketing product

You were recently promoted to a management position. One of your first tasks is to discipline one of your staff for an ongoing tardiness problem. What information do you need prior to the discipline...

Your professor is dealing with a case where a student was alleged to have cheated on the final exam. Would documentation be important? If so, what type of documentation would be necessary?

What does John Jacak in the HRM Close-up say are the most important aspects in a privacy policy?