Question

In: Finance

You bought the building, located at Little Ferry, NJ for $50 Million, which was 6% Capitalization...

You bought the building, located at Little Ferry, NJ for $50 Million, which was 6% Capitalization Rate (CAP). This building is occupied only by Wal-Mart. You made 40% down and financed 60% of the purchase price at 5% APR, 5 year balloon with 25 year amortization schedule. You have 25 year Absolute Triple Net lease with Wal-Mart. There is no annual escalation of the base rent. The building’s $50 million value consists of $25 million land value and $25 million improvement. In addition to $50 million purchase price, you had to pay 3% transaction (closing) costs (equivalently $1.5 million), which include the legal, financing, administrative, inspection, and all taxes. Use 39 years for the annual depreciation. Assume 30% tax rate.

What is the net cash flow for the first year? Note: Net Cash Flow is defined as NOI – Annual Interest Payment – Tax + Annual Depreciation.

Solutions

Expert Solution

Given:

Property Value or Cost = $50 million

Loan taken (.i.e. Principal amount) = 60% of Cost = $30 million

Capitalization Rate (.i.e. Cap Rate) = 6%

Amortization years = 25

Transaction cost over and above cost = $1.5 million

Useful life of the asset (years) = 39

Tax Rate = 30%

Note:

Net Cash Flow = NOI - Annual Interest Payment - Tax + Annual Depcreciation

This problem is solved by calculating individual components as under:

Step 1)

Calculate Ne Operating Income (.i.e. NOI) using Cap Rate formula given as under:

Cap Rate = NOI / Purchase Price

Therefore,

NOI = Cap Rate * Purchase Price

NOI = 6% * 50,000,000

NOI = $3,000,000

Step 2)

Calculate Annual Depreciation as under:

Since land is not subject to depreciation, the total value of the equipment is $25 million with useful life of 39 years and assumed zero salvage value.

Therefore,

Annual depreciation = (Cost - Salvage Value) / Useful Life

Annual Depreciation = $25,000,000 / 39

Annual Depreciation = $641,025.64

Step 3)

Calculate Annual Interest Payment as under:

As we know, APR = [((Interest) / Principal Amount) / n) *(12/25*12)

Therefore,

5% = ((Interest) / $30,000,000) / 25)*(12/12*25)

.i.e Interest = (5%*$30,000,000)/(12/12*25)

Annual Interest = $60,000

Step 4)

Calculate Tax as under:

Tax = NOI *Tax Rate

Therefore, Tax = $3,000,000 *30%

Tax = $900,000

Finally, Net Cash Flow = NOI - Annual Interest Payment - Tax + Annual Depcreciation

Therefore, Net Cash Flow = 3,000,000 - 60,000 - 900,000 + 641,025.64

Net Cash Flow = $2,681,026.64


Related Solutions

5. Kirby Corporation bought a building and the land on which it is situated for a...
5. Kirby Corporation bought a building and the land on which it is situated for a total cash price of $429,000. The company paid transfer costs to the lawyer of $5,000. Renovations done to the building totaled $52,000. The land and building were independently appraised at market values of $150,000 and $350,000 before the renovation respectively. Required: a) Allocate the cost of the property on the basis of the appraised values. Ensure you show your calculations. b) Prepare the journal...
You are considering investment in a project which will cost $50 million which will be depreciated...
You are considering investment in a project which will cost $50 million which will be depreciated to 0 over the next 3 years. The project will generate revenues of $13 million per year for the next 6 years with no expenses (other than depreciation). The company’s cost is capital is 8% and the corporate tax rate is 40%. After the 6 years, the project ends. What is the NPV of the project?
An investor bought the straddle on the $50 strike for $6. What price must the stock...
An investor bought the straddle on the $50 strike for $6. What price must the stock expire at in order for the investor to make money? Please describe a strangle option strategy? Please describe a straddle options strategy? In what ways are they similar? In what ways are they different?
You are the manager of a health clinic that is located in a building owned by...
You are the manager of a health clinic that is located in a building owned by four physician partners. The clinic owners hire all the clinic staff, including doctors, nurses, lab technicians, and office staff. Based on what you have learned in the context of this course, identify and discuss the decisions that would need to be made in order to efficiently operate this clinic in both the short run and the long run. Discuss and classify the clinic input...
A real estate investor has bought an office building valued at $100 million. After a 10%...
A real estate investor has bought an office building valued at $100 million. After a 10% down payment for the property price, the investor has borrowed a one-year mortgage loan at 10% interest rate from Nopay Bank to finance the remaining purchase price. The credit rating of the investor is ABB indicating that his probability of default is 3%. The current market value of the office building is $100 million. The office building is pledged with Nopay Bank as collateral....
The purchase price of Property and Building was of 50 million (100 single rooms and restaurants...
The purchase price of Property and Building was of 50 million (100 single rooms and restaurants with a total of 200 seats) purchased 10 years ago. Each year, 250,000 have been recorded as depreciation cost. • The present value of Capital Stock is 14 millions, Retained Earnings 3.5 millions, Mortgage 30 millions, Other long term loan 3 millions, Working Capital 3 millions. • We plan a refurbishment plan over the next 3 years of 2 million a year; the planned...
In a state lottery, if 6 numbers are chosen out of 50. If you match all 6, you win a million dollars. Is this a combination or permutation?
In a state lottery, if 6 numbers are chosen out of 50. If you match all 6, you win a million dollars. Is this a combination or permutation? How do you know? If it was the other one, would your chances be higher or lower and as a result would the pay out be higher or lower?
Clayton Company bought real estate, on which there was an old office building, for $300,000. It...
Clayton Company bought real estate, on which there was an old office building, for $300,000. It paid $50,000 in cash as a down payment and signed a 10% mortgage for the remainder. It immediately had the old building razed at a net cost of $35,000. Attorneys were paid $6,000 in connection with the land purchase and an additional $3,000 in connection with permits and zoning variances necessary for Patton's new office building. $20,000 was paid for excavation for the basement...
You just bought the first floor of the famous Building for $250,000. You plan to rent...
You just bought the first floor of the famous Building for $250,000. You plan to rent the space to convenience stores. Your banker has offered you a mortgage with the following terms: The mortgage is for the full amount of $250,000. The mortgage will be repaid in equal monthly payments over 36 months, starting 1 month from now. The annual interest rate on the mortgage is 8%, compounded monthly. You have to pay the bank an initiation charge of $1,500...
Bob the Builder purchased a land and building in Year 6 for $4,000,000. $1.6 million of...
Bob the Builder purchased a land and building in Year 6 for $4,000,000. $1.6 million of the purchase price was allocated to the land, and the balance to the building. At the time of the purchase it was estimated that the building would have a useful life of 40 years but no residual value. In Year 18, Bob exchanged the land and building for a piece of undeveloped land. The fair market value of the assets given up was estimated...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT