ENTREPRENEURSHIP -6 Assignment "Financial Plan Final Draft" 2 Pin It W5 Assign

profiletv.ian
r-assigment-tony_bianchini-g00089145-book1.xlsx
Home>Business & Finance homework help>Operations Management homework help>ENTREPRENEURSHIP -6 Assignment "Financial Plan Final Draft" 2 Pin It W5 Assign

SETUP

Setup and Assumptions
TONY BIANCHINI-G00089145
PROFESSOR BENJAMIN BRINK
GRATHAM UNIVERSITY
COMPANY INFORMATION
FRESH JUICY FRUIT PUNCH INC. (FJFP)
What month will you officially start your company? January
What year will you officially start your company? 2015
SALES ASSUMPTIONS
The Worksheets can accommodate sales projections for up to 10 major product/service lines. How many major product/service lines do you plan to have for your business? Ten
Ten
Most businesses sell at least some of their products/services on credit (e.g., "net 30" as opposed to cash). What percentage of your sales will be made on credit? 25%
For sales you make on credit, what terms will you extend? In other words, how many days will pass from the date of sale to when you expect to be paid? 30
PERSONNEL ASSUMPTIONS
Approximately how much do you expect to spend per year on benefits for each SALARIED/FULL TIME employee (medical insurance, etc.)? $5,000
Approximately how much do you expect to spend per year on benefits for each HOURLY/PART-TIME employee (medical insurance, etc.)? $36
With health insurance and other benefits costing more each year, your plan should account for annual increases. How much do you estimate your benefit costs will increase each year? 5.00%
If you plan to increase wages (both salaried & hourly) on an annual basis, how much to you plan to increase them by? 3.50%
Approximately what percentage of each employee's salary or wages do you plan to set aside for payroll taxes? 15.00%
FINANCIAL ASSUMPTIONS
What will be the opening balance in your bank account on the first day of business? This will be the opening balance in your Cash Flow Statements. $5,000
At approximately what rate do you expect to be taxed on your net income? 25.00%
If you will use an interest-bearing account for your banking, at what rate will you accrue interest? 1.00%

SALESPROJ

