Microsoft Office Tutorials and References
In Depth Information
Introduction
FroYo ToGo
99/99/9999
Six-Month Financial Projection
Month 1
ZZZ,ZZ9.99
Month 2
ZZZ,ZZ9.99
Month 3
ZZZ,ZZ9.99
Month 4
ZZZ,ZZ9.99
Month 5
ZZZ,ZZ9.99
Month 6
ZZZ,ZZ9.99
Total
ZZZ,ZZ9.99
Chart
Revenue
Gross Margin
Expenses
Cost of Goods Sold
ZZZ,ZZ9.99
ZZZ,ZZ9.99 ZZZ,ZZ9.99 ZZZ,ZZ9.99 ZZZ,ZZ9.99 ZZZ,ZZ9.99 ZZZ,ZZ9.99
Bonus
Commission
Kiosk Rental
Marketing
Equipment Repair and Maintenance
ZZZ,ZZ9.99
ZZZ,ZZ9.99
ZZZ,ZZ9.99 ZZZ,ZZ9.99 ZZZ,ZZ9.99 ZZZ,ZZ9.99 ZZZ,ZZ9.99 ZZZ,ZZ9.99
ZZZ,ZZ9.99 ZZZ,ZZ9.99 ZZZ,ZZ9.99 ZZZ,ZZ9.99 ZZZ,ZZ9.99 ZZZ,ZZ9.99
Total Expenses
Operating Income
What-If Assumptions
Margin
Bonus
Sales Revenue for Bonus
Commission
kiosk Rental
Marketing
Equipment Repair and Maintenance
Z9.99%
Z,ZZ9.99
Z,ZZZ9.99
Z9.99%
Z9.99%
Z9.99%
Z9.99%
Six-Month Projected Expenses
$
(a) Worksheet
April
May
June
July
August
September
(b) Clustered Column Chart
Figure 3 – 3
Table 3–1 FroYoToGo Six-Month Financial Projections Data and What-If Assumptions
Projected Monthly Total Sales Revenues
April
45,000.00
May
52,000.00
June
67,500.00
July
90,000.00
August
77,500.00
September
63,750.00
What-If Assumptions
Margin
77.5%
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%
Search JabSto ::




Custom Search