financial projections chart
Year One Business Projections Company Name: Your Business Name here
Notes for Completing this Form *Please complete each cell highlighted in green. If there is no amount, place a $0 in the cell. Do not enter data in cells that are not highlighted green. *It is helpful to use your prior year tax return or financials as a historical reference when comepleting projections
Prepared By:
Year: 2022 January February March April May June July August September October November December Annual Totals Income/Total Revenue Box Granola 1800.00 2000.00 2200.00 2200.00 2600.00 2600.00 2500.00 2200.00 2500.00 2500.00 3000.00 1900.00 ($ 28,000) Refill Granola 500.00 900.00 1700.00 1300.00 1500.00 1550.00 1000.00 1050.00 1450.00 1400.00 2000.00 650.00 ($ 15,000) Item/Service #3 ($ -) Item/Service #4 ($ -) Item/Service #5 ($ -) Item/Service #6 ($ -) Item/Service #7 ($ -) Item/Service #8 ($ -) Item/Service #9 ($ -) Total Revenue ($ 2,300) ($ 2,900) ($ 3,500) ($ 3,900) ($ 4,100) ($ 4,150) ($ 3,500) ($ 3,250) ($ 3,950) ($ 3,900) ($ 5,000) ($ 2,550) ($ 43,000)
Cost of Goods Sold . Costs of Labor (If tracked through COGS) ( -) ( -) ( -) ( -) ( -) ( -) ( -) ( -) ( -) ( -) ( -) ( -) ($ -) Inventory ( 480) ( 725) ( 875) ( 975) ( 1,025) ( 1,038) ( 875) ( 813) ( 988) ( 975) ( 1,250) ( 638) ($ 10,655) Materials and Supplies (Directly related to production) ( 35) ( 37) ( 46) ( 48) ( 55) ( 56) ( 58) ( 44) ( 49) ( 48) ( 60) ( 35) ($ 571) Other ( -) ( -) ( -) ( -) ( -) ( -) ( -) ( -) ( -) ( -) ( -) ( -) ($ -) Total Cost of Goods Sold ($ 515) ($ 762) ($ 921) ($ 1,023) ($ 1,080) ($ 1,094) ($ 933) ($ 857) ($ 1,037) ($ 1,023) ($ 1,310) ($ 673) ($ 11,226)
Gross Margin ($ 1,785) ($ 2,138) ($ 2,579) ($ 2,877) ($ 3,020) ($ 3,057) ($ 2,567) ($ 2,394) ($ 2,914) ($ 2,877) ($ 3,690) ($ 1,878) ($ 31,774)
Operating Expenses Advertising and Marketing ( 900) ( 900) ( 900) ( 900) ( 900) ( 900) ( 900) ( 900) ( 900) ( 900) ( 900) ( 900) ($ 10,800) Automobile Expenses (Gasoline & Mantainance) ( 120) ( 120) ( 120) ( 120) ( 120) ( 120) ( 120) ( 120) ( 120) ( 120) ( 120) ( 120) ($ 1,440) Contract Labor/1099's ($ -) Employee Benefit Programs ($ -) Insurance Expenses (Non-Health) ( 150) ( 150) ( 150) ( 150) ( 150) ( 150) ( 150) ( 150) ( 150) ( 150) ( 150) ( 150) ($ 1,800) Legal or Professional Services ( 40) ( 40) ( 40) ( 40) ($ 160) Meals & Entertainment ( 35) ( 35) ( 35) ( 35) ( 35) ( 35) ( 35) ( 35) ( 35) ( 35) ( 35) ( 35) ($ 420) Office Supplies ( 14) ( 23) ( 17) ( 27) ( 37) ( 37) ( 27) ( 27) ( 30) ( 27) ( 40) ( 20) ($ 326) Office Expenses ($ -) Rent or Lease (Food Trailer and Floor Space) ($ -) Repairs and Maintenance ($ -) Taxes or Licenses (Once a year) ( 10) ( 10) ( 10) ( 10) ( 10) ( 10) ( 10) ( 10) ( 10) ( 10) ( 10) ( 10) ($ 120) Travel Expenses ($ -) Utilities (Phone, Internet, Electric, Water, Gas) ( 50) ( 50) ( 50) ( 50) ( 50) ( 50) ( 50) ( 50) ( 50) ( 50) ( 50) ( 50) ($ 600) Wages to W2 Employees (20 Hrs/30 days/$13.00) ($ -) Wage Taxes (Employer SS/MC, Unemployment @ 9.45%) ($ -) Other ($ -) Total Operating Expenses ($ 1,279) ($ 1,288) ($ 1,322) ($ 1,292) ($ 1,302) ($ 1,342) ($ 1,292) ($ 1,292) ($ 1,335) ($ 1,292) ($ 1,305) ($ 1,325) ($ 15,666) Income Tax ($ -) ($ -) ($ -) ($ -) ($ -) ($ -) ($ -) ($ -) ($ -) ($ -) ($ -) ($ -) ($ -) Net Profit/Loss ($ 506) ($ 850) ($ 1,257) ($ 1,585) ($ 1,718) ($ 1,715) ($ 1,275) ($ 1,102) ($ 1,579) ($ 1,585) ($ 2,385) ($ 553) ($ 16,108)
Income/Revenue Assumptions For the financial plan in the second year, we have projected a 20% increase in sales, leveraged by the marketing and advertising efforts carried out during the first year. Having achieved this goal, we expect to begin reducing operational and logistical costs in the third stage of our project, thereby optimizing business profitability and improving resource management efficiency.
($ (758) ($ (763) ($ (768) ($ (773) ($ (779) ($ (784) ($ (789) ($ (794) ($ (800) ($ (805) ($ (810) ($ (816) ($ (758) ($ (1,521) ($ (2,290) ($ (3,063) ($ (3,842) ($ (4,626) ($ (5,415) ($ (6,209) ($ (7,008) ($ (7,813) ($ (8,624) ($ (9,439)