Please help me with this problem. Thanks Sam & Tony purchase a house. They find one that is selling for $450,000. They have been advised to make a 20% down payment. How much total interest will they pay if they take the full 20 years to pay off the mortgage with an interest rate of 3.75%? Please show the formula/work, Thanks
R=Monthly Payment
P= Principal
r- rate
n- number of payments per year
t=number of years
selling price is $450000
a down payment is 20%
so loan amount is



.

L=







..................Monthly
Payment
.
.
.
total interest is given by



..................
total interest
Please help me with this problem. Thanks Sam & Tony purchase a house. They find one...
Mortgage Analysis Part I You are planning to purchase a house that costs $480,000. You plan to put 20% down and borrow the remainder. Based on your credit score, you believe that you will pay 3.99% on a 30-year mortgage. Use the function “PMT” to calculate your mortgage payment. Calculate the total cost of the home purchase. (Down payment plus principal (loan amount) plus interest.) Calculate how much interest you will pay in total? Assume that you plan to pay...
Aya and Harumi would like to buy a house and their dream house costs $500,000. They have $50,000 saved up for a down payment but would still need to take out a mortgage loan for the remaining $450,000 and they’re not sure whether they could afford the monthly loan payments. The bank has offered them an interest rate of 4.25%, compounded monthly. How much would they have to be able to afford to pay each month in order to pay off...
This extended problem covers many of the features of a mortgage. You purchase a town house for $300,000. Since you are able to make a down payment of 20 percent ($60,000), you are able to obtain a $240,000 mortgage loan for 20 years at a 4 percent annual rate of interest. a. What are the annual payments that cover the interest and principal repayment? b. How much of the first payment goes to cover the interest? c. How much of...
The house you wish to buy costs Rs.30,000,000. Thedealer has a special leasing arrangement where you pay Rs.1,700,000 today and Rs.450,000 permonth for the next six years. If you purchase the house, you will pay it off in monthly paymentsover the next six years at required rate of return of 6 percent per annum. You believe that youwill be able to sell the house for Rs.35,000,000 in six years.Required to calculate and answer the following :1. What option will be...
Problem #2 (30%) To buy a house you ask a bank for a mortgage loan of $ 400,000, repayable in 30 years of monthly payments at a yearly interest rate of 3%. After 20 years (240 monthly payments) you decide to pay off the remainder of the loan. A) What is your monthly payment? B) What sum you must pay to the bank to extinguish your loan?
Mortgage Information Annual Interest Rate 4.90% Repayment Years 30 Price of House $275,000 Down Payment $55,000 Principal of Loan Monthly Payments On the Mortgage worksheet, use the PMT function in cell B7 to calculate the monthly payments of the mortgage. Use cell locations from this worksheet to define each argument of the function. Assumethat payments are made at the end of each month.On the Mortgage worksheet, use the data provided to enter a formula in cell B6 to calculate the...
You are planning to purchase a new house or condominium to use as your primary residence. This assignment will analyze some of the financial aspects of doing so. The final purchase price is $420,000 and, if you need a mortgage from the bank, your down payment will have to be 20% of the purchase price. The mortgage is a 30-year fixed rate loan with an Annual Percentage Rate (APR) of 6.00%. You will incur a one-time closing cost of $6,500...
You plan to purchase a $190,000 house using a 15-year mortgage obtained from your local credit union. The mortgage rate offered to you is 6.75 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 plan to purchase a $270,000 house using either a 30-year mortgage obtained from your local savings bank with a rate of 7.45...
Suppose you just purchase a new house for $550,000, with a 20% down payment. The mortgage has a 6.1 percent stated annual interest rate, compounded monthly, and calls for equal monthly payments over the next 30 years. Your first payment will be due in 1 month. However, the mortgage has an eight-year balloon payment, meaning that the balance of the loan must be paid off at the end of Year 8. Suppose there are no other transaction costs or finance...
Say that you purchase a house for 264,000 by getting a mortgage for 230,000 and Payne a down payment for 34,000. If you get a 20 year mortgage would it interest rate of 6% what is the monthly payments? What will the loan balance be in five years? if the house appreciates at 3% per year what will be the value of the house in five years?