A $110,000 mortgage was amortized over 20 years by monthly repayments. The interest rate on the mortgage was fixed at 5.60% compounded semi-annually for the entire period. Full solutions should be shown on separate sheets of paper. Submit your solutions. a. Calculate the size of the payments rounded up to the next $100.

A $110,000 mortgage was amortized over 20 years by monthly repayments. The interest rate on the mortgage was fixed at 5.60% compounded semi-annually for the entire period. Full solutions should be shown on separate sheets of paper. Submit your solutions. a. Calculate the size of the payments rounded up to the next $100.

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

Using a spreadsheet program, create an amortization schedule for a 30-year mortgage of $500,000 at an annual interest rate of 4.24%. (a) In which month does the amount of principal in a monthly payment first exceed the amount of interest? (b) How much interest is repaid for the term of the loan? (Round your answer to the nearest cent.)
A mortgage for a condominium had a principal balance of $44, 700 that had to be amortized over the remaining period of 6 years. The interest rate was fixed at 4.42% compounded semi-annually and payments were made monthly. Full solutions should be shown on separate sheets of paper. Submit your solutions. a. Calculate the size of the payments. Round up to the next whole number b. If the monthly payments were set at $808, by how much would the time period of the mortgage shorten? year(s) months
Using a spreadsheet program, create an amortization schedule for a 30-year mortgage of $500,000 at an annual interest rate of 4.24%. (a) In which month does the amount of principal in a monthly payment first exceed the amount of interest? _____ (b) How much interest is repaid for the term of the loan? (Round your answer to the nearest cent.) _____$ (c) If the loan amount was $750,000 instead of $500,000, would the month in which the amount of principal in a monthly payment first exceeded the amount of interest change?
The balance on a mortgage was $42,600 and an interest rate of 4.25% compounded semi-annually was charged for the remaining 3-year term. Monthly payments were made to settle the mortgage. a. Calculate the size of the monthly payments. Round up to the next whole number b. If the monthly payments were set at $1,412, how long would it take to pay off the mortgage? Express the answer in years and months, rounded to the next payment period (C). If the monthly payments were set at $1,412, calculate the size of the final payment.
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.
Consider that you take out a $250,000, 15-year mortgage with 3.5% interest with monthly payments. Create the amortization schedule. (Show the first 3 payments) Payment # Payment Amount Interest Paid Principal Paid Remaining Balance
A borrower has taken out a 30-year mortgage for $104,000 at an annual rate of 12%. a. Use the table to find the monthly payment for this mortgage. b. Construct the first three lines of an amortization schedule for this mortgage. c. Assume that the borrower has decided to pay an extra $200 per month to pay off the mortga more quickly. Find the first three lines of your payment schedule under this assumption. Click the icon to view a table of monthly payments on a $1,000 loan. a. The monthly payments for this mortgage are $ (Type an integer or a decimal.) Enter your answer in the answer box and then click Check Answer. 6 parts remainino Olear All Cherk Answe javascript:doExercise(3): Copyright © 2020 Pearson Education Inc. All rights reserved. | 99 a 立

The balance on a mortgage was $48,200 and an interest rate of 4.50% compounded semi-annually was charged for the remaining 5-year term. Monthly payments were made to settle the mortgage. a. Calculate the size of the monthly payments. b. If the monthly payments were set at $998, how long would it take to pay off the mortgage? c. If the monthly payments were set at $998, calculate the size of the final payment.
A $180,000 mortgage was amortized over 20 years by monthly repayments. The interest rate on the mortgage was fixed at 4.20% compounded semi-annually for the entire period. a. Calculate the size of the payments rounded up to the next $100. Round up to the next 100 b. Using the payment from part a., calculate the size of the final payment. Round to the nearest cent
Using a spreadsheet program, create an amortization schedule for a 30-year mortgage of $500,000 an annual interest rate of 4.29%. (a) In which month does the amount of principal in a monthly payment first exceed the amount of interest? b) How much interest is repaid for the term of the loan? (Round your answer to the nearest cent.) tf the loan amount was $750,000 instead of $500,000, would the month in which the amount of principal in a monthly payment first exceeded the amount of interest change? Yes No
A $150,000 mortgage was amortized over 20 years by monthly repayments. The interest rate on the mortgage was fixed at 5.40% compounded semi-annually for the entire period. a. Calculate the size of the payments rounded up to the next $100. b. Using the payment from part a., calculate the size of the final payment
A fully amortizing mortgage loan is made for $84,000 at 6 percent interest for 25 years. Payments are to be made monthly. Required: a. Calculate monthly payments. b. Calculate interest and principal payments during month 1. c. Calculate total principal and total interest paid over 25 years. d. Calculate the outstanding loan balance if the loan is repaid at the end of year 10. e. Calculate total monthly interest and principal payments through year 10. f. What would the breakdown of interest and principal be during month 50?