calculate cashflow highlighted below

The $200 is the initial investment and assume tax rate is 52% and discount rate is 10%.

Transcribed Image Text:

Year Net Project Cost 0 1 2 3 4 5 6 7 8 9 10 200 Net sales 2112 2304 2496 2688 2880 2880 3072 3072 3264 3264 [COGS] 1100 1200 1300 1400 1500 1500 1600 1600 1700 1700 S, G&A 1100 1050 1000 900 700 700 730 730 750 750 Erosion 180 200 210 220 230 230 240 240 250 250 Profit before -268 -146 -14 168 450 450 502 502 564 564 taxes EBIT Depreciatio 19 18 17 16 15 13 12 11 10 9 la 11 This cocument is available fee of charge on StuDocu.com Downloaded by Bryant Wu (bbbryant03@gmail.com) EBT -287 -164 -31 152 435 437 490 491 554 555 Net -78.72 -14.88 72.96 208.8 209.76 235.2 235.68 265.92 266.4 Profit NOP 137.7 AT 6 Figure 2. Determining NWC for DCF Framework. AR 124 134 142 151 160 160 169 169 178 178 Invento 207 222 237 251 266 266 281 281 296 296 ries Liabiliti (2) (82) (108) (138) (185) (184) (195) (195) (207) (207) es NWC 329 274 271 264 241 242 255 255 267 267 ANWC (55) (3) (7) (23) H 13 -0 12 -0 Figure 3. DCF Framework and Resulting Calculations Cash -200 2.92 13.28 103.64 254 flows 109.6 228 239.96 251.96 268.72 279.72 Year Net Project Cost 0 1 2 3 4 5 6 7 8 9 10 200 Net sales 2112 2304 2496 2688 2880 2880 3072 3072 3264 3264 [COGS] 1100 1200 1300 1400 1500 1500 1600 1600 1700 1700 S, G&A 1100 1050 1000 900 700 700 730 730 750 750 Erosion 180 200 210 220 230 230 240 240 250 250 Profit before -268 -146 -14 168 450 450 502 502 564 564 taxes EBIT Depreciatio 19 18 17 16 15 13 12 11 10 9 la 11 This cocument is available fee of charge on StuDocu.com Downloaded by Bryant Wu (bbbryant03@gmail.com) EBT -287 -164 -31 152 435 437 490 491 554 555 Net -78.72 -14.88 72.96 208.8 209.76 235.2 235.68 265.92 266.4 Profit NOP 137.7 AT 6 Figure 2. Determining NWC for DCF Framework. AR 124 134 142 151 160 160 169 169 178 178 Invento 207 222 237 251 266 266 281 281 296 296 ries Liabiliti (2) (82) (108) (138) (185) (184) (195) (195) (207) (207) es NWC 329 274 271 264 241 242 255 255 267 267 ANWC (55) (3) (7) (23) H 13 -0 12 -0 Figure 3. DCF Framework and Resulting Calculations Cash -200 2.92 13.28 103.64 254 flows 109.6 228 239.96 251.96 268.72 279.72