6. On January 1, Wonder Water borrowed $300,000 for 5 years at 4.5% to finance expansion. Fixed principal payments are to be made quarterly beginning Mar 1. Below is an instalment schedule for Wonder Water. (13 marks)
WONDER WATER
INSTALMENT PAYMENT SCHEDULE- FIXED PRINCIPAL PAYMENTS
Interest Period |
Cash Pmt |
Interest Expense |
Reduction of Principal |
Principal |
Jan 1 |
300,000 |
|||
Mar 1 |
? |
3,375 |
5,000 |
295,000 |
Jun 1 |
8,319 |
? |
5,000 |
? |
Sep 1 |
? |
3,263 |
? |
285,000 |
Dec 1 |
? |
? |
5,000 |
? |
Instructions
(a) Determine the missing values (round to the nearest dollar).
(b) Prepare the journal entries for the payments made on March 1 and Sept 1.
Answer
Interest Period |
Cash Pmt |
Interest Expense |
Reduction of Principal |
Principal |
Jan-01 |
$300,000 |
|||
Mar-01 |
$8,375 |
$3,375 |
$5,000 |
$295,000 |
Jun-01 |
$8,319 |
$3,319 |
$5,000 |
$290,000 |
Sep-01 |
$8,263 |
$3,263 |
$5,000 |
$285,000 |
Dec-01 |
$8,206 |
$3,206 |
$5,000 |
$280,000 |
--Working
Cash Pmt |
Interest Expense |
Reduction of Principal |
Principal |
300000 |
|||
=3375+5000 |
3375 |
5000 |
295000 |
8319 |
=8319-5000 |
5000 |
=295000-5000 |
=5000+3263 |
3263 |
5000 |
285000 |
=5000+3206 |
=285000*4.5%*0.25 |
5000 |
=285000-5000 |
Date |
Accounts title |
Debit |
Credit |
Mar-01 |
Notes Payable /Long term loans |
$5,000 |
|
Interest Expense |
$3,375 |
||
Cash |
$8,375 |
||
Sep-01 |
Notes Payable /Long term loans |
$5,000 |
|
Interest Expense |
$3,263 |
||
Cash |
$8,263 |
6. On January 1, Wonder Water borrowed $300,000 for 5 years at 4.5% to finance expansion....
6. On January 1, Wonder Water borrowed $300,000 for 5 years at 4.5% to finance expansion. Fixed principal payments are to be made quarterly beginning Mar 1. Below is an instalment schedule for Wonder Water. (13 marks) WONDER WATER INSTALMENT PAYMENT SCHEDULE- FIXED PRINCIPAL PAYMENTS Interest Period Cash Pmt Interest Expense Reduction of Principal Principal Jan 1 300,000 Mar 1 ? 3,375 5,000 295,000 Jun 1 8,319 ? 5,000 ? Sep 1 ? 3,263 ? 285,000 Dec 1 ? ?...
Question 1 Fantastic Fashions has just completed its first quarter of operations. Below are transactions that have not yet been recorded. Prepare the journal entries listed below. Jan 1 Pre-tax cash sales amounted to $75,000. HST is collected on all sales at a rate of 13%. Jan 15 Signed a three month note for $12,000 to extend amounts owing on account to Trendy Taste Inc. Interest is 6% annually and due at maturity. Mar 1...
. On January 1, Marvelous Metals borrowed $1,200,000 at 7% for 15 years to begin the development of a new mine. Blended principal payments must be made on the first day of each month. (18 marks) Instructions (a) Complete the instalment schedule listed below (round to the nearest dollar). (b) Assuming the year end is March 31, prepare the necessary adjusting entry. (c) Prepare the journal entries for the payments made on May 1 and June 1. MARVELOUS METALS INSTALMENT...
7. On January 1, Marvelous Metals borrowed $1,200,000 at 7% for 15 years to begin the development of a new mine. Blended principal payments must be made on the first day of each month. (18 marks) Instructions (a) Complete the instalment schedule listed below (round to the nearest dollar). (b) Assuming the year end is March 31, prepare the necessary adjusting entry. (c) Prepare the journal entries for the payments made on May 1 and June 1. MARVELOUS METALS INSTALMENT...
Tran Company issued a $300,000, 7 percent mortgage on January 1, 2018, to purchase a building. Payments of $12,377 are made semiannually. Complete the following amortization schedule (partial) for Tran Company. Round to the nearest dollar. (Do not round intermediary calculations. Only round the amount you input in the cell to the nearest whole dollar.) Date Payment Interest | Principal Loan Balance Jan 1, 2018 300,000 Jun 30, 2018 $ 12,377 Dec 31, 2018 Jun 30, 2019 Dec 31, 2019
DueNorth Mining Inc. purchased some crushing equipment on July 1, 2020 for $300,000. A down payment of $30,000 was required and the remainder was financed with a 8% instalment loan payable over 5 years with payments made on a quarterly basis. The quarterly payments required are $16,512 and include both interest and principal. The following is an extract from the loan amortization table the supplier provided to DueNorth : Payment Dates 9/30/20 12/31/20 3/31/21 6/30/21 9/30/21 12/31/21 Beginning loan balance...
DueNorth Mining Inc. purchased some crushing equipment on July 1, 2020 for $300,000. A down payment of $30,000 was required and the remainder was financed with a 8% instalment loan payable over 5 years with payments made on a quarterly basis. The quarterly payments required are $16,512 and include both interest and principal. The following is an extract from the loan amortization table the supplier provided to DueNorth : Payment Dates Beginning loan balance Payment Interest Principal Ending loan balance...
The following is the trial balance of the business on 30 June 2019. Trial Balance as at 30 June 2019 Debit (RM)Credit (RM)Premise244,600Motor Vehicle112,000Furniture & Fittings60,000Office Equipment3,800Bank27,360Cash4,140Trade Receivables22,250Trade Payables25,243Fixed Deposit 6%20,000Stationeries1,438Salary22,600Bad Debt1,000Utilities Expenses5,460Insurance Expenses8,000Carriage Inward2,465Commission3,450Purchases338,343Sales645,989Inventory as at 1 July 201818,340Capital120,000Loan 4%36,000Interest on Loan2,880 Discount2,5504,556Provision for doubtful debt428Return200Accumulated depreciation: Motor Vehicle40,600Accumulated depreciation: Furniture & Fittings20,000Accumulated depreciation: Office Equipment 760897,226897,226Additional information: Inventory value at 30 June 2019Cost ValueMarket Value RM16,882RM28,155Insurance of RM1,600 was paid for the month of July and...
A cash-flow budget uses the same format as a cash-flow statement. It is prepared on a monthly basis and it reflects budgeted income and expenses.In addition to the cash-flow statement, Deon and May made a list of budget assumptions: . Deon's income will increase by 5%, effective January 1 . His bonus is generally 10% of his income in the previous year, and he receives it in January. . May's raise will be 3%, effective January 1, Interest and dividend...
A cash-flow budget uses the same format as a cash-flow statement. It is prepared on a monthly basis and it reflects budgeted income and expenses. In addition to the cash-flow statement, Deon and May made a list of budget assumptions, listed for you here: • Deon’s income will increase by 5%, effective January 1. His bonus is generally 10% of his income in the previous year, and he receives it in January. • May’s raise will be 3%, effective January...