Complete a full analysis of the profit and loss statement.
What do the percentages tell you? Is this business in good financial condition Articulate (in detail) your conclusions.
Home Insert Page Layude TUMU Arial - 11 - A BIU.E.D.A. E = = 3 Cut Lg Copy Format Painter Clipboard C18 3Wrap Te Merge & Font Alignment fx ='Year 1'!C31 EFG Revenue FOOD SALES BEVERAGE SALES Non Alcoholic Beverages Catering (added year 2) Year 1 % 465,925 78% 104,595 18% 25,0624% Year 2 545,902 144,000 48,000 590,000 41% 11% 4% 44% 0% [ 0% Total Gross Revenues $ 595,583 $ 1,327,902 in Cost of Good Sold COGS-FOOD COGS-BEVERAGE COGS COGS COGS COGS COGS Total Cost of Goods Sold Gross Income 161,710 ### 29,067 4.92 1,725 0.34 0 0.02 0 0.0% 0 0.0 0 0.0% 192,503 32% 403,080 68% 191,066 14.4% 40,320 3.0% 3,360 0.3% 224,200 16.924 0 0.02 0 0.04 0 0.0% 458,946 35% 868,956 65% N $ $ NNN Expenses Advertising & Promotion Auto Expense B&O Tax- State of Washinton Only Bank Charges Commissions Consulting Expense Credit Card Fees Depreciation Expense Insurance Health Intro Into Notes I Notes Sales break out Sales bre: Ready 3,600(0.6% 00.000 0 0.0 6000 00.00 000 19,200 3.2% 0 0.0% 240004 Staffing Loan 3.600(0.3% 00.0% 000 6000.00 0 0.0% 000 42,000 3.2% 0 0.0 24.000 18:21 Year 1 Year 2 Sales P&I Type here to search t Bea ut === E Wrap Merge L he Insert Page Layout Formulas Data Review View Arial Arial -11 - A ^ Copy Format Painter BIU A oard Font Alignment 18 fx ='Year 1'!C31 D E F G H B&O Tax- State of Washinton Only 0 0.04 0 0.0% Bank Charges P 600 0.12 600 0.04 Commissions 00.0% 0 0.02 Consulting Expense 00.0% 0 0.04 Credit Card Fees 19,200 3.24 42,000 3.22 Depreciation Expense 0 0.02 0 0.02 Insurance - Health 24,000 4.0 24,000 1.84 Insurance - Hazard/Liability 1,200 0.2% 6,000 0.52 Interest Expense - Bank Loan 5,795 10% 5,331 0.4% Interest Expense - Other Loan 0 0.0% 00.0% Interest Expense - Shareholder Loans 0 0.0% 0 0.0 Janitorial Expense 12,000 2.0: 36,000 2.74 Licenses & Permits - Business 300 0.1% 3000.0% Meals/Meetings 600 0.1 6000.0% Office Expense 1.2000 2. 1,2000.1 Payroll - Management 0 0.0% 0 0.0 Payroll - Staff 190,080319 336,000 Payroll Taxes (State and Federal) 47,520 8.0% Postage & Printing 60,000 45 60001 Professional Fees 6000.000 Rent Expense 2,400 0.4% 2.400 0.2 30,000 5.0 Repairs Maintenance 30.000 2.3 Security & Alarm Expense 2.400 0.4% 2,400 0.25% Supplies - Kitchen and Bar 1.200 0.25 1 2000 Telephone 12.000 2.0 12.000 0.9 Utilities 3.6000.650 3.6000 3 Miscellaneous 24,000 4 000 24,000 18 Total G&A Expenses 0004 0 0.0 382,295 Net Income Before Taxes 645 5 591,831 45% 20,785 3 5 5 277.125 .. - Ready introdot Sales break out Sales Staffing Loan Year 1 Year 2 PAL Type here to search