Froyotogo Financial Projection

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 2

FroYoToGo 11/15/2017

Six-Month Financial Projection

er
b
m
st

te

t
u

al
l

ar
e
ri

ay

ep
ly
n

t
p

h
To
Ju

Ju
M
A

C
S
Revenue $45,000.00 $52,000.00 $67,500.00 $90,000.00 $77,500.00 $63,750.00 $395,750.00
Cost of Goods Sold 10,125.00 11,700.00 15,187.50 20,250.00 17,437.50 14,343.75 89,043.75
Gross Margin $34,875.00 $40,300.00 $52,312.50 $69,750.00 $60,062.50 $49,406.25 ###

Expenses
Bonus $0.00 $0.00 $5,000.00 $5,000.00 $5,000.00 $5,000.00 $20,000.00
Commission 13,500.00 15,600.00 20,250.00 27,000.00 23,250.00 19,125.00 118,725.00
Kiosk Rental 4,500.00 5,200.00 6,750.00 9,000.00 7,750.00 6,375.00 39,575.00
Marketing 2,250.00 2,600.00 3,375.00 4,500.00 3,875.00 3,187.50 19,787.50
Equipment Repair and Maintenance 1,800.00 2,080.00 2,700.00 3,600.00 3,100.00 2,550.00 15,830.00
Total Expenses $22,050.00 $25,480.00 $38,075.00 $49,100.00 $42,975.00 $36,237.50 ###

Operating Income $12,825.00 $14,820.00 $14,237.50 $20,650.00 $17,087.50 $13,168.75 $92,788.75

What-If Assumptions

Margin 77.50%

Bonus 5,000.00

Sales Revenue for Bonus 60,000.00

Commission 30.00%

Kiosk Rental 10.00%

Marketing 5.00%

Equipment Repair and Maintenance 4.00%


Six-Month Projected Expenses
30,000

25,000

20,000

$ 15,000

10,000

5,000

0
April May June July August September

Bonus Commission Kiosk Rental


Marketing Equipment Repair and Maintenance

You might also like