In: Finance
Your company is considering a 4-year expansion project that requires an initial fixed asset investment of $157,000. The fixed asset will be depreciated straight-line to zero over its 4-year life. The project is estimated to generate $150,000 in annual sales, with costs of $52,000. The project requires an initial investment in net working capital of $15,000, and the fixed asset will be sold for $13,000 at the end of the project. The tax rate is 25%, and the required return is 11%. Find the NPV of the project. Round your answer to the nearest dollar, for example 10789.
1.Straight Line Depreciation = $36,000 per year
Straight Line Depreciation for each year
= [ Cost of the machine – Salvage Value ] / Useful life
= [$157000-13000 ] / 4 Years
= $36,000 per year
2.Expected Net Income and Net cash Flow
EXPECTED NET INCOME |
||
Revenues |
||
Sales |
1,50,000 |
|
Expenses |
||
Cost |
52,000 |
|
Straight Line Depreciation |
36,000 |
|
88,000 |
||
Income Before Taxes |
62,000 |
|
Income Tax Expense@25% |
$15,500 |
|
Net Income |
$ 46,500 |
|
EXPECTED CASH FLOW |
||
Net Income |
$ 46500 |
|
Straight Line Depreciation |
$36000 |
|
Expected Cash Flow |
$82500 |
|
Chart values are based on |
||||
N= |
11% |
|||
I= |
4 Years |
|||
Cash flow |
Select chart |
Amount |
PV Factor |
Present Value |
Annual cash flow |
Present value of annuity of $1 |
$82500 |
3.1024 |
$2,55,952 |
Residual Value |
Present Value of $1 |
$13,000+15000=28000 |
0.6587 |
$18,444 |
Present Value of cash inflows |
$2,74,396 |
|||
Present Value of cash outflows |
157,000+15000=172000 |
$172000 |
||
Net Present Value |
$1,02,396 |