On January 1, 2021, Norwood borrows $200,000 cash from a bank by signing a five-year installment note
Question:
On January 1, 2021, 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 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 (A) (B) (C) (D) Credit Amortization Schedule (E) Debit Debit Interest Notes Ending Expense 8% x (A) Payable Cash Balance Beginning Balance + Period Ending Date (D) – (B) (computed) (А) - (C) Excel: Installment note payments. (1) 12/31/2021 $60,000 $4,800 $ 18,482 $23,282 $41,518 A B (2) 12/31/2022 ... 41,518 21,557 1 Rate per period 2 Number of periods 8% 3,321 19,961 23,282 (3) 12/31/2023 21,557 1,725 21,557 23,282 3 Loan amount $60,000 $9,846 $60,000 $69,846 Loan payments =-PMT(B1,B2,B3)=$23,282 Equal Cash Payments Decreasing Accrued Increasing Principal Component Interest Excel: Principal portion of payments. A B 1 Rate per period $4,800 $18,482 8% 2021 | Interest 2 Number of periods 3 * 2022 $3,321 $19,961 3 Loan amount $60,000 Principal Period Principal 2023 $1,725 $21,557 4 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 computed by solving the following equation. The amount is computed by dividing $60,000 by 2.5771, yielding $23,282. =-PPMT(B1,A6,B2,B3)=$19,961- =-PPMT(B1,A7,82,B3-$21,557- Table Present Value Factor Dollar Amount Present Value В.3 2.5771 ? = $60,000 Activate Win 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 selected transactions for Eduardo Company. Nov. 1 Accepted a $5,000, 180-day, 6% note dated November 1 from Melosa Allen in granting a time extension on her...
-
The per-unit cost of an item is its average total cost (5 total cost/quantity). Suppose that a new cell phone application costs $100,000 to develop and only $.50 per unit to deliver to each cell...
-
A heat engine receives 1 kW heat transfer at 1000 K and gives out 600 W as work with the rest as heat transfer to the ambient. What are the fluxes of exergy in and out?
-
For the first three months of 2012, the stock market put up its best first-quarter performance in over a decade (Money.cnn.com, April 9, 2012). The accompanying table shows a portion of the daily...
-
Donny Blake is an accountant for Swenson Company. Early this year Donny made a highly favorable projection of sales and profits over the next 3 years for Swen- son's hot-selling computer PLEX. As a...
-
Ryan Murphy, nephew of the author, swims for the University of California at Berkeley. Ryan's best time in the 100-meter backstroke is 45.3 seconds. The mean of all NCAA swimmers in this event is...
-
The total arm and blade of a windshield wiper is 12 in. long and rotates back and forth through an angle of 91. The shaded region in the figure is the portion of the windshield cleaned by the 10-in....
-
The elements arsenic and phosphorus are common dopants in crystalline silicon that impart semiconductor properties to it via the introduction of p-type carriers into the silicon lattice. The doping...
-
Brian, Joe, and Nate are the founders of Airbnb. Assume that the company currently has $250,000 in equity and is considering a $100,000 expansion to meet increased demand. The $100,000 expansion...
-
Refer to the information in QS 17-7. Determine the prior year and current year common-size percents for cost of goods sold using net sales as the base. Data From QS 17-7 Use the following information...
-
For an asset that fits into the MACRS "All property not assigned to another class" designation, show in a table the depreciation and book value over the asset's l0-year life of use. The cost basis of...
-
The business obtained a bank loan for the amount of $ 3 3 6 0 0 ( including GST ) on January 1 , 2 0 2 4 . The bank charges interest of 7 % per annum and interest payments are due quaterly. The...
-
Integrals may have infinite limits of integration, or integrands that have singularities. Such integrals are called "improper" even though there is nothing wrong with such integrals. They may have...
-
discuss the evolutionary trade-offs that organisms face in adapting to different environmental niches, and how these trade-offs shape the diversity of life forms and ecological strategies observed in...
-
What is the expected annual return for a stock that is priced at $64.78, is expected to pay a dividend of $2.00 every quarter forever, and is expected to pay its next dividend in 3 months?
-
Eloise made a contract in January that gave her until the end of the year to complete her work on a new computer system for Dexter. In mid-July, Eloise is working on the computer system. The contract...
-
The beginning balance sheet of Text Source Co. included a $700,000 investment in Taylor stock (20% ownership). During the year, Text Source completed the following investment transactions: Mar. 3...
-
By referring to Figure 13.18, determine the mass of each of the following salts required to form a saturated solution in 250 g of water at 30 oC: (a) KClO3, (b) Pb(NO3)2, (c) Ce2(SO4)3.
-
Refer to Exercise 22-10. (1) Prepare a contribution margin income statement for Apollo Company showing sales, variable costs, and fixed costs at the break-even point. (2) If the companys fixed costs...
-
Apollo Company management targets an annual after-tax income of $840,000. The company is subject to a 20% income tax rate. Assume that fixed costs remain at $630,000. Compute the (1) Unit sales to...
-
Apollo Companys sales manager predicts that annual sales of the companys product will soon reach 40,000 units and its price will increase to $200 per unit. According to the production manager, the...
-
Scenario You are an independent consultant hired by Penmen Groceries, and they are exploring options to modernize their accounting information system (AIS). They are looking for an audit company to...
-
Sort the following into asset, liability and expenses Accounts payable, Interest expense, Accounts receivable, Land, Advertising expense, Note payable, Building, Property tax expense, Cash, Rent...
-
The most commonly used style for a letter of application is Question 15 options: a) block letter style. b) adjusted block letter style. c) ragged right. d) ragged left
Study smarter with the SolutionInn App