Question: Based on this spreadsheet below. Is it possible to project customer growth? Revenue growth? If so, how can we do this with no historical data.

Based on this spreadsheet below. Is it possible to project customer growth? Revenue growth? If so, how can we do this with no historical data.

Based on this spreadsheet below. Is it possible to project customer growth?

A B D E F G H Break-Even Point 1 2 3 #1 #1 # 500.00 4 417.00 300.00 5 6 417.00 7 3,091.96 170.00 500.00 500.00 Typical Sale Sales Price (per Unit) Variable Cost (per unit) Gross Profit (per Unit) % Fixed Costs dedicated to typical sale Fixed Costs (based on percentage) Break-Even (Units per month) RATE OF SALES Work Days per Month Break-Even (Units per day) 8 $1,300.00 $ 1,150.66 $ 149.34 0.01 $ 60.34 0.40 28 0.01 Variable Costs (per month) Materials (printing) Packaging Transportation Labor Google Cloud Mailgun Twilio Payment System (fee +2.9%) Taxes Admin (10%) Other Total Variable Costs (per Unit) 217.00 8.33 9 10 8.33 11 Fixed Costs (per month) Travel Rent Utilities Salaries Liability Insurance Marketing Legal and Accounting Fees Loan Payments Supplies (office, copier, etc) Web Hosting Google Suite Social Media Fee (buffer) Figma Circle Computer Webflow Food Contingency Total Fixed Costs 12 13 14 15 $ 1,150.6 16 500.00 3.00 12.00 100.00 84.00 199.00 125.00 32.00 17 $ $ 18 19 $ 20 21 22 $ 6,033.96 23 24 25 26 A B D E F G H Break-Even Point 1 2 3 #1 #1 # 500.00 4 417.00 300.00 5 6 417.00 7 3,091.96 170.00 500.00 500.00 Typical Sale Sales Price (per Unit) Variable Cost (per unit) Gross Profit (per Unit) % Fixed Costs dedicated to typical sale Fixed Costs (based on percentage) Break-Even (Units per month) RATE OF SALES Work Days per Month Break-Even (Units per day) 8 $1,300.00 $ 1,150.66 $ 149.34 0.01 $ 60.34 0.40 28 0.01 Variable Costs (per month) Materials (printing) Packaging Transportation Labor Google Cloud Mailgun Twilio Payment System (fee +2.9%) Taxes Admin (10%) Other Total Variable Costs (per Unit) 217.00 8.33 9 10 8.33 11 Fixed Costs (per month) Travel Rent Utilities Salaries Liability Insurance Marketing Legal and Accounting Fees Loan Payments Supplies (office, copier, etc) Web Hosting Google Suite Social Media Fee (buffer) Figma Circle Computer Webflow Food Contingency Total Fixed Costs 12 13 14 15 $ 1,150.6 16 500.00 3.00 12.00 100.00 84.00 199.00 125.00 32.00 17 $ $ 18 19 $ 20 21 22 $ 6,033.96 23 24 25 26

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!