FS (1) - CF

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 12

Good Item Treats

FORECASTED REVENUE 2024

Annual revenue
Sales Price per unit per product
Original chips (unflavored) 1,755 70.00 122,850.00
classic flavors (cheese, bbq, sourcream) 8,058 75.00 604,350.00
spicy classic flavors (spicy cheese, s.bbq, s.sourcre 4,299 80.00 343,920.00

TOTAL OF FORECASTED REVENUE 1,071,120.00

Good Item Treats


Pro Forma Income Statement
For the year ending 2024-2028

2024 2025 2026


Sales 1,071,120 2,359,964 2,548,715

Cost of Goods Sold


Direct Materials Beginning Inventory - 2,454.26 7,820.64
Direct Material (Purchases) 247,194.00 509,219.64 524,496.23
Direct Labor 151,372.80 311,827.97 321,182.81
Overhead - 120,000 120,000
Total Cost of Goods Available for Sale 398,566.80 943,501.87 973,499.68
Less: Direct Material Ending Inventory 2,454.26 7,820.64 8,178.37
Total Cost of Goods Sold 396,112.54 935,681.23 965,321.31

Gross Margin 675,007.46 1,424,282.77 1,583,393.69

Operating Expenses:
Sales and Marketing 10,000.00 20,600.00 21,218.00
Salaries and Wages 191,055.00 393,573.30 405,380.50
Utilities 20,574.00 61,548.00 63,394.44
Supplies 17,726.00 36,515.56 37,611.03
Maintenance, repair, and overhaul 2,275.65 4,687.84 4,828.47
Rental Expense 180,000.00 360,000.00 360,000.00
Permits and Licenses 2,600.00 1,055.00 1,086.65
Interest Expense 20,681.12 49,634.69 49,634.69
Transportation Expense 5,000.00 10,000.00 10,000.00
Depreciation Expense 3,719.00 10,693.27 10,902.94
Miscellaneous Expense 3,000.00 6,180.00 6,365.40
Total Operating Expense 456,630.77 948,307.66 964,056.72

Operating Income 218,376.69 475,975.11 619,336.97


Provision for Income Tax 43,675.34 95,195.02 123,867.39
Net Income 174,701.35 380,780.09 495,469.58

Good Item Treats


Pro Forma Balance Sheet
For the year ending 2024-2028

2024 2025 2026


Cash 376,689.97 679,339.26 1,135,719.36
Accounts Receivable - - -
Inventory 2,454.26 7,820.64 8,178.37
Current Assets 379,144.23 687,159.90 1,143,897.73
Capital Improvements 3,424.00 3,424.00 3,424.00
Machinery and Equipment 15,171.00 48,994.00 48,994.00
Less: Accumulated Depreciation 3,719.00 14,412.27 25,315.21
Total Equipment 14,876.00 38,005.73 27,102.79

Total Assets 394,020.23 725,165.63 1,171,000.52

Accounts Payable - - -
Loan Payable - - -
Current Liabilities - - -
Long-Term Debt 159,318.88 109,684.19 60,049.50
Total Liabilities 159,318.88 109,684.19 60,049.50

Capital 60,000.00 234,701.35 615,481.44


Retained Earnings 174,701.35 380,780.09 495,469.58
Total Equity 234,701.35 615,481.44 1,110,951.02

Total Liabilities and Equity 394,020.23 725,165.63 1,171,000.52


0.00 0.00 0.00

Good Item Treats


Pro Forma Cash Flow
For the year ending 2024-2028

2024 2025 2026


Net income 174,701.35 380,780.09 495,469.58
Add: Depreciaton Expense 3,719.00 10,693.27 10,902.94
Operating Activities 178,420.35 391,473.36 506,372.52

Capital Expenditure -18,595.00 -33,823.00


Investing Activities -18,595.00 -33,823.00

Debt Repayment -20,681.12 -49,634.69 -49,634.69


New Debt 180,000.00
New Capital 60,000.00 - -
Finacing Activities 219,318.88 -49,634.69 -49,634.69
Net Cash Flow 379,144.23 308,015.67 456,737.83

Beginning Cash Balance - 379,144.23 687,159.90


Ending Cash Balance 379,144.23 687,159.90 1,143,897.73

2024 2025 2026


net income 174,701.35 380,780.09 495,469.58

operating activities:
depreciation expense 3,719.00 10,693.27 10,902.94
increase in inventory - 2,454.26 - 5,366.38 - 357.73
net cash provided by operating activities 1,264.74 5,326.89 10,545.21

investing activities
capital improvements - 3,424.00 - -
additions to equipment - 15,171.00 - 33,823.00 -
proceeds from sale of equipment - - -
net cash used in investing activities - 18,595.00 - 33,823.00 -

financing activities
loans payable 159,318.88 - 49,634.69 - 49,634.69
capital 60,000.00 - -
net cash used in financing activities 219,318.88 - 49,634.69 - 49,634.69

net cash flows beginning - 376,689.97 679,339.26


net cash flows ending 376,689.97 679,339.26 1,135,719.36

2024 2025 2026


Operaring Activities
Net Profit 174,701.35 380,780.09 495,469.58
Payback Period 0.16 0.76 1.35
Return on Investment 291.17 162.24 80.50
Break-even Ratio
2027 2028
2,731,902 2,972,810

8,178.37 8,595.27
540,231.12 556,438.05
330,818.29 340,742.84
120,000 120,000
999,227.78 1,025,776.16
8,595.27 9,049.82
990,632.51 1,016,726.34

1,741,269.49 1,956,083.66

21,854.54 22,510.18
417,541.91 430,068.17
65,296.27 67,255.16
38,739.36 39,901.54
4,973.33 5,122.53
360,000.00 360,000.00
1,119.25 1,152.83
49,634.69 28,953.57
10,000.00 10,000.00
11,112.62 11,322.29
6,556.36 6,753.05
980,271.97 976,286.26

760,997.52 979,797.40
152,199.50 195,959.48
608,798.02 783,837.92

2027 2028
1,705,578.41 2,500,284.07
- -
8,595.27 9,049.82
1,714,173.68 2,509,333.89
3,424.00 3,424.00
48,994.00 48,994.00
36,427.83 47,750.12
15,990.17 4,667.88

1,730,163.85 2,514,001.77

- -
- -
- -
10,414.81 28,953.57
10,414.81 28,953.57

1,110,951.02 1,719,749.04
608,798.02 783,837.92
1,719,749.04 2,503,586.96

1,730,163.85 2,532,540.53
0.00 18,538.76

2027 2028
608,798.02 783,837.92
11,112.62 11,322.29
619,910.64 795,160.21

- -

-49,634.69 -28,953.57

- -
-49,634.69 -28,953.57
570,275.95 766,206.64

1,143,897.73 1,714,173.68
1,714,173.68 2,480,380.32

2027 2028
608,798.02 783,837.92

11,112.62 11,322.29
- 416.90 - 454.55
10,695.72 10,867.74

- -
- -
- -
- -

- 49,634.69

- 49,634.69 -

1,135,719.36 1,705,578.41
1,705,578.41 2,500,284.07

2027 2028 Total

608,798.02 783,837.92 2,443,586.96


1.95 2.24
54.80 45.58
Good Item Treats

FORECASTED REVENUE revenue 2024


Sales Price per unit per product
Original chips (unflavored) 1,755 70.00 122,850.00
classic flavors (cheese, bbq, sourcream) 8,058 75.00 604,350.00
spicy classic flavors (spicy cheese, s.bbq, s.sourcre 4,299 80.00 343,920.00

TOTAL OF FORECASTED REVENUE 1,071,120.00

Good Item Treats


Pro Forma Income Statement
For the year ending 2024-2028

2024 2025 2026


Sales 1,071,120 2,359,964 2,548,715

Cost of Goods Sold


Direct Materials Beginning Inventory - 2,454.26 7,820.64
Direct Material (Purchases) 247,194.00 509,219.64 524,496.23
Direct Labor 151,372.80 311,827.97 321,182.81
Overhead - 120,000 120,000
Total Cost of Goods Available for Sale 398,566.80 943,501.87 973,499.68
Less: Direct Material Ending Inventory 2,454.26 7,820.64 8,178.37
Total Cost of Goods Sold 396,112.54 935,681.23 965,321.31

Gross Margin 675,007.46 1,424,282.77 1,583,393.69

Operating Expenses:
Sales and Marketing 10,000.00 20,600.00 21,218.00
Salaries and Wages 191,055.00 393,573.30 405,380.50
Utilities 20,574.00 61,548.00 63,394.44
Supplies 17,726.00 36,515.56 37,611.03
Maintenance, repair, and overhaul 2,275.65 4,687.84 4,828.47
Rental Expense 180,000.00 360,000.00 360,000.00
Permits and Licenses 2,600.00 1,055.00 1,086.65
Interest Expense 20,681.12 49,634.69 49,634.69
Transportation Expense 5,000.00 10,000.00 10,000.00
Depreciation Expense 3,719.00 10,693.27 10,902.94
Miscellaneous Expense 3,000.00 6,180.00 6,365.40
Total Operating Expense 456,630.77 948,307.66 964,056.72
Operating Income 218,376.69 475,975.11 619,336.97
Provision for Income Tax 43,675.34 95,195.02 123,867.39
Net Income 174,701.35 380,780.09 495,469.58

Good Item Treats


Pro Forma Balance Sheet
For the year ending 2024-2028

2024 2025 2026


Cash 379,144.23 687,159.90 1,143,897.73
Accounts Receivable - - -
Inventory 2,454.26 7,820.64 8,178.37
Current Assets 381,598.49 694,980.54 1,152,076.10
Capital Improvements 3,424.00 3,424.00 3,424.00
Machinery and Equipment 15,171.00 48,994.00 48,994.00
Less: Accumulated Depreciation 3,719.00 14,412.27 25,315.21
Total Equipment 14,876.00 38,005.73 27,102.79

Total Assets 396,474.49 732,986.27 1,179,178.89

Accounts Payable - - -
Loan Payable - - -
Current Liabilities - - -
Long-Term Debt 20,681.12 49,634.69 49,634.69
Total Liabilities 20,681.12 49,634.69 49,634.69

Capital 240,000.00 414,701.35 795,481.44


Retained Earnings 174,701.35 380,780.09 495,469.58
Total Equity 414,701.35 795,481.44 1,290,951.02

Total Liabilities and Equity 435,382.47 845,116.13 1,340,585.71


38,907.98 112,129.86 161,406.82

Good Item Treats


Pro Forma Cash Flow
For the year ending 2024-2028

2024 2025 2026


Net income 174,701.35 380,780.09 495,469.58
Add: Depreciaton Expense 3,719.00 10,693.27 10,902.94
Operating Activities 178,420.35 391,473.36 506,372.52

Capital Expenditure -18,595.00 -33,823.00


Investing Activities -18,595.00 -33,823.00

Debt Repayment -20,681.12 -49,634.69 -49,634.69


New Debt 180,000.00
New Capital 60,000.00 - -
Finacing Activities 219,318.88 -49,634.69 -49,634.69

Net Cash Flow 379,144.23 308,015.67 456,737.83

Beginning Cash Balance - 379,144.23 687,159.90


Ending Cash Balance 379,144.23 687,159.90 1,143,897.73

2024 2025 2026


Operaring Activities
Net Profit 174,701.35 380,780.09 495,469.58
Payback Period 0.63 1.35 1.74
Return on Investment 72.79 91.82 62.29
Break-even Ratio
2027 2028
2,731,902 2,972,810

8,178.37 8,595.27
540,231.12 556,438.05
330,818.29 340,742.84
120,000 120,000
999,227.78 1,025,776.16
8,595.27 9,049.82
990,632.51 1,016,726.34

1,741,269.49 1,956,083.66

21,854.54 22,510.18
417,541.91 430,068.17
65,296.27 67,255.16
38,739.36 39,901.54
4,973.33 5,122.53
360,000.00 360,000.00
1,119.25 1,152.83
49,634.69 28,953.57
10,000.00 10,000.00
11,112.62 11,322.29
6,556.36 6,753.05
980,271.97 976,286.26
760,997.52 979,797.40
152,199.50 195,959.48
608,798.02 783,837.92

2027 2028
1,714,173.68 2,480,380.32
- -
8,595.27 9,049.82
1,722,768.95 2,489,430.14
3,424.00 3,424.00
48,994.00 48,994.00
36,427.83 47,750.12
15,990.17 4,667.88

1,738,759.12 2,494,098.02

- -
- -
- -
49,634.69 28,953.57
49,634.69 28,953.57

1,290,951.02 1,899,749.04
608,798.02 783,837.92
1,899,749.04 2,683,586.96

1,949,383.73 2,712,540.53
210,624.61 218,442.51

2027 2028
608,798.02 783,837.92
11,112.62 11,322.29
619,910.64 795,160.21

- -

-49,634.69 -28,953.57

- -
-49,634.69 -28,953.57

570,275.95 766,206.64

1,143,897.73 1,714,173.68
1,714,173.68 2,480,380.32

2027 2028 Total

608,798.02 783,837.92 2,443,586.96


2.26 2.48
47.16 41.26

You might also like