Question

In: Accounting

Using excel! Hagrid buys a home for $230,000 and put $19000 down.  He finances the rest at...

Using excel!

Hagrid buys a home for $230,000 and put $19000 down.  He finances the rest at 6% for 30 years.  

If he refinances after 8 years at 3.95% how much will he save assuming he pays the original amount the whole time?

How many years total does it take to pay off the loan?

Solutions

Expert Solution

LOAN AMOUT 211000.00 (230000-19000)
(FOR 30 YEARS ASSUMING MONTHLY EQUAL INSTALLMENT )
IF HE CHOOSE TO PAY @6% FOR 30 YEARS
THEN HE WILL PAY EMI OF $1265 PER MONTH
AND TOTAL AMOUNT WILL BE $ 455419
AND IF HE REFINANCE AFTER 8 YEARS THEN PAY AT SAME EMI @ 3.95%
THEN TOTAL AMOUNT PAID BY HIM WILL BE $ 374545
1. TOTAL SAVING $80,874
2. TOTAL TIME TAKEN IN CASE OF REFINANCE 24 YEARS 8 MONTHS
Year Principal Interest Total Payment Balance Loan Paid To Date
(A) (B) (A + B)
2026 ? 8,014 ? 7,171 ? 15,186 ? 1,77,186 4.33%
2027 ? 8,337 ? 6,849 ? 15,186 ? 1,68,849 8.83%
2028 ? 8,672 ? 6,514 ? 15,186 ? 1,60,177 13.51%
2029 ? 9,021 ? 6,165 ? 15,186 ? 1,51,156 18.38%
2030 ? 9,384 ? 5,802 ? 15,186 ? 1,41,772 23.45%
2031 ? 9,761 ? 5,425 ? 15,186 ? 1,32,010 28.72%
2032 ? 10,154 ? 5,032 ? 15,186 ? 1,21,857 34.20%
2033 ? 10,562 ? 4,623 ? 15,186 ? 1,11,294 39.91%
2034 ? 10,987 ? 4,199 ? 15,186 ? 1,00,307 45.84%
2035 ? 11,429 ? 3,757 ? 15,186 ? 88,878 52.01%
2036 ? 11,889 ? 3,297 ? 15,186 ? 76,989 58.43%
2037 ? 12,367 ? 2,819 ? 15,186 ? 64,622 65.11%
2038 ? 12,864 ? 2,321 ? 15,186 ? 51,758 72.05%
2039 ? 13,382 ? 1,804 ? 15,186 ? 38,376 79.28%
2040 ? 13,920 ? 1,266 ? 15,186 ? 24,456 86.80%
2041 ? 14,480 ? 706 ? 15,186 ? 9,976 94.61%
2042 ? 9,976 ? 148 ? 10,124 ? 0 100.00%
Year Principal Interest Total Payment Balance Loan Paid To Date
(A) (B) (A + B)
2018 ? 2,591 ? 12,590 ? 15,181 ? 2,08,409 1.23%
2019 ? 2,751 ? 12,430 ? 15,181 ? 2,05,658 2.53%
2020 ? 2,921 ? 12,260 ? 15,181 ? 2,02,737 3.92%
2021 ? 3,101 ? 12,080 ? 15,181 ? 1,99,637 5.39%
2022 ? 3,292 ? 11,889 ? 15,181 ? 1,96,345 6.95%
2023 ? 3,495 ? 11,686 ? 15,181 ? 1,92,850 8.60%
2024 ? 3,711 ? 11,470 ? 15,181 ? 1,89,139 10.36%
2025 ? 3,939 ? 11,241 ? 15,181 ? 1,85,200 12.23%
2026 ? 4,182 ? 10,998 ? 15,181 ? 1,81,017 14.21%
2027 ? 4,440 ? 10,740 ? 15,181 ? 1,76,577 16.31%
2028 ? 4,714 ? 10,466 ? 15,181 ? 1,71,863 18.55%
2029 ? 5,005 ? 10,176 ? 15,181 ? 1,66,858 20.92%
2030 ? 5,314 ? 9,867 ? 15,181 ? 1,61,544 23.44%
2031 ? 5,641 ? 9,539 ? 15,181 ? 1,55,902 26.11%
2032 ? 5,989 ? 9,191 ? 15,181 ? 1,49,913 28.95%
2033 ? 6,359 ? 8,822 ? 15,181 ? 1,43,554 31.96%
2034 ? 6,751 ? 8,430 ? 15,181 ? 1,36,803 35.16%
2035 ? 7,167 ? 8,013 ? 15,181 ? 1,29,636 38.56%
2036 ? 7,609 ? 7,571 ? 15,181 ? 1,22,026 42.17%
2037 ? 8,079 ? 7,102 ? 15,181 ? 1,13,948 46.00%
2038 ? 8,577 ? 6,604 ? 15,181 ? 1,05,370 50.06%
2039 ? 9,106 ? 6,075 ? 15,181 ? 96,264 54.38%
2040 ? 9,668 ? 5,513 ? 15,181 ? 86,597 58.96%
2041 ? 10,264 ? 4,917 ? 15,181 ? 76,333 63.82%
2042 ? 10,897 ? 4,284 ? 15,181 ? 65,436 68.99%
2043 ? 11,569 ? 3,611 ? 15,181 ? 53,866 74.47%
2044 ? 12,283 ? 2,898 ? 15,181 ? 41,584 80.29%
2045 ? 13,040 ? 2,140 ? 15,181 ? 28,543 86.47%
2046 ? 13,845 ? 1,336 ? 15,181 ? 14,699 93.03%
2047 ? 14,699 ? 482 ? 15,181 ? 0 100.00%

