**USING EXCEL** CAPITAL BUDGETING Falcon Airlines, Inc. As owner of Falcon Airli
ID: 2792799 • Letter: #
Question
**USING EXCEL**
CAPITAL BUDGETING Falcon Airlines, Inc.
As owner of Falcon Airlines, you are considering the purchase of a new de-icing machine. The machine will be used to remove ice from the wings of Falcon’s planes during winter. The new machine will cost $98,000, shipping costs of $2,000, and also will require $3,000 in working capital to support the new machine’s operation. The equipment will be depreciated over a 3-year period using MACRS and will have an expected salvage value of $4,000 at the end of its expected economic life of four years. The annual savings associated with the machine are expected to be $25,000 per year for the next four years. The company will not deduct the salvage value from the machine’s cost when calculating depreciation. The existing de-icing machine is one year old but is not adequate for the company’s needs; it can be sold today for $40,000. The equipment was purchased for $60,000 and was being depreciated over a three-year period using the MACRS method. Falcon uses a hurdle rate of 11% for its capital budgeting projects and has a marginal tax rate of 30%. Determine whether you should purchase the new de-icing machine.
a. Determine the depreciation associated with the new machine, for each year using MACRS b. Determine unused depreciation on old machine c. Determine the cash inflows (after depreciation and taxes) associated with the new machine. d. Determine the cash outflows associated with the machine. Then determine the present value of both the cash outflows and the cash inflows. e. Determine the net present value of the proposed project, as well as the profitability index. f. Determine the modified internal rate of return (MIRR) for the new machine. g. Determine the payback period for the new machine. h. Determine the discounted payback period for the new machine.Explanation / Answer
CASH OUTFLOWS ( OR INITIAL INVESTMENT)
Cost of New Asset $98,000
Shipping 2,000
Working Capital 3,000
Sale Proceeds (40,000)
Tax on Sale of Old Asset
(see below) (6)
Total Cash Outflows (Initial Investment) $62,994
TAX ON SALE OF OLD ASSET
Original Cost $60,000 Selling Price $40,000
-Acc. Depreciation 19,980 -Book Value 40,020
Book Value $40,020 Gain (Loss) ($20)
Total Tax = Gain * Tax rate = ($20) x 30% = ($6)
CHANGE IN DEPRECIATION
Depreciation on New Asset – Depreciation on Old Asset = Change In Depreciation
Next Year = $33,300 - $26,700 = $6,600
Year 2 = 44,500 - 8,880 = 35,620
Year 3 = 14,800 - 4,440 = 10,360
Year 4 = 7,400 - 0 = 7,400
Year 5 = 0 - 0 = 0
Year 6 = 0 - 0 = 0
Year 7 = 0 - 0 = 0
Year 8 = 0 - 0 = 0
Year 9 = 0 - 0 = 0
Year 10 = 0 - 0 = 0
DETERMINATION OF CASH INFLOWS
Yr. Net Savings x (1 - T.R.) + Change in Deprec. x Tax Rate = Cash Inflow*
1 $25,000 x 0.70 + $6,600 x 0.30 = $19,480 2 25,000 x 0.70 + 35,620 x 0.30 = 28,186 3 25,000 x 0.70 + 10,360 x 0.30 = 20,608 4 25,000 x 0.70 + 7,400 x 0.30 = 19,720 5 0 x 0.00 + 0 x 0.00 = 0 6 0 x 0.00 + 0 x 0.00 = 0 7 0 x 0.00 + 0 x 0.00 = 0 8 0 x 0.00 + 0 x 0.00 = 0 9 0 x 0.00 + 0 x 0.00 = 0 10 0 x 0.00 + 0 x 0.00 = 0 * Does Not Include The Terminal Cash Flows (Shown Below) Of $5,800
TERMINAL CASH INFLOWS (Year 4)
Working Capital $3,000
+ Salvage Value of New Asset + 4,000
- Tax on Sale of New Asset:
Salvage Value of New Asset $4,000
- Book Value 0
Gain (Loss ) 4,000
x Tax Rate 30%
Tax on Salvage Value - 1,200
Total Terminal Cash Inflows $5,800
CASH OUTFLOWS @ 11% CASH INFLOWS
Cash flow x PVF = PVB
Cost of New Asset $98,000 (1) $19,480 x 0.901 = $17,550
Shipping 2,000 (2) 28,186 x 0.812 = 22,876
Working Capital 3,000 (3) 20,608 x 0.731 = 15,068
Sale Proceeds (40,000) (4) 25,520 x 0.659 = 16,811
Tax on Sale of Old Asset (6) (5) 0 x 0.000 = 0
(6) 0 x 0.000 = 0
(7) 0 x 0.000 = 0
(8) 0 x 0.000 = 0
(9) 0 x 0.000 = 0
(10) 0 x 0.000 = 0
_ P.V. OF COSTS = $62,994 P.V. OF BENEFITS = $72,305
SUMMARY OF FINDINGS
Net Present Value = $9,311 Profitability Index = 1.15 Internal Rate of Return = 17.57% Payback Period (yrs) = 2.74 Modified Internal Rate of Return = 14.89%
MODIFIED INTERNAL RATE OF RETURN
CASH OUTFLOWS @ 11% CASH INFLOWS
Cash Flow x FVF = Future Value
(0) Cost of New Asset $98,000 (1) 19,480 x 1.368 = $26,641 Shipping $2,000 (2) 28,186 x 1.232 = 34,728 Working Capital $3,000 (3) 20,608 x 1.110 = 22,875 Sale Proceeds ($40,000) (4) 25,520 x 1.000 = 25,520 Tax on Sale of Old Asset ($6) (5) 0 x 0.000 = 0
(6) 0 x 0.000 = 0
(7) 0 x 0.000 = 0
(8) 0 x 0.000 = 0
(9) 0 x 0.000 = 0
(10) 0 x 0.000 = 0 P.V. OF COSTS = $62,994 F.V. OF BENEFITS = $109,764
PAY BACK PERIOD
YEAR CASH OUTFLOW CASH INFLOW AMOUNT OWED NO. OF YEARS
0 $ 62994 62994
1 19480 43514 1
2 28186 15328 1
3 20608 0 0.74
PAYBACK PERIOD = 2.74 YEARS
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.