Profit Plan Capacity 6,000,000.00
Sales COGS: Variable Cost Fixed Cost R&D Selling Administrative Interest
8.80
6,000,000.00 3,319,500.00
6.60
3,328,130.00 3,574,710.00 4,752,000.00 3,825,000.00
0.25 0.35 0.50
4.55%
Profit Before Taxes Taxes (40%) Profit After Tax
3.13%
Cash Flows Profit Depreciation Additional Depreciation (New Investment) Change In Inventory Change in A/R Initial Cash
957,791.40 2,593,700.00 400,000.00 1,148,400.00 (7,868,467.00) 1,121,450.00
Ending Cash
(1,647,125.60)
Assumptions 52,800,000.00 Volume and Price (39,600,000.00) Meet Cost per Unit (3,319,500.00) Estimated Savings (832,032.50) (1,251,148.50) (2,376,000.00) (3,825,000.00)
Estimated Savings Estimated Savings Estimated Savings Save Debt Level
Risk 10% 25% 80% 80% 80% 80% 10%
1,596,319.00 (638,527.60) 957,791.40
9165869
No Finished Goods Inventory Left
10.45%
Unit Cost Fixed Cost
6,600.00 3,319,500.00
Coffee Grade Price per KG
D 8,800.00
12,485.00 4,100,500.00
C 19,500.00
Margin - Advertising (a) 0% 1% 2% 3% 4% 5% 6% 7% 8% 9% 10%
9,880,500.00
12,700,425.00 12,642,600.00 12,760,125.00 13,035,450.00 13,357,500.00 13,717,500.00 14,194,350.00 13,956,900.00 13,726,440.00 13,310,100.00 12,816,600.00
14,275.00 4,100,500.00
16,288.00 4,100,500.00
17,791.00 4,100,500.00
19,166.00 4,100,500.00
20,441.00 4,100,500.00
B 26,600.00
BB 30,000.00
A 35,500.00
AA 39,000.00
AAA 42,600.00
16,174,125.00 16,351,564.00 16,191,715.10 17,766,207.47 18,691,764.00 19,714,670.00 21,295,043.00 21,188,571.00 20,841,362.00 20,379,415.00 20,004,010.00
16,865,148.00 16,902,692.00 17,521,188.00 18,448,620.00 19,472,108.00 20,592,164.00 21,593,684.00 21,387,840.00 21,136,572.00 20,764,596.00 20,387,132.00
15,432,527.00 15,769,830.00 16,740,274.00 18,102,596.00 19,616,284.00 21,250,494.00 22,742,117.00 23,180,908.00 23,005,687.00 22,561,718.00 21,994,537.00
9,128,778.00 9,840,848.00 11,123,646.00 12,883,740.00 14,794,816.00 16,859,548.00 18,764,158.00 18,904,380.00 18,730,824.00 20,303,880.00 20,166,982.00
(1,286,307.00) (688,419.00) 778,803.00 2,685,825.00 4,756,515.00 6,975,537.00 8,974,701.00 9,208,338.00 10,000,252.00 11,933,875.00 12,635,065.00
Unit Cost Fixed Cost
6,600.00 3,319,500,000.00
Coffee Grade Price per KG
D
12,485.00 4,100,500,000.00
C 8,800.00
19,500.00
6,000,000.00
2,395,000.00 2,455,000.00 2,545,000.00 2,665,000.00 2,800,000.00 2,950,000.00 3,130,000.00 3,196,000.00 3,268,000.00 3,310,000.00 3,340,000.00
Margin - Advertising (a) 0% 1% 2% 3% 4% 5% 6% 7% 8% 9% 10%
14,275.00 4,100,500,000.00
B
16,288.00 4,100,500,000.00
BB
17,791.00 4,100,500,000.00
A
19,166.00 4,100,500,000.00
AA
20,441.00 4,100,500,000.00
AAA
26,600.00
30,000.00
35,500.00
39,000.00
42,600.00
1,645,000.00 1,696,000.00 1,720,700.00 1,896,999.00 2,024,000.00 2,166,000.00 2,367,000.00 2,417,000.00 2,446,000.00 2,465,000.00 2,494,000.00
1,529,000.00 1,566,000.00 1,649,000.00 1,760,000.00 1,884,000.00 2,022,000.00 2,157,000.00 2,195,000.00 2,231,000.00 2,258,000.00 2,286,000.00
1,103,000.00 1,145,000.00 1,226,000.00 1,334,000.00 1,456,000.00 1,591,000.00 1,723,000.00 1,792,000.00 1,823,000.00 1,837,000.00 1,843,000.00
667,000.00 717,000.00 799,000.00 910,000.00 1,034,000.00 1,172,000.00 1,307,000.00 1,345,000.00 1,366,000.00 1,495,000.00 1,523,000.00
127,000.00 157,000.00 229,000.00 325,000.00 433,000.00 553,000.00 667,000.00 694,000.00 752,000.00 875,000.00 935,000.00
