Calculate the loan balance be at the end of the fifth year

Assignment Help Financial Management

Reference no: EM131487639

PLEASE SHOW WORK ON CALCULATIONS AND EXPLAIN. 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 the loan to negatively amortize; however, the loan will mature at the end of the five-year period. All loan payments are to be made monthly, and every year will be 10 percent higher than in the previous year. (I.e., loan payments in months 13-24 are 10 percent higher than in months 1-12. Loan payments in months 25-36 are 10 percent higher than in months 13-24. And so on for five years.)

a. Calculate the loan balance be at the end of the fifth year. Show and explain all calculations.

b. Calculate what the monthly loan payment would instead need to be in order for the loan balance at the end of the first year to be equal to the loan balance at the beginning of the first year. Show a loan amortization table for this case, just for the first year: what would be the total loan payment? The principal payment? The interest payment?

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

Reference no: EM131487639

Questions Cloud

Enjoys the challenge of preparing his tax return : Tom, an executive for a large corporation, enjoys the challenge of preparing his tax return.

Calculate the investors before-tax irr : A property is expected to have NOI of $100,000 the first year. Calculate the investor’s before-tax IRR.

What is current share price : Metallica Bearings, Inc., is a young start-up company. If the required return on this stock is 13.5 percent, what is the current share price?

Solving for future value of ordinary annuity : If the opportunity cost of capital (interest rate) is 10% per year compounded annually what is the future value?

Calculate the loan balance be at the end of the fifth year : A company is trying to structure a loan with the Bank of California. Calculate the loan balance be at the end of the fifth year.

Calculate the macaulay duration for this annuity : Calculate the Macaulay duration for this annuity given an effective interest rate of 5%.

What is the future value of the same annuity due : If the future value of an ordinary, 8-year annuity is $7,300 and interest rates are 8.0 percent, what is the future value of the same annuity due?

What will be the nature of its gain or loss : Thrasher Corporation sells short 100 shares of ARC stock at $20 per share on January 15, 2016. what will be the nature of its gain or loss?

Department of research and development at apple : Within the department of Research and Development at Apple, inventors build a new product that is anticipated to sell in stores for $399 each.

User Account

All Pages