Scribd
Upload
18 views3 pages

Kaithlyn's Ice Cream Financial Projections

Kaithlyn's Ice Cream Shoppe projects revenues to increase each month over the next six months, from RM55,000 in January to RM74,750 in June, with total projected revenue of RM427,000. Projected expenses also increase each month, including bonuses paid if sales reach RM65,000. The projection estimates operating income will be highest in January at RM20,487.50 and lowest in April at RM19,957.50, with total projected operating income of RM139,057.50 over the six month period.

Uploaded by

Hidayat Tajuddin
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
18 views3 pages

Kaithlyn's Ice Cream Financial Projections

Kaithlyn's Ice Cream Shoppe projects revenues to increase each month over the next six months, from RM55,000 in January to RM74,750 in June, with total projected revenue of RM427,000. Projected expenses also increase each month, including bonuses paid if sales reach RM65,000. The projection estimates operating income will be highest in January at RM20,487.50 and lowest in April at RM19,957.50, with total projected operating income of RM139,057.50 over the six month period.

Uploaded by

Hidayat Tajuddin
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

Kaithlyn's Ice Cream Shoppe

Six-Month Financial Projection

ary
ry

rch
ua

bru

ril
Jan

Ma

Ap
Fe
Revenue RM55,000.00 RM62,500.00 RM67,000.00
Cost of Goods Sold 11,687.50 13,281.25 14,237.50
Gross Margin RM43,312.50 RM49,218.75 RM52,762.50

Expenses
Bonus RM0.00 RM0.00 RM5,000.00
Commission 12,375.00 14,062.50 15,075.00
Site Rental 5,500.00 6,250.00 6,700.00
Marketing 2,750.00 3,125.00 3,350.00
Equipment Repair and Maintenance 2,200.00 2,500.00 2,680.00
Total Expenses RM22,825.00 RM25,937.50 RM32,805.00

Operating Income RM20,487.50 RM23,281.25 RM19,957.50

What-If Assumptions
Margin 78.75%
Bonus 5,000.00
Sales Revenue for Bonus 65,000.00
Commission 22.50%
Site Rental 10.00%
Marketing 5.00%
Equipment Repair and Maintenance 4.00%
1/3/2021
12/16/1998
h

art
ril

tal
ne
y
Ma
Ap

Ch
To
Ju
RM90,250.00 RM77,500.00 RM74,750.00 RM427,000.00
19,178.13 16,468.75 15,884.38 90,737.50
RM71,071.88 RM61,031.25 RM58,865.63 RM336,262.50

RM5,000.00 RM5,000.00 RM5,000.00 RM20,000.00


20,306.25 17,437.50 16,818.75 96,075.00
9,025.00 7,750.00 7,475.00 42,700.00
4,512.50 3,875.00 3,737.50 21,350.00
3,610.00 3,100.00 2,990.00 17,080.00
RM42,453.75 RM37,162.50 RM36,021.25 RM197,205.00

RM28,618.13 RM23,868.75 RM22,844.38 RM139,057.50


Six-M onth P roje cted Expenses
Bonus Commission Site Rental
Marketing Equipment Repair and Maintenance

25,000

20,000

15,000

RM

10,000

5,000

0
January February March April May June

You might also like