Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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.
image text in transcribed
image text in transcribed
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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accounting Information Systems Understanding Business Processes

Authors: Brett Considine, Alison Parkes, Karin Olesen, Michael Lee, Derek Speer

3rd Edition

1742165559, 978-1742165554

More Books

Students also viewed these Accounting questions

Question

=+a) Draw the decision tree.

Answered: 1 week ago

Question

7.9 Determine how the final hiring decision is made.

Answered: 1 week ago