A homebuyer takes - out a loan in the amount of $500,000 for a term of 20 years at 6% APR, compounded monthly. A balance of $200,000 will remain and must be paid - off as a lump sum when the term expires. Complete the following: • Fill-in the rest of the below spreadsheet. Determine the total interest paid during the first year. Determine the total interest paid during the second year. Payment PMT IPMT PPMT Balance 0 $500,000.00 1 -$3,149.29 -$2,500.00 -$649.29 $499,350.71 2 ? ? ? ? 3 ? ? ? ? 4 ? ? ? ? 5 ? ? ? ? 6 ? ? ? ? 7 ? ? ? 8 ? ? ? ? ? 9 ? ? ? ? 10 ? ? ? 11 ? ? ? 12 ? ? ? 13 ? ? ? ? ? ? ? 14 ? ? ? ? 15 ? ? ? ? 16 ? ? ? ? 17 ? ? ? ? 18 ? ? ? ? 19 ? ? ? ? 20 ? ? ? ? 21 ? ? ? ? 22 ? ? ? ? 23 ? ? ? ? 24 ? ? ? ? First Year Total Interest ? Second Year ?

A homebuyer takes - out a loan in the amount of $500,000 for a term of 20 years at 6% APR, compounded monthly. A balance of $200,000 will remain and must be paid - off as a lump sum when the term expires. Complete the following: • Fill-in the rest of the below spreadsheet. Determine the total interest paid during the first year. Determine the total interest paid during the second year. Payment PMT IPMT PPMT Balance 0 $500,000.00 1 -$3,149.29 -$2,500.00 -$649.29 $499,350.71 2 ? ? ? ? 3 ? ? ? ? 4 ? ? ? ? 5 ? ? ? ? 6 ? ? ? ? 7 ? ? ? 8 ? ? ? ? ? 9 ? ? ? ? 10 ? ? ? 11 ? ? ? 12 ? ? ? 13 ? ? ? ? ? ? ? 14 ? ? ? ? 15 ? ? ? ? 16 ? ? ? ? 17 ? ? ? ? 18 ? ? ? ? 19 ? ? ? ? 20 ? ? ? ? 21 ? ? ? ? 22 ? ? ? ? 23 ? ? ? ? 24 ? ? ? ? First Year Total Interest ? Second Year ?

Intermediate Financial Management (MindTap Course List)

13th Edition

ISBN:9781337395083

Author:Eugene F. Brigham, Phillip R. Daves

Publisher:Eugene F. Brigham, Phillip R. Daves

Chapter22: Providing And Obtaining Credit

Section: Chapter Questions

Problem 1P: Cost of Bank Loan On March 1, Minnerly Motors obtains a business loan from a local bank. The loan is...

See similar textbooks

Similar questions

Homeland Plus specializes in home goods and accessories. In order for the company to expand its business, the company takes out a long-term loan in the amount of $650,000. Assume that any loans are created on January 1. The terms of the loan include a periodic payment plan, where interest payments are accumulated each year but are only computed against the outstanding principal balance during that current period. The annual interest rate is 8.5%. Each year on December 31, the company pays down the principal balance by $80,000. This payment is considered part of the outstanding principal balance when computing the interest accumulation that also occurs on December 31 of that year. A. Determine the outstanding principal balance on December 31 of the first year that is computed for interest. B. Compute the interest accrued on December 31 of the first year. C. Make a journal entry to record interest accumulated during the first year, but not paid as of December 31 of that first year.
McMasters Inc. specializes in BBQ accessories. In order for the company to expand its business, they take out a long-term loan in the amount of $800,000. Assume that any loans are created on January 1. The terms of the loan include a periodic payment plan, where interest payments are accumulated each year but are only computed against the outstanding principal balance during that current period. The annual interest rate is 9%. Each year on December 31, the company pays down the principal balance by $50,000. This payment is considered part of the outstanding principal balance when computing the interest accumulation that also occurs on December 31 of that year. A. Determine the outstanding principal balance on December 31 of the first year that is computed for interest. B. Compute the interest accrued on December 31 of the first year. C. Make a journal entry to record interest accumulated during the first year, but not paid as of December 31 of that first year.
Next Level Potter wishes to deposit a sum that at 12% interest, compounded semiannually, will permit 2 withdrawals: 40,000 at the end of 4 years and 50,000 at the end of 10 years. Analyze the problem to determine the required deposit, stating the procedure to follow and the tables to use in developing the solution.
On January 1, 2018, King Inc. borrowed $150,000 and signed a 5-year, note payable with a 10% interest rate. Each annual payment is in the amount of $39,569 and payment is due each Dec. 31. What is the journal entry on Jan. 1 to record the cash received and on Dec. 31 to record the annual payment? (You will need to prepare the first row in the amortization table to determine the amounts.)
Whole Leaves wants to upgrade their equipment, and on January 24 the company takes out a loan from the bank in the amount of $310,000. The terms of the loan are 6.5% annual interest rate, payable in three months. Interest is due in equal payments each month. Compute the interest expense due each month. Show the journal entry to recognize the interest payment on February 24, and the entry for payment of the short-term note and final interest payment on April 24. Round to the nearest cent if required.
Samuel Ames owes 20,000 to a friend. He wants to know how much he would have to pay if he paid the debt in 3 annual installments at the end of each year, which would include interest at 14%. Draw a time line for the problem. Indicate what table to use. Look up the table value and place it in a brief formula. Solve.
Sub-Cinema Inc. borrowed $10,000 on Jan. 1 and will repay the loan with 12 equal payments made at the end of the month for 12 months. The interest rate is 12% annually. If the monthly payments are $888.49, what is the journal entry to record the cash received on Jan. 1 and the first payment made on Jan. 31?
Cost of Bank Loan On March 1, Minnerly Motors obtains a business loan from a local bank. The loan is a 25,000 interest-only loan with a nominal rate of 11%. Interest is calculated on a simple interest basis with a 365-day year. What is Minnerlys interest charge for the first month (assuming 31 days in the month)?
Jain Enterprises honors a short-term note payable. Principal on the note is $425,000, with an annual interest rate of 3.5%, due in 6 months. What journal entry is created when Jain honors the note?
A customer takes out a loan of $130,000 on January 1, with a maturity date of 36 months, and an annual interest rate of 11%. If 6 months have passed since note establishment, what would be the recorded interest figure at that time? A. $7,150 B. $65,000 C. $14,300 D. $2,383
Mohammed LLC is a growing consulting firm. The following transactions take place during the current year. A. On June 10, Mohammed borrows $270,000 from a bank to cover the initial cost of expansion. Terms of the loan are payment due in four months from June 10, and annual interest rate of 5%. B. On July 9, Mohammed borrows an additional $100,000 with payment due in four months from July 9, and an annual interest rate of 12%. C. Mohammed pays their accounts in full on October 10 for the June 10 loan, and on November 9 for the July 9 loan. Record the journal entries to recognize the initial borrowings, and the two payments for Mohammed.
Pickles R Us is a pickle farm located in the Northeast. The following transactions take place: A. On November 6, Pickles borrows $820,000 from a bank to cover the initial cost of expansion. Terms of the loan are payment due in six months from November 6, and annual interest rate of 3%. B. On December 12, Pickles borrows an additional $200,000 with payment due in three months from December 12, and an annual interest rate of 10%. C. Pickles pays its accounts in full on March 12, for the December 12 loan, and on May 6 for the November 6 loan. Record the journal entries to recognize the initial borrowings, and the two payments for Pickles.