Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Management Principles and Applications

Authors: Sheridan Titman, Arthur Keown, John Martin

12th edition

133423824, 978-0133423822

More Books

Students also viewed these Finance questions

Question

Explain the steps involved in training programmes.

Answered: 1 week ago

Question

What are the need and importance of training ?

Answered: 1 week ago

Question

What kind of financial pressures can an LBO cause?

Answered: 1 week ago

Question

What are major risk factors for mental disorders?

Answered: 1 week ago