Please show all steps in excel to solve this. Five years ago, Charles purchased a house for $500,000. Charles borrowed a mortgage with 80% of LTV (loan to value ratio). The interest rate on the mortgage is 5%. Payment terms are being made monthly to amortize the loan over 30 years. Charles has found another lender who will refinance the current outstanding loan balance at 4.0% with monthly payments for 30 years. The new lender will charge two discount points on the new loan. Other refinancing costs will equal $2,000. What is the monthly payment for the current loan? What is the new loan amount if Charles chooses to refinance? What is the monthly payment for the new loan? What is the effective cost of Charles new loan if he holds the loan for 30 years? If Charles wants to refinance today, at least how many years should he stay in the house (do not prepay)? Explain?
Please show all steps in excel to solve this. Five years ago, Charles purchased a house for $500,000. Charles borrowed a mortgage with 80% of LTV (loan to value ratio). The interest rate on the mortgage is 5%. Payment terms are being made monthly to amortize the loan over 30 years. Charles has found another lender who will refinance the current outstanding loan balance at 4.0% with monthly payments for 30 years. The new lender will charge two discount points on the new loan. Other refinancing costs will equal $2,000. What is the monthly payment for the current loan? What is the new loan amount if Charles chooses to refinance? What is the monthly payment for the new loan? What is the effective cost of Charles new loan if he holds the loan for 30 years? If Charles wants to refinance today, at least how many years should he stay in the house (do not prepay)? Explain?
Chapter4: Time Value Of Money
Section: Chapter Questions
Problem 25PROB
Related questions
Question
Please show all steps in excel to solve this.
Five years ago, Charles purchased a house for $500,000. Charles borrowed a mortgage with 80% of LTV (loan to value ratio). The interest rate on the mortgage is 5%. Payment terms are being made monthly to amortize the loan over 30 years. Charles has found another lender who will refinance the current outstanding loan balance at 4.0% with monthly payments for 30 years. The new lender will charge two discount points on the new loan. Other refinancing costs will equal $2,000.
- What is the monthly payment for the current loan?
- What is the new loan amount if Charles chooses to refinance?
- What is the monthly payment for the new loan?
- What is the effective cost of Charles new loan if he holds the loan for 30 years?
- If Charles wants to refinance today, at least how many years should he stay in the house (do not prepay)? Explain?
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 1 steps
Recommended textbooks for you