Conchita has made a $210,400 loan for a home. Her 25-year fixed-rate loanan interest rate of 5.25%, Create an amortization schedule for the first two payments.E Click the icon to view the table to find the monthly payment of principal and interest per $1,000 of the amount financed.Complete the table for the first month below,MonthlypaymentEnd-of-monthMonthInterestPrincipalprincipal(Round to the nearest cent as needed.) YearsAnnual interest ratefinanced 4.00% 4.25% 4.50% 4.75% 5.00% 5.25% 5.50% 5.75% 6.00% 6.25% 6.50% 6.75% 7.00% 7.25% 7.50% 7.75%1010.1210.2410.3610.4810.6110.7310.8510.9811.1011.2311.3511.4811.6111.7411.8712.00128.768.889.009.129.259.379.509.639.7610.699.898.577.9710.0210.1510.2810.4210.55157.407.527.657.787.918.448.047.426.746.398.178.308.718.858.999.139.279.417.697.026.68176.766.897.027.157.297.567.838.118.258.408.548.698.836.196.607.608.217.907.55206.066.336.466.887.167.317.467.757.908.067.757.396.996.987.597.236.826.56225.705.845.976.116.256.546.837.137.287.43255.285.425.565.705.855.996.146.296.446.606.916.756.326.047.07304.774.925.075.225.375.525.685.846.006.166.496.657.16354.434.584.734.895.055.215.375.545.705.876.216.396.746.92

Using excel PMT function for monthly payment

Conchita has made a $210,400 loan for a home. Her 25-year fixed-rate loan has an interest rate of 5.25%. Create an amortization schedule for the first two payments. E Click the icon to view the table to find the monthly payment of principal and interest per $1,000 of the amount financed. Complete the table for the first month below. Monthly payment End-of-month Month Interest Principal principal (Round to the nearest cent as needed.)

Conchita has made a $210,400 loan for a home. Her 25-year fixed-rate loan has an interest rate of 5.25%. Create an amortization schedule for the first two payments. E Click the icon to view the table to find the monthly payment of principal and interest per $1,000 of the amount financed. Complete the table for the first month below. Monthly payment End-of-month Month Interest Principal principal (Round to the nearest cent as needed.)

Principles of Accounting Volume 1

19th Edition

ISBN:9781947172685

Author:OpenStax

Publisher:OpenStax

Chapter12: Current Liabilities

Section: Chapter Questions

Problem 11EB: Whole Leaves wants to upgrade their equipment, and on January 24 the company takes out a loan from...

See similar textbooks

Similar questions

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.
Halep Inc. borrowed $30,000 from Davis Bank and signed a 4-year note payable stating the interest rate was 4% compounded annually. Halep Inc. will make payments of $8,264.70 at the end of each year. Prepare an amortization table showing the principal and interest in each payment.
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.)
Calculating and comparing add-on and simple interest loans. Eli Nelson is borrowing 10,000 for five years at 7 percent. Payments, which are made on a monthly basis, are determined using the add-on method. a. How much total interest will Eli pay on the loan if it is held for the full five-year term? b. What are Elis monthly payments? c. How much higher are the monthly payments under the add-on method than under the simple interest method?
Scrimiger Paints wants to upgrade its machinery and on September 20 takes out a loan from the bank in the amount of $500,000. The terms of the loan are 2.9% annual interest rate and payable in 8 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 October 20, and the entry for payment of the short-term note and final interest payment on May 20. Round to the nearest cent if required.
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.
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.
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?
Using the information provided, what transaction represents the best application of the present value of an annuity due of $1? A. Falcon Products leases an office building for 8 years with annual lease payments of $100,000 to be made at the beginning of each year. B. Compass, Inc., signs a note of $32,000, which requires the company to pay back the principal plus interest in four years. C. Bahwat Company plans to deposit a lump sum of $100.000 for the construction of a solar farm In 4 years. D. NYC Industries leases a car for 4 yearly annual lease payments of $12,000, where payments are made at the end of each year.
Sharapovich Inc. borrowed $50,000 from Kerber Bank and signed a 5-year note payable stating the interest rate was 5% compounded annually. Sharapovich Inc. will make payments of $11,548.74 at the end of each year. Prepare an amortization table showing the principal and interest in each payment.
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.
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.