Question

In: Finance

Kennedy Air is evaluating a new project.  The equipment will cost $50,000 plus $10,000 to install.  It will...

Kennedy Air is evaluating a new project.  The equipment will cost $50,000 plus $10,000 to install.  It will be depreciated using the MACRS 3-year class.  The project would require an increase in inventories of $6,000 and an increase in A/P of $1,000.  The firm’s yearly revenues would increase by $40,000 but would also increase operating costs by $10,000.  The project is expected to last 3 years and the equipment can then be sold for $10,000.  The firm’s tax rate is 40% and their cost of capital is 12%.  What is the project’s NPV?

Solutions

Expert Solution

NPV of the project is $5,505

Calculations: -

A). Initial cash outflow of the project is $65,000

initial cash outflow = cost of new equipment + increase in Net working

1.cost of new equipment = cost of purchase + installation cost

= $50,000 + $10,000

= $60,000

2.increase in Net working capital

= increase in inventories – increase in accounts payable

= $6,000 - $1,000

= $5,000

initial cash outflow = ($60,000 + $5,000) = $65,000

B.) Yearly operating Cash Flow is $65,486

Step 1: calculation of depreciation

Depreciation base =$60,000

Depreciation expense = depreciation base * rate

years

depreciation rate

depreciation

accumulated depreciation

1

0.333

19980

19980

2

0.445

26700

46680

3

0.148

8880

55560

Step 2: calculation of operating cash flow

Years

$1

$2

$3

Annual Sales

$40,000

$40,000

$40,000

Operating costs

($10,000)

($10,000)

($10,000)

Depreciation expense

($19,980)

($26,700)

($8,880)

EBIT

$10,020

$3,300

$21,120

Tax (40%)

($4,008)

($1,320)

($8,448)

Net income

$6,012

$1,980

$12,672

add non-cash expense(depreciation)

$19,980

$26,700

$8,880

Operating cash flows

$25,992

$28,680

$21,552

C.) Terminal cash flow of the project is $12776

Terminal cash flow = NSV of project assets + Recovered Net working capital

. NSV of new equipment

Book value of new asset (BV)

Depreciation basis - Accumulated Depreciation

= $60,000 - $55560

=$4,440

Market value (MV)

=$10,000

NSV of project old asset

= MV - tax rate (MV-BV)

=$10,000 - .4 *($10,000- $4,440)

=$7,776

Recovered Net working capital = $5,000

Therefore, Terminal cash flow =$7,776 + $5,000 = $12776

D.) NPV calculation

Years

0

1

2

3

initial investment

(60,000)

change in net working capital

(5,000)

5000

operating cash flow

$25,992

$28,680

$21,552

NSV of new equipment

7776

Total cash flows

(65,000)

$25,992

$28,680

$34,328

PVIF @   12%

1

0.8929

0.7972

0.7118

Discounted cash flows

(65,000)

$23,207

$22,864

$24,434

Sum of Discounted cash flows from year 1 to 6 = $70,505

NPV = Sum of Discounted cash flows from year 1 to 3 – initial outflow

NPV = $70,505 – 65,000

NPV = $5,505


Related Solutions

Kennedy Air is evaluating a new project. The equipment will cost $70,000 plus $8,000 to install....
Kennedy Air is evaluating a new project. The equipment will cost $70,000 plus $8,000 to install. It will be depreciated using the MACRS 3-year class. The project would require an increase in inventories of $5,000 and an increase in A/P of $3,000. The firm’s yearly revenues would increase by $70,000 but would also increase operating costs by $20,000. The project is expected to last 3 years and the equipment can then be sold for $12,000. The firm’s tax rate is...
A company is evaluating a new 4-year project. The equipment necessary for the project will cost...
A company is evaluating a new 4-year project. The equipment necessary for the project will cost $3,600,000 and can be sold for $725,000 at the end of the project. The asset is in the 5-year MACRS class. The depreciation percentage each year is 20.00 percent, 32.00 percent, 19.20 percent, 11.52 percent, and 11.52 percent, respectively. The company's tax rate is 40 percent. What is the aftertax salvage value of the equipment?
The company is evaluating new equipment that will cost $2,000,000. The equipment is in the MACRS...
The company is evaluating new equipment that will cost $2,000,000. The equipment is in the MACRS 3-year class and will be sold after 3 years for $150,000. Use of the equipment will increase net working capital by 200,000.    The equipment will save $850,000 in operating costs each year for 3 years. The company's tax rate is 25 percent and its cost of capital is 12%. Please show formulas in Excel.
Pear Orchards is evaluating a new project that will require equipment of $261,000. The equipment will...
Pear Orchards is evaluating a new project that will require equipment of $261,000. The equipment will be depreciated on a 5-year MACRS schedule. The annual depreciation percentages are 20.00 percent, 32.00 percent, 19.20 percent, 11.52 percent, and 11.52 percent, respectively. The company plans to shut down the project after 4 years. At that time, the equipment could be sold for $74,900. However, the company plans to keep the equipment for a different project in another state. The tax rate is...
Pear Orchards is evaluating a new project that will require equipment of $237,000. The equipment will...
Pear Orchards is evaluating a new project that will require equipment of $237,000. The equipment will be depreciated on a 5-year MACRS schedule. The annual depreciation percentages are 20.00 percent, 32.00 percent, 19.20 percent, 11.52 percent, and 11.52 percent, respectively. The company plans to shut down the project after 4 years. At that time, the equipment could be sold for $59,300. However, the company plans to keep the equipment for a different project in another state. The tax rate is...
Pear Orchards is evaluating a new project that will require equipment of $247,000. The equipment will...
Pear Orchards is evaluating a new project that will require equipment of $247,000. The equipment will be depreciated on a 5-year MACRS schedule. The annual depreciation percentages are 20.00 percent, 32.00 percent, 19.20 percent, 11.52 percent, and 11.52 percent, respectively. The company plans to shut down the project after 4 years. At that time, the equipment could be sold for $65,800. However, the company plans to keep the equipment for a different project in another state. The tax rate is...
Firm is evaluating the following project to install a new production facility. The production facility requires...
Firm is evaluating the following project to install a new production facility. The production facility requires an investment in a machine costing 25,000 USD. The machine will be fully depreciated according to the straight-line method. The life of the project is estimated to be 4 years. When the project is over, although the book value of the machine is 0, you expect to sell the machine at a market value of 1,000 USD. The project also requires working capital in...
Your company is considering a new project that will require $10,000 of new equipment at the...
Your company is considering a new project that will require $10,000 of new equipment at the start of the project. The equipment will have a depreciable life of five years and will be depreciated to a book value of $3,000 using straight-line depreciation. The cost of capital is 9 percent, and the firm's tax rate is 34 percent. Estimate the present value of the tax benefits from depreciation. A. $476 B. $924 C. $1,400 D. $1,851 Which statement is true...
A new equipment will cost 200,000 to install, 5,000 annually maintenance, and have a life of...
A new equipment will cost 200,000 to install, 5,000 annually maintenance, and have a life of 5 years. The revenue generated by this equipment is estimated to be 60,000 per year. The MARR is 10% per year compounded monthly. Examine the sensitivity of present worth to variation in individual parameters estimates, while others remain constant 1.Sensitivity to installation cost variation: 150,000 to 250,000 2.Sensitivity to revenue variation: 45,000 to 75,000 3.Sensitivity to life variation: 4 year to 7 year 4.Plot...
Dell is evaluating a project which has the initial cost of $10,000 and generates the following...
Dell is evaluating a project which has the initial cost of $10,000 and generates the following cash flow/ Year 1 2 3 4 5 Cash Flow 5,000 3,000 4,000 8,000 10,000 The firm's cost of capital is 10%. Calculate NPV, PI, IRR, MIRR, discounted payback, and payback period
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT