You have taken a loan of $92,000.00 for 35 years at a 4.9% annual interest rate, with interest compounded quarterly. Fill in the amortization table below to show how the payments will be applied to interest and principal: (Round all answers to 2 decimal places. Please note the order of the headings in the table - make sure you put the answers in the appropriate columns as layed out below.)

You have taken a loan of $92,000.00 for 35 years at a 4.9% annual interest rate, with interest compounded quarterly. Fill in the amortization table below to show how the payments will be applied to interest and principal: (Round all answers to 2 decimal places. Please note the order of the headings in the table - make sure you put the answers in the appropriate columns as layed out below.)

Corporate Fin Focused Approach

5th Edition

ISBN:9781285660516

Author:EHRHARDT

Publisher:EHRHARDT

Chapter4: Time Value Of Money

Section4.17: Amortized Loans

Problem 1ST

See similar textbooks

Similar questions

Develop a complete amortization table for a loan of $4500, to be paid back in 24 uniform monthly installments, based on an interest rate of 6%. The amortization table must include the Payment Number, Principal Owed (beginning of period), Interest Owed in Each Period, Total Owed (end of each period), Principal Paid in Each Payment, Uniform Monthly Payment Amount. You must also show the equations used to calculate each column of thetable. You are encouraged to use spreadsheets. The entire table must be shown.
Prepare the first row of a loan amortization schedule based on the following information. The loan amount is for $24,323.00 with an annual interest rate of 15.77%. The loan will be repaid over 7.0 years with monthly payments. Find Loan payment: Interest portion: Principle portion: Loan balance after first monthly payment:
Prepare the first row of a loan amortization schedule based on the following information. The loan amount is for $17,900 with an annual interest rate of 09.00%. The loan will be repaid over 22 years with monthly payments. 1. What is the Loan Payment? 2. What portion of this payment is Interest? 3. What portion of this payment is Principal? 4. What is the Loan balance after first monthly payment?
Label all final answers with the correct units, if applicable. Unless otherwise stated, use 4 decimal places for intermediate computations of interest rates (if needed) then round off final answers to two decimal places. For monetary amounts, use 2 decimal places even for intermediate computations. 5. Juan takes out a 3-year multi-purpose loan for P200,000 from a loaning institution. The annual interest rate is 12.0% compounded monthly. a. Determine the monthly amortization for this loan. b. How much does he still owe after paying 6 installments? Show the table of diminishing balances as part of your solution. c. Due to the pandemic, the loaning institution offered a loan restructuring program in which a bor- rower's current loan balance can be recomputed with a reduced annual interest rate of 9.0%, with payment terms of up to 5 years. Juan decides to avail of this program. If he will pay off the remainder of his loan within 30 months, what will be his monthly installment under this…
A $23,970 loan is to be settled by making payments of $6,999 at the end of every six months. The interest is 7.58% compounded monthly. a) Find the number of payments in the term. N = b) Fill in the missing values of the amortization schedule below. Round off your answers to two decimal places. Enter a positive value for all answers. Payment Number 0 1 2 3 4 Payment Amount ($) PMT FA A A A Interest Portion ($) INT FA A $ Principal Portion ($) PRN $ A $ Loan Balance ($) BAL A A $23,970
Prepare an amortization schedule for a three-year loan of $99,000. The interest rate is 10 percent per year, and the loan calls for equal annual payments. How much total interest is paid over the life of the loan? (Leave no cells blank. Enter '0' where necessary. Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.) Year Beginning Balance Total Payment Interest Payment Principal Payment Ending Balance 1 2 3
You apply for a loan of $151,000 with the following terms: A 7-year loan with semi-annual payments of $14,800 (paid at the end of each period). Based on this information, what is the APR of this loan? (Note: All answers are rounded to two decimals) 4.53% 4.82% 8.42% 9.06% 8.78%
Prepare an amortization schedule for a three-year loan of $84,000. The interest rate is 9 percent per year, and the loan calls for equal annual payments. How much total interest is paid over the life of the loan? Note: Leave no cells blank. Enter '0' where necessary. Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16. Year 1 2 3 Beginning Balance Total Payment Total interest Interest Payment Principal Payment Ending Balance
Prepare an amortization schedule for a three-year loan of $96,000. The interest rate is 9 percent per year, and the loan calls for equal annual payments. How much total interest is paid over the life of the loan? (Leave no cells blank. Enter '0' where necessary. Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.) Year 1 2 3 Beginning Balance Total Payment Total interest Interest Payment Principal Payment Ending Balance
Prepare an amortization schedule for a five-year loan of $71,500. The interest rate is 7 percent per year, and the loan calls for equal annual payments. If you could show how to solve using a financial calculator that would be greatly apprectiated, thank you. YEAR BEGINNING BALANCE TOTAL PAYMENT INTEREST PAYMENT PRINCIPAL PAYMENT ENDING BALANCE 1 2 3 4 5
A $22,550 loan is to be settled by making payments of $6,862 at the end of every three months. The interest is 4.5% compounded semi-annually. a) Find the number of payments in the term. N b) Fill in the missing values of the amortization schedule below. Round off your answers to two decimal places. Enter a positive value for all answers. Payment Number 0 1 2 3 4 Payment Amount ($) PMT FA GA SA Interest Portion Principal Portion ($) INT ($) PRN SA GA = 6A SA SA $ $ $ Loan Balance ($) BAL GA GA $22,550
Use the amortization table to determine how much interest is paid in the first 4 months of the loan. Click the icon to view the amortization table. (Type an integer or a decimal.)