Question

In: Finance

The table below illustrates a very simple capital budgeting project over just three years. It represents...

The table below illustrates a very simple capital budgeting project over just three years. It represents many of the key items in the capital budgeting process. The WACC is 12.5% and the tax rate used for analysis and planning is 33.0%. Run through the calculations necessary to find the numbers for the missing spaces.

NOTE: If the table is not fully viewable, zoom out until it is.

Round all numbers to the nearest whole dollar and enter in the spaces without decimals or dollar signs; negative numbers should be entered with a simple minus sign (and no space). No credit is given for incorrect entries.

For example, calculated cash of $2,347.59 would be entered as 2348; a calculation of $(3,290) should be entered as -3290.

?

Period 0 Period 1 Period 2 Period 3
Depreciation $400 $400 $400
Other operating expenses $650 $850 $1,150
Operating income $(250) $700 $900
NOPAT $ $469 $603
Adjustment for depreciation $ $400 $400
Anticipated changes in cash flow from existing products
Salvage or terminal value $250
Initial project capital investments $(1,200)
Net incremental cash flows $(1,200) $ $869 $1,253
WACC 12.5%
PV $(1,200) $ $ $880
NPV $573

Solutions

Expert Solution

NOPAT = operating profit * (1 - tax rate)

For period 1, NOPAT = - $ 250 * ( 1 - 0.33) = - $250 * 0.67 = - $168

Adjustment for depriciation is the amount depriciated for a particular period. for period 1, Adjustment for depriciation will be $ 400.

Net Incremental cash flow = NOPAT + Adjustment for depriciation = - $168 + $400 = $ 232

PV = Net Incremental cash flow / ( 1 + WACC) ^ no of periods

For period 1, PV = $232 / (1 + 0.125) = $232 / 1.125 = $206

For period 2, PV = $869 / (1 + 0.125) ^ 2 = $869 / 1.266 = $687

So above given table will like :


Related Solutions

Epiphany Industries is considering a new capital budgeting project that will last for three years. Epiphany...
Epiphany Industries is considering a new capital budgeting project that will last for three years. Epiphany plans on using a cost of capital of 12% to evaluate this project. Based on extensive research, it has prepared the following incremental cash flow projections: Year 0 1 2 3 Sales (Revenues in $) ​ 100,000 100,000 100,000 - Cost of Goods Sold (50% of Sales) ​ 50,000 50,000 50,000 - Depreciation ​ 30,000 30,000 30,000 = EBIT ​ 20,000 20,000 20,000 -...
Epiphany Industries is considering a new capital budgeting project that will last for three years. Epiphany...
Epiphany Industries is considering a new capital budgeting project that will last for three years. Epiphany plans on using a cost of capital of 12% to evaluate this project. Based on extensive research, it has prepared the following incremental cash flow projections: Year 0 1 2 3 Sales (Revenues) 100,000 100,000 100,000 - Cost of Goods Sold (50% of Sales) 50,000 50,000 50,000 - Depreciation 30,000 30,000 30,000 = EBIT 20,000 20,000 20,000 - Taxes (35%) 7000 7000 7000 =...
How would a very risky investment/project be handled in the capital budgeting/cost of capital context?
How would a very risky investment/project be handled in the capital budgeting/cost of capital context?
Case Project Create a company. Your represents the capital budgeting committee of a successful firm. You...
Case Project Create a company. Your represents the capital budgeting committee of a successful firm. You have been invited to the next Board of Directors meeting to present your analysis and recommendation on a new capital project. Your presentation should contain the following: 1. Brief description of the proposed capital project 2. Estimation of the incremental cash flows related to the project 3. Estimation of the weighted average cost of capital 4. Financial evaluation of capital budget project (using NPV...
Charlene is evaluating a capital budgeting project that should last for 4 years. The project requires...
Charlene is evaluating a capital budgeting project that should last for 4 years. The project requires $125,000 of equipment and is eligible for 100% bonus depreciation. She is unsure whether immediately expensing the equipment or using straight-line depreciation is better for the analysis. Under straight-line depreciation, the cost of the equipment would be depreciated evenly over its 4-year life (ignore the half-year convention for the straight-line method). The company's WACC is 10%, and its tax rate is 20%. a. What...
Charlene is evaluating a capital budgeting project that should last for 4 years. The project requires...
Charlene is evaluating a capital budgeting project that should last for 4 years. The project requires $150,000 of equipment. She is unsure what depreciation method to use in her analysis, straight-line or the 3-year MACRS accelerated method. Under straight-line depreciation, the cost of the equipment would be depreciated evenly over its 4-year life (ignore the half-year convention for the straight-line method). The applicable MACRS depreciation rates are 33%, 45%, 15%, and 7%. The company's WACC is 10%, and its tax...
Charlene is evaluating a capital budgeting project that should last for 4 years. The project requires...
Charlene is evaluating a capital budgeting project that should last for 4 years. The project requires $800,000 of equipment. She is unsure what depreciation method to use in her analysis, straight-line or the 3-year MACRS accelerated method. Under straight-line depreciation, the cost of the equipment would be depreciated evenly over its 4-year life (ignore the half-year convention for the straight-line method). The applicable MACRS depreciation rates are 33%, 45%, 15%, and 7%. The company's WACC is 14%, and its tax...
Kristin is evaluating a capital budgeting project that should last for 4 years. The project requires...
Kristin is evaluating a capital budgeting project that should last for 4 years. The project requires $750,000 of equipment. She is unsure what depreciation method to use in her analysis, straight-line or the 3-year MACRS accelerated method. Under straight-line depreciation, the cost of the equipment would be depreciated evenly over its 4-year life (ignore the half-year convention for the straight-line method). The applicable MACRS depreciation rates are 33%, 45%, 15%, and 7%. The company's WACC is 10%, and its tax...
Charlene is evaluating a capital budgeting project that should last for 4 years. The project requires...
Charlene is evaluating a capital budgeting project that should last for 4 years. The project requires $225,000 of equipment. She is unsure what depreciation method to use in her analysis, straight-line or the 3-year MACRS accelerated method. Under straight-line depreciation, the cost of the equipment would be depreciated evenly over its 4-year life (ignore the half-year convention for the straight-line method). The applicable MACRS depreciation rates are 33%, 45%, 15%, and 7%. The company's WACC is 11%, and its tax...
Kristin is evaluating a capital budgeting project that should last for 4 years. The project requires...
Kristin is evaluating a capital budgeting project that should last for 4 years. The project requires $150,000 of equipment. She is unsure what depreciation method to use in her analysis, straight-line or the 3-year MACRS accelerated method. Under straight-line depreciation, the cost of the equipment would be depreciated evenly over its 4-year life (ignore the half-year convention for the straight-line method). The applicable MACRS depreciation rates are 33%, 45%, 15%, and 7%. The company's WACC is 8%, and its tax...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT