Question

In: Finance

You purchased a house five years ago and borrowed $400,000 . The loan you used has...

You purchased a house five years ago and borrowed $400,000 .
The loan you used has 300 more monthly payments of $1,686 each, starting next month, to pay off the loan.
You can take out a new loan for $355,625 at 2.00% APR compounded monthly , with 300 more payments, starting next month to pay off this new loan.
If your investments earn 2.75% APR compounded monthly , how much will you save in present value terms by using the new loan to pay-off the original loan?

There may be rounding in this case, so pick the closest answer.

Solutions

Expert Solution

I HAVE SOLVED USING FINANCIAL FORMULA AS WELL AS USING EXCEL FUNCTION


Related Solutions

You purchased a house five years ago and borrowed $400,000 . The loan you used has...
You purchased a house five years ago and borrowed $400,000 . The loan you used has 300 more monthly payments of $1,686 each, starting next month, to pay off the loan. You can take out a new loan for $355,625 at 2.00% APR compounded monthly , with 300 more payments, starting next month to pay off this new loan. If your investments earn 2.75% APR compounded monthly , how much will you save in present value terms by using the...
You purchased a house five years ago and borrowed $250,000 . The loan you used has...
You purchased a house five years ago and borrowed $250,000 . The loan you used has 300 more monthly payments of $1,194 each, starting next month, to pay off the loan. You can take out a new loan for $226,119 at 3.00% APR compounded monthly , with 300 more payments, starting next month to pay off this new loan. and pay off the old loan. If your investments earn 3.00% APR compounded monthly , how much will you save in...
Five years ago you borrowed $100,000 to finance the purchase of a $120,000 house. The interest...
Five years ago you borrowed $100,000 to finance the purchase of a $120,000 house. The interest rate on the old mortgage is 10%. Payment terms are being made monthly to amortize the loan over 30 years. You have found another lender who will refinance the current outstanding loan balance at 8% with monthly payments for 30 years. The new lender will charge two discount points on the loan. Other refinancing costs will equal $3,000. There are no prepayment penalties associated...
Five years ago, Richard borrowed $300,000 to purchase a house inSandy Lake. At the time,...
Five years ago, Richard borrowed $300,000 to purchase a house in Sandy Lake. At the time, the quoted rate on the mortgage was 6 percent, the amortization period was 25 years, the term was 5 years, and the payments were made monthly. Now that the term of the mortgage is complete, Richard must renegotiate his mortgage. If the current market rate for mortgages is 8 percent, what is Richard’s new monthly payment? (Round effective monthly rate to 6 decimal places,...
Five years ago, Richard borrowed $300,000 to purchase a house in Sandy Lake. At the time,...
Five years ago, Richard borrowed $300,000 to purchase a house in Sandy Lake. At the time, the quoted rate on the mortgage was 6 percent, the amortization period was 25 years, the term was 5 years, and the payments were made monthly. Now that the term of the mortgage is complete, Richard must renegotiate his mortgage. If the current market rate for mortgages is 8 percent, what is Richard’s new monthly payment? (Round effective monthly rate to 6 decimal places,...
you borrowed 100,000 exactly 5 years ago. the loan is structured as an amortized loan. the...
you borrowed 100,000 exactly 5 years ago. the loan is structured as an amortized loan. the interest rate is 6 % and you make quarterly (end of quarter) payments of 1937.06. the loan is amortized over 25 years. how much principal have you paid over the first 5 years ?
You bought your house five years ago and you believe you will be in the house...
You bought your house five years ago and you believe you will be in the house only about five more years before it gets too small for your family. Your original home value when you bought it was $500,000, you paid 10 percent down, and you financed closing costs equal to 3 percent of the mortgage amount. The mortgage was a 25-year fixed- rate mortgage with a 5 percent annual interest rate. Rates on 30-year mortgages are now at 3...
Five years ago, Jason purchased a $400,000 life insurance policy on his life. For each of...
Five years ago, Jason purchased a $400,000 life insurance policy on his life. For each of the following, indicate how much of the $400,000 policy proceeds are included in his gross estate. a) The proceeds are payable to his estate. b) The proceeds were paid to his daughter, but Jason retained the right to change beneficiaries. c) $100,000 of the proceeds are used to pay debts of his estate with the balance paid to his daughter. Jason retained no rights...
9 years ago you borrowed $147695 to buy a house. The interest rate quoted to you...
9 years ago you borrowed $147695 to buy a house. The interest rate quoted to you was 6.26 percent for 30 years with monthly payments. Assuming you have made regular monthly payments up to now, what is the amount (in $) you still owe on the loan today? Answer to two decimals. Hint: The hard way to do this is to use an amortization table. There is an easier way - see if you can find it. Can you explain...
You borrowed $10,000 two years ago. The loan terms are: 5-year loan with APR of 12%...
You borrowed $10,000 two years ago. The loan terms are: 5-year loan with APR of 12% and with monthly payments of $222.44. Today, you decided you want to pay off the loan in 20 months rather than the remaining life of the loan. How much more do you have to add to your monthly payment in order to accomplish it? Write out your answer in the space provided. MAKE SURE TO SHOW HOW YOU OBTAIN THE ANSWER (STEPS NECESSARY). If...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT