FINANCIAL PROJECTION CHEESE COMPANY
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAPAQARASATAUAVAWAXAYAZBABBBCBDBEBFBGBHBIBJBKBLBMBNBOBPBQBRBSBTBUBVBWBXBYBZCACBCCCDCECFCGCHCICJCKCLCMCNCOCPCQCRCSCTCUCV
1
2
MAKE ENTRIES ONLY IN YELLOW BOXES
3
4
How many weeks will you be working in year52.00INCOME AND EXPENSESYEAR
5
Product 1 - Selling Price$2.50Annual Sales
6
Product 2 - Selling Price$1.25Product 1$6,240.00
7
Product 3 - Selling Price$15.00Product 2$3,250.00
8
Product 4 - Selling Price$20.00Product 3$19,500.00
9
Product 4$10,400.00
10
Product 1 - Material Cost$0.40Total Sales$39,390.00
11
Product 2 - Material Cost$0.20
12
Product 3 - Material Cost$5.00Material Costs
13
Product 4 - Material Cost$5.00Product 1$998.40
14
Product 2$520.00
15
Product 1 - Estimated Number Weekly Sales48.00Product 3$13,000.00
16
Product 2 - Estimated Number Weekly Sales50.00Product 4$2,600.00
17
Product 3 - Estimated Number Weekly Sales25.00
18
Product 4 - Estimated Number Weekly Sales10.00
19
Totoal Cost of Sales$17,118.40
20
What Is Your Hourly Rate Not Counting Labor
21
Labor CalculationProduct 1Annual Fixed Expenses
22
Hourly Labor Rate$20.00Delivery$750.00
23
Hrly Units Prod5.00Utilities$0.00
24
Unit Labor Cost$4.00Packaging$1,000.00
25
Insurance$400.00
26
Labor CalculationProduct 2Misc$600.00
27
Hourly Labor Rate$20.00Total Expenses$2,750.00
28
Hrly Units Prod10.00
29
Unit Labor Cost$2.00Net Owners Income$19,521.60
30
31
Labor CalculationProduct 3
32
Hourly Labor Rate$20.00
33
Hrly Units Prod6.00
34
Unit Labor Cost$3.33
35
Annual Hours Worked - Owner1,352.00
36
Labor CalculationProduct 4Hourly Income14.44
37
Hrly Lbr Rate$10.00
38
Hrly Units Prod5.00
39
Unit Labor Cost$2.00
40
41
Estimated Yearly Expenses
42
Delivery500.00
43
Utilities300.00
44
Packaging300.00
45
Insurance400.00
46
Misc600.00
47
Total Expenses$2,100.00
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
YEALRY INCOME AND EXPENSE
91
GROSS INCOME$39,390
92
COST OF SALES$17,118
93
EXPENSES$2,100
94
NET PROFIT$20,172
Loading...
 
 
 
Cash Flow Year 1
Cash Flow 3 Yrs
Bank
Interview Pg 1
Assumptions (2)