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 build a spreadsheet in excel and please show all steps and formulas in Excel to solve questions a. through f. and please show any additional calculations please!!
Five years ago, Marty purchased a house of $500,000. He borrowed a mortgage with 80% of LTV
(loan to value ratio), monthly payments and the interest rate of 5% for 30 years. Marty 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 he chooses to refinance?
d. What is Marty's monthly payment for the new loan?
e. What is the effective cost of your new loan if you hold the loan for 30 years? Do you
refinance?
f. If Marty 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.
This is a popular solution
Trending nowThis is a popular solution!
Step by stepSolved in 3 steps with 2 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.Similar questions
- ** HINT: Look online or look back at your worksheets for "add- on interest" problems! Melanie bought a used car for $10,000. (S)he put $100 down and financed the balance with the dealer at 5% add-on interest. If they agreed to make 36 monthly payments, then: (Round each answer to the nearest penny) What is the total payback amount of the loan? $ What is the amount of each payment? $ /month What is the total amount of interest paid on the loan? $arrow_forwardCan someone please help me to solve this problem with neat hand written calculations showing all work? Please and thank you!!arrow_forwardI need the answer of the question attached. Please provide all possible answers. Thank you!arrow_forward
- AS an accountant at City Bank in Boston, Ken, the Loan Officer called you for some help on a loan application that he is working on. One of his customers is looking for a $50,000 loan for a car. He is offering him a 7% 5 year $50,000 loan and asking you to help him calculate the installment amount. This is the data Ken sent you: Face Amount of Loan $50,000 Contract Rate… 7% Term of the Loan….. 5 yearsarrow_forwardMichael Sanchez purchased a condominium for $74,000. He made a 20% down payment and financed the balance with a 30 year, 5% fixed-rate mortgage. (Round your answers to the nearest cent. Use this table, if necessary.) (a) What is the amount (in $) of the monthly principal and interest portion, PI, of Michael's loan? $ (b) Construct an amortization schedule for the first four months of Michael's mortgage. PaymentNumber MonthlyPayment(in $) MonthlyInterest(in $) Portion Usedto ReducePrincipal(in $) LoanBalance(in $) 0 $ 1 $ $ $ $ 2 $ $ $ $ 3 $ $ $ $ 4 $ $ $ $ (c) If the annual property taxes are $1,640 and the hazard insurance premium is $670 per year, what is the total monthly PITI of Michael's loan (in $)? $arrow_forwardPIANO LOANS. Stephanie has her eye on a $150,000 Steinway D Grand Piano. Will a cheery major chord or a depressing minor chord best describe her meeting with a loan officer? Use a calculator to do the math after writing out the proper formula. Round to the nearest dollar. Her credit history allows her to qualify for a 6% (APR, compounded monthly) loan that she plans to pay off over the next 15 years. If her earnings allow her to comfortably make monthly payments of $1200, what is the most she can afford to borrow? b. Alternatively, she can qualify for a 6% (APR, compounded monthly), 20-year loan. If she borrows $150,000, then what would her monthly payment be? c. Finally, suppose Stephanie runs up a lot of credit card debt in college, so that she can only qualify for a 9% (APR, compounded monthly), 20-year loan. If she still wants to buy that $150,000 piano, what will her monthly payment be? 4. а.arrow_forward
- Please show how to solve this using excel and please show all formulas in the spreadsheet please!! Thomas decides to buy a house with price of $450,000. Thomas puts 20% down payment and considers a 30-year fixed rate mortgage to pay the remaining balance. The lender offers Thomas two choices of the mortgage with monthly payments shown in the table as choice 1 and choice 2, assume that the origination cost is $6,000. A. If you hold the loan for 30 years, what is the effective cost for each choice? B. How about the effective cost for each choice if the loan will only be outstanding for 5 years (60 months) (i.e. the borrow will pay off the loan at the end of 60 months)?arrow_forwardProblem #1. Jason's uncle loaned him $26,560 to help start a landscaping business. They agreed that Jason would pay off the entire loan plus 3.24% annually compounded interest in 4 years, and that in the meantime he would make monthly deposits into a bank account to make sure that he has the amount needed when the loan comes due. The bank will pay 2.09%. (a) Find the total amount Jason will need to repay the loan. Show your work. (b) How much should each of his monthly deposits be? Show your work.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_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