On 1/1/19, Lantana Loan Co., a calendar-year company, accepts a 5%, $500,000 three-year loan that pays interest semi-annually on 6/30 and 12/31 from Diamond Distributors, when the market rate of interest was 10%. In exchange for the note, Diamond agrees to make semi-annual Interest payments and repay the full $500,000 at maturity. Complete the amortization table for this note, then complete all journal entries for 2019. Answer: Beginning note balance is calculated using Excel PV function with the following inputs: Amortization Table:

On 1/1/19, Lantana Loan Co., a calendar-year company, accepts a 5%, $500,000 three-year loan that pays interest semi-annually on 6/30 and 12/31 from Diamond Distributors, when the market rate of interest was 10%. In exchange for the note, Diamond agrees to make semi-annual Interest payments and repay the full $500,000 at maturity. Complete the amortization table for this note, then complete all journal entries for 2019. Answer: Beginning note balance is calculated using Excel PV function with the following inputs: Amortization Table:

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Assume that on September 1, 2022, Brannigan, which has a year-end of December 31, borrows $120,000,000 on a three-year, 7%note. The note requires annual interest payments and repayment ofthe principal plus the final year's interest at the end of the thirdyear.Even though no payment is due on December 31, interest must beaccrued for the period
The payment necessary to amortize a 4.9% loan of $86,000 compounded annually, with 4 annual payments is $24,196.70. The total of the payments is $96,786.80 with a total interest payment of $10,786.80. The borrower made larger payments of $25,000.00. Calculate (a) the time needed to pay off the loan, (b) the total amount of the payments, and (c) the amount of interest saved. a. The time needed to pay off the loan with payments of $25,000.00 is _____ years. (Round up to the nearest year.) b. The total amount of the payments is $______ (Round to the nearest cent as needed.) c. The amount of interest saved is $______. (Round to the nearest cent as needed.)
Culver Inc. bought an Internet domain name by issuing a $276,000, 6-year, non-interest-bearing note to Ti-Mine Corp. with an effective yield of 10%. The note is repayable in 6 annual payments of $46,000 made at the end of each year. Click here to view the factor table PRESENT VALUE OF 1. Click here to view the factor table PRESENT VALUE OF AN ANNUITY OF 1. Prepare the journal entry to record the purchase of the intangible asset. (Round factor values to 5 decimal places, eg. 1.25124 and final answer to O decimal places, eg. 5,275. Credit account titles are automatically indented when the amount is entered. Do not indent manually. If no entry is required, select "No entry" for the account titles and enter O for the amounts.) Account Titles and Explanation Debit Credit Notes Payable
On 12-31-21, Austin entered into an agreement that required Austin to pay a supplier $4,000 every year on 12-31 until 12-31-30. The agreement required Austin to make the first annual payment on 12-31-24. Assume the market rate of interest for Austin is 6%. As of 12-31-21 what was the present value of Austin's obligation?
2. C-type Company receives $ 400,000 when it issues 6% mortgage note payable for 4 years to finance the construction of a building at December 31, 2020. The term provides for semiannual installment payment of 34,000 (including real estate tax and insurance $1900) on June 30 and December 31. Instructions: i. Prepare an installment payments schedule for the first 4 years. Prepare entries for the mortgage loan and first installment payment. Show the Balance sheet representation at December 31, 2020. ii. iii.
Blue Skies Bank of Florida issues a three-month (90-day) negotiable CD in the amount of $20 million to ABC Insurance Company at a negotiated annual interest rate of 2.75 percent (360 day basis). Calculate the value of this CD account on the day it matures and the amount of interest income ABC will earn. What interest return will ABC Insurance earn in a 365 day year? write the laws pleas
Boyd Co. produces and sells aviation equipment. On the first day of its fiscal year, Boyd issued $83,000,000 of five-year, 8% bonds at a market (effective) interest rate of 10%, with interest payable semiannually. This information has been collected in the Microsoft Excel Online file. The amount of discount to be amortized for the first semiannual interest payment period, using the interest method. Round your answer to the nearest dollar.
The payment necessary to amortize a 4.5% loan of $81,000 compounded annually, with 5 annual payments is $18,451.12. The total of the payments is $92,255.60 with a total interest payment of $11,255.60. The borrower made larger payments of $19,000.00. Calculate (a) the time needed to pay off the loan, (b) the total amount of the payments, and (c) the amount of interest saved. Thank you~
On January 1, 2021, Tropical Paradise borrows $33,000 by agreeing to a 6%, four-year note with the bank. The funds will be used to purchase a new BMW convertible for use in promoting resort properties to potential customers. Loan payments of $775.01 are due at the end of each month with the first installment due on January 31, 2021. Record the issuance of the installment note payable and the first two monthly payments. (Do not round intermediate calculations. Round your final answers to 2 decimal places. If no entry is required for a particular transaction/event, select "No Journal Entry Required" in the first account field.)
To pay for remodeling, the company will take out a $500,000 five-year loan at 9.5% interest, compounded quarterly. The terms of the loan have been entered in the Loan Analysis worksheet. In cell B8, calculate the quarterly payment on the loan based on the loan conditions already entered. Complete the amortization schedule in cells B11 through E30. Column B contains the interest payment for each quarter, and column C contains the principal payment. Column D contains the remaining principal at the start of each month. The initial principal remaining is $500,000. The subsequent remaining principal values are reduced by the principal payment made in the previous quarter. Calculate the ending balance in cell D31. Use the IPMT function in cell B11 to calculate the interest amount paid per period. Copy this formula to cell B30. Use the PPMT function in cell C11 to calculate the principal amount paid per period. Copy this formula to cell C30. Write a formula in cell D11 to indicate the…
Cullumber Electronics issues a $355,500, 3%, 10-year mortgage note on December 31, 2021. The proceeds from the note are to be used in financing a new research laboratory. The terms of the note provide for annual installment payments, exclusive of real estate taxes and insurance, of $41,675. Payments are due on December 31. (a) Prepare an installment payments schedule for the first 4 years. (Round answers to 0 decimal places, e.g. 15,250.) Annual Interest Period Cash Payment Interest Expense Reduction of Principal Principal Balance Issue Date $enter a dollar amount 1 $enter a dollar amount $enter a dollar amount $enter a dollar amount enter a dollar amount 2 enter a dollar amount enter a dollar amount enter a dollar amount enter a dollar amount 3 enter a dollar amount enter a dollar amount enter a dollar amount enter a dollar amount 4 enter a dollar amount…
To pay for remodeling, the company will take out a $500,000 five-year loan at 9.5% interest, compounded quarterly. The terms of the loan have been entered in the Loan Analysis worksheet. In cell B8, calculate the quarterly payment on the loan based on the loan conditions already entered. Complete the amortization schedule in cells B11 through E30. Column B contains the interest payment for each quarter, and column C contains the principal payment. Column D contains the remaining principal at the start of each month. The initial principal remaining is $500,000. The subsequent remaining principal values are reduced by the principal payment made in the previous quarter. Calculate the ending balance in cell D31. Use the IPMT function in cell B11 to calculate the interest amount paid per period. Copy this formula to cell B30. Use the PPMT function in cell C11 to calculate the principal amount paid per period. Copy this formula to cell C30. Write a formula in cell D11 to indicate the…