You are planning on buying a new house and want to make sure you can afford the monthly payments. The house you picked will necessitate you borrow $300,000. You think you can get the following. mortgage terms: borrow $300,000 at a fixed quoted (nominal) annual rate of 3.775%; to be paid off in equal monthly payments over 15 years.Compute the required monthly payment, and prepare an amortization table, showing for each month the beginning balance, payment, payment applied to interest, payment applied to principal, and ending. balance. (Assume monthly compounding) (solution needs to be in excel)

You are planning on buying a new house and want to make sure you can afford the monthly payments. The house you picked will necessitate you borrow $300,000. You think you can get the following. mortgage terms: borrow $300,000 at a fixed quoted (nominal) annual rate of 3.775%; to be paid off in equal monthly payments over 15 years.Compute the required monthly payment, and prepare an amortization table, showing for each month the beginning balance, payment, payment applied to interest, payment applied to principal, and ending. balance. (Assume monthly compounding) (solution needs to be in excel)

EBK CONTEMPORARY FINANCIAL MANAGEMENT

14th Edition

ISBN:9781337514835

Author:MOYER

Publisher:MOYER

Chapter5: The Time Value Of Money

Section: Chapter Questions

Problem 15P

See similar textbooks

Similar questions

We suggest the use of a spreadsheet to create the amortization tables. You take out a 30-year mortgage for $70,000 at 9.45%, to be paid off monthly. Construct an amortization table showing how much you will pay in interest each year for the first 15 years and how much goes toward paying off the principal. If you sell your house after 15 years, how much will you still owe on the mortgage according to the amortization table? HINT [See Example 8.] (Round your answer to the nearest cent.) $
You plan to purchase a $130,000 house using a 15-year mortgage obtained from your local credit union. The mortgage rate offered to you is 5.25 percent. You will make a down payment of 20 percent of the purchase price. a. Calculate your monthly payments on this mortgage. b. Construct the amortization schedule for the first six payments.
You are considering an option to purchase or rent a single residential property. You can rent it for $2,000 per month and the owner would be responsible for maintenance, property insurance, and property taxes. Alternatively, you can purchase this property for $200,000 and finance it with an 80 percent mortgage loan at 4 percent fixed-rate interest that will fully amortize over a 30-year period. The loan requires monthly payments. The loan can be prepaid at any time with no penalty. You have done research in the market area and found that (1) properties have historically appreciated at an annual rate of 2 percent per year, and rents on similar properties have also increased at 2 percent annually; (2) maintenance and insurance are currently $1,500.00 each per year and they have been increasing at a rate of 3 percent per year; (3) you are in a 24 percent marginal tax rate and plan to occupy the property as your principal residence for at least four years; (4) the capital gains exclusion…
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 take out a $117,000, 20-year mortgage loan to buy a condo. The interest rate on the loan is 5%. To keep things simple, we will assume you make payments on the loan annually at the end of each year. a. What is your annual payment on the loan? b. Construct a mortgage amortization. c. What fraction of your initial loan payment is interest? d. What fraction of your initial loan payment is amortization? e. What is the total of the loan amount paid off after 10 years (halfway through the life of the loan)? f. If the inflation rate is 3%, what is the real value of the first (year-end) payment? g. If the inflation rate is 3%, what is the real value of the last (year-end) payment? h. Now assume the inflation rate is 6% and the real interest rate on the loan is unchanged. What must be the new nominal interest rate? i-1. Recompute the amortization table. i-2. What is the real value of the first (year-end) payment in this high-inflation scenario? j. What is the real value of the last…
You plan to obtain a $10000 loan from a furniture dealer at 10% annual interest rate that you will pay off in annual payments over five years. Determine the annual payments on this loan and complete the amortisation table.
You are considering purchasing a new home. You will need to borrow AED 4,000,000 to purchase the home. A mortgage company offers you a 10-year fixed rate mortgage at 12% APR. If you borrow the money from this mortgage company, what is your monthly mortgage payment
The Joneses are interested in purchasing a house listed at $580,000 in Thunder Bay. They are prepared to make a down payment of $200,000 and the rest of the money is financed by a mortgage offered by Royal Bank. The mortgage rate is 12% (APR compounded semiannually).a. What is the effective monthly rate on this mortgage?b. If the Joneses choose an amortization period of 10 years, what will be the monthly payment on their mortgage loan?c. What is the interest portion of the 25th payment? What is the principal portion of that payment? Please answer fast I give you upvote.
You want to buy a car, and a local bank will lend you $40,000. The loan will be fully amortized over 10 years, and the nominal interest rate will be 8% with interest paid annually. 1: What will be the annual loan payment? 2: Construct Amortization Schedule Table.
Suppose you are buying your first condo for $190,000, and you will make a $10,000 down payment. You have arranged to finance the remainder with a 30-year, monthly payment, amortized mortgage at 3.5% nominal interest rate, with the first payment due in one month. What will your monthly payments be? You are not required to show calculations. However to receive credit you must provide the inputs used (N, PMT, FV, I/Y, PV) to solve. If you utilize a template, you can copy and paste the section used in the submission. $808.28 $853.18 $527.78
You have been shopping for a new home. You have a choice of financing.You can choose either a $200,000 mortgage at 4.75 percent for 30 years, ora $200,000 mortgage at 3.5 percent for 15 years.a. Calculate the monthly payment for both the 30-year and 15-yearmortgages.b. Calculate the amount of interest paid over the life of the loan for bothmortgages.c. Choose the best mortgage for you and explain your answer.
Suppose you are buying your first condo for $180,000, and you will make a $15,000 down payment. You have arranged to finance the remainder with a 30-year, monthly payment, amortized mortgage at a 6.5% nominal interest rate, with the first payment due in one month. What will your monthly payments be?