Given:

Investment: Sell at end of Project:

Trucks $3$ @ $$45,000$ each w$/3$yr MACRS Trucks $-$ $$10,000$ each

Machinery $=$ $$750,000$ w$/7-$yr MACRS Machinery $-$ $$150,000$

Working capital:

Project Life $=5-$Years Account Receivables $-1\mathrm{.}5$ Months

Accounts Payables $-1-$month

Product Selling Price $-$ $$250/$unit Finished Goods Inventory $-1$ month

Labor $-$ $$25/$unit Raw Material Inventory $-1-$Month

Materials $-$ $$40/$unit

Overhead Fixed$-$ $$200,000/$year

Annual quantity $5,000$

Blended Income Tax Rate: $25\%$

MARR $-15\%$

Find:

Project Cash Flows $5$ Points Show answers in your worksheet

Depreciation $2$ Points

Gains$/$Loss Tax $3$ Point

Working Capital $3$ Points

IRR $1$ Point

NPV $1$ Point$\backslash$table$[[,$Class,$3,5,7,10,15,20],[$Year n$,$Depreciation Rate,$200\%,200\%,200\%,200\%,150\%,150\%],[1,,33\mathrm{.}33,20\mathrm{.}00,14\mathrm{.}29,10\mathrm{.}00,5\mathrm{.}00,3\mathrm{.}750],[2,,44\mathrm{.}45,32\mathrm{.}00,24\mathrm{.}49,18\mathrm{.}00,9\mathrm{.}50,7\mathrm{.}219],[3,,14\mathrm{.}81^(**),19\mathrm{.}20,17\mathrm{.}49,14\mathrm{.}40,8\mathrm{.}55,6\mathrm{.}677],[4,,7\mathrm{.}41,11\mathrm{.}52^(**),12\mathrm{.}49,11\mathrm{.}52,7\mathrm{.}70,6\mathrm{.}177],[5,,,11\mathrm{.}52,8\mathrm{.}93^(**),9\mathrm{.}22,6\mathrm{.}93,5\mathrm{.}713],[6,,,5\mathrm{.}76,8\mathrm{.}92,7\mathrm{.}37,6\mathrm{.}23,5\mathrm{.}285],[7,,,,8\mathrm{.}93,6\mathrm{.}55^(**),5\mathrm{.}90^(**),4\mathrm{.}888],[8,,,,4\mathrm{.}46,6\mathrm{.}55,5\mathrm{.}90,4\mathrm{.}522],[9,,,,,6\mathrm{.}56,5\mathrm{.}91,4\mathrm{.}462^(**)],[10,,,,,6\mathrm{.}55,5\mathrm{.}90,4\mathrm{.}461],[11,,,,,3\mathrm{.}28,5\mathrm{.}91,4\mathrm{.}462],[12,,,,,,5\mathrm{.}90,4\mathrm{.}461],[13,,,,,,5\mathrm{.}91,4\mathrm{.}462],[14,,,,,,5\mathrm{.}90,4\mathrm{.}461],[15,,,,,,5\mathrm{.}91,4\mathrm{.}462],[16,,,,,,2\mathrm{.}95,4\mathrm{.}461],[17,,,,,,,4\mathrm{.}462],[18,,,,,,,4\mathrm{.}461],[19,,,,,,,4\mathrm{.}462],[20,,,,,,,4\mathrm{.}461],[21,,,,,,,2\mathrm{.}231]]$