House Mortgage Suppose you purchase a house for $592,978 and make a down payment of 14% of the purchase price. The balance is amortized over 22 years. The house mortgage agreement is subject to 3.3479% compounded semi-annually for the first four years and requires equal monthly payments. - What is the size of the equal monthly payments for the first four years? What is the house mortgage balance at the end of the four years? Perform this calculation using Excel, without an amortization schedule. After four years, the house mortgage is refinanced at a reduced nominal rate of 3.1469% compounded semi-annually and the house mortgage is amortized over the remainder of the term. What is the size of the new mortgage payments for the remainder of the term? What is the size of the final loan payment? Perform this calculation in Excel, without an amortization schedule. 1 Prepare one complete amortization schedule showing the mortgage amortized over the full 22-year period (reflecting the change in payment size). Cell reference values appropriately. ROUND all monetary values to the nearest cent Express only the totals as currency.

House Mortgage Suppose you purchase a house for $592,978 and make a down payment of 14% of the purchase price. The balance is amortized over 22 years. The house mortgage agreement is subject to 3.3479% compounded semi-annually for the first four years and requires equal monthly payments. - What is the size of the equal monthly payments for the first four years? What is the house mortgage balance at the end of the four years? Perform this calculation using Excel, without an amortization schedule. After four years, the house mortgage is refinanced at a reduced nominal rate of 3.1469% compounded semi-annually and the house mortgage is amortized over the remainder of the term. What is the size of the new mortgage payments for the remainder of the term? What is the size of the final loan payment? Perform this calculation in Excel, without an amortization schedule. 1 Prepare one complete amortization schedule showing the mortgage amortized over the full 22-year period (reflecting the change in payment size). Cell reference values appropriately. ROUND all monetary values to the nearest cent Express only the totals as currency.

EBK CONTEMPORARY FINANCIAL MANAGEMENT

14th Edition

ISBN:9781337514835

Author:MOYER

Publisher:MOYER

Chapter19: Lease And Intermediate-term Financing

Section: Chapter Questions

Problem 20P

See similar textbooks

Similar questions

Calculating single-payment loan amount due at maturity. Stanley Price plans to borrow 8,000 for five years. The loan will be repaid with a single payment after five years, and the interest on the loan will be computed using the simple interest method at an annual rate of 6 percent. How much will Stanley have to pay in five years? How much will he have to pay at maturity if hes required to make annual interest payments at the end of each year?
Cost of Bank Loan Mary Jones recently obtained an equipment loan from a local bank. The loan is for 15,000 with a nominal interest rate of 11%. However, this is an installment loan, so the bank also charges add-on interest. Mary must make monthly payments on the loan, and the loan is to be repaid in 1 year. What is the effective annual rate on the loan (assuming a 365-day year)?
Compound Interest Issues You are given the following situations: 1. Thomas Petty owes a debt of 7,000 from the purchase of a boat. The debt bears 12% interest payable annually. Thomas will pay the debt and interest in 5 annual installments beginning in 1 year. Calculate the equal annual installments that will pay off the debt and interest at 12% on the unpaid balance. 2. On January 1, 2019, John Cothran offers to buy Ruth Houses used tractor and equipment for 4,000 payable in 12 equal semiannual installments which are to include payment of 10% interest on the unpaid balance and payment of a portion of the principal with the first installment to be made on January 1, 2019. Calculate the amount of each of these installments. 3. Nadine Love invests in a 60,000 annuity at 12% compounded annually on March 1, 2019. The first of 15 receipts from the annuity is payable to Love on March 1, 2029, 10 years after the annuity is purchased and on the date Love expects to retire. Calculate the amount of each of the 15 equal annual receipts. Required: Using the appropriate tables, solve each of the preceding situations.
Marathon Peanuts converts a $130,000 account payable into a short-term note payable, with an annual interest rate of 6%, and payable in four months. How much interest will Marathon Peanuts owe at the end of four months? A. $2,600 B. $7,800 C. $137,800 D. $132,600
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.
Future Value Hugh Colson deposited 20,000 in a special savings account that provides for interest at the annual rate of 12% compounded semiannually if the deposit is maintained for 4 years. Required: Calculate the balance of the savings account at the end of the 4-year period.
If Bergen Air Systems takes out a $100,000 loan, with eight equal principal payments due over the next eight years, how much will be accounted for as a current portion of a noncurrent note payable each year?
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.
Lime Co. incurs a $4,000 note with equal principal installment payments due for the next eight years. What is the amount of the current portion of the noncurrent note payable due in the second year? A. $800 B. $1,000 C. $500 D. nothing, since this is a noncurrent note payable
Calculating interest and APR of installment loan. Assuming that interest is the only finance charge, how much interest would be paid on a 5,000 installment loan to be repaid in 36 monthly installments of 166.10? What is the APR on this loan?