Question

In: Accounting

A company is negotiating loan terms with a bank. The company would like to purchase a...

A company is negotiating loan terms with a bank. The company would like to purchase a property for $2.5 million. The property is projected to produce a first-year NOI of $180,000. Loan: The bank is willing to allow the loan to negatively amortize; however, the loan will need to be paid back at the end of the four-year period. Because of the risky nature of such loan, the bank will allow a 65 percent LTV loan on the property at the time of its purchase. It also requires a DCR in the first year of at 1.30. The contract (or the accrual) rate of interest on the loan is 12 percent. All loan payments are to be made monthly.

a. Show the loan amortization schedule for the next four years: Year 1, Year 2, Year 3 and Year 4, no months. Show and explain all calculations.

b. If the property value does not change, what will the loan-to-value ratio be at the end of the four-year period? Calculate. Show and explain all calculations.

c. Since the loan balance will be due in four years, let’s say the bank would like to make sure that the LTV at that time does not exceed 70 percent. To make this happen, how should the company counter-offer the asking price? Calculate the counter-offer price. Show and explain all calculations.

Solutions

Expert Solution

Please post C seperately.Rate on the basis of a and b.Thanks.

Worth of property = $2,500,000
LTV = 65%
Therefore, Loan amount = $2,500,000*65% = $1,625,000
1st year NOI = $180,000
1st year DCR = 1.3
Therefore, 1st year loan amount paid = $180,000/1.30 = $138462 in 1 year (=$138462/12 in 1 month) = $11,538.50
Since loan is allowed to negatively amortize, any unpaid interest would be added to the principal in next period.
It is assumed that the interest rate is 12% per year, or 1 % per month and calculations are done accordingly.
a. Year Month Principal unpaid Interest on principal Loan repayment made Payment towards interest Interest unpaid
1 1 $1,625,000 $16,250 $11,538.50 $11,538.50 $4,711.50
2 $1,629,711.50 $16,297.12 $11,538.50 $11,538.50 $4,758.62
3 $1,634,470.12 $16,344.70 $11,538.50 $11,538.50 $4,806.20
4 $1,639,276.32 $16,392.76 $11,538.50 $11,538.50 $4,854.26
5 $1,644,130.58 $16,441.31 $11,538.50 $11,538.50 $4,902.81
6 $1,649,033.39 $16,490.33 $11,538.50 $11,538.50 $4,951.83
7 $1,653,985.22 $16,539.85 $11,538.50 $11,538.50 $5,001.35
8 $1,658,986.57 $16,589.87 $11,538.50 $11,538.50 $5,051.37
9 $1,664,037.94 $16,640.38 $11,538.50 $11,538.50 $5,101.88
10 $1,669,139.82 $16,691.40 $11,538.50 $11,538.50 $5,152.90
11 $1,674,292.71 $16,742.93 $11,538.50 $11,538.50 $5,204.43
12 $1,679,497.14 $16,794.97 $11,538.50 $11,538.50 $5,256.47
2 1 $1,684,753.61 $16,847.54 $11,538.50 $11,538.50 $5,309.04
2 $1,690,062.65 $16,900.63 $11,538.50 $11,538.50 $5,362.13
3 $1,695,424.78 $16,954.25 $11,538.50 $11,538.50 $5,415.75
4 $1,700,840.52 $17,008.41 $11,538.50 $11,538.50 $5,469.91
5 $1,706,310.43 $17,063.10 $11,538.50 $11,538.50 $5,524.60
6 $1,711,835.03 $17,118.35 $11,538.50 $11,538.50 $5,579.85
7 $1,717,414.88 $17,174.15 $11,538.50 $11,538.50 $5,635.65
8 $1,723,050.53 $17,230.51 $11,538.50 $11,538.50 $5,692.01
9 $1,728,742.54 $17,287.43 $11,538.50 $11,538.50 $5,748.93
10 $1,734,491.46 $17,344.91 $11,538.50 $11,538.50 $5,806.41
11 $1,740,297.88 $17,402.98 $11,538.50 $11,538.50 $5,864.48
12 $1,746,162.36 $17,461.62 $11,538.50 $11,538.50 $5,923.12
3 1 $1,752,085.48 $17,520.85 $11,538.50 $11,538.50 $5,982.35
2 $1,758,067.83 $17,580.68 $11,538.50 $11,538.50 $6,042.18
3 $1,764,110.01 $17,641.10 $11,538.50 $11,538.50 $6,102.60
4 $1,770,212.61 $17,702.13 $11,538.50 $11,538.50 $6,163.63
5 $1,776,376.24 $17,763.76 $11,538.50 $11,538.50 $6,225.26
6 $1,782,601.50 $17,826.02 $11,538.50 $11,538.50 $6,287.52
7 $1,788,889.02 $17,888.89 $11,538.50 $11,538.50 $6,350.39
8 $1,795,239.41 $17,952.39 $11,538.50 $11,538.50 $6,413.89
9 $1,801,653.30 $18,016.53 $11,538.50 $11,538.50 $6,478.03
10 $1,808,131.33 $18,081.31 $11,538.50 $11,538.50 $6,542.81
11 $1,814,674.15 $18,146.74 $11,538.50 $11,538.50 $6,608.24
12 $1,821,282.39 $18,212.82 $11,538.50 $11,538.50 $6,674.32
4 1 $1,827,956.71 $18,279.57 $11,538.50 $11,538.50 $6,741.07
2 $1,834,697.78 $18,346.98 $11,538.50 $11,538.50 $6,808.48
3 $1,841,506.26 $18,415.06 $11,538.50 $11,538.50 $6,876.56
4 $1,848,382.82 $18,483.83 $11,538.50 $11,538.50 $6,945.33
5 $1,855,328.15 $18,553.28 $11,538.50 $11,538.50 $7,014.78
6 $1,862,342.93 $18,623.43 $11,538.50 $11,538.50 $7,084.93
7 $1,869,427.86 $18,694.28 $11,538.50 $11,538.50 $7,155.78
8 $1,876,583.64 $18,765.84 $11,538.50 $11,538.50 $7,227.34
9 $1,883,810.97 $18,838.11 $11,538.50 $11,538.50 $7,299.61
10 $1,891,110.58 $18,911.11 $11,538.50 $11,538.50 $7,372.61
11 $1,898,483.19 $18,984.83 $11,538.50 $11,538.50 $7,446.33
12 $1,905,929.52 $19,059.30 $11,538.50 $11,538.50 $7,520.80
b LTV $1905929.52/$2500000
76.24%

