On January 1, 2021, Gordon borrows $150,000 cash from a bank by signing a three-year installment note
Question:
On January 1, 2021, Gordon borrows $150,000 cash from a bank by signing a three-year installment note bearing 10% interest. The note requires equal payments of $60,316 each year on December 31.
Required
1. Complete an amortization table for this installment note similar to the one in Exhibit 14.12.
2. Prepare journal entries to record the note’s issuance and each of the first two payments.
Exhibit 14.12
EXHIBIT 14.12 Payments Installment Note Amortization Schedule (A) (B) (C) (D) (E) Debit Debit Credit Interest Notes Ending Expense 8% x (A) Payable (D) – (B) Beginning + Cash Balance Period Ending Date Balance (computed) (А) — (С) Excel: Installment note payments. (1) 12/31/2021 $60,000 $4,800 $ 18,482 $23,282 $41,518 B 1 Rate per period (2) 12/31/2022 41,518 3,321 19,961 23,282 21,557 8% 2 Number of periods (3) 12/31/2023 21,557 1,725 21,557 23,282 Loan amount $60,000 $9,846 $60,000 $69,846 4 Loan payments =-PMT(B1,82,B3)-$23,282 Decreasing Accrued Interest Increasing Principal Component Equal Cash Payments Excel: Principal portion of payments. A B 1 Rate per period 8% 2021 $4,800 $18,482 L Interest 2 Number of periods 3 * 2022 $3,321 $19,961 Loan amount $60,000 Principal Period Principal 2023 $1,725 $21,557 1 $5,000 $15,000 $25,000 2 3 *Table B.3 in Appendix B is used to compute the dollar amount of three payments that equal the initial note balance of $60,000 at 8% =-PPMT(B1,A5,82,B3)-$18,482 interest. We go to Table B.3, row 3, and across to the 8% column, where the present value factor is 2.5771. The dollar amount is then =-PPMT(B1.A6,82,B3)-$19,961 computed by solving the following equation. The amount is computed by dividing $60,000 by 2.5771, yielding $23,282. Table Present Value Factor Dollar Amount Present Value =-PPMT(B1,A7,B2,B3)-$21,557 В.3 2.5771 $60.000 End of Year
Step by Step Answer:
Part 1 Part 2 Background Amount of Paym...View the full answer
Related Video
An amortization schedule (sometimes called an amortization table) is a table detailing each periodic payment on an amortizing loan. Each calculation done by the calculator will also come with an annual and monthly amortization schedule above. Each repayment for an amortized loan will contain both an interest payment and payment towards the principal balance, which varies for each pay period. An amortization schedule helps indicate the specific amount that will be paid towards each, along with the interest and principal paid to date, and the remaining principal balance after each pay period
Students also viewed these Business questions
-
On November 1, 2020, Norwood borrows $200,000 cash from a bank by signing a five-year installment note bearing 8% interest. The note requires equal payments of $50,091 each year on October 31....
-
On October 1, 2020, Gordon borrows $150,000 cash from a bank by signing a three-year installment note bearing 10% interest. The note requires equal payments of $60,316 each year on September 30....
-
Prepare journal entries to record these transactions: (a) Benton Company retires its delivery equipment, which cost $41,000. Accumulated depreciation is also $41,000 on this delivery equipment. No...
-
"Your lumber company has bought a machine that automatically cuts lumber. the seller of the machine claims that the machine cuts lumber to a mean length of 7 feet (84 inches) with a standard...
-
A nozzle in a high pressure liquid water sprayer has an area of 0.5 cm2. It receives water at 250 kPa, 20C and the exit pressure is 100 kPa. Neglect the inlet kinetic energy and assume a nozzle...
-
In order to test if the population mean differs from 16, you draw a random sample of 32 observations and compute the sample mean and the sample standard deviation as 15.2 and 0.6, respectively. Use...
-
On January 2, 2006, the S. H. Park company installed a brand new $87,000 special moulding machine for producing a new product. The product and the machine have an expected life of three years. The...
-
Effect of accounting events on the income statement and statement of cash flows Required Explain how each of the following events or series of events and any related adjusting entry will affect the...
-
+ T b) To verify the solution and the interval, convert xy5 - xy5 sin x = 1 to explicit function(s 1 y= (x-xsin x) (Use a comma to separate answers as needed.) 5 a t
-
Pam Corporation paid $170,000 for an 80 percent interest in Sun Corporation on December 31, 2016, when Sun's stockholders' equity consisted of $100,000 capital stock and $50,000 retained earnings. A...
-
Allegiant issues 6%, 20-year bonds with a par value of $2,000,000 and semiannual interest payments. In each separate situation, determine whether the bond is issued at par value, at a discount, or at...
-
Refer to the bond details in Problem 14-1B, except assume that the bonds are issued at a price of $4,192,932. Required 1. Prepare the January 1 journal entry to record the bonds issuance. 2. For each...
-
Might differences across countries in population growth account for the persistence in income disparity across countries? Use the Solow growth model to address this question and discuss.
-
Alpha Company uses machine - hours as the only overhead cost - allocation base. The manager provided the following data for one of the products for 2 0 2 3 : the direct cost rate is $ 5 per unit and...
-
Alberts Credit Agency uses a standard cost system for the processing of its credit applications. Before the beginning of the last pay period, Alberts estimated it would process 2,500 applications....
-
1. The definition of family has changed over time as a result of legal, cultural, and institutional shifts. Discuss two ways that the definition of family has changed over time and include which...
-
Assume XYZ has a marginal tax rate of 21 percent for the foreseeable future and earns an after-tax rate of return of 8 percent on its assets. Joel Johnson, XYZ's VP of finance, is attempting to...
-
Your task for this week is to run the following code on your computer: public class Fibonacci { public static void main(String[] args). { for (int num = 0; num <100; num++) { } System.out.println(num...
-
Assume that a Logan Burger restaurant has the following perpetual inventory record for hamburger patties: At July 31, the accountant for the restaurant determines that the current replacement cost of...
-
How much more interest will be earned if $5000 is invested for 6 years at 7% compounded continuously, instead of at 7% compounded quarterly?
-
Jammin Co. manufactures and markets several products. Management is considering the future of one product, electronic keyboards, that has not been as profitable as planned. Since this product is...
-
Koto Co.s monthly sales and costs data for its operating activities of the past year follow. Management wants to use these data to predict future fixed and variable costs. Required 1. Prepare a...
-
Caruso Co. sold 40,000 units of its only product and incurred a $100,000 loss (ignoring taxes) for the current year as shown here. During a planning session for year 2012s activities, the production...
-
Norm and Linda are married, file a joint return, and have one 5-year-old child. Their adjusted gross income is $436,000 . What is their child tax credit for 2021 ?
-
The following data relate to direct labor costs for the current period: Standard costs 7,400 hours at $11.40 Actual costs 6,200 hours at $10.70 The direct labor time variance is a.$13,680 unfavorable...
-
Cane Company manufactures two products called Alpha and Beta that sell for $155 and $115, respectively. Each product uses only one type of raw material that costs $6 per pound. The company has the...
Study smarter with the SolutionInn App