Question

Suppose you are planning to develop a new apartment building next to Iowa State. You anticipate...

  1. Suppose you are planning to develop a new apartment building next to Iowa State. You anticipate that the project will take two years to develop at a total cost of $3,000,000. Once open, you expect the building to produce a Net Operating Income of $250,000 annually.

You’ve arranged a financing package that covers the construction period with a two-year interest only (IO) loan offered at loan-to-value ratio of 80% and an annual interest rate of 6%. Once the building opens, you will pay-off the balance of the IO loan with a 20-year amortizing fixed-rate mortgage (FRM) with payments annually at an annual interest rate of 5%.

Based on this information, answer the following:

  1. What is the initial loan balance and annual debt service payment due on the interest-only construction loan? (3 pts)
  1. Once development is complete, what is the debt service payment due on the 20-year FRM? (3 pts)

Homework Answers

Answer #1

(a) Calculation of intital loan balance and annual debt service payment

Total cost of project = $3,000,000

Loan to value ratio = 80%

Interest rate= 6%

Initial loan balance = Total cost of project * Loan to value ratio

= $3,000,000 * 80%

= $2,400,000

Annual debt service payment = Initial loan balance * Interest rate

= $2,400,000 * 6%

= $144,000

(b) Calculation of debt service payment due on 20-year FRM

Debt service payment due of 20-year FRM = [Initial loan balance*r*(1+r)^n] / [(1+r)^n - 1]

= [2,400,000*0.05*(1+0.05)^20] / [(1+0.05)^20 - 1]

= 318,396 / 1.6533

= $192,582.21

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
First, you could build an office building on the site. You’ve spoken with a broker who...
First, you could build an office building on the site. You’ve spoken with a broker who tells you that you can expect to earn around $60 /sf/year on new office space in the market. The site is currently zoned for residential, but the city has granted variances to nearby parcels allowing for office development. You’re optimistic that the city will grant you a similar variance allowing a 25,000 sf office building on your lot. You’ve spoken to a banker who...
Ann wants to buy a building. The annual NOI for the building will be $175,000. She...
Ann wants to buy a building. The annual NOI for the building will be $175,000. She wants to get a 20 year interest only fixed rate mortgage at an annual rate of 8.35% with annual compounding and annual payments to buy the building. The lender has a minimum Debt Service Coverage Ratio (DSCR) of 1.20. What is the largest annual loan payment the lender will allow Ann to make based on the DSCR? A. $1,746,506.99 B. $102,600.26 C. $145,833.33 D....
Solve using excel: A. Suppose you are considering the purchase of an apartment building that has...
Solve using excel: A. Suppose you are considering the purchase of an apartment building that has 12 units that can be rented out at $1,050 per month. You have estimated operating expenses and expected vacancy and collection losses for the first year to be $35,700 and $30,240, respectively. You also have estimated that you will be able to generate an additional $3,840 in the first year from garage rentals on the property. If the expected purchase price of the property...
On 1 January 2019, 3D-Construction (Pty) Ltd obtained planning permission to build a new office building....
On 1 January 2019, 3D-Construction (Pty) Ltd obtained planning permission to build a new office building. Construction commenced on 1 March 2019. To help fund the cost of this building, a loan for $10 million was taken out from Bank Gaborone on 1 April 2019. The interest rate on the loan was 10% per annum. Construction of the building ceased during the month of July due to an unexpected shortage of labor and materials. By 31 December 2019, the building...
You are planning to purchase a house for $180,000. You will pay 20% down payment and...
You are planning to purchase a house for $180,000. You will pay 20% down payment and take a mortgage loan for the remaining 80%. You could get a 3/1 ARM amortized over 15 years at 3.9 % or a fixed 15 year FRM loan at 5.3%. The expected interest rate of the ARM from years 4 to 5 is 7.5%. You will live in the house for five years, and after that you expect to sell the house for $200,000...
Joe and Sue are building a new home and are looking at a 30 year construction...
Joe and Sue are building a new home and are looking at a 30 year construction loan of $380,000 with the first year being interest only. From years 2 to 30, the loan is a normal amortized loan. The first year is interest only as the house is being built. The interest rate is 4.375% APR. What is the monthly payment for the first year. What is the monthly payment for years 2-30? At the end of 10 years, they...
You plan to break ground for a new building that has 30 2-bedroom apartments. The new...
You plan to break ground for a new building that has 30 2-bedroom apartments. The new building will cost $12,000000 including renovations that would last a year (i.e., you would not have a tenant for a year. The interest rate for commercial loan is 5% per annum. You would pay the money upfront making $0 down payment. You are taking a 30-year loan with no balloon payment. The loan is estimated to being in January 2020 when you expect to...
Crab State Bank has offered you a $1,250,000 5-year loan at an interest rate of 10.25...
Crab State Bank has offered you a $1,250,000 5-year loan at an interest rate of 10.25 percent, requiring equal annual end-of-year payments that include both principal and interest on the unpaid balance. Develop an amortization schedule for this loan. Round your answers to the nearest dollar. End of Year Payment Interest (10.25%) Principal Reduction Balance Remaining    0       $1,250,000 1 $ $ $ 2 3 4 5
An Office building is listed for sale at $500,000. You can borrow 80% at 6% interest...
An Office building is listed for sale at $500,000. You can borrow 80% at 6% interest amortized monthly for a 20 year term and put 20% down. Your required unleveraged IRR is 10% and you want to use a 9% terminal cap rate. You plan a five year holding period after the purchase. You have calculated the annual pre-debt service NOI for each year as: Yr. 1 = $40,000 Yr. 2 = $41,000 Yr. 3 = $42,000 Yr. 4 =...
Crab State Bank has offered you a $1,250,000 5-year loan at an interest rate of 10.25...
Crab State Bank has offered you a $1,250,000 5-year loan at an interest rate of 10.25 percent, requiring equal annual end-of-year payments that include both principal and interest on the unpaid balance. Develop an amortization schedule for this loan. Round your answers to the nearest dollar. End of Year Payment Interest (10.25%) Principal Reduction Balance Remaining 0 $1,250,000 1 $ $ $ 2 3 4 5 can you explain the steps please.