pandl 5 year - Pro Forma Income Statement Fiscal Year 2014...

Info icon This preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Pro Forma Income Statement Fiscal Year 2014 - 2015 Jan-15 Feb-15 Mar-15 Apr-15 May-15 Jun-15 Jul-15 Aug-15 Sep-14 Oct-14 Nov-14 Dec-14 Total Sales Food 90,000 75,642 72,685 95,145 98,425 99,652 97,525 115,235 120,589 130,256 122,658 110,528 1,228,340 85% Liquor 11,118 9,344 8,979 11,753 12,158 12,310 12,047 14,235 14,896 16,090 15,152 13,653 151,736 11% Beer 2,382 2,002 1,924 2,519 2,605 2,638 2,582 3,050 3,192 3,448 3,247 2,926 32,515 2% Wine 2,382 2,002 1,924 2,519 2,605 2,638 2,582 3,050 3,192 3,448 3,247 2,926 32,515 2% Total Sales 105,882 88,991 85,512 111,935 115,794 117,238 114,735 135,571 141,869 153,242 144,304 130,033 1,445,106 100% Cost of Sales Food 27,000 22,693 21,806 28,544 29,528 29,896 29,258 34,571 36,177 39,077 36,797 33,158 368,502 26% Liquor 2,779 2,336 2,245 2,938 3,040 3,077 3,012 3,559 3,724 4,023 3,788 3,413 37,934 3% Beer 596 501 481 630 651 659 645 763 798 862 812 731 8,129 1% Wine 953 801 770 1,007 1,042 1,055 1,033 1,220 1,277 1,379 1,299 1,170 13,006 1% Total Cost of Sales 31,328 26,330 25,301 33,119 34,261 34,688 33,947 40,112 41,976 45,341 42,696 38,473 427,571 30% Gross Profit 74,554 62,660 60,211 78,816 81,534 82,550 80,788 95,459 99,894 107,902 101,608 91,559 1,017,535 70% Operating Expenses Salaries & Wages 55,320 ### 55,320 ### 55,320 ### 55,320 55,320 ### 55,320 55,320 55,320 663,840 46% Employee Benefits 4,984 4,984 4,984 4,984 4,984 4,984 4,984 4,984 4,984 4,984 4,984 4,984 59,813 4% Direct Operating Expenses 6,506 6,417 6,421 6,514 6,952 6,898 6,417 6,417 6,417 6,417 6,417 6,417 78,207 5% Marketing 4,215 4,215 4,215 4,215 4,215 4,215 4,215 4,215 4,215 4,215 4,215 4,215 50,579 4% Utilities 3,928 3,928 3,928 3,928 3,928 3,928 3,928 3,928 3,928 3,928 3,928 3,928 47,141 3% General & Admin Expenses 5,805 5,811 5,805 5,805 5,805 5,805 5,805 5,805 5,805 5,805 5,805 5,805 69,662 5% Repair & Maintenance 2,500 2,500 2,500 2,500 2,500 2,500 2,500 2,500 2,500 2,500 2,500 2,500 30,000 2% Total Operating Expenses 83,258 83,175 83,173 83,266 83,704 83,650 83,169 83,169 83,169 83,169 83,169 83,169 999,241 69% Operating Profit (8,704) (20,515) (22,962) (4,450) (2,170) (1,100) (2,381) 12,289 16,725 24,733 18,438 8,390 18,294 1% Occupancy Costs Rent 8,000 ### 8,000 ### 8,000 ### 8,000 8,000 ### 8,000 8,000 8,000 96,000 7% Property Taxes 1,440 1,440 1,440 1,440 1,440 1,440 1,440 1,440 1,440 1,440 1,440 1,440 17,280 1% Other Taxes 250 ### 250 ### 250 ### 250 250 ### 250 250 250 3,000 0% Property Insurance 1,200 ### 1,200 ### 1,200 ### 1,200 1,200 ### 1,200 1,200 1,200 14,400 1% Total Occupancy Cost 10,890 10,890 10,890 10,890 10,890 10,890 10,890 10,890 10,890 10,890 10,890 10,890 130,680 9% IBITDA (19,594) (31,405) (33,852) (15,340) (13,060) (11,990) (13,271) 1,399 5,835 13,843 7,548 (2,500) (112,386) -8% Interest 1,000 982 964 946 928 910 892 873 855 836 817 798 10,802 1% Depreciation 542 542 542 542 542 542 542 542 542 542 542 542 6,500 0% Income Before Taxes (21,135) (32,929) (35,358) (16,828) (14,530) (13,442) (14,705) (16) 4,438 12,465 6,190 (3,840) (129,688) -9% 55 | Page As a % of Sales
Image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Operating Expense Details Fiscal Year 2014 - 2015 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total Payroll Management 9,167 9,167 9,167 9,167 9,167 9,167 9,167 9,167 9,167 9,167 9,167 9,167 110,000 7.6% Projected Personnel 24,063 24,063 24,063 24,063 24,063 24,063 24,063 24,063 24,063 24,063 24,063 24,063 288,756 20.0% Taxes & Benefits 4,984 4,984 4,984 4,984 4,984 4,984 4,984 4,984 4,984 4,984 4,984 4,984 59,813 4.1% Total Payroll 38,214 38,214 38,214 38,214 38,214 38,214 38,214 38,214 38,214 38,214 38,214 38,214 458,569 31.7% Direct Operating Expenses Uniforms 241 241 241 241 241 241 241 241 241 241 241 241 2,890 0.2% Laundry & Linen 591 591 591 591 591 591 591 591 591 591 591 591 7,088 0.5% Tableware 1,250 1,250 1,250 1,250 1,250 1,250 1,250 1,250 1,250 1,250 1,250 1,250 15,000 1.0% Kitchen Utensils 450 361 365 458 896 842 361 361 361 361 361 361 5,540 0.4% Cleaning Supplies 1,204 1,204 1,204 1,204 1,204 1,204 1,204 1,204 1,204 1,204 1,204 1,204 14,451 1.0% Paper Supplies 963 963 963 963 963 963 963 963 963 963 963 963 11,561 0.8% Bar Supplies 241 241 241 241 241 241 241 241 241 241 241 241 2,890 0.2% Menus 241 241 241 241 241 241 241 241 241 241 241 241 2,890 0.2% Contract Cleaning 963 963 963 963 963 963 963 963 963 963 963 963 11,561 0.8% Flowers & Decorations 241 241 241 241 241 241 241 241 241 241 241 241 2,890 0.2% Miscellaneous 120 120 120 120 120 120 120 120 120 120 120 120 1,445 0.1% Total Direct Operating Expenses 6,506 6,417 6,421 6,514 6,952 6,898 6,417 6,417 6,417 6,417 6,417 6,417 78,207 5.4% Marketing Advertising/Promotions 3,011 3,011 3,011 3,011 3,011 3,011 3,011 3,011 3,011 3,011 3,011 3,011 36,128 2.5% Research 1,204 1,204 1,204 1,204 1,204 1,204 1,204 1,204 1,204 1,204 1,204 1,204 14,451 1.0% Total Advertising & Promotion 4,215 4,215 4,215 4,215 4,215 4,215 4,215 4,215 4,215 4,215 4,215 4,215 50,579 3.5% Utilities Electrical 2,122 2,122 2,122 2,122 2,122 2,122 2,122 2,122 2,122 2,122 2,122 2,122 25,464 1.8% Gas 602 602 602 602 602 602 602 602 602 602 602 602 7,226 0.5% Trash Removal 602 602 602 602 602 602 602 602 602 602 602 602 7,226 0.5% Water 602 602 602 602 602 602 602 602 602 602 602 602 7,226 0.5% Total Utilities 3,928 3,928 3,928 3,928 3,928 3,928 3,928 3,928 3,928 3,928 3,928 3,928 47,141 3.3% Administrative & General Expenses Bank Charges 50 50 50 50 50 50 50 50 50 50 50 50 600 0.0% Cash (Over)/Short 100 100 100 100 100 100 100 100 100 100 100 100 1,200 0.1% Credit Card Charges 1,673 1,679 1,673 1,673 1,673 1,673 1,673 1,673 1,673 1,673 1,673 1,673 20,082 1.4% Miscellaneous 1,204 1,204 1,204 1,204 1,204 1,204 1,204 1,204 1,204 1,204 1,204 1,204 14,451 1.0% Postage 150 150 150 150 150 150 150 150 150 150 150 150 1,800 0.1% Printing & Office Supplies 321 321 321 321 321 321 321 321 321 321 321 321 3,852 0.3% Professional Fees 1,204 1,204 1,204 1,204 1,204 1,204 1,204 1,204 1,204 1,204 1,204 1,204 14,451 1.0% Security Services 500 500 500 500 500 500 500 500 500 500 500 500 6,000 0.4% Telephone & Fax 602 602 602 602 602 602 602 602 602 602 602 602 7,226 0.5% Total Administrative & General 5,805 5,811 5,805 5,805 5,805
Image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern