Reference no: EM133475228
Case: You work for a small warehousing business that is looking to expand its services of storing physical inventory for future sale or distribution by purchasing another warehousing facility. You are managing the purchase of this property.
You have located a warehouse property to purchase at a price of $320,000. You plan to make a 20% downpayment of $64,000. Interest rates are rising quickly, but you've managed to secure a fixed-rate commercial mortgage at 4.5%. Commercial mortgages are typically much shorter than consumer mortgages like home loans, so the lender has offered you a 10-year term.
Set up a mortgage spreadsheet model (including an amortization table) and answer the following questions below.
Question 1. What is the monthly interest rate for this mortgage?
Question 2. What is the monthly payment for this fixed-rate, 10-year mortgage?
Question 3. What is the total interest paid on this mortgage over the 10 year term?
Question 4. What is the ending balance on the mortgage after the first year?
Question 5. Sometimes commercial lenders will amortize a loan for 10 years, but require the borrower to pay off the loan in a shorter period of time by paying off the rest of the loan in one final payment, known as a "balloon" payment. How much would you have to pay for that balloon payment (the ending balance) if your loan was still amortized for 10 years but you had to pay it off in 5 years?
Question 6. How much would your monthly payment be if you managed to negotiate the price of the warehouse property down to $275,000 from $320,000, but kept your downpayment the same?
Question 7. Let's say that your company was not able to get a commercial mortgage with a 4.5% interest rate, and instead the lender would only offer the loan at a 5.5% interest rate. What is the new monthly interest rate?
Question 8. How much total interest would you pay at the end of the 10-year term if the interest rate was 5.5% rather than 4.5%, if all of the other original loan terms stayed the same?
Question 9. Let's say that your lender was only willing to offer you a 5-year fixed rate commercial mortgage (a loan amortized over 5 years) rather than a 10-year loan. What would your monthly payment be for a 5-year loan, if all of the other original loan terms stayed the same?
Question 10. How much total interest would you pay if your commercial mortgage was for 5 years rather than 10 years, keeping all of the other original loan terms the same?
Which will help you connect your readings to things
: Your writing will be focused on Everyday Physics which will help you connect your Readings to things that have happened in the world around you.
|
What is the present value on january 1
: What is the present value on January 1, 2016, of $30,000 due on January 1, 2020, and discounted at 10% compounded annually?
|
Discuss the foundation of this form of government
: The U.S. Constitution created a unique general form of government. Discuss this form of government in detail noting different variations of it.
|
Discuss the biblical reference identified in your content
: Identify and discuss what artifacts, activities, etc.,you have completed during this course to demonstrateyour development in the respective competency or norm.
|
What is the monthly interest rate for mortgage
: How much total interest would you pay if your commercial mortgage was for 5 years rather than 10 years, keeping all of the other original loan terms the same
|
What is perspective on preserving traditional music culture
: What is your perspective on preserving traditional music culture vs. allowing it to change? Give an example to support your view.
|
What kinds of state taxes do u pay
: How much and what kinds of state taxes do u pay? Calculate ur state income, sales, gas, and (if applicable) property taxes for the past year.
|
Design a technology innovation prototype that tackles
: Design a technology innovation prototype that tackles a big problem and gives hope. Speak to why it is important and innovative.
|
Share your views and opinions on ai
: Share your thoughts/takeaways from the article attached. Read the article and share your views and opinions. Not simply agree or disagree. AI
|