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...
-
Can the main effect of gender on weight loss be interpreted? If so, interpret the main effect, using the = 0.01 level of significance. If not, explain why not. Exercises 810 refer to the following...
-
The following are financial data taken from the 2015 annual report of Pfizer, Inc: Calculate the following ratios for 2015 and 2014: intangible asset turnover, fixed asset turnover, accumulated...
-
Biales Waste Disposal, GmbH, headquartered in the industrial city of Dusseldorf, Germany, operates seven specially-constructed semitrailers and cabs for commercial long-distance hauling of...
-
Lee Sutherlin is a self - employed electrical consultant. He estimates his annual net earnings at $ 3 5 , 9 0 0 . How much Social Security and Medicare must he pay ( in $ ) this year? Social Security...
-
1. What are some problems with Precisions performance appraisal process that might cause challenges for Jackson to implement a merit pay program? 2. What changes do you recommend Precision make to...
-
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...
-
In Fig. 35-32a, a beam of light in material 1 is incident on a boundary at an angle of 30°. The extent to which the light is bent due to refraction depends, in part, on the index of refraction n2...
-
Mr. Burk wrote an article in his local small town community newspaper in which he stated, "The only thing reliable about Mr. Smith, owner of Smith's Grocery Store, is that he is a liar." Mr. Smith...
-
List 3 typical components of a personal financial plan, and briefly explain one of them. Briefly define/explain: liquidity, risk tolerance and annuity List 4 "common" compoundings per year , and also...
-
what would be the formula for the following? 1. present value and multiple cash flows 2. future value and multiple cash flows 3. calculating EAR: 4. Calculating the number of periods : 5. Calculating...
-
Separate variables in the following partial differential equation for u(x, t): DE for X(x): DE for T(t): = 0 = 0 (Simplify your answers so that the highest derivative in each equation is positive.) t...
-
What is the purpose of tests of controls? With reference to the three (3) main risk components of the Audit Risk Model , explain the circumstances where it is NOT appropriate for the Auditor to test...
-
In a Marist survey of adults, these are the words or phrases that subjects find most annoying in conversation (along with their frequencies of response): like (127); just sayin' (81); you know (104);...
-
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...
-
The men's dress shirt department had been given the following information to use and developing a merchandise plan for the fall-winter season: Planned net sales: $566,000 Operating expenses: 35.8%...
-
Leases vs. Loans and investment decisions: A law firm is expanding rapidly and must move to new office space. business is good, and the firm is encouraged to purchase an entire building for $10...
-
The U.S. government actively seeks the identification and cleanup of sites that contain hazardous materials. The Environmental Protection Agency (EPA) identifies contaminated sites under the...
Study smarter with the SolutionInn App