a. | Interest expense and unpaid balance will decrease throughout the amortization period | |||||||
b. | Date | Account titles and explanation | Debit | Credit | ||||
Nov 1. | Interest expense | 1000 | ||||||
Note payable | 1633 | |||||||
Cash | 2633 | |||||||
(Monthly installment paid) | ||||||||
Dec 1. | Interest expense | 984 | ||||||
Note payable | 1649 | |||||||
Cash | 2633 | |||||||
(Monthly installment paid) | ||||||||
c. | Interest period | Payment date | Monthly payment | Interest expense | Principal reduction | Unpaid balance | ||
Issue date | Oct 1. | 100000 | ||||||
1 | Nov 1. | 2633 | 1000 | 1633 | 98367 | |||
2 | Dec 1. | 2633 | 984 | 1649 | 96718 | |||
3 | Jan 1. | 2633 | 967 | 1666 | 95052 | |||
(96718*1%) | (2633-967) | (96718-1666) | ||||||
4 | Feb 1. | 2633 | 951 | 1682 | 93369 | |||
(95052*1%) | (2633-951) | (95052-1682) | ||||||
d. | Current liability: | |||||||
Interest expense for the 3rd interest period ( To be paid in Jan 1)-Interest payable | ||||||||
Principal reduction for the 3rd interest period ( To be paid in Jan 1)-Note payable | ||||||||
Principal reduction for the next 12 monthly installments after 3rd interest period-Note payable |
1010-4 PROBLEM 10.4B preparation and Use of an Amortization Table pays 16 percent interest instead of...
PROBLEM 10.4B Preparation and Use of an Amortization Table On October 1, 2018. Jenco signed a four-year, $100,000 note payable to Vicksburg State Bank in conjunction with the purchase of equipment. The note calls for interest at an annual rate of 12 percent (1 percent per month). The note is fully amortizing over a period of 48 months. The bank sent Jenco an amortization table showing the allocation of monthly payments between interest and principal over the life of the...
can someone please show me how this is done?? L010-4 EXERCISE 10.6 Use of an Amortization Table Glen Pool Club, Inc., has a $150,000 mortgage liability. The mortgage is payable in monthly installments of $1,543, which include interest computed at an annual rate of 12 percent (1 percent monthly). a. Prepare a partial amortization table showing (1) the original balance of this loan, and (2) the allocation of the first two monthly payments between interest expense and the reduction in...
Mike Williams Inc. signed a 4-year, installment note payable with Buffalo Bank. The note was for $100,000, 12% annual interest (1% per month), with monthly payments of $2,633 (for both principle and interest). The journal entry for the third payment of $2,633 would include (to the nearest whole dollar)
ACC 213 Lab #9 for Chapter 10 - Installment Notes & Amortization Tables 4 5 Instructions: First, complete the amortization table in Part 1 using the information provided. Once the table is completed, then record the two journal entries in Part 2 Information: Your car loan has monthly payments, the first payment occurring 1 month after loan starts $27,000 24 principal months monthly interest total payments 2 5% 0.4166666667% 24 years per year $1,184.53 monthly payment 16 17 Part 1:...
On December 16, 2019, Carboy, Inc., borrows $120,000 cash from Third National Bank at 9 percent annual interest. The note is due in 45 days. At December 31, 2019, Carboy records any unpaid interest with an adjusting entry. On January 30, 2020, Carboy pays the principal and interest owed on the bank note. Prepare the January 30 entry by Carboy for the payment (maturity) of the note plus interest by selecting the account names from the drop-down menus and entering...
Exercise 10-10 Installment note amortization table LO C1 On January 1, 2018, Eagle borrows $31,000 cash by signing a four-year, 8% installment note. The note requires four equal payments of $9,360, consisting of accrued interest and principal on December 31 of each year from 2018 through 2021. (Table B.1, Table B.2, Table B.3, and Table B.4) (Use appropriate factor(s) from the tables provided.) Prepare an amortization table for this installment note. (Round all amounts to the nearest whole dollar.) Payments...
Exercise 10-10 Installment note amortization table LO C1 points On January 1, 2018, Eagle borrows $17,000 cash by signing a four-year, 6% installment note. The note requires four equal payments of $4,906, consisting of accrued interest and principal on December 31 of each year from 2018 through 2021. (Table B.1, Table B.2, Table B.3, and Table B.4) (Use appropriate factor(s) from the tables provided.) Prepare an amortization table for this installment note. (Round all amounts to the nearest whole dollar.)...
Spreadsheet 1: Amortization Table Create an amortization table in MS-Excel in the format shown below: Scenario: 2 years ago Janice got a $100,000, 15-year mortgage with an annual interest rate of 6% and monthly payments. 1) What is her monthly payment? 2) How much does she owe today (after 24 payments)? 3) How much will she owe in 3 years (after 60 payments)? 4) How much will she owe in 3 years (after 60 payments) if she makes an extra...
Thanks in advance. Exercise 10-10 Installment note amortization table LO C1 On January 1, 2018, Eagle borrows $19,000 cash by signing a four-year, 8% installment note. The note requires four equal payments of $5,737, consisting of accrued interest and principal on December 31 of each year from 2018 through 2021. (Table B1. Table B.2. Table B.3, and Table B.4) (Use appropriate factor(s) from the tables provided.) Prepare an amortization table for this installment note. (Round all amounts to the nearest...
Amortization Table. You wish to buy a $40,000 car. The bank can finance you with a 3-year loan at a 4 percent APR. If you make a $7,000 down payment on the purchase. What are the monthly payments on your loan? How much will you pay in interest each year? Show the amortization table (use monthly payments).