Related Solutions

Using excel! Snape buys a home for $450000 and puts $50000 down.  He finances the rest at...
Using excel! Snape buys a home for $450000 and puts $50000 down.  He finances the rest at 5.4% for 30 years.  He begins paying an extra $700 per month after 5 years How much will he end up saving? When will it be paid off assuming he purchased the home June 1, 1999?
Using Excel! Professor McGonagall buys a home for $129,000 and puts $15000 down.  She finances the rest...
Using Excel! Professor McGonagall buys a home for $129,000 and puts $15000 down.  She finances the rest for 30 years at 4.25% If she refinances after 5 years at 3.9%, how much will she save assuming she keeps paying the original amount?
Using excel spreadsheets only! Malfoy buys a home down the street from Hagrid for $342,000 and...
Using excel spreadsheets only! Malfoy buys a home down the street from Hagrid for $342,000 and puts 10% down.  He finances the rest at 4.3% for 30 years.   He decides to refi after 11 years at 3.8%.  If he pays the original payment, how much does he save?
. Which option is better for your purchase of a $230,000 home with a 18% down...
. Which option is better for your purchase of a $230,000 home with a 18% down payment: A) Interest rate of 9.5% with a 15 year mortgage or B) Interest rate of 5.5% with a 30 year mortgage? *****To answer which is "better" you must address which option has a lower monthly payment, *AND* which option will cost you more interest by the end of the loan. ***** Using the simple interest formula, for *both options above*, calculate the interest...
A home is purchased for $169050. The homeowner pays $33810 down and finances the balance for...
A home is purchased for $169050. The homeowner pays $33810 down and finances the balance for 25 years at 7.25% compounded monthly. a. Find the size of the payments rounded up to the next cent. $ b. How much of the first payment is interest? $ c. How much is still owed on the loan just after 140 payments. $ d. What is the owner's equity after 140 payments? $ e. How much is owed just before the 140 payment...
A home is purchased for $134550. The homeowner pays $26910 down and finances the balance for...
A home is purchased for $134550. The homeowner pays $26910 down and finances the balance for 20 years at 8% compounded monthly. a. Find the size of the payments rounded up to the next cent. I calculated it to be 900.34, but it is wrong. b. How much is owed just before the 95 payment is actually made? I calculated it to be 23778.88 but it's also wrong. Just after 95 payments are made, the loan is refinanced at 6.5%...
A home is purchased for $134550. The homeowner pays $26910 down and finances the balance for...
A home is purchased for $134550. The homeowner pays $26910 down and finances the balance for 20 years at 8% compounded monthly. a. Find the size of the payments rounded up to the next cent. $   b. How much of the first payment is interest? $   c. How much is still owed on the loan just after 95 payments. $   d. What is the owner's equity after 95 payments? $   e. How much is owed just before the 95 payment...
A home is purchased for $153200. The homeowner pays $30640 down and finances the balance for...
A home is purchased for $153200. The homeowner pays $30640 down and finances the balance for 30 years at 7.5% compounded monthly. a. Find the size of the payments rounded up to the next cent. b. How much of the first payment is interest? c. How much is still owed on the loan just after 110 payments. d. What is the owner's equity after 110 payments? e. How much is owed just before the 110 payment is actually made? Just...
4. Joe Levi bought a home in Arlington, Texas, for $127,000. He put down 25% and...
4. Joe Levi bought a home in Arlington, Texas, for $127,000. He put down 25% and obtained a mortgage for 30 years at 8.00%. What is the difference in interest cost if he had obtained a mortgage rate of 6.00%? (Use Table 15.1.) (Use 360 days a year. Round your intermediate values and final answer to the nearest cent.) Difference $
Jackson is buying a house for $187,000. He puts 20% down then finances the balance for...
Jackson is buying a house for $187,000. He puts 20% down then finances the balance for 30 years at 2.75% interest. The monthly homeowners association dues are $115 per month. Home insurance totals $1712 per year, and annual taxes are $2740. Assuming home owner association fees, taxes and insurance are added monthly to the total house payment, find the total monthly amount that Jackson will pay for the house.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT