Five years ago, Sam purchased a house of $500,000. Sam borrows 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. Sam 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. Please show how to solve using excel and excel formulas a. What is Sam's monthly payment for the current loan? b. What is the new loan amount if Sam chooses to refinance? c. What is Sam's monthly payment for the new loan? d. What is the effective cost of Sam's new loan if he holds the loan for 30 years? e. If Sam wants to refinance today, at least how many years should he stay in the house (do not prepay)? Explain?

Five years ago, Sam purchased a house of $500,000. Sam borrows 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. Sam 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. Please show how to solve using excel and excel formulas a. What is Sam's monthly payment for the current loan? b. What is the new loan amount if Sam chooses to refinance? c. What is Sam's monthly payment for the new loan? d. What is the effective cost of Sam's new loan if he holds the loan for 30 years? e. If Sam wants to refinance today, at least how many years should he stay in the house (do not prepay)? Explain?

EBK CONTEMPORARY FINANCIAL MANAGEMENT

14th Edition

ISBN:9781337514835

Author:MOYER

Publisher:MOYER

Chapter19: Lease And Intermediate-term Financing

Section: Chapter Questions

Problem 19P

See similar textbooks

Similar questions

Amna has a housing loan of $50,000 over 15 years with a 6% interest rate. According to the Bank he will be paying $422 monthly on this loan. What is the amount of interest and principal for the first and second installment? Assume that you have saved money for a down payment on your dream house, but you still need to borrow $12000 from your bank to complete the deal. The bank offers you a 30-year mortgage at an annual rate of 7%. Calculate a) Monthly payment/EMI b) Principal Amount and Interest for the first three months. Answer as soon as possible plsss!!
Stephen has just purchased a home for $125,000. A mortgage company has approved his loan application for a 30-year fixed-rate loan at 5.00%. Stephen has agreed to pay 25% of the purchase price as a down payment. Find the total interest Stephen will pay if he pays the loan on schedule. E Click the icon to view the table of the monthly payment of principal and interest per $1,000 of the amount financed. The total interest is S. (Round to the nearest cent as needed.)
Jonathan wishes to borrow $180 000 from a commercial bank. He was told that the loan would be amortized over five years and that payment could be made at the beginning or at the end of each year. Please assist Jonathan by answering the following questions. a. Explain to Jonathan, what is the purpose of a loan amortization schedule? b. Jonathan borrows $180 000 at 9% per annum for five years. The loan is repayable in five equal instalments at the beginning of the year. What is the annual payment?
Stephen has just purchased a home for $151,000. A mortgage company has approved his loan application for a 30-year fixed-rate loan at 5.25%. Stephen has agreed to pay 30% of the purchase price as a down payment. How much would Stephen's monthly payment increase for a 20-year mortgage over a 30-year mortgage? LOADING... Click the icon to view the table of the monthly payment of principal and interest per $1,000 of the amount financed. The monthly payment would increase by ?
Uncle Roger borrows $120,000 to buy a house on mortgage. The nominal annual interest rate on the mortgage is 10% and the mortgage has a term of 25 years. Calculate the monthly repayment.
Stephen has just purchased a home for $153,200. A mortgage company has approved his loan application for a 30-year fixed-rate loan at 4.75%. Stephen has agreed to pay 25% of the purchase price as a down payment. If Stephen made the same loan for 20 years, how much interest would he save? E Click the icon to view the table of the monthly payment of principal and interest per $1,000 of the amount financed. Stephen would save $ (Round to the nearest cent as needed.)
George secured an adjustable-rate mortgage (ARM) loan to help finance the purchase of his home 5 years ago. The amount of the loan was $350,000 for a term of 30 years, with interest at the rate of 6%/year compounded monthly. Currently, the interest rate for his ARM is 5.5%/year compounded monthly, and George's monthly payments are due to be reset. What will be the new monthly payment? (Round your answer to the nearest cent.)$
George secured an adjustable-rate mortgage (ARM) loan to help finance the purchase of his home 5 years ago. The amount of the loan was $350,000 for a term of 30 years, with interest at the rate of 8%/year compounded monthly. Currently, the interest rate for his ARM is 2.5%/year compounded monthly, and George's monthly payments are due to be reset. What will be the new monthly payment? (Round your answer to the nearest cent.) $ Submit Answer
Five years ago, Bob purchased an apartment in Tai Po of $2,000,000. He made a down payment of 30% and financed the balance with a 20 years' conventional mortgage to be amortized through monthly payments. The term is adjustable-rate mortgage (ARM) with interest of 8% per year compounded monthly. Currently, the interest rate for his ARM is 5% per year compounded monthly. Bob is thinking of refinancing his property by paying an extra amount of $500,000 now and to amortize the rest of the loan in the next 8 years. (a) What was Bob's monthly mortgage payment for his first 5 years? (interest is 8%) (b) What is Bob's outstanding principal now if he does not refinance his apartment? (interest is 8%) (c) What is Bob's outstanding principal now if he refinances his apartment by paying the extra payment? (d) What will Bob's new monthly mortgage payment be (after the reset) if he refinances his apartment? (interest is 5%)
Five years ago, Matthew borrowed $280,000 to purchase a house in Sandy Lake. At the time, the quoted rate on the mortgage was 8 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, Matthew must renegotiate his mortgage. If the current market rate for mortgages is 10 percent, what is Matthew's new monthly payment? (Round effective monthly rate to 6 decimal places, e.g. 25.125412% and final answer to 2 decimal places, e.g. 125.12. Do not round your intermediate calculations.) New monthly payment $
Dick and Jane Buell have purchased a home for $114,500. They will necd to obtain a mortgage for 75% of that amount. The Nearbi State Bank will give them a mortgage for 40 years at 17.3% interest. In the first six months of this mortgage, how much of the $1265.50 monthly payment goes to principal and how much to interest?
Your friend has just purchased a house and has incurred a $150,000, 4.5% mortgage payable at $760.03 per month. After making the first monthly payment, he receives a statement from the bank indicating only $197.53 had been applied to reducing the principal amount of the loan. Your friend then calculates that at the rate of $197.53 per month, it will take 63 years to pay off the $150,000 mortgage. Discuss and explain whether your friend’s analysis is correct or not.