Froyotogo: Six-Month Financial Projection

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

FroYoToGo

Revenue
Cost of Goods Sold
Gross Margin

$45,000.00
10,125.00
$34,875.00

Expenses
Bonus
Commission
Kiosk Rental
Marketing
Equipment Repair and Maintenance
Total Expenses

$0.00
13,500.00
4,500.00
2,250.00
1,800.00
$22,050.00

Operating Income

$12,825.00

What-If Assumptions

Margin
Bonus
Sales Revenue for Bonus
Commission
Kiosk Rental
Marketing
Equipment Repair and Maintenance

77.50%
5,500.00
60,000.00
30.00%
10.00%
5.00%
4.00%

M
ay

A
p

ri
l

Six-Month Financial Projection

st
$67,500.00
15,187.50
$52,312.50

$90,000.00
20,250.00
$69,750.00

$77,500.00
17,437.50
$60,062.50

$0.00
15,600.00
5,200.00
2,600.00
2,080.00
$25,480.00

$5,000.00
20,250.00
6,750.00
3,375.00
2,700.00
$38,075.00

$5,000.00
27,000.00
9,000.00
4,500.00
3,600.00
$49,100.00

$5,000.00
23,250.00
7,750.00
3,875.00
3,100.00
$42,975.00

$14,820.00

$14,237.50

$20,650.00

$17,087.50

S
e

g
u
A
u

ly
Ju

e
n
Ju

ri
l

A
p

M
ay
$52,000.00
11,700.00
$40,300.00

4/11/2015

$63,750.00
14,343.75
$49,406.25

$395,750.00
89,043.75
###

$5,000.00
19,125.00
6,375.00
3,187.50
2,550.00
$36,237.50

$20,000.00
118,725.00
39,575.00
19,787.50
15,830.00
###

$13,168.75

$92,788.75

C
h
ar
t

To
ta
l

te
m
b
S
ep

A
u

g
u

st

er

California

Six-Month Projected Expenses


30,000

25,000

20,000

15,000

10,000

5,000

April

May

June

July

Bonus

Commission

Marketing

Equipment Repair and Maintenance

August
Kiosk Rental

September

You might also like