On 1 April 2019, Exotica Ltd borrowed $56,870 from the bank at 10% per annum interest....
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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). 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).
Expert Answer:
Related Book For
Financial Accounting A User Perspective
ISBN: 978-0470676608
6th Canadian Edition
Authors: Robert E Hoskin, Maureen R Fizzell, Donald C Cherry
Posted Date:
Students also viewed these accounting questions
-
Prepare the journal entry to record Channel One Companys issuance of 100,000 shares of $0.50 par value common stock assuming the shares sell for: a. $0.50 cash per share. b. $2 cash per share.
-
Prepare the journal entry to record Selectist Companys issuance of 104,000 shares of no-par value common stock assuming the shares: a. Sell for $15 cash per share. b. Are exchanged for land valued at...
-
One thousand dollars is borrowed for one year at an interest rate of 1%per month. If the same sum of money could be borrowed for the same period at an interest rate of 12% per year, how much could be...
-
The roller coaster in Figure P6.36 starts with a velocity of 15 m/s. One of the riders is a small girl of mass 30 kg. Find her apparent weight when the roller coaster is at locations B and C. At...
-
Do you think that business practices in an Islamic country are likely to differ from business practices in the United States? If so, how?
-
Short statements reflecting various personality traits which individuals rate on the degree to which they are self-descriptive are referring to as what ? Provide brief explanation.
-
We consider automobile injury claims data using data from the Insurance Research Council (IRC), a division of the American Institute for Chartered Property Casualty Underwriters and the Insurance...
-
The balance sheet for Tactex Controls Inc., provincially incorporated in 2012, reported the following components of equity on December 31, 2013. In 2014 and 2015, the company had the following...
-
Sweet Catering completed the following selected transactions during May 2024: (Click the icon to view the transactions.) Read the requirements. Requirement 1. Show whether each transaction would be...
-
Singleton Supplies Corporation (SSC) manufactures medical products for hospitals, clinics, and nursing homes. SSC may introduce a new type of X-ray scanner designed to identify certain types of...
-
Discuss the social security system. Current status and future outlook. Be thorough and focus on the economic considerations.
-
Discuss the significant trade-off between two competing objectives in hospital information systems. What are the competing objectives? What is the nature of the trade-off? Be detailed and thorough in...
-
Employ various sources of data to examine a particular case of a phenomenon in-depth. Different sources of data may require an analytical approach other than thematic analysis. If you were to use...
-
The following table provides partial information on total product, average product, and marginal product for a production function. Using the relationship between these products, fill in the missing...
-
Firm Supply. Credit Check, Inc., offers credit checking services to credit card companies and retailers. The following relation exists between the number of credit checks performed and total costs in...
-
Along that train of thought, craft Reflection Analysis paper addressing the following: What were your initial course goals?( my primary goal for this term is to gain a comprehensive and nuanced...
-
GSK Pharmaceuticals wish to ensure that their Paracetamol tablets contain, on average, the amount quoted on the packet of their product - namely 500 mg. Clinical tests on a random sample of 38...
-
Refer to the data in QS 10-1. Based on financial considerations alone, should Helix accept this order at the special price? Explain.
-
Describe the following terms as they relate to bond prices: par, premium, and discount. Discuss.
-
Claude Resources Inc. is a Saskatchewan-based "junior" natural resource company involved in gold mining. Note 2 accompanying its 2009 financial statements outlines its significant accounting...
-
Describe the basic differences between the periodic and perpetual inventory systems.
-
Do you know about the chart of accounts in your organization as it pertains to information you receive?
-
If you receive reports in the course of your work, do you believe that they are prepared for outside (third party) use or for internal (management) use? What leads you to believe this?
-
If so, is it similar to one of the three formats illustrated in this chapter? If not, how is it different?
Study smarter with the SolutionInn App