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

Assignment Help Finance Basics

Reference no: EM132043809

Question: 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.

d. Calculate the lender's IRR if the property instead sells for only $500,000 after 10 years. Show and explain all calculations.

Reference no: EM132043809

Questions Cloud

Describe the role of the security department : Describe the role of the security department and other departments you believe to be key stakeholders in achieving the program's goals and objectives.

What will be the market price of the security : The market price of a security is $40. Its expected return is 13%. The risk-free rate is 7% and the market risk premium is 8%.

How public administration differs from private management : The relationship between the federal Administrative Procedures Act (APA) and the uniform state APA of 1946.

Calculate the minimum return on the stock : Calculate the minimum return on the stock required to get the option in the money. (Do not round intermediate calculations. Enter your answer as a percent.

Calculate the loan balance be at the end of the fifth year : 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).

How do the two systems differ : How do the two systems differ and What are the characteristics of the companies that would use each?

Which ideas in the essay need further development : Identify the problem statement in the essay. Does the introduction and conclusion focus clearly on the problem statement?

What total amount of bond interest expense will be recognize : Batata inc. issues 12.50%, 10-year bonds with a par value of $470,000 and semiannual interest payments. On the issue date, the annual market rate.

Who establishes the culture within the organization : What suggestions do you recommend for overcoming the "code of silence" that permeates all levels of the department? Explain.

User Account

All Pages