Sales Projections 2015
Assumptions January February March April May June July August September October November December TOTAL
Product Line 1
Unit Volume 25.00% 2000 2500 3125 3906 4883 6104 7629 9537 11921 14901 18626 23283 108415
Unit Price 0.00% $5 $5 $5 $5 $5 $5 $5 $5 $5 $5 $5 $5
Gross Sales $10,000 $12,500 $15,625 $19,531 $24,414 $30,518 $38,147 $47,684 $59,605 $74,506 $93,132 $116,415 $542,077
(Commissions) 30.00% 10.00% $300 $375 $469 $586 $732 $916 $1,144 $1,431 $1,788 $2,235 $2,794 $3,492 $16,262
(Returns and Allowances) 2.50% $250.00 $313 $390.63 $488.28 $610.35 $762.94 $953.67 $1,192.09 $1,490.12 $1,862.65 $2,328.31 $2,910.38 $13,552
Net Sales $9,450 $11,813 $14,766 $18,457 $23,071 $28,839 $36,049 $45,061 $56,326 $70,408 $88,010 $110,012 $512,262
(Cost of Goods Sold) 30.00% $3,000.00 $3,750 $4,688 $5,859 $7,324 $9,155 $11,444 $14,305 $17,881 $22,352 $27,940 $34,925 $162,623
GROSS PROFIT $6,450 $8,063 $10,078 $12,598 $15,747 $19,684 $24,605 $30,756 $38,445 $48,056 $60,070 $75,088 $349,639
Product Line 2
Unit Volume 2.00% 0 0 0 0 0 0 0 0 0 0 0 0 0
Unit Price 2.50% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Gross Sales $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
(Commissions) 50.00% 15.00% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
(Returns and Allowances) 3.00% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Net Sales $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
(Cost of Goods Sold) 50.00% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
GROSS PROFIT $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Product Line 3
Unit Volume 2.00% 0 0 0 0 0 0 0 0 0 0 0 0 0
Unit Price 2.50% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Gross Sales $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
(Commissions) 50.00% 15.00% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
(Returns and Allowances) 3.00% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Net Sales $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
(Cost of Goods Sold) 50.00% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
GROSS PROFIT $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Product Line 4
Unit Volume 2.00% 0 0 0 0 0 0 0 0 0 0 0 0 0
Unit Price 2.50% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Gross Sales $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
(Commissions) 50.00% 15.00% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
(Returns and Allowances) 3.00% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Net Sales $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
(Cost of Goods Sold) 50.00% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
GROSS PROFIT $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Product Line 5
Unit Volume 2.00% 0 0 0 0 0 0 0 0 0 0 0 0 0
Unit Price 2.50% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Gross Sales $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
(Commissions) 50.00% 15.00% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
(Returns and Allowances) 3.00% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Net Sales $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
(Cost of Goods Sold) 50.00% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
GROSS PROFIT $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Product Line 6
Unit Volume 2.00% 0 0 0 0 0 0 0 0 0 0 0 0 0
Unit Price 2.50% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Gross Sales $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
(Commissions) 50.00% 15.00% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
(Returns and Allowances) 3.00% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Net Sales $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
(Cost of Goods Sold) 50.00% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
GROSS PROFIT $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Product Line 7
Unit Volume 2.00% 0 0 0 0 0 0 0 0 0 0 0 0 0
Unit Price 2.50% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Gross Sales $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
(Commissions) 50.00% 15.00% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
(Returns and Allowances) 3.00% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Net Sales $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
(Cost of Goods Sold) 50.00% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
GROSS PROFIT $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Product Line 8
Unit Volume 2.00% 0 0 0 0 0 0 0 0 0 0 0 0 0
Unit Price 2.50% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Gross Sales $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
(Commissions) 50.00% 15.00% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
(Returns and Allowances) 3.00% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Net Sales $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
(Cost of Goods Sold) 50.00% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
GROSS PROFIT $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Product Line 9
Unit Volume 2.00% 0 0 0 0 0 0 0 0 0 0 0 0 0
Unit Price 2.50% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Gross Sales $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
(Commissions) 50.00% 15.00% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
(Returns and Allowances) 3.00% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Net Sales $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
(Cost of Goods Sold) 50.00% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
GROSS PROFIT $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Product Line 10
Unit Volume 2.00% 0 0 0 0 0 0 0 0 0 0 0 0 0
Unit Price 2.50% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Gross Sales $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
(Commissions) 50.00% 15.00% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
(Returns and Allowances) 3.00% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Net Sales $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
(Cost of Goods Sold) 50.00% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
GROSS PROFIT $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Totals for All Product Lines
Total Unit Volume 2000 2500 3125 3906 4883 6104 7629 9537 11921 14901 18626 23283 108415
Total Gross Sales $10,000 $12,500 $15,625 $19,531 $24,414 $30,518 $38,147 $47,684 $59,605 $74,506 $93,132 $116,415 $542,077
(Total Commissions) $300 $375 $469 $586 $732 $916 $1,144 $1,431 $1,788 $2,235 $2,794 $3,492 $16,262
(Total Returns and Allowances) $250 $313 $391 $488 $610 $763 $954 $1,192 $1,490 $1,863 $2,328 $2,910 $13,552
Total Net Sales $9,450 $11,813 $14,766 $18,457 $23,071 $28,839 $36,049 $45,061 $56,326 $70,408 $88,010 $110,012 $512,262
(Total Cost of Goods Sold) $3,000 $3,750 $4,688 $5,859 $7,324 $9,155 $11,444 $14,305 $17,881 $22,352 $27,940 $34,925 $162,623
TOTAL GROSS PROFIT $6,450 $8,063 $10,078 $12,598 $15,747 $19,684 $24,605 $30,756 $38,445 $48,056 $60,070 $75,088 $349,639

INVENTORY

Inventory 2015
January February March April May June July August September October November December TOTAL
Product Line 1
Cost of Goods Sold $3,000 $3,750 $4,688 $5,859 $7,324 $9,155 $11,444 $14,305 $17,881 $22,352 $27,940 $34,925 $162,623
Ingredients $1,500 $1,875 $2,344 $2,930 $3,662 $4,578 $5,722 $7,153 $8,941 $11,176 $13,970 $17,462 $81,311
Bottles / Caps $900 $1,125 $1,406 $1,758 $2,197 $2,747 $3,433 $4,292 $5,364 $6,706 $8,382 $10,477 $48,787
Labels $600 $750 $938 $1,172 $1,465 $1,831 $2,289 $2,861 $3,576 $4,470 $5,588 $6,985 $32,525
Cartons $600 $750 $938 $1,172 $1,465 $1,831 $2,289 $2,861 $3,576 $4,470 $5,588 $6,985 $32,525
Total Inventory Expense $3,600 $4,500 $5,625 $7,031 $8,789 $10,986 $13,733 $17,166 $21,458 $26,822 $33,528 $41,910 $195,148
Product Line 2
Cost of Goods Sold $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Items/Parts 1 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Items/Parts 2 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Items/Parts 3 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Items/Parts 4 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Inventory Expense $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Product Line 3
Cost of Goods Sold $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Items/Parts 1 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Items/Parts 2 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Items/Parts 3 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Items/Parts 4 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Inventory Expense $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Product Line 4
Cost of Goods Sold $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Items/Parts 1 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Items/Parts 2 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Items/Parts 3 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Items/Parts 4 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Inventory Expense $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Product Line 5
Cost of Goods Sold $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Items/Parts 1 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Items/Parts 2 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Items/Parts 3 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Items/Parts 4 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Inventory Expense $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Product Line 6
Cost of Goods Sold $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Items/Parts 1 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Items/Parts 2 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Items/Parts 3 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Items/Parts 4 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Inventory Expense $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Product Line 7
Cost of Goods Sold $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Items/Parts 1 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Items/Parts 2 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Items/Parts 3 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Items/Parts 4 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Inventory Expense $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Product Line 8
Cost of Goods Sold $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Items/Parts 1 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Items/Parts 2 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Items/Parts 3 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Items/Parts 4 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Inventory Expense $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Product Line 9
Cost of Goods Sold $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Items/Parts 1 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Items/Parts 2 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Items/Parts 3 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Items/Parts 4 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Inventory Expense $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Product Line 10
Cost of Goods Sold $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Items/Parts 1 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Items/Parts 2 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Items/Parts 3 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Items/Parts 4 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Inventory Expense $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
GRAND TOTAL INVENTORY $3,600 $4,500 $5,625 $7,031 $8,789 $10,986 $13,733 $17,166 $21,458 $26,822 $33,528 $41,910 $195,148

INCST

Income Statements
Author: For information about this worksheet, see "Income Statements" in Successful Business Plan: Secrets & Strategies.		 2015
January February March April May June July August September October November December TOTAL
INCOME
Gross Sales $10,000 $12,500 $15,625 $19,531 $24,414 $30,518 $38,147 $47,684 $59,605 $74,506 $93,132 $116,415 $542,077
(Commissions) $300 $375 $469 $586 $732 $916 $1,144 $1,431 $1,788 $2,235 $2,794 $3,492 $16,262
(Returns and allowances) $250 $313 $391 $488 $610 $763 $954 $1,192 $1,490 $1,863 $2,328 $2,910 $13,552
Net Sales $9,450 $11,813 $14,766 $18,457 $23,071 $28,839 $36,049 $45,061 $56,326 $70,408 $88,010 $110,012 $512,262
(Cost of Goods) $3,000 $3,750 $4,688 $5,859 $7,324 $9,155 $11,444 $14,305 $17,881 $22,352 $27,940 $34,925 $162,623
GROSS PROFIT $6,450 $8,063 $10,078 $12,598 $15,747 $19,684 $24,605 $30,756 $38,445 $48,056 $60,070 $75,088 $349,639
EXPENSES - General and Administrative
Salaries and wages $16,200 $16,200 $16,200 $16,200 $16,200 $16,200 $19,200 $19,200 $19,200 $19,200 $19,200 $19,200 $212,400
Employee benefits $4,586 $4,586 $4,586 $4,586 $4,586 $4,586 $6,253 $6,253 $6,253 $6,253 $6,253 $6,253 $65,036
Payroll taxes $2,430 $2,430 $2,430 $2,430 $2,430 $2,430 $2,880 $2,880 $2,880 $2,880 $2,880 $2,880 $31,860
Professional services $458 $458 $458 $458 $458 $458 $458 $458 $458 $458 $458 $458 $5,500
Marketing and advertising $7,700 $5,180 $4,112 $3,631 $3,391 $3,213 $3,147 $3,090 $3,043 $3,003 $2,973 $2,950 $45,434
Rent $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $1,800
Equipment rental $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Maintenance $75 $75 $75 $75 $75 $75 $100 $100 $100 $100 $100 $100 $1,050
Depreciation $606 $606 $606 $606 $606 $606 $606 $606 $606 $606 $606 $606 $7,267
Insurance $50 $50 $50 $50 $50 $50 $50 $50 $50 $50 $50 $50 $600
Telephone service $50 $50 $50 $50 $50 $50 $100 $100 $100 $100 $100 $100 $900
Utilities $75 $75 $75 $75 $75 $75 $75 $75 $75 $75 $75 $75 $900
Office supplies $50 $50 $50 $50 $50 $50 $50 $50 $50 $50 $50 $50 $600
Postage and shipping $75 $75 $75 $75 $75 $75 $100 $100 $100 $100 $100 $100 $1,050
Travel $75 $75 $75 $75 $75 $75 $100 $100 $100 $100 $100 $100 $1,050
Entertainment $50 $50 $50 $50 $50 $50 $50 $50 $50 $50 $50 $50 $600
Interest on loans $150 $144 $138 $132 $126 $119 $113 $107 $101 $95 $89 $82 $1,396
Other (change title here) $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Other (change title here) $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
TOTAL EXPENSES $32,780 $30,254 $29,180 $28,693 $28,447 $28,263 $33,432 $33,369 $33,315 $33,270 $33,233 $33,204 $377,442
Net income before taxes -$26,330 -$22,192 -$19,102 -$16,095 -$12,700 -$8,579 -$8,827 -$2,613 $5,130 $14,786 $26,837 $41,884 -$27,803
Provision for taxes on income $0 $0 $0 $0 $0 $0 $0 $0 $1,282 $3,697 $6,709 $10,471 $0
NET PROFIT -$26,330 -$22,192 -$19,102 -$16,095 -$12,700 -$8,579 -$8,827 -$2,613 $3,847 $11,090 $20,128 $31,413 -$27,803

CSHFLOW

Cash Flow
Author: For information about this worksheet, see "Cash-Flow Projections" in "The Financials" chapter of Successful Business Plan: Secrets & Strategies.		 2015
January February March April May June July August September October November December TOTAL
CASH RECEIPTS
Income from Sales
Cash Sales $7,500 $9,375 $11,719 $14,648 $18,311 $22,888 $28,610 $35,763 $44,703 $55,879 $69,849 $87,311 $406,557
Collections $0 $2,500 $3,125 $3,906 $4,883 $6,104 $7,629 $9,537 $11,921 $14,901 $18,626 $23,283 $106,415
Total Cash from Sales $7,500 $11,875 $14,844 $18,555 $23,193 $28,992 $36,240 $45,300 $56,624 $70,781 $88,476 $110,595 $512,973
Income from Financing
Interest Income $0
Author: This line item is automatically calculated for you based on the interest rate you entered on the "Setup and Assumptions" sheet. 		$27 $8 $0 $39 $28 $16 $8 $5 $9 $21 $44 $204
Loan Proceeds $60,000 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $60,000
Equity Capital Investments $60,000 $0 $0 $75,000 $0 $0 $0 $0 $0 $0 $0 $0 $135,000
Total Cash from Financing $120,000 $27 $8 $75,000 $39 $28 $16 $8 $5 $9 $21 $44 $195,204
Other Cash Receipts $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
TOTAL CASH RECEIPTS $127,500 $11,902 $14,852 $93,555 $23,233 $29,020 $36,255 $45,307 $56,629 $70,789 $88,497 $110,638 $708,177
CASH DISBURSEMENTS
Inventory $3,600 $4,500 $5,625 $7,031 $8,789 $10,986 $13,733 $17,166 $21,458 $26,822 $33,528 $41,910 $195,148
Operating Expenses $32,025 $29,505 $28,437 $27,956 $27,716 $27,538 $32,713 $32,657 $32,609 $32,570 $32,539 $32,516 $368,780
Commissions/Returns & Allowances $550 $688 $859 $1,074 $1,343 $1,678 $2,098 $2,623 $3,278 $4,098 $5,122 $6,403 $29,814
Capital Purchases $36,050 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $36,050
Loan Payments $2,579 $2,579 $2,579 $2,579 $2,579 $2,579 $2,579 $2,579 $2,579 $2,579 $2,579 $2,579 $30,946
Income Tax Payments $0
Author: Note that on your Income Statements, we've generated an estimate for income taxes. This line on the Cash Flow statement is where you should reflect the actual payments you intend to make on a regular basis (probably quarterly).
Author: This line item is automatically calculated for you based on the interest rate you entered on the "Setup and Assumptions" sheet. 		$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Investor Dividend Payments $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Owner's Draw $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
TOTAL CASH DISBURSEMENTS $74,804 $37,271 $37,500 $38,640 $40,427 $42,781 $51,123 $55,024 $59,924 $66,069 $73,768 $83,408 $660,738
NET CASH FLOW $52,696 -$25,369 -$22,648 $54,915 -$17,194 -$13,762 -$14,868 -$9,717 -$3,294 $4,721 $14,729 $27,231 $47,439
Opening Cash Balance $5,000 $57,696 $32,327 $9,679 $64,594 $47,400 $33,638 $18,770 $9,053 $5,758 $10,479 $25,208
Cash Receipts $127,500 $11,902 $14,852 $93,555 $23,233 $29,020 $36,255 $45,307 $56,629 $70,789 $88,497 $110,638
Cash Disbursements $74,804 $37,271 $37,500 $38,640 $40,427 $42,781 $51,123 $55,024 $59,924 $66,069 $73,768 $83,408
ENDING CASH BALANCE $57,696 $32,327 $9,679 $64,594 $47,400 $33,638 $18,770 $9,053 $5,758 $10,479 $25,208 $52,439 $52,439

BALSHEET

Balance Sheet
Author: For information about this worksheet, see "Balance Sheet" in "The Financials" chapter of Successful Business Plan: Secrets & Strategies.		 Balance Sheet
Author: For information about this worksheet, see "Balance Sheet" in "The Financials" chapter of Successful Business Plan: Secrets & Strategies.		 Balance Sheet Balance Sheet Balance Sheet
FRESH JUICY FRUIT PUNCH INC. FRESH JUICY FRUIT PUNCH INC. FRESH JUICY FRUIT PUNCH INC. FRESH JUICY FRUIT PUNCH INC. FRESH JUICY FRUIT PUNCH INC.
First Quarter First Quarter Second Quarter Third Quarter Fourth Quarter
2015 2015 2015 2015 2015
ASSETS ASSETS ASSETS ASSETS ASSETS
Current Assets Current Assets Current Assets Current Assets Current Assets
Cash $32,327 Cash $18,770 Cash $10,479 Cash $52,439 Cash $9,231
Accounts Receivable $3,125 Accounts Receivable $4,654 Accounts Receivable $18,626 Accounts Receivable $58,208 Accounts Receivable $29,105
Inventory $1,350 Inventory $5,585 Inventory $16,492 Inventory $61,590 Inventory $61,590
Other Current Assets $0 Other Current Assets $0 Other Current Assets $0 Other Current Assets $0 Other Current Assets $0
Total Current Assets $36,802 Total Current Assets $29,009 Total Current Assets $45,598 Total Current Assets $172,236 Total Current Assets $99,927
Fixed Assets Fixed Assets Fixed Assets Fixed Assets Fixed Assets
Land $0 Land $0 Land $0 Land $0 Land $0
Facilities $0 Facilities $0 Facilities $0 Facilities $0 Facilities $0
Equipment $30,000 Equipment $0 Equipment $0 Equipment $0 Equipment $0
Computers & Telecommunications $6,050 Computers & Telecommunications $0 Computers & Telecommunications $0 Computers & Telecommunications $0 Computers & Telecommunications $0
(Less Accumlated Depreciation) $1,211 (Less Accumlated Depreciation) $1,817 (Less Accumlated Depreciation) $3,633 (Less Accumlated Depreciation) $12,111 (Less Accumlated Depreciation) $13,322
Total Fixed Assets $34,839 Total Fixed Assets -$1,817 Total Fixed Assets -$3,633 Total Fixed Assets -$12,111 Total Fixed Assets -$13,322
Other Assets $0 Other Assets $0 Other Assets $0 Other Assets $0 Other Assets $0
TOTAL ASSETS $71,641 TOTAL ASSETS $27,192 TOTAL ASSETS $41,965 TOTAL ASSETS $160,125 TOTAL ASSETS $86,604
LIABILITIES LIABILITIES LIABILITIES LIABILITIES LIABILITIES
Current Liabilities Current Liabilities Current Liabilities Current Liabilities Current Liabilities
Short-Term Notes Payable $0
Sure Product Consulting: Short-Term Notes Payable: loan payments to be made within one year 		Short-Term Notes Payable $15,339
Sure Product Consulting: Short-Term Notes Payable: loan payments to be made within one year 		Short-Term Notes Payable $7,698 Short-Term Notes Payable -$0 Short-Term Notes Payable -$0
Income Taxes Due $0
Author: If you see a number here, it reflects the difference between the projected income taxes owed (as calculated on your Income Statements) and what you've said you will actually pay (as entered on your Cash Flow statements).		 Income Taxes Due $0
Author: If you see a number here, it reflects the difference between the projected income taxes owed (as calculated on your Income Statements) and what you've said you will actually pay (as entered on your Cash Flow statements).
Author: For information about this worksheet, see "Balance Sheet" in "The Financials" chapter of Successful Business Plan: Secrets & Strategies.
Sure Product Consulting: Short-Term Notes Payable: loan payments to be made within one year
Author: If you see a number here, it reflects the difference between the projected income taxes owed (as calculated on your Income Statements) and what you've said you will actually pay (as entered on your Cash Flow statements).		 Income Taxes Due $4,979 Income Taxes Due $22,159 Income Taxes Due $0
Other Current Liabilities $0 Other Current Liabilities $0 Other Current Liabilities $0 Other Current Liabilities $0 Other Current Liabilities $0
Total Current Liabilities $0 Total Current Liabilities $15,339 Total Current Liabilities $12,677 Total Current Liabilities $22,159 Total Current Liabilities -$0
Long-Term Liabilities Long-Term Liabilities Long-Term Liabilities Long-Term Liabilities Long-Term Liabilities
Long-Term Notes Payable $29,773 Long-Term Notes Payable $0 Long-Term Notes Payable $0 Long-Term Notes Payable $0 Long-Term Notes Payable $0
Other Long-Term Liabilities $0 Other Long-Term Liabilities $0 Other Long-Term Liabilities $0 Other Long-Term Liabilities $0 Other Long-Term Liabilities $0
Total Long-Term Liabilities $29,773 Total Long-Term Liabilities $0 Total Long-Term Liabilities $0 Total Long-Term Liabilities $0 Total Long-Term Liabilities $0
NET WORTH NET WORTH NET WORTH NET WORTH NET WORTH
Paid-In Capital $65,000 Paid-In Capital $5,000 Paid-In Capital $5,000 Paid-In Capital $140,000 Paid-In Capital $140,000
Retained Earnings -$23,132 Retained Earnings $6,853 Retained Earnings $24,288 Retained Earnings -$2,034 Retained Earnings -$53,396
Total Net Worth $41,868 Total Net Worth $11,853 Total Net Worth $29,288 Total Net Worth $137,966 Total Net Worth $86,604
TOTAL LIABILITIES AND NET WORTH $71,641 TOTAL LIABILITIES AND NET WORTH $27,192 TOTAL LIABILITIES AND NET WORTH $41,965 TOTAL LIABILITIES AND NET WORTH $160,125 TOTAL LIABILITIES AND NET WORTH $86,604

BRKEVN

Break-even Estimates
Year 1 (2015-2016)
January 50822.0499569337
February 46905.6589774035
March 45240.252214223
April 44485.345887623
May 44104.261969625
June 43818.3862820258
July 51833.0032814908
August 51735.4826920729
September 51651.8644660353
October 51581.6353264081
November 51524.340276236
December 51479.5794383727
Monthly Average 48765.1550640375

1YRATGI

Year 1: Financials at-a-Glance (2015-2016) Gross Sales January February March April May June July August September October November December 10000 12500 15625 19531.25 24414.0625 30517.578125 38146.97265625 47683.7158203125 59604.644775390625 74505.805969238281 93132.257461547852 116415.32182693481 Gross Profit January February March April May June July August September October November December 6450 8062.5 10078.125 12597.65625 15747.0703125 19683.837890625 24604.79736328125 30755.996704101563 38444.995880126953 48056.244850158691 60070.306062698364 75087.882578372955 Net Profit January February March April May June July August September October November December -26330.222222222219 -22191.650040425287 -19101.837678173863 -16095.39184751681 -12700.178657908113 -8579.0212612816431 -8827.489753280337 -2613.3896322854562 3847.1574746506485 11089.567548469116 20127.829938394611 31412.665380466937

1YRCASHFLW

Year 1: Cash Flow (2015-2016) Net Cash Flow January February March April May June July August September October November December 52696.460614559983 -25369.122367749107 -22648.004990555557 54914.591364559965 -17193.955572970972 -13761.776625151637 -14868.006669268645 -9717.2030587893678 -3294.4946836073505 4720.6602648135304 14728.820737882532 27230.578462548292 Ending Cash Balance 57696.460614559983 32327.338246810883 9679.333256255326 64593.924620815291 47399.969047844315 33638.192422692686 18770.185753424033 9052.9826946346657 5758.4880110273152 10479.148275840853 25207.969013723385 52438.547476271677