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.