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.

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 icon This preview has intentionally blurred sections. Sign up to view the full version.

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.
  • Spring '16
  • Ward
  • Fiscal Year, Expense, Operating expense, operating expenses, Direct Operating Expenses

{[ 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