Excel

Sheet1

Manola Department Stores, Inc.
Six-Month Financial Projection
	January	February	March	April	May	June	Total
Revenue	$ 1,475,000.00	$ 1,406,000.00	$ 1,116,600.00	$ 1,496,000.00	$ 1,102,900.00	$ 1,455,000.00	$ 8,051,500.00
Cost of Goods Sold	$ 206,718.75	$ 263,437.60	$ 222,487.60	$ 290,875.00	$ 206,793.75	$ 214,743.76	$ 1,405,056.46
Gross Margin	$ 1,268,281.25	$ 1,142,562.40	$ 894,112.40	$ 1,205,125.00	$ 896,106.25	$ 1,240,256.24	$ 6,646,443.54
Expenses							$ - 0
Bonus	$ 7,500.00	$ 7,500.00	$ - 0	$ 7,500.00	$ - 0	$ - 0	$ 22,500.00
Salary	$ 367,426.00	$ 351,210.00	$ 296,650.00	$ 374,500.00	$ 276,725.00	$ 286,265.00	$ 1,952,776.00
Bonus	$ 7,500.00	$ 7,500.00	$ - 0	$ 7,500.00	$ - 0	$ - 0	$ 22,500.00
Site Rental	$ 147,650.00	140.600.00	$ 118,660.00	$ 149,000.00	$ 110,290.00	$ 114,500.00	$ 640,100.00
Marketing	$ 1,447.50	$ 49,175.00	$ 41,631.00	$ 82,430.00	$ 38,601.00	$ 40,065.50	$ 253,350.00
Miscellaneous	$ 1,467.50	$ 49,175.00	$ 41,631.00	$ 52,430.00	$ 36,601.50	$ 40,065.50	$ 221,370.50
Total Expenses	$ 525,491.00	$ 597,660.00	$ 498,572.00	$ 665,860.00	$ 462,217.50	$ 480,896.00	$ 3,230,696.50