This assignment is a little different than the other assignments, because this one is fairly computational. This assignment is one big question with 13 parts – each part builds on the previous part. The assignment is set up so you can see the previous and later parts of the assignment, but can submit one part at a time.
1]
Down payment = cost of house * down payment %
Down payment = $500,000 * 20% = $100,000
2]
Mortgage loan amount = cost of house - down payment
Mortgage loan amount = $500,000 - $100,000 = $400,000
3]
Monthly loan payment is calculated using PMT function in Excel :
rate = 5% / 12 (converting annual rate into monthly rate)
nper = 30*12 (30 year loan with 12 monthly payments each year)
pv = 400000 (loan amount)
PMT is calculated to be $2,147.29
4]
Total interest paid = (monthly payment * total number of payments) - loan amount
Total interest paid = ($2,147.29 * (30*12)) - $400,000
Total interest paid = $373,023.14
This assignment is a little different than the other assignments, because this one is fairly computational....
[2 points] Suppose that 15 years ago you bought a home for $500,000, paying 20% as a down payment, and financing the rest at 5% interest for 30 years. How much money did you pay as your down payment? [2 points] How much money was your existing mortgage (loan) for? [2 points] What is your current monthly payment on your existing mortgage? Note: Carry at least 4 decimal places during calculations, but round your final answer to the nearest cent....
Please help me! I am very lost in trying to figure all of this out! 1. Suppose that 10 years ago you bought a home for $150,000, paying 10% as a down payment, and financing the rest at 8% interest for 30 years. How much money did you pay as your down payment? 2. How much money was your existing mortgage (loan) for? 3. What is your current monthly payment on your existing mortgage? Note: Carry at least 4 decimal...
Question 4: Application of Time Value of Money to Mortgages (30 marks) Shanna wants to buy a house costing $325,000 and has obtained a loan from TD Bank. A minimum down payment of 15% would be required and the bank will provide the difference. Her grandparent have told her that they will cover her down payment. a. TD Bank has quoted her mortgage interest rate is 4.5%; this rate would be compounded semi- annually, while her payments would be made...
4. A. What would be your monthly mortgage payment if you pay for a $250,000 home by making a 20% down payment and then take out a 3.74% thirty year fixed rate mortgage loan where interest is compounded monthly to cover the remaining balance. All work must be shown justifying the following answers. Mortgage payment = B. How much total interest would you have to pay over the entire life of the loan. Total interest paid = C. Suppose you inherit some money and...
Suppose you are two years into a 30-year mortgage at 4.125%. Your minimal monthly payment is $710.79 and your remaining balance on the loan is $141,500. You've been offered a deal to refinance to a 15 year mortgage at 3.125% with no closing costs. To determine if you should refinance, answer the following. (A) What is the monthly payment on a 15 year mortgage for $141,500 at 3.125% interest? (B) If you were to make the minimum monthly payments on...
Ten years ago you obtained a 30-year mortgage for $400,000 with a fixed interest rate of 3% APR compounded monthly. The mortgage is a standard fixed rate mortgage with equal monthly payments over the life of the loan. What are the monthly fixed mortgage payments on this mortgage (i.e., the minimum required monthly payments to pay down the mortgage in 30 years)? What is the remaining loan balance immediately after making the 120th monthly payment (i.e., 10 years after initially...
5. Calculating Take-home Pay, and Length of Savings: Because it is such a large amount, most people, when deciding to buy a home, need to plan ahead and start saving for the down payment. Using the average starting salary in the career you chose after graduation as a guideline (from #2), calculate your monthly take-home pay; this is your net monthly pay after you have an average of 30% taken out for income taxes. Monthly take-home (net) pay after 30%...
1. You want to buy a $249,000 home. You plan to pay 5% as a down payment, and take out a 30 year loan for the rest. a) How much is the loan amount going to be? $ b) What will your monthly payments be if the interest rate is 6%? $ c) What will your monthly payments be if the interest rate is 7%? $ 2. You can afford a $1150 per month mortgage payment. You've found a 30...
The mortgage on your house is five years old. It required monthly payments of $ 1,422, had an original term of 30 years and had an interest rate of 9% (APR). In the intervening five years, interest rates have fallen and so you have decided to refinance, that is, you will roll over the outstanding balance into a new mortgage. The new mortgage has a 30-year term, requires monthly payments, and has an interest rate of 6.125 % (APR). a....
do I have it right Part 1: Mortgage A mortgage is a loan used to purchase a home. It is bedover a period of 1,20 or 30 years. The interest rate is determined by the term of the l e ngth of time to pay back the loan) and the credit rating of the person borrowing the money Once a person signs the documents to borrow money for a home the presented we amortization table or schedule for the mortgage...