Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

can you please solve this 7. A $12,500,000 loan has a stated interest rate of 6.75%, a 10-year term and a 30 year amortization period.

can you please solve this image text in transcribed
7. A $12,500,000 loan has a stated interest rate of 6.75%, a 10-year term and a 30 year amortization period. What is the mortgage constant? Use the payment function in Excel to calculate. 8. A property has a value of $15,000,000. A lender is willing to make a loan at a maximum 80% Loan to Value. What is the maximum loan amount the lender would calculate under Loan to Value underwriting? 9. A property has Net Operating Income of $1,450,000. A lender requires a minimum of 1.35 x Debt Service coverage Ratio. The mortgage constant is 8.25%. What is the maximum loan the lender would calculate using the Debt Service Coverage Ratio underwriting test? 10. A lender has calculated a maximum loan under the LTV underwriting approach of $9,650,000 and a maximum loan using the DSCR underwriting approach of $9,875,000. What amount would the lender be willing to lend? 11. A buyer has agreed to purchase a property for $25,000,000. A bank will loan 70% of this price and require 1 point and $75,000 in loan closing costs. In addition, the buyer has other acquisition costs for the property of $90,000. How much equity is required to close the transaction? 12. Lender A will loan $17,000,000 at an effective interest rate of 7.75% after points and loan closing costs. Lender B will loan $20,000,000 at an effective interest rate of 8.625% after points and loan closing costs. What is the incremental interest cost of the incremental loan amount from Lender B

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accounting And Finance For Non Specialists

Authors: Eddie McLaney, Peter Atrill

2nd Edition

0135717469, 9780135717462

More Books

Students also viewed these Accounting questions

Question

Explain the benefits of a health and wellness strategy

Answered: 1 week ago

Question

Describe the components of a workplace wellness programme

Answered: 1 week ago