On January 1, 2019, ABC Corp. borrowed $81,000 by signing an installment loan. The loan will be repaid in 20 equal payments, one at the beginning of each year. The first payment is made on January 1, 2017. The interest rate for the loan is 10%. Calculate the annual payment required. Show your final answer and show all the work to support your answer. Prepare the amortization table for the loan using the format covered in class.
equal annual payment
= P * R * (1+R)n / (+r)n - 1
p = 81000
r= 0.10
n = 20years
As the first payment is made immediately
we would deduct 1 from n in numerator
= 81000 *0.10 * (1+0.10)20-1/ (1+0.10)20-1
=8100*[6.1159/5.7275]
=8649.29$
Period | beginning balance | Payment | Principal [beginning balance-interest] | interest beginning balance *10% | ending balance [beginning balance - principal] |
January 1,2019 | 81000 | 8649.29 | 8649.29 | 0.00 | 72350.71 |
January 1,2020 | 72350.71 | 8649.29 | 1414.22 | 7235.07 | 70936.49 |
January1,2021 | 70936.49 | 8649.29 | 1555.64 | 7093.65 | 69380.85 |
January1,2022 | 69380.85 | 8649.29 | 1711.20 | 6938.09 | 67669.65 |
January1,2023 | 67669.65 | 8649.29 | 1882.33 | 6766.96 | 65787.32 |
January1,2024 | 65787.32 | 8649.29 | 2070.56 | 6578.73 | 63716.76 |
January1,2025 | 63716.76 | 8649.29 | 2277.61 | 6371.68 | 61439.15 |
January1,2026 | 61439.15 | 8649.29 | 2505.38 | 6143.91 | 58933.77 |
January1,2027 | 58933.77 | 8649.29 | 2755.91 | 5893.38 | 56177.86 |
January1,2028 | 56177.86 | 8649.29 | 3031.50 | 5617.79 | 53146.36 |
January1,2029 | 53146.36 | 8649.29 | 3334.65 | 5314.64 | 49811.70 |
January1,2030 | 49811.70 | 8649.29 | 3668.12 | 4981.17 | 46143.58 |
January1,2031 | 46143.58 | 8649.29 | 4034.93 | 4614.36 | 42108.65 |
January1,2032 | 42108.65 | 8649.29 | 4438.43 | 4210.86 | 37670.22 |
January1,2033 | 37670.22 | 8649.29 | 4882.27 | 3767.02 | 32787.96 |
January1,2034 | 32787.96 | 8649.29 | 5370.49 | 3278.80 | 27417.46 |
January1,2035 | 27417.46 | 8649.29 | 5907.54 | 2741.75 | 21509.92 |
January1,2036 | 21509.92 | 8649.29 | 6498.30 | 2150.99 | 15011.62 |
January1,2037 | 15011.62 | 8649.29 | 7148.13 | 1501.16 | 7863.49 |
January1,2038 | 7863.49 | 8649.29 | 7862.94 | 786.35 | 0.00 |
there will be no interest in 1st year as the installment is paid immediately
On January 1, 2019, ABC Corp. borrowed $81,000 by signing an installment loan. The loan will be...
Exercise 10-13 Installment note entries LO C1 On January 1, 2019, Eagle Company borrows $24,000 cash by signing a four-year, 8% installment note. The note requires four equal payments of $7,246, consisting of accrued interest and principal on December 31 of each year from 2019 through 2022. Prepare the journal entries for Eagle to record the note's issuance and the four payments. (Round your intermediate calculations and final answers to the nearest dollar amount.) 1 Eagle borrows $24,000 cash by signing a four-year,...
On January 1, 2019, Eagle Company borrows $35,000 cash by signing a four-year, 7% installment note. The note requires four equal payments of $10,333, consisting of accrued interest and principal on December 31 of each year from 2019 through 2022 Prepare the journal entries for Eagle to record the note's issuance and the four payments (Round your intermediate calculations and final answers to the nearest dollar amount.) View transaction list Eagle borrows $35,000 cash by signing a four-year, 7% installment...
On January 1, 2017, Eagle borrows $30,000 cash by signing a four-year, 7% installment note. The note requires four equal payments of $8,857, consisting of accrued interest and principal on December 31 of each year from 2017 through 2020. (Round your intermediate calculations and final answers to the nearest dollar amount.) Prepare the journal entries for Eagle to record the loan on January 1, 2017, and the four payments from December 31, 2017, through December 31, 2020. View transaction list...
On January 1, Shadow Fork Ranch borrowed $250,000 cash by signing a 10-year, 8% installment note requiring equal payments each December 31 of $37,258. What amount of interest expense will be included in the first annual payment? A. $17,258. B. $12,258. C. $20,000. D. $25,000.
19 On January 1, 2019, Eagle Company borrows $35,000 cash by signing a four-year, 7% installment note. The note requires four equal payments of $10,333, consisting of accrued interest and principal on December 31 of each year from 2019 through 2022. Prepare an amortization table for this installment note. (Round all amounts to the nearest whole dollar.) Payments points (E) ( 8 02:16:59 Period Ending Date 2019 (A) Beginning Balance (B) Debit Interest Expense (C) Debit Notes Payable (D) Credit...
On January 1, 2019, Eagle Company borrows $32,000 cash by signing a four-year, 9% installment note. The note requires four equal payments of $9,877, consisting of accrued interest and principal on December 31 of each year from 2019 through 2022. Prepare an amortization table for this installment note. (Round all amounts to the nearest whole dollar.)
On January 1, 2017, Eagle borrows $30,000 cash by signing a four-year, 7% installment note. The note requires four equal payments of $8,857, consisting of accrued interest and principal on December 31 of each year from 2017 through 2020. (Round your intermediate calculations and final answers to the nearest dollar amount.) Prepare the journal entries for Eagle to record the loan on January 1, 2017, and the four payments from December 31, 2017, through December 31, 2020. View transaction list...
On January 1, 2017, Eagle borrows $30,000 cash by signing a four-year, 7% installment note. The note requires four equal payments of $8,857, consisting of accrued interest and principal on December 31 of each year from 2017 through 2020. (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. beginning balance debit interest expense debit notes payable credit cash ending balance ***for 2017 2018 2019...
On January 1, 2016, Eagle borrows $100,000 cash by signing a four-year, 7% installment note. The note requires four equal total payments of accrued interest and principal on December 31 of each year from 2016 through 2019. 1. Compute the amount of each of the four equal total payments. 2. Prepare an amortization table for this installment note like the one in Exhibit 10.14. Use the information in Exercise 10-10 to prepare the journal entries for Eagle to record the...
On January 1, a company borrowed cash by issuing a $460,000, 4%, installment note to be paid in three equal payments at the end of each year beginning December 31. (FV of $1, PV of $1, FVA of $1, PVA of $1, FVAD of $1 and PVAD of $1) What would be the amount of each installment? Prepare an amortization table for the installment note. Prepare the journal entry for the second installment payment.