Essentials Of Investments
11th Edition
ISBN: 9781260013924
Author: Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher: Mcgraw-hill Education,
expand_more
expand_more
format_list_bulleted
Related questions
Question
Please help solve this in Excel and please show all the steps and formulas to solve this step by step in Excel.
Please use the following information to answer a. through f. Five years ago, Nick purchased a house of $500,000. Nick borrows a mortgage with 80% of LTV (loan to value ratio), monthly payments and the interest rate of 5% for 30 years. Nick found a new lender who will refinance the current outstanding loan balance plus all the costs associated with the new loan at 3.5% with monthly payments for 30 years. Suppose that the new lender will charge 3.5 discount points on the new loan and other refinancing costs will equal $2,000.
a. What is the monthly payment for the current loan?
b. What is the current outstanding loan balance?
c. What is the new loan amount if Nick chooses to refinance?
d. What is Nick's monthly payment for the new loan?
e. What is the effective cost of the new loan if Nick holds the loan for 30 years? Should Nick refinance?
f. If Nick wants to refinance today, at least how many years should he stay in the house (do not prepay)? Please explain Why?
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by stepSolved in 1 steps with 1 images
Knowledge Booster
Similar questions
- Today, Julie borrowed $5000 to purchase furniture for her new house. She can repay the loan in either of the two ways described below. (a) Five equal annual installments with interest determined at 5% per year. (b) One payment 3 years from now with interest determined at 7% per year. Show how to solve for each option, and please show how you solved it mathematicallyarrow_forwardIvan is looking to purchase a home that costs $ 160,000. The interest rate is currently at 3.7%. Use the monthly payment formula below to find Ivan's monthly mortgage payment for the next 30 years. M = P)(1+)¹²t (1+)12t_1 Emilio's savings account had a balance of $621.96 at the end of July. During August, he made three savings account deposits of $83.11, $52.89, and $307.84 and one withdrawal of $129.00. At the end of August his account earned $11.50 in interest. Will Emilio meet his savings account goal of $1,000 by September 1st?arrow_forwardRansford and Alda Mariano own a home recently appraised for $422,500. The balance on their existing mortgage is $113,083. If their bank is willing to loan up to 80% of the appraised value, what is the amount of credit available to them (in $)? $arrow_forward
- I need the answer of the question attached. Please provide all possible answers. Thank you!arrow_forwardThis problem is a complex financial problem that requires several skills, perhaps some from previous sections.Clark and Lana take a 30-year home mortgage of $122,000 at 7.4%, compounded monthly. They make their regular monthly payments for 5 years, then decide to pay $1300 per month. (a) Find their regular monthly payment. (Round your answer to the nearest cent.)$ (b) Find the unpaid balance when they begin paying the $1300. (Round your answer to the nearest cent.)$ (c) How many payments of $1300 will it take to pay off the loan? Give the answer correct to two decimal places. monthly payments(d) Use your answer to part (c) to find how much interest they save by paying the loan this way. (Round your answer to the nearest cent.)arrow_forwardPlease correct, I don't know how I'm wrong. I have one more chance so please double checkarrow_forward
- Several years ago, Bill Smith borrowed $125,000 to buy his house. He has a 15 year, monthly payment mortgage with an interest rate of 8.75 percent per annum. Bill is thinking about refinancing his house so he would like to know the payoff on his current loan. Assuming that he just made payment number 94, compute the payoff on Bill's loan. Round your answer to 2 decimal places; record your answer without commas and without a dollar sign.arrow_forwardYara owns a home that was recently appraised for $181,000. The balance on the existing mortgage is $84,200. If Yara's bank is willing to loan up to 73% of the appraised value, find the potential amount of credit available on a home equity loan. O $47,930 O $61,466 O $96,800 $132,130 * O 0 o oarrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
- Essentials Of InvestmentsFinanceISBN:9781260013924Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.Publisher:Mcgraw-hill Education,
Foundations Of FinanceFinanceISBN:9780134897264Author:KEOWN, Arthur J., Martin, John D., PETTY, J. WilliamPublisher:Pearson,
Fundamentals of Financial Management (MindTap Cou...FinanceISBN:9781337395250Author:Eugene F. Brigham, Joel F. HoustonPublisher:Cengage Learning
Corporate Finance (The Mcgraw-hill/Irwin Series i...FinanceISBN:9780077861759Author:Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan ProfessorPublisher:McGraw-Hill Education
Essentials Of Investments
Finance
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Mcgraw-hill Education,
Foundations Of Finance
Finance
ISBN:9780134897264
Author:KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:Pearson,
Fundamentals of Financial Management (MindTap Cou...
Finance
ISBN:9781337395250
Author:Eugene F. Brigham, Joel F. Houston
Publisher:Cengage Learning
Corporate Finance (The Mcgraw-hill/Irwin Series i...
Finance
ISBN:9780077861759
Author:Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:McGraw-Hill Education