Madison Public Market Operating Pro Forma Updated: 10/01/2020
OPERATING ASSUMPTIONS VACANCY RATES
Operating Months per Year 12 Year 1 15%
Operating Days per Month 25 Year 2 15%
Operating Days per year 300 Year 3 15%
Est Total Sales at Stabilization $10,000,000 Year 4 15%
Fringe Benefits (%) 25% Year 5 15%
Cost Inflation Rate 2%
EVENT RENTALS Events per year Cost per event Event revenue
South Hall 52 $2,000 $104,000
RENTS & CAM Community Room/Mezz 24 $400 $9,600
Rent Growth 2% Whole Facility 3 $10,000 $30,000
Ave Storefront Rent PSF $37 - $0
Average Sales PSF GLA $648 $0
Storefront GLA 15,440 $143,600
CAM PSF $12
Average Rent+CAM as % Sales 7.6%
Food Innoavtion Center Year 1 Year 2 Year 3 Year 4 Year 5
DAY STALLS Public Market Businesses 31,800$ 34,980$ 41,340$ 44,520$ 44,520$
Daystall Daily Fee $75 Other business users 54,000$ 59,400$ 70,200$ 75,600$ 75,600$
Daystall uses per day 2 Training Programs 17,500$ 19,250$ 22,750$ 24,500$ 24,500$
Daystall uses per year 600 Food Processing 17,500$ 19,250$ 22,750$ 24,500$ 24,500$
Daystall rev per year 45,000 Occupancy & Scale Up 50% 55% 65% 70% 70%
120,800 132,880 157,040 169,120 169,120
INCOME YEAR 1 YEAR 2 YEAR 3 YEAR 4 YEAR 5
Permanent Stall Rents 571,280$ 582,706$ 594,360$ 606,247$ 618,372$
Common Area Maintenance 185,280$ 188,986$ 192,765$ 196,621$ 200,553$
Day Stall Rents 45,000$ 45,900$ 46,818$ 47,754$ 48,709$
Event Revenue 21,540$ 71,800$ 73,236$ 74,701$ 76,195$
Liquor Revenue 25,000$ 30,000$ 35,000$ 45,000$ 45,900$
FIC Revenues 120,800$ 132,880$ 157,040$ 169,120$ 169,120$
Ongoing Fundraising 5,000$ 5,100$ 5,202$ 5,306$ 5,412$
Vacancy Loss (113,484)$ (115,754)$ (118,069)$ (120,430)$ (122,839)$
TOTAL INCOME 860,416$ 941,618$ 986,352$ 1,024,319$ 1,041,422$
EXPENSES
Personnel YEAR 1 YEAR 2 YEAR 3 YEAR 4 YEAR 5
Executive Director/ FIC Manager 80,000$ 81,600$ 83,232$ 84,897$ 86,595$
Operations Manager 70,000$ 71,400$ 72,828$ 74,285$ 75,770$
Events Coordinator 32,500$ 33,150$ 33,813$ 34,489$ 35,179$
Marketing/Outreach Coordinator 65,000$ 66,300$ 67,626$ 68,979$ 70,358$
Maintenance 50,000$ 51,000$ 52,020$ 53,060$ 54,122$
Custodial 50,000$ 51,000$ 52,020$ 53,060$ 54,122$
Admin Assistant / Bookkeeper 45,000$ 45,900$ 46,818$ 47,754$ 48,709$
Fringe 98,125$ 100,088$ 102,089$ 104,131$ 106,214$
Total Personnel 490,625$ 500,438$ 510,446$ 520,655$ 531,068$
Non-Personnel YEAR 1 YEAR 2 YEAR 3 YEAR 4 YEAR 5
Advertising/Events 30,000$ 30,600$ 31,212$ 31,836$ 32,473$
Food Safety Consultant 10,000$ 10,000$ 10,000$ 10,000$ 10,000$
Property Taxes 40,000$ 41,200$ 42,436$ 43,709$ 45,020$
Legal/Professional 25,000$ 25,500$ 26,010$ 26,530$ 27,061$
Insurance 25,000$ 25,500$ 26,010$ 26,530$ 27,061$
Fees/Permits 5,000$ 5,100$ 5,202$ 5,306$ 5,412$
Net Utilities (electric/gas/water) 120,000$ 122,400$ 124,848$ 127,345$ 129,892$
Garbage 30,000$ 30,600$ 31,212$ 31,836$ 32,473$
IT 15,000$ 15,300$ 15,606$ 15,918$ 16,236$
Maintenance/Repairs 12,000$ 15,000$ 15,300$ 15,606$ 15,918$
Supplies 25,000$ 25,500$ 26,010$ 26,530$ 27,061$ low
Capital Reserves 10,000$ 10,200$ 10,404$ 10,612$ 10,824$
Snow Removal 15,000$ 15,300$ 15,606$ 15,918$ 16,236$
Landscaping 2,000$ 5,000$ 5,100$ 5,202$ 5,306$
Community Programming 5,000$ 5,100$ 5,202$ 5,306$ 5,412$
Total Non-Personnel 369,000$ 382,300$ 390,158$ 398,186$ 406,386$
Contracy Events & FIC
YEAR 1 YEAR 2 YEAR 3 YEAR 4 YEAR 5
Total Income 860,416$ 941,618$ 986,352$ 1,024,319$ 1,041,422$
Total Expenses 859,625$ 882,738$ 900,604$ 918,841$ 937,455$
Net Operating Income (NOI) 791$ 58,880$ 85,748$ 105,478$ 103,968$
Seed Money 100,000$ 100,000$ 100,000$
Funds From Operations 100,791$ 158,880$ 185,748$ 105,478$ 103,968$