Related Solutions

How could the cash budget be used when negotiating the terms of a bank loan?
How could the cash budget be used when negotiating the terms of a bank loan?
Summit Record Company is negotiating with two banks for a $139,000 loan. Fidelity Bank requires a...
Summit Record Company is negotiating with two banks for a $139,000 loan. Fidelity Bank requires a compensating balance of 14 percent, discounts the loan, and wants to be paid back in four quarterly payments. Southwest Bank requires a compensating balance of 7 percent, does not discount the loan, but wants to be paid back in 12 monthly installments. The stated rate for both banks is 12 percent. Compensating balances will be subtracted from the $139,000 in determining the available funds...
Summit Record Company is negotiating with two banks for a $136,000 loan. Fidelity Bank requires a...
Summit Record Company is negotiating with two banks for a $136,000 loan. Fidelity Bank requires a compensating balance of 14 percent, discounts the loan, and wants to be paid back in four quarterly payments. Southwest Bank requires a compensating balance of 7 percent, does not discount the loan, but wants to be paid back in 12 monthly installments. The stated rate for both banks is 10 percent. Compensating balances will be subtracted from the $136,000 in determining the available funds...
Summit Record Company is negotiating with two banks for a $147,000 loan. Fidelity Bank requires a...
Summit Record Company is negotiating with two banks for a $147,000 loan. Fidelity Bank requires a compensating balance of 30 percent, discounts the loan, and wants to be paid back in four quarterly payments. Southwest Bank requires a compensating balance of 15 percent, does not discount the loan, but wants to be paid back in 12 monthly installments. The stated rate for both banks is 8 percent. Compensating balances will be subtracted from the $147,000 in determining the available funds...
PLEASE SHOW ALL WORK. 2. A bank is negotiating a loan. The loan can either be...
PLEASE SHOW ALL WORK. 2. A bank is negotiating a loan. The loan can either be paid off as a lump sum of $100,000 at the end of five years, or as equal annual payments at the end of each of the next five years. If the interest rate on the loan is 10% regardless of the payment method, what annual payments should be made so that both forms of payment are equivalent? 3. You have an investment opportunity that...
A company is trying to structure a loan with the Bank of California. The company would...
A company is trying to structure a loan with the Bank of California. The company would like to purchase a property for $2.5 million. The property is projected to produce a first-year NOI of $200,000. Loan: The lender will allow an 80 percent LTV loan on the property. It also requires a DCR in the first year of at 1.25. The contract (or the accrual) rate of interest on the loan is 12 percent. The lender is willing to allow...
Happy, Inc. is negotiating a loan for expansion purposes and the bank requires audited financial statements....
Happy, Inc. is negotiating a loan for expansion purposes and the bank requires audited financial statements. Before closing the accounting records for the year ended December 31, 2017, Happy's controller prepared the following comparative financial statements for 2017 and 2016: Happy, Inc. Balance Sheets December 31, 2017 and 2016 2017 2016 Cash ...................................... $  550,000 $ 300,000 Investment securities (reported at market;   cost, $142,000) .........................   156,000         0 Accounts receivable .......................   974,000   784,000 Allowance for doubtful accounts ...........   (100,000)    (64,000) Inventories ..................................
XYZ company used a loan of 7500000 TL from the bank for 10 years to purchase...
XYZ company used a loan of 7500000 TL from the bank for 10 years to purchase a CNC machine tool. For this loan, the bank will apply 20% interest for the first 3 years, 22% for the second three years and 26% for the last 4 years. The bought bench has 100000 TL repairs each year and 50000 TL maintenance expenses each year. At the end of 10 years a) What is the total amount to be paid to the...
Broke National Bank offers you an auto loan to purchase a car. The loan amount is...
Broke National Bank offers you an auto loan to purchase a car. The loan amount is $10,000. The loan amortizes interest over five years of monthly payments. The interest rate is 6% on an annual basis. What is your monthly payment? N = ________                                       i = ________ FV = $________                                   PV = $________ PMT = $________ per month Assuming you take the loan described in the prior problem, how much of the initial payment is interest and how much of...
Your hospital is negotiating with medical insurance providers, who would like to reduce the amount they...
Your hospital is negotiating with medical insurance providers, who would like to reduce the amount they pay as reimbursement for hospital stays. For a particular procedure, they would like to reduce payment by $300 and have patients go home one day earlier. To see what effect this would have on hospital costs, a random sample of 50 patients who were recently admitted for this procedure was analyzed. Had they left one day earlier, the average savings would have been $322.44,...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT