Question: A capital budgeting project is being considered for implementation. The asset is a 3-year MACRS class asset with a four-year project life. The cost of

A capital budgeting project is being considered for implementation. The asset is a 3-year MACRS class asset with a four-year project life. The cost of the asset, and the first year revenue and operating cost projections are provided in the table below:

Price of Asset

$280,000.00

Freight / Installation

$20,000.00

Depreciation Schedule:

Year 1

$99,000.00

Year 2

$135,000.00

Year 3

$45,000.00

Year 4

$21,000.00

Salvage Value

$30,000.00

Increase in NWC

$25,000.00

Revenues from project

$260,000.00

Operating Costs (excluding depreciation)

$115,000.00

Tax Rate

34%

Required Rate of Return

12%

Opportunity Cost - Sale of plant space

$100,000.00

Expected Annual Growth Project Revenue

4%

Expected Annual increase in operating cost

8%

Using Based on these projections, complete the Project Cash Flow Table below to calculate the relevant after tax cash flows, and then calculate the NPV and the IRR for the project. Show your numbers in thousands (200.00 for 200,000, etc). Read the problem carefully and consider all the data, especially the annual growth in revenue and operating costs.

Year

0

1

2

3

4

Total Revenues

Operating Costs (exc. dep)

Depreciation

Earnings before taxes

Taxes

Net income

Add back Depreciation

Net operating cash flows

Equipment Cost

Installation

Change in Net Working Capital

Opportunity Cost of Project

Salvage Value

Tax on Salvage Value

Return of NWC

NET CASH FLOWS

Q-1

Q-2

Q-3

Q-4

Q-5

Q- 6: I/YR = _________

Q

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!