Question: Please answer ASAP Complete the pro forma cash flow for the first year. This should have a column of numbers for each month in the

Please answer ASAP
Complete the pro forma cash flow for the first year. This should have a column of numbers for each month in the first year, plus a column (or more) for the month before you start business.
-How much do you expect to sell every month? How much money will this bring in? This is your cash inflow.
Assuming an average sale price of $7.50 per cakes, we can estimate monthly revenue based on the projected number sold each month.
Expected sales: 75 cakes/day *30 days =2,250 cakes
Monthly revenue: $16,875
-How much up-front cash do you need to start the business?
Deposit for lease: $5,000
Down payment on equipment: $10,000
Permits: $500
Equipment: $3,000
Supplies: $1,000
Insurance: $1,000
Advertising: $2,500
Total: $23,000
-How much will it cost to produce your product or service? COGS, labor
Total monthly production cost: $5,625(COGS)+ $7,200(Labor)= $12,825
Cost of goods sold (COGS) per month: $2.50*2,250 cakes = $5,625
Assuming an hourly wage of $10 and 8 hours of work per day:
Daily labor cost: $10/hour *8 hours = $80
Monthly labor cost: $80*30 days = $2400
Total monthly labor cost: $2,400*3 employees = $7,200
-What are your fixed costs? Salaries, rent, lease payments, advertising, insurance, utilities.
Monthly fixed costs (Rent, salaries, utilities, advertising, other expenses): $5,333
Rent: $1,500
Salaries: $2,400
Utilities: $400
Advertising: $500
Other expenses: $200
Total monthly fixed costs: $5333
-Calculate the net amount of money flowing in (or out) each month.
-What is the running cash balance?
-What is the cumulative cash balance?
Please help me with the missing questions and do an excel table and show me the formulas please. The numbers are invented numbers, it is a business plan for a new business.

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!