You have been approved for a mortgage for a property. The mortgage is for a 20-year period with a 7.2% annual interest rate for a total amount of $1,700,000 What is the annual payment if payments are made annually What would you put in your annual cash flow if you were paying the mortgage on a monthly basis? What will be the interest and principal payments for the second and third years of the mortgage? What will be the remaining principal balance at the end of the fifth year? Answer question using excel formulas

You have been approved for a mortgage for a property. The mortgage is for a 20-year period with a 7.2% annual interest rate for a total amount of $1,700,000 What is the annual payment if payments are made annually What would you put in your annual cash flow if you were paying the mortgage on a monthly basis? What will be the interest and principal payments for the second and third years of the mortgage? What will be the remaining principal balance at the end of the fifth year? Answer question using excel formulas

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

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?
You purchase a home and have a $200,000 mortgage for 20 years at 5%. Utilize an amortization schedule. What are the periodic annual payment required for the mortgage? What are the interest payment for the first year? What is the first year principal repayment What is the balance owed at the end of the first year? What are the interest paid on the principal repayment for the second year ? What is the balance owed at the end of the second year ? Why did the interest paid on the principal repayment change in the second year?
(a) Find the monthly mortgage payment on a $170000 15-year mortgage if the interest rate on the loan is 3.81%. (b) How much will you pay in interest over the life of the loan if you pay the minimum monthly payment each month?
You plan to purchase a $310,000 house using a 15-year mortgage obtained from your bank. The mortgage rate offered to you is 5.10 percent. You will make a down payment of 20 percent of the purchase price. a. Calculate your monthly payments on this mortgage. b. (1) Construct the amortization schedule for the mortgage. b. (2) How much total interest is paid on this mortgage?
Suppose you are interested in taking an FHA mortgage loan for $250,000 in order to purchase your principal residence. In order to do so, you must pay an additional up-front mortgage insurance premium (UFMIP) of 1.0% of the mortgage balance. If the interest rate on the fully-amortizing mortgage loan is 5% and the term is 30 years and the UFMIP is financed (i.e., it is included in the loan amount), what is the dollar portion of your monthly mortgage payment that is designated to cover the UFMIP? A. $2,500.00B. $1,119.41C. $159.67D. $13.42
A mortgage has the following terms: Amount: $750,000 Rate: 6.25% Amortization (Years): 30 Term (Years): 20 Please determine the following: What is the Monthly Payment? In preparing an Income Statement, what is the Interest Expense for years 1 – 5? What is the Principal Balance at the end of year 6? What is the value of the loan at the expiration? If rates remain constant (flat), what would the benefit be to refinance this loan after year 10? do all the questions 1-5 and show the formulas in excel and show how you got it
Suppose you purchase a home and obtain a 30-year fixed-rate loan of $145,000 at an annual interest rate of 7.5%. Of the second month's mortgage payment, how much is applied to the principal?
a. What will be the monthly payment on a 30-year, $250,000 mortgage loan, where the interest rate is 6% per year, compounded monthly? How much interest is paid over the life of the loan? b. What will be the monthly payment on a 30-year, $250,000 mortgage loan, where the interest rate is 6% per year, compounded continuously? How much interest is paid over the life of the loan? c. What will be the monthly payment on a 15-year, $250,000 mortgage loan, where the interest rate is 6% per year, compounded monthly? How much interest is paid over the life of the loan?
What is the value accumulated at the end of 30 years if $300 deposited at the end of each month in a mutual fund account that earns 12 percent annually during the period. Ans. A mortgage calls for monthly payments of $970.30, including interest at 7.6 percent. The current value of the mortgage is $95,258.72. Approximately how long will it take to fully amortize the mortgage? Ans. An income-producing property is priced at $550,000 and is expected to generate the following after-tax cash flows: Year 1: $50,000; Year 2: $55,000; Year 3: $60,000 and $600,000. Calculate the annual IRR for this investment opportunity. Ans.
You plan to purchase a $320,000 house using a 15-year mortgage obtained from your bank. The mortgage rate offered to you is 5.20 percent. You will make a down payment of 15 percent of the purchase price. a. Calculate your monthly payments on this mortgage. b. (1) Construct the amortization schedule for the mortgage. b. (2) How much total interest is paid on this mortgage? Answer is not complete. Complete this question by entering your answers in the tabs below. Req A Req B1 Amortization Schedule Month 1 2 3 179 180 Construct the amortization schedule for the mortgage? (Do not round intermediate calculations. Round your answers to 2 decimal places. (e.g., 32.16)) Req 82 Total Interest Amortization Schedule for the 15-Year Mortgage Interest Cumulative Principal Principal 272,000.00 270,999.26 Cumulative Interest Ending 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 立

You borrow $300,000 to buy a house; if the annual interest rate is 4% and the term of the loan is 20 years, what is the annual payment required to retire the mortgage loan? Complete the loan amortization schedule for the first payment: Payment Interest Portion Principal Portion Ending Balance #1