Please aggregate this profit and loss table:
Year # Pre-Opening 1 Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12 2 3 4 5 6 7
Income
Rentable Event Space Income $0 $1,000,000 $83,333 $83,333 $83,333 $83,333 $83,333 $83,333 $83,333 $83,333 $83,333 $83,333 $83,333 $83,333 $1,200,000 $1,200,000 $1,200,000 $1,200,000 $1,200,000 $1,200,000
Cooking Class/Workshop Income $0 $17,500 $1,458 $1,458 $1,458 $1,458 $1,458 $1,458 $1,458 $1,458 $1,458 $1,458 $1,458 $1,458 $21,000 $21,000 $21,000 $21,000 $21,000 $21,000
Private Event Space Income $0 $150,000 $12,500 $12,500 $12,500 $12,500 $12,500 $12,500 $12,500 $12,500 $12,500 $12,500 $12,500 $12,500 $180,000 $180,000 $180,000 $180,000 $180,000 $180,000
Monthly Membership Income $0 $322,500 $26,875 $26,875 $26,875 $26,875 $26,875 $26,875 $26,875 $26,875 $26,875 $26,875 $26,875 $26,875 $531,150 $536,400 $536,400 $536,400 $536,400 $536,400
Catering Revenue $0 $50,000 $4,167 $4,167 $4,167 $4,167 $4,167 $4,167 $4,167 $4,167 $4,167 $4,167 $4,167 $4,167 $60,000 $60,000 $60,000 $60,000 $60,000 $60,000
Food Sales Revenue $0 $794,274 $66,190 $66,190 $66,190 $66,190 $66,190 $66,190 $66,190 $66,190 $66,190 $66,190 $66,190 $66,190 $1,036,206 $1,108,740 $1,186,352 $1,269,397 $1,358,255 $1,453,333
Beverage Sales $0 $548,169 $45,681 $45,681 $45,681 $45,681 $45,681 $45,681 $45,681 $45,681 $45,681 $45,681 $45,681 $45,681 $668,354 $668,354 $668,354 $668,354 $668,354 $668,354
Takeout/Delivery Revenue $0 $111,198 $9,267 $8,825 $9,267 $9,267 $9,267 $9,267 $9,267 $9,267 $9,267 $9,267 $9,267 $9,267 $135,578 $135,578 $135,578 $135,578 $135,578 $135,578
Merchandise Sales Revenue $0 $105,903 $8,825 $8,825 $8,825 $8,825 $8,825 $8,825 $8,825 $8,825 $8,825 $8,825 $8,825 $8,825 $138,161 $147,832 $158,180 $169,253 $181,101 $193,778
Gift Card Revenue $0 $5,295 $441 $441 $441 $441 $441 $441 $441 $441 $441 $441 $441 $441 $6,908 $7,392 $7,909 $8,463 $9,055 $9,689
Vendor Partnership Sales $0 $190,626 $15,885 $15,885 $15,885 $15,885 $15,885 $15,885 $15,885 $15,885 $15,885 $15,885 $15,885 $15,885 $248,689 $266,098 $284,725 $304,655 $325,981 $348,800
Advertising Revenue $0 $20,000 $1,667 $1,667 $1,667 $1,667 $1,667 $1,667 $1,667 $1,667 $1,667 $1,667 $1,667 $1,667 $25,680 $27,478 $29,401 $31,459 $33,661 $36,018
Online Ordering/Meal Kit Revenue $0 $190,626 $15,885 $15,885 $15,885 $15,885 $15,885 $15,885 $15,885 $15,885 $15,885 $15,885 $15,885 $15,885 $248,689 $266,098 $284,725 $304,655 $325,981 $348,800
Total Income $0 $3,506,092 $292,174 $291,732 $292,174 $292,174 $292,174 $292,174 $292,174 $292,174 $292,174 $292,174 $292,174 $292,174 $4,500,416 $4,624,969 $4,752,624 $4,889,214 $5,035,366 $5,191,749
Costs of Goods Sold
Catering COGS $0 -$17,500 -$1,458 -$1,458 -$1,458 -$1,458 -$1,458 -$1,458 -$1,458 -$1,458 -$1,458 -$1,458 -$1,458 -$1,458 -$21,000 -$21,000 -$21,000 -$21,000 -$21,000 -$21,000
Catering Operating Expenses $0 -$15,000 -$1,250 -$1,250 -$1,250 -$1,250 -$1,250 -$1,250 -$1,250 -$1,250 -$1,250 -$1,250 -$1,250 -$1,250 -$18,000 -$18,000 -$18,000 -$18,000 -$18,000 -$18,000
Food Sales COGS $0 -$516,278 -$43,023 -$43,023 -$43,023 -$43,023 -$43,023 -$43,023 -$43,023 -$43,023 -$43,023 -$43,023 -$43,023 -$43,023 -$673,534 -$720,681 -$771,129 -$825,108 -$882,866 -$944,666
Beverage Sales COGS $0 -$164,451 -$13,704 -$13,704 -$13,704 -$13,704 -$13,704 -$13,704 -$13,704 -$13,704 -$13,704 -$13,704 -$13,704 -$13,704 -$200,506 -$200,506 -$200,506 -$200,506 -$200,506 -$200,506
Takeout/Deliveray COGS $0 -$77,839 -$6,487 -$6,487 -$6,487 -$6,487 -$6,487 -$6,487 -$6,487 -$6,487 -$6,487 -$6,487 -$6,487 -$6,487 -$94,905 -$94,905 -$94,905 -$94,905 -$94,905 -$94,905
Merchandise SalesCOGS $0 -$37,066 -$3,089 -$3,089 -$3,089 -$3,089 -$3,089 -$3,089 -$3,089 -$3,089 -$3,089 -$3,089 -$3,089 -$3,089 -$48,356 -$51,741 -$55,363 -$59,239 -$63,385 -$67,822
Gift Card COGS $0 -$530 -$44 -$44 -$44 -$44 -$44 -$44 -$44 -$44 -$44 -$44 -$44 -$44 -$691 -$739 -$791 -$846 -$906 -$969
Vendor Partnership COGS $0 -$19,063 -$1,589 -$1,589 -$1,589 -$1,589 -$1,589 -$1,589 -$1,589 -$1,589 -$1,589 -$1,589 -$1,589 -$1,589 -$24,869 -$26,610 -$28,472 -$30,466 -$32,598 -$34,880
Online Ordering/Meal Kit COGS $0 -$19,063 -$1,589 -$1,589 -$1,589 -$1,589 -$1,589 -$1,589 -$1,589 -$1,589 -$1,589 -$1,589 -$1,589 -$1,589 -$24,869 -$26,610 -$28,472 -$30,466 -$32,598 -$34,880
Total Costs of Goods Sold $0 -$866,789 -$72,232 -$72,233 -$72,233 -$72,233 -$72,233 -$72,233 -$72,233 -$72,233 -$72,233 -$72,233 -$72,233 -$72,233 -$1,106,730 -$1,160,792 -$1,218,639 -$1,280,535 -$1,346,764 -$1,417,628
Gross Profit $0 $2,639,303 $219,942 $219,499 $219,941 $219,941 $219,941 $219,941 $219,941 $219,941 $219,941 $219,941 $219,941 $219,941 $3,393,686 $3,464,177 $3,533,985 $3,608,680 $3,688,603 $3,774,120
Operating Expenses
Real Estate Taxes -$19,321 -$34,126 -$2,844 -$2,844 -$2,844 -$2,844 -$2,844 -$2,844 -$2,844 -$2,844 -$2,844 -$2,844 -$2,844 -$2,844 -$34,126 -$34,126 -$34,126 -$34,126 -$34,126 -$34,126
Lease -$415,378 -$436,147 -$36,346 -$36,346 -$36,346 -$36,346 -$36,346 -$36,346 -$36,346 -$36,346 -$36,346 -$36,346 -$36,346 -$36,346 -$457,954 -$480,852 -$504,895 -$530,139 -$556,646 -$584,479
Insurance - Business -$20,000 -$7,700 -$642 -$642 -$642 -$642 -$642 -$642 -$642 -$642 -$642 -$642 -$642 -$642 -$10,506 -$10,821 -$11,146 -$11,480 -$11,825 -$3,980
Utilities -$5,000 -$18,480 -$1,540 -$1,540 -$1,540 -$1,540 -$1,540 -$1,540 -$1,540 -$1,540 -$1,540 -$1,540 -$1,540 -$1,540 -$25,214 -$25,971 -$26,750 -$27,552 -$28,379 -$9,552
Salaries/ Wages -$280,000 -$485,000 -$40,417 -$40,417 -$40,417 -$40,417 -$40,417 -$40,417 -$40,417 -$40,417 -$40,417 -$40,417 -$40,417 -$40,417 -$509,250 -$534,713 -$561,449 -$589,521 -$618,997 -$649,947
AMPM Consulting Fee -$135,000 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Furniture /Equip/ Artwork / Signage -$591,988 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Employee Related Expenses -$25,000 -$57,750 -$4,813 -$4,813 -$4,813 -$4,813 -$4,813 -$4,813 -$4,813 -$4,813 -$4,813 -$4,813 -$4,813 -$4,813 -$78,795 -$81,159 -$83,594 -$86,101 -$88,684 -$29,851
R&M - masonry repair -$36,000 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Waste Disposal -$5,500 -$4,620 -$385 -$385 -$385 -$385 -$385 -$385 -$385 -$385 -$385 -$385 -$385 -$385 -$6,304 -$6,493 -$6,687 -$6,888 -$7,095 -$2,388
Accounting/Legal -$5,000 -$5,250 -$438 -$438 -$438 -$438 -$438 -$438 -$438 -$438 -$438 -$438 -$438 -$438 -$5,411 -$5,573 -$5,740 -$5,912 -$6,208 -$6,518.31
Tech/Software Subscriptions -$32,000 -$33,600 -$2,800 -$2,800 -$2,800 -$2,800 -$2,800 -$2,800 -$2,800 -$2,800 -$2,800 -$2,800 -$2,800 -$2,800 -$35,280 -$37,044 -$38,896 -$40,841 -$42,883 -$45,027
Cleaning Supplies -$12,000 -$12,600 -$1,050 -$1,050 -$1,050 -$1,050 -$1,050 -$1,050 -$1,050 -$1,050 -$1,050 -$1,050 -$1,050 -$1,050 -$13,230 -$13,892 -$14,586 -$15,315 -$16,081 -$16,885
preopening food & beverage -$38,000 -$39,900 -$3,325 -$3,325 -$3,325 -$3,325 -$3,325 -$3,325 -$3,325 -$3,325 -$3,325 -$3,325 -$3,325 -$3,325 -$41,895 -$43,990 -$46,189 -$48,499 -$50,924 -$53,470
Marketing: 3rd party not emp -$70,000 -$64,680 -$5,390 -$5,390 -$5,390 -$5,390 -$5,390 -$5,390 -$5,390 -$5,390 -$5,390 -$5,390 -$5,390 -$5,390 -$88,250 -$90,898 -$93,625 -$96,434 -$99,327 -$104,293
Janitorial: 3rd party not emp -$5,500 -$5,775 -$481 -$481 -$481 -$481 -$481 -$481 -$481 -$481 -$481 -$481 -$481 -$481 -$7,880 -$8,116 -$8,359 -$8,610 -$8,868 -$2,985
Contigency -$50,000 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Operating Expenses -$1,745,687 -$1,205,628 -$100,469 -$100,471 -$100,471 -$100,471 -$100,471 -$100,471 -$100,471 -$100,471 -$100,471 -$100,471 -$100,471 -$100,471 -$1,314,095 -$1,373,647 -$1,436,043 -$1,501,420 -$1,570,043 -$1,543,503
23% 25% 25% 25% 25% 26% 25%
Net Operating Income -$1,745,687 $1,433,675 $119,473 $119,028 $119,470 $119,470 $119,470 $119,470 $119,470 $119,470 $119,470 $119,470 $119,470 $119,470 $2,079,591 $2,090,530 $2,097,942 $2,107,260 $2,118,559 $2,230,618

With this Profit and Loss table in one unique table:
Year # Pre-Opening 1 2 3 4 5 6 7 8 9 10 11
Gross Potential Income
Commercial Lease Income $0 $181,885 $458,351 $481,268 $505,332 $530,598 $557,128 $194,995 $0 $0 $0 $0
Rentable Event Space Income $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Cooking Class/Workshop Income $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Private Event Space Income $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Monthly Membership Income $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Catering Revenue $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Food Sales Revenue $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Beverage Sales $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Takeout/Delivery Revenue $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Merchandise Sales Revenue $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Gift Card Revenue $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Vendor Partnership Sales $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Advertising Revenue $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Online Ordering/Meal Kit Revenue $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Effective Gross Income $0 $181,885 $458,351 $481,268 $505,332 $530,598 $557,128 $194,995 $0 $0 $0 $0
Operating Expenses
Real Estate Taxes $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Insurance - Building $20,000 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Utilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Salaries/ Wages $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Employee Related Expenses $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
R&M $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Waste Disposal $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Accounting/Legal $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Tech/Software Subscriptions $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Cleaning Supplies $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Marketing $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Janitorial $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Operating Expenses $20,000 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Net Operating Income -$20,000 $181,885 $458,351 $481,268 $505,332 $530,598 $557,128 $194,995 $0 $0 $0 $0
Acquisition Costs
Property Purchase $2,767,000 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Acquisition Fees $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Closing Costs $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Acquisition Costs $2,767,000 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Soft Improvement Costs
Architecture - General LI, to be broken out $200,000 0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Engineering $82,000 0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Interior Design $25,500 0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Permits / Shoring Bond $9,500 0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Misc Fees (DD, Misc.) $0 0 $0 $0 $0 $0 $0 $0 $0 $0 $0
PM Reimbursements $45,000 0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Inspections/Testing Lab $7,400 0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Legal $2,500 0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Accounting $2,500 0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Insurance $0 0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Real Estate Taxes $0 0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Development Fee $0 0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Developer Overhead $25,000 0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Utility Fees $0 0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Marketing $0 0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Advertising $0 0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Lease Up $0 0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Soft Cost Contingency $45,372 0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Soft Costs $444,772 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Hard Improvement Costs
Demolition & Abatement $0 0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Environmental $0 0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Sitework $0 0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Surveys/Inspections $4,210 0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Furniture / Artwork / Signage $591,988 0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Construction Costs $1,113,000 0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Estimating/Escalation Contingency $85,460 0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Construction Contingency $179,466 0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Hard Costs $1,974,124 0 $0 $0 $0 $0 $0 $0 $0 $0 $0