The ABC Corporation is considering opening an office in a new market area that would allow it to increase its annual sales by $2.5 million. Cost of goods sold is estimated to be 40 percent of sales, and corporate overhead would increase by $300,000, not including the cost of either acquiring or leasing office space. The corporation will have to invest $2.5 million in office furniture, office equipment, and other up-front costs associated with opening the new office before considering the costs of owning or leasing the office space. A small office building could be purchased for sole use by the corporation at a total price of $3.9 million, of which $600,000 of the purchase price would represent land value, and $3.3 million would represent building value. The cost of the building would be depreciated over 39 years. The corporation is in a 30 percent tax bracket. An investor is willing to purchase the same building and lease it to the corporation for $450,000 per year for a term of 15 years, with the corporation paying all real estate operating expenses (absolute net lease). Real estate operating expenses are estimated to be 50 percent of the lease payments. Estimates are that the property value will increase over the 15-year lease term for a sale price of $4.9 million at the end of the 15 years. If the property is purchased, it would be financed with an interest-only mortgage for $2,730,000 at an interest rate of 10 percent with a balloon payment due after 15 years.
a. What is the return from opening the office building under the assumption that it is leased?
b. What is the return from opening the office building under the assumption that it is owned?
c. What is the return on the incremental cash flow from owning versus leasing?
d. In general, what other factors might the firm consider before deciding whether to lease or own?

Respuesta :

Answer:

A. 12.02%

B. 12.56%.

C. 13.41%

D.1. How long will it take for the asset to be needed

2. How much space is needed to establish the firm.

3. How much expense will the firm incurred to help keep the assets perfectly.

Explanation:

a. Calculation to determine the return from opening the office building under the assumption that it is leased

First step is to calculate the after-tax cash flow l

Sales $2,500,000

Less Cost of goods sold $1,000,000

(40%*$2,500,000)

Gross income $1,500,000

($2,500,000-$1,000,000)

Less: Operating expense

Business expense $300,000

Real estate $225,000

(50%*$450,000)

Less: Lease payments $450,000

Interest payment-

Depreciation-

Taxable income $525,000

Less: Tax ($157,500)

(30%*$225,000)

Income after tax$367,500

($525,000-$157,500)

Add: Depreciation-

Principal-

After-tax cash flow$367,500

($525,000-$157,500)

Now let determine the return from opening the office building

Since the after tax cash flow for 15 years is the amount of $367,500 while the cash outlay is the amount of $2,500,000 using excel to determine the Internal rate of return (IRR) the return from opening the office building will be 12.02%.

Therefore the return from opening the office building under the assumption that it is leased is 12.02%

b. Calculation to determine the return from opening the office building under the assumption that it is owned.

First step is to Calculate the after-tax cash flow

Sales $2,500,000

Cost of goods sold $1,000,000

(40%*$2,500,000)

Gross income $1,500,000

($2,500,000-$1,000,000)

Less: Operating expense

Business expense $300,000

Real estate $225,000

(50%*$450,000)

Less: Lease payments

Interest payment $273,000

(10%*$2,300,000)

Less: Depreciation $84,615

Taxable income $617,385

Less: Tax at 30% $185,215

(30%*$617,385)

Income after tax $432,169

($617,385-$185,215)

Add: Depreciation$84,615

Principal0

After-tax cash flow $516,785

($432,169+$84,615)

Since the after tax cash flow for 15 years is the amount of $367,500, the residual value after 15 years is the amount of $2,006,015 calculated as ($1,489,231+$516,785)and The cash outlay is the amount of $3,670,000 using excel to compute the Internal rate of return (IRR) the return from opening the office building

will be 12.56%.

c. Calculation to determine the return on the incremental cash flow from owning versus leasing

First step is to Calculate the difference between owning and leasing cash flows

Sales -

Cost of goods sold-

Gross income-

Less: Operating expense-

Business expense-

Real estate-

Less: Lease payments ($450,000)

Interest payment $273,000

(10%*$2,300,000)

Less: Depreciation$84,615

Taxable income $92,385

Less: Tax at 30% $27,715

(30%$92,385)

Income after tax $64,669

($92,385-$27,715)

Add: Depreciation $84,615

Principal0

After-tax cash flow $149,285

($64,669+$84,615)

Since the after-tax cash flow is the amount of $149,285 for 15 years and the cash outlay is the amount of $1,170,000 using the internal rate of return with excel the return on the incremental cash flow from owning versus leasing will be 13.41%.

d.Factors the firm might consider before deciding whether to lease or own are :

1. How long will it take for the asset to be needed

2. How much space is needed to establish the firm.

3. How much expense will the firm incurred to help keep the assets perfectly.