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?
-
The classified balance sheet for Thorn, Inc., as of December 31, 2010, is presented next. Requirements 1. Calculate Thorns debt ratio as of December 31, 2010. 2. What percentage of Thorns assets...
-
Research by Aiken et al. on magnet hospitals shows: A. Job satisfaction has no impact on an organizations effectiveness. B. Magnet hospitals have high turnover rates. C. Job satisfaction is...
-
How much acquisition and integration cost was included within GAAP Other (expense) income, net for the 6 months ended December 31, 2018? $0 $1,755 $2,613 $4,368
-
Consider the following table, which gives a security analyst's expected return on two stocks in two particular scenarios for the rate of return on the market: Market Return Aggressive Stock -3% 38 5%...
-
Figure 1 shows an experimental setup to be used in identifying the value of unknown resister, R. Internal resistance of Voltmeter is 0.5 kn. Observations are as follows, Voltmeter Reading - 100 V...
-
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...
-
The world population in billions is approximately P = 7.4e 0.0107t where t is in years since 2016. Estimate the relative rate of change of population in 2020 using this model and (a) t = 1 (b) t =...
-
At the beginning of the year, Mahogany. Incorporated bought machinery, shelving, and a forklift. The machinery initially cost $33,600 but had to be overhauled (at a cost of $2,800) before it could be...
-
AMAT113: Calculus II - Worksheet 5 1. For each of the following sequences state whether it is convergent or divergent. In the former case you must give the limit and, in the latter, give a brief...
-
Consider a 110 ft long, 1 in. type M copper tubing. (Due to the nature of this problem, do not use rounded intermediate values in your calculations-including answers submitt What is the outside...
-
JEnergy Limited has an authorized share capital of 9 0 0 0 0 0 1 0 % preference shares of $ 2 each and 1 2 0 0 0 0 0 Ordinary shares of 5 2 each. The following are the balances in the books at 3 1...
-
Please compute for the following requirements and show solution in good accounting form so I can compare it with my own answer. Thank you! 1. Uncle Ben Corp. sells a product for P5 per unit. The...
-
a. Find the probability of getting exactly 6 girls in 8 births. b. Find the probability of getting 6 or more girls in 8 births. c. Which probability is relevant for determining whether 6 is a...
-
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...
-
A firm with a 1 4 % WACC is evaluating two projects for this year's capital budget. After - tax cash flows, including depreciation, are as follows: 0 1 2 3 4 5 Project M - $ 1 5 , 0 0 0 $ 5 , 0 0 0 $...
-
Critically discuss the centralised distribution system with the decentralised distribution system. Which structure is more suitable for a large company. Support your arguments by referring to SCM...
-
Jules and Lin are married and filing jointly, with an adjusted gross income of $87,500. Determine the person's (or couple's) taxable income. Assume the standard deduction unless otherwise stated. Use...
Study smarter with the SolutionInn App