
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
Concept explainers
Question

Transcribed Image Text:Your firm has taken out a $527,000 loan with 8.5% APR (compounded monthly) for some commercial property. As is common in commercial real estate, the loan is a 5-year loan based on a 15-year amortization.
This means that your loan payments will be calculated as if you will take 15 years to pay off the loan, but you actually must do so in 5 years. To do this, you will make 59 equal payments based on the 15-year
amortization schedule and then make a final 60th payment to pay the remaining balance. (Note: Be careful not to round any intermediate steps less than six decimal places.)
a. What will your monthly payments be?
b. What will your final payment be?
a. What will your monthly payments be?
The monthly payments will be $
(Round to the nearest cent.)
(...)
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
- You have just purchased a new warehouse. To finance the purchase, you' ve arranged for a 35-year mortgage for 85 percent of the $3,100,000 purchase price. The monthly payment on this loan will be $17,200. a. What is the APR on this loan? (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g ., 32.16.) b. What is the EAR on this loan? (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.)arrow_forwardCreate an amortization table in Excel for a new car loan for 30,000 for six years at 5%. Determine the total amount of interest you will pay on this loan. Copy the table from Step 1, make an extra principal payment of $2,000 on the first day of year two. How does this change the total interest you will pay on this loan? Create an amortization table in Excel for a new car loan for 30,000 for three years at 5%. Determine the total amount of interest you will pay on this loan. Copy the table from Step 3, change the interest rate to 2%. How does this change the total interest that you will pay on the loan? What is the total amount you will pay for the car (principal and interest) in each of the steps 1, 2, 3 and 4.arrow_forwardConsidering the following information, what is the NPV if the borrower refinances the loan? Expected holding period: 3 years; current loan balance: $400,000; current loan interest: 5.875%; remaining term on current mortgage: 15 years; new loan interest: 3.625%; new loan term: 15 years; cost of refinancing: $6,000. Assume that the opportunity cost is 10%. Should the borrower refinancearrow_forward
- You can afford a loan payment of $1200 a month. You have put an offer of $175,000 on a house. You are considering three different loans. Loan A. P = $175,000 at a rate of 5% with monthly payments for 30 years. Loan B. P = $175,000 at a rate of 4% with monthly payments for 15 years. Loan C. P = $175,000 at a rate of 4.5% with monthly payments for 20 years. Find the payment and total interest for each loan. Loan A: Payment = Total Interest = Loan B: Payment = Total Interest = Loan C: Payment = Total Interest =arrow_forwardYou need to borrow $15,000. You bank offers you a loan that you have to pay back $500 at the end of each quarter for total 40 quarter (total 10 years). Calculate the effective annual interest rate being charged for the loan.arrow_forwardYou are buying a house for $290,000.00 with a downpayment of $29,000.00. The loan will be paid back over 20 years with monthly payments of $1,609.25. If the interest rate is 4.2% compounded monthly, what would the unpaid balance be immediately after the eleventh payment? What is the equity after the eleventh payment? The unpaid balance would be $ The equity would be $arrow_forward
- Consider borrowing $250,000 to purchase a house at a 4% annual interest rate to be paid infull in 15 years. Build a fixed payment monthly amortization schedule for the above loan.What is the total amount of interest you will pay on the loan.arrow_forwardYou bought a house for $1,000,000. You paid 20% as the down payment and financed the rest. The mortgage loan has 30 years maturity and 4% APR which is compounded monthly. Use Excel Spread sheet to amortize the loan and find out the monthly principle and interest payments through out the life of this loan. I need this on an excel spreadsheetarrow_forwardYou have just purchased a new warehouse. To finance the purchase, you’ve arranged for a 34-year mortgage loan for 80 percent of the $3,240,000 purchase price. The monthly payment on this loan will be $15,700. What is the APR on this loan? Note: Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16. What is the EAR on this loan? Note: Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.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 LearningCorporate 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