Turkey Investments would like to buy a commercial building, and is negotiating loan terms with a local bank The building is for sale for $4 million The estimated first year NOI of the building is $300,000 Loan The bank is willing to allow the loan to negatively amortize The loan will need to be paid off three years from today To compensate for the riskiness of such loan, the bank will allow a relatively low LTV ratio applied to the building purchase, 50 The bank also requires that the first year DCR is 1 40 The contract interest rate (a k a the accrual rate) on the loan is 13 percent Monthly loan payments are required (a) First, the required monthly loan payment equals $ Don't put the $ sign Round to whole dollar Then, build a loan amortization schedule for the next 3 years Year 1, Year 2, and Year 3 No months, just years (like in class) Use your results to fill out the table below Don't put the $ sign Round to whole dollar End of Year 1 End of Year 2 End of Year 3 Ending loan balance $ $ $ This kind turkey has a HINT for you If you're doing the math right, the interest payment in the 3rd year should equal $277,149 (b) Now, assume that the building value does not change over the next several years The loan to value ratio be at the end of the 3rd year equals Don't put the sign Round to 2decimal places E g , if you got 71 23 , type 71 23 (c) If the loan to value ratio at the time of sale in 3 years is below the ratio allowed for that year by the bank, then the investment company can afford to pay than the asking price Type more or less (d) Continuing part (c), lets say the bank wants to make sure that the loan to value ratio in 3 years does not exceed 60 percent To make this happen, the investment company can negotiate the asking price and make the following counter offer $ (Assume that the offered price can be below the asking price, but it can also be above it if, say, there's high competition ) Don't put the $ sign Round to whole dollar, and to the nearest 100,000

The Answer is in the image, click to view...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Nov 18, 2020

Turkey Investments would like to buy a commercial building, and is negotiating loan terms with a local bank. The building is for sale for $4

Turkey Investments would like to buy a commercial building, and is negotiating loan terms with a local bank. The building is for sale for $4 million. The estimated first-year NOI of the building is $300,000.

Loan: The bank is willing to allow the loan to negatively amortize. The loan will need to be paid off three years from today. To compensate for the riskiness of such loan, the bank will allow a relatively low LTV ratio applied to the building purchase, 50%. The bank also requires that the first-year DCR is 1.40. The contract interest rate (a.k.a. the accrual rate) on the loan is 13 percent. Monthly loan payments are required.

(a) First, the required monthly loan payment equals $. Don't put the $ sign. Round to whole dollar.

Then, build a loan amortization schedule for the next 3 years: Year 1, Year 2, and Year 3. No months, just years (like in class). Use your results to fill out the table below. Don't put the $ sign. Round to whole dollar.

	End of Year 1	End of Year 2	End of Year 3
Ending loan balance	$	$	$

This kind turkey has a HINT for you: If you're doing the math right, the interest payment in the 3rd year should equal $277,149.

(b) Now, assume that the building value does not change over the next several years. The loan-to-value ratio be at the end of the 3rd year equals %. Don't put the % sign. Round to 2decimal places. E.g., if you got 71.23%, type 71.23.

(c) If the loan-to-value ratio at the time of sale in 3 years is below the ratio allowed for that year by the bank, then the investment company can afford to pay than the asking price. Type "more" or "less".

(d) Continuing part (c), let’s say the bank wants to make sure that the loan-to-value ratio in 3 years does not exceed 60 percent. To make this happen, the investment company can negotiate the asking price and make the following counter-offer: $. (Assume that the offered price can be below the asking price, but it can also be above it if, say, there's high competition.) Don't put the $ sign. Round to whole dollar, and to the nearest 100,000.