• Author / Uploaded
• paul

Citation preview

TSP 1st Per. 2112 1012 1100

2nd Per. 2304 1104 1050

3rd Per. 2496 1196 1000

46 15 -149

43

41

11

155

77

-6

-81

-72 65

5 61

74 58

Cash flow from operation

-7

66

132

Receivables Inventories Prepaid & Deferred Exp. Less Current Liabilities Total Working Funds (15 Thru 19)

124 207

134 222

142 237

(2) 329

(82) 274

(108) 271

2nd Per.

3rd Per.

Profit Projections Net Sales Gross Profit

Selling Expense Increase Overhead Depreciation on Jell-O equipment Start-up costs Profit before taxes Taxes (52%) Net Profit Depreciation

Project Request Detail Land Buildings Machinery & Equipment Engineering Other (Explain) Expense Portion (Before Tax) Sub Total Less: Salvage Value (Old Asset) Total Project Cost* Less: Taxes on Exp. Portion Net Project Cost

Total Project Cash Flows (Oper. + Inv Cash Flow available to Investors Cash flow from operations Working Capital New Plant and Equipment Jell-O Facilities Total Cash Flows Net Present Value (VAN) TIR

Jell-O Facilities Used Cash Flow available to Investors

1st Per. $ 80 120 453 0 653 653 0 Per.

1st Per.

8

-7 -329

-200 -453 -645 539.5 18.5%

0 Per.

-336

1st Per.

66

132 3

121

135

55

2nd Per.

3rd Per.

Cash flow from operations :Depre(1Working Capital New Plant and Equipment Jell-O Facilities Total Cash Flows Net Present Value (VAN) TIR

SGA Overhead Allocation Cash Flow available to Investors Cash flow from operations :Overh(1Working Capital New Plant and Equipment Jell-O Facilities Total Cash Flows Net Present Value (VAN) TIR

Erosion of Jell-O Profits Cash Flow available to Investors Cash flow from operations Working Capital New Plant and Equipment Jell-O Facilities Total Cash Flows Net Present Value (VAN) TIR

Alternatives Analysis 1 2 3 4 5 6 7 8

0

-22 0

0 453 453 326.2 -9.5%

0 Per.

0

-22

1st Per.

0

0 0

0 0 0 128.5 Err:523

0 Per.

-86

-20

2nd Per.

3rd Per.

0 0

0 0

0

-86 0

Net Present Value (VAN) Base Case 540 540 540 540 540 540 540 540

0

2nd Per.

0

-20

-21

0

1st Per.

0 0 0 -646.6 Err:523

-21

0

3rd Per.

-96

-101 0

-96

-101

0

Erosion of Jell-O Profits -647 -647 -647 -647 0 0 0 0

4th Per. 2688 1288 900

5th Per. 2880 1380 700 90 35

38 350

6th Per. 2880 1380 700 90 33 555

7th Per. 3072 1472 730 90 30 557

8th Per. 3072 1472 730 90 26 622

9th Per. 3264 1564 750 90 24 626

700

-182

-289

-290

-323

-326

-364

168

266

267

299

300

336

54

50

46

42

37

34

222

316

313

341

337

370

157 251

160 266

160 266

169 281

169 281

178 296

(138) 270

(185) 241

(184) 242

(195) 255

(195) 255

(207) 267

7th Per.

8th Per.

9th Per.

341

337

370

4th Per.

5th Per.

222

6th Per.

316 1

313 29

-1

-13

0

-12

223

345

312

328

337

358

4th Per.

5th Per.

6th Per.

7th Per.

8th Per.

9th Per.

-18

-17 0

-16 0

-14 0

-12 0

-12 0

0

-18

-17

-16

-14

-12

-12

4th Per.

5th Per.

6th Per.

7th Per.

8th Per.

9th Per.

0

43 0

0

0

43

4th Per.

-110

-110 0

-110

-110

43 0

43 0

43

43

7th Per.

8th Per.

9th Per.

-115

-115

-120

0

Jell-O Facilities Used 326 0 326 0 326 0 326 0

43 0

43

6th Per.

0

-106

43

5th Per.

-106

43 0

0

-115

0

-115

0

-120

SGA Overhead Allocation 129 129 0 0 129 129 0 0

10th Per. 3264 1564 750 90 21 703

-366 337 30 367

178 296 (207) 267

10th Per.

11th Per.

367 0

367

10th Per.

267 31 60 358

11th Per.

0 OJO … OJO

-10 0

-10

0 0 -60

10th Per.

11th Per.

43

0 0

43

0 0 0

10th Per.

11th Per.

-60 0

0 OJO … OJO

0

0 OJO … OJO

0

0 OJO … OJO

-120 0

-120

0 0 0

Net Present Value (VAN) Total 348 21 219 -107 994 668 866 540