$\backslash$table$[[$Project A:$,,,,,,,],[,$Year$],[,0,1,2,3,4,5,6],[,,,,,,,],[$Equipment cost$,$$ $202,000,,,,,,],[$Inflation rate,,$0\mathrm{.}0\%,2\mathrm{.}8\%,2\mathrm{.}8\%,2\mathrm{.}8\%,2\mathrm{.}8\%,2\mathrm{.}8\%],[,,,,,,,],[$Unit sales,,$5,100,,,,,],[$Projected $\%$ change in unit sales,,,$20\mathrm{.}0\%,11\mathrm{.}0\%,5\mathrm{.}0\%,\mathrm{.}5\mathrm{.}0\%,-1\mathrm{.}0\%],[$Selling price per unit,,$ $48\mathrm{.}50,,,,,],[$Projected $\%$ change in selling prices,,,$2\mathrm{.}1\%,3\mathrm{.}0\%,3\mathrm{.}0\%,1\mathrm{.}0\%,1\mathrm{.}0\%],[$Direct materials as $\%$ of sales,,$40\mathrm{.}2\%,39\mathrm{.}6\%,39\mathrm{.}2\%,38\mathrm{.}9\%,38\mathrm{.}9\%,38\mathrm{.}9\%],[$Direct labor hours per unit produced,,$0\mathrm{.}75,0\mathrm{.}749,0\mathrm{.}748,0\mathrm{.}747,0\mathrm{.}746,0\mathrm{.}746],[$Direct labor rate per hour with benefits,,$ $15\mathrm{.}10,,,,,],[$Increase in direct labor rate from prior year,,,$3\mathrm{.}0\%,3\mathrm{.}0\%,3\mathrm{.}0\%,3\mathrm{.}0\%,3\mathrm{.}0\%],[$Variable overhead as a $\%$ of sales,,$4\mathrm{.}8\%,5\mathrm{.}0\%,5\mathrm{.}0\%,5\mathrm{.}0\%,5\mathrm{.}5\%,5\mathrm{.}4\%],[$Fized overhead excluding depreciation,,$ $20\mathrm{.}000,,,,,],[$Variable selling and administrative exp as $\%$ of sales,,$2\mathrm{.}9\%,3\mathrm{.}0\%,3\mathrm{.}0\%,3\mathrm{.}0\%,3\mathrm{.}1\%,3\mathrm{.}2\%],[$Fixed selling and administrative expense,,$ $10,100,,,,,],[$Weighted average cost of capital,,$10\%,,,,,]]\backslash$table$[[,,,,,,,],[$Unit sales,,$5,100,6,120\mathrm{.}0,5,661\mathrm{.}0,5,355\mathrm{.}0,\backslash$table$[[4,845\mathrm{.}0],[$$ $23\mathrm{.}52]],\backslash$table$[[5,049\mathrm{.}0],[$$ $23\mathrm{.}52]]],[$Selling price per unit,,$ $48\mathrm{.}50,$$ $49\mathrm{.}40,$$ $70\mathrm{.}57,$$ $70\mathrm{.}57,$$ $113,967,$$ $118,765],[$Annual net sales,,$ $247,350,$$ $302,311,$$ $399,483,5,377,889,,],[$Direct labor hours,,$6,800,8,171,7,568,7,169,6,495,6,768],[$Direct labor rate,,$ $,15\mathrm{.}10,$$ $15\mathrm{.}55,$$ $,16\mathrm{.}02,$$ $16\mathrm{.}50,$$ $17\mathrm{.}00,$$ $17\mathrm{.}51],[$Direct labor cost,,$ $102,680,$$ $127,082,$$ $121,239,$$ $118,284,$$ $110,378,$$ $118,476],[,,,,,,,],[,,,,,,,],[,0,1,2,3,4,5,6],[,,,,,,,],[$Net sales,,,,,,,$],[$Cost of goods sold:,,,,,,,$],[$Materials$,,,,,,,],[$Direct Labor,,,,,,,$],[$Variable overhead,,,,,,,$],[$Fixed Overhead not including depreciation expense,,,,,,,$],[$Depreciation expense,,,,,,,$],[$Cost of goods sold,,,,,,,$],[$Cost of goods sold as $\%$ of sales,,,,,,,$]]$

$\backslash$table$[[$Operating Expenses:,,,,,,,$],[$Variable selling and administrative costs,,,,,,,$],[$Fixed selling and administrative costs,,,,,,,$],[$Total operating expenses,,,,,,,$],[$Operating income,,,,,,,$],[$Income taxes,,,,,,,$],[$Income after taxes,,,,,,,$],[$Add: Depreciation,,,,,,,$],[$Net cash flow,,,,,,,$],[,,,,,,,],[$Net present value,,,,,,,$],[$Internal rate of return,,,,,,,$],[$Modified internal rate of return,,,,,,,$],[$Payback$,,,,,,,],[$Discounted payback,,,,,,,$],[$Total cash flow,,,,,,,$],[,$Year$],[,0,1,2,3,4,5,6],[$Payback:$,,,,,,,],[$Cash flow,,,,,,,$],[$Cummulative cash flow,,,,,,,$],[$Payback$,,,,,,,]]$

$\backslash$table$[[61,$Total cash flow,Year$],[\backslash$table$[[62],[63]],,0,1,2,3,4,5,6],[64,$Payback:,,,,,,,$],[,,,,,,,,],[65,$Cash flow,,,,,,,$],[66,$Cummulative cash flow,,,,,,,$],[67,$Payback,,,,,,,$],[68,,,,,,,,],[69,$Discounted Payback:,,,,,,,$],[70,$Cash flow,,,,,,,$],[71,$Cummulative cash flow,,,,,,,$],[72,$Discounted Payback,,,,,,,$],[73,,$Units Shipped,NPV$,,,,,],[74,$Project A Data Table:,,,,,,,$],[75,,,,,,,,],[76,$Sales $-10\%$ reduction in units,$4,590,,,,,,],[77,$Sales $-$ Forecasted number of units,$5,100,,,,,,],[78,$Sales $-10\%$ higher number of units,$5,610,,,,,,]]$