Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Exhibit 2-Profit and Loss Statement (2014-2016) Ordinary Income/Expense ($ US) Accrual Basis January through December 2014 2015 2016 Comments Income Food Sales 18,000 24,568 86,921

image text in transcribed

image text in transcribed

Exhibit 2-Profit and Loss Statement (2014-2016) Ordinary Income/Expense ($ US) Accrual Basis January through December 2014 2015 2016 Comments Income Food Sales 18,000 24,568 86,921 Total Income 18,000 24,568 86,921 2014: 8 special public events & seasonal weekend street service; 2015: 15 special public events; 2016: 40 special public events Cost of Goods Sold Food Purchases 12,533 32,401 Goal: = 30% of Food Sales thru purchasing efficiencies and sourcing co-operative Direct Labor Payroll (Cody paid 4,937 10,675 2015: Cody (450 hrs) & sub- $3,613 (2015) and $6,470 (2016)) contract labor 2016: Cody (650 hrs) & sub- contract labor Business Licenses/ 1,434 4,005 Permits/Insurance Per event basis Total COGS 6,000 18,904 47,081 Gross Profit 12,000 5,664 39,840 Operating Expense (Fixed) Advertising & Promotion 1,105 2,131 Automobile Expenses 369 4,700 Fuel and maintenance Bank Service Charges 287 210 Computer and Internet 228 1,000 Expenses Office Supplies 283 53 Professional Fees 2,300 Client meetings, Legal, Acct, R&D Propane 286 555 Reimbursement 109 Rent Expense 1,500 Leased kitchen space Repairs and Maintenance 92 Restaurant Supplies 1,454 549 Supplies 382 1,239 Uniforms 73 Utilities 255 Total Operating Expense 15,000 7,849 14,766 2014 Operating Expense not itemized Net Ordinary Income (2,185) 25,074 Other Income/Expense Ask My Accountant 33 1,604 Total Other Expense 33 1,604 Net Operating Income (3,000) (2,218) 23,470 John paid himself a salary from Net Income after reinvesting back in business (2016) Source: John Christ Owner, Wil's Grill (July 2017) 2,043 1,412 Exhibit 3 Estimated Investment Levels and Future Revenue Projections (rounded) 2016 Actual Revenue Est. 2017 Total/ 2018 Total/ 2019 Total/ Investment YOY Rev. YOY Rev. YOY Rev. (A) Expand Street Food: $9,000 $122,000/$35,000 $162,000/$40,000 $212,000/$50,000 $ $87,000 (B) Add Catering and $25,000 $147,000/$60,000 $217,000/$70,000 $307,000/$90,000 Maintain Street Food: $87,000 John research assumed: 20%-25% (A) & 40%-45% (B) profit before taxes . discount rate range 5%-18% 20% YOYnormal growth rate for street food revenue (2016-2019) +2% YOY inflation rate; +3% YOY contingency expense $3,500 revenue per catering event (2017) 5% YOY higher operating expenses for (B) vs. (A) 2017 COGS 50% (A) and 52% (B) of Total Income bef. inflation/contingency "Est. Investment" primarily kitchen equipment Source: John Christ - Owner, Wil's Grill (July 2017) Exhibit 2-Profit and Loss Statement (2014-2016) Ordinary Income/Expense ($ US) Accrual Basis January through December 2014 2015 2016 Comments Income Food Sales 18,000 24,568 86,921 Total Income 18,000 24,568 86,921 2014: 8 special public events & seasonal weekend street service; 2015: 15 special public events; 2016: 40 special public events Cost of Goods Sold Food Purchases 12,533 32,401 Goal: = 30% of Food Sales thru purchasing efficiencies and sourcing co-operative Direct Labor Payroll (Cody paid 4,937 10,675 2015: Cody (450 hrs) & sub- $3,613 (2015) and $6,470 (2016)) contract labor 2016: Cody (650 hrs) & sub- contract labor Business Licenses/ 1,434 4,005 Permits/Insurance Per event basis Total COGS 6,000 18,904 47,081 Gross Profit 12,000 5,664 39,840 Operating Expense (Fixed) Advertising & Promotion 1,105 2,131 Automobile Expenses 369 4,700 Fuel and maintenance Bank Service Charges 287 210 Computer and Internet 228 1,000 Expenses Office Supplies 283 53 Professional Fees 2,300 Client meetings, Legal, Acct, R&D Propane 286 555 Reimbursement 109 Rent Expense 1,500 Leased kitchen space Repairs and Maintenance 92 Restaurant Supplies 1,454 549 Supplies 382 1,239 Uniforms 73 Utilities 255 Total Operating Expense 15,000 7,849 14,766 2014 Operating Expense not itemized Net Ordinary Income (2,185) 25,074 Other Income/Expense Ask My Accountant 33 1,604 Total Other Expense 33 1,604 Net Operating Income (3,000) (2,218) 23,470 John paid himself a salary from Net Income after reinvesting back in business (2016) Source: John Christ Owner, Wil's Grill (July 2017) 2,043 1,412 Exhibit 3 Estimated Investment Levels and Future Revenue Projections (rounded) 2016 Actual Revenue Est. 2017 Total/ 2018 Total/ 2019 Total/ Investment YOY Rev. YOY Rev. YOY Rev. (A) Expand Street Food: $9,000 $122,000/$35,000 $162,000/$40,000 $212,000/$50,000 $ $87,000 (B) Add Catering and $25,000 $147,000/$60,000 $217,000/$70,000 $307,000/$90,000 Maintain Street Food: $87,000 John research assumed: 20%-25% (A) & 40%-45% (B) profit before taxes . discount rate range 5%-18% 20% YOYnormal growth rate for street food revenue (2016-2019) +2% YOY inflation rate; +3% YOY contingency expense $3,500 revenue per catering event (2017) 5% YOY higher operating expenses for (B) vs. (A) 2017 COGS 50% (A) and 52% (B) of Total Income bef. inflation/contingency "Est. Investment" primarily kitchen equipment Source: John Christ - Owner, Wil's Grill (July 2017)

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

Managerial Accounting

Authors: McGraw Hill Education

14th Edition

1121182518, 978-1121182516

More Books

Students also viewed these Accounting questions