Question: I NEED HELP ASAP! I will rate! I need the PROFIT for 2017, 2018, 2019 based on the profit and loss statement. I also need

I NEED HELP ASAP! I will rate!

I need the PROFIT for 2017, 2018, 2019 based on the profit and loss statement. I also need NPV for the same years.

THANK YOU SO MUCH!

I NEED HELP ASAP! I will rate! I need the PROFIT

I NEED HELP ASAP! I will rate! I need the PROFIT

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/ 4,005 Permits/Insurance Per event basis Total COGS 47,081 Gross Profit 12,000 39,840 Operating Expense (Fixed) Advertising & Promotion 2,131 Automobile Expenses 4,700 Fuel and maintenance Bank Service Charges 210 Computer and Internet 1,000 Expenses Office Supplies 53 Professional Fees 2,300 Client meetings, Legal, Acct, R&D Propane 555 Reimbursement 109 Rent Expense 1,500 Leased kitchen space Repairs and Maintenance 92 Restaurant Supplies 549 Supplies 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 Tota! 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) 2016 Actual Revenue Est. 2017 Total/ 2018 Total/ 2019 Tota!/ 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/ 4,005 Permits/Insurance Per event basis Total COGS 47,081 Gross Profit 12,000 39,840 Operating Expense (Fixed) Advertising & Promotion 2,131 Automobile Expenses 4,700 Fuel and maintenance Bank Service Charges 210 Computer and Internet 1,000 Expenses Office Supplies 53 Professional Fees 2,300 Client meetings, Legal, Acct, R&D Propane 555 Reimbursement 109 Rent Expense 1,500 Leased kitchen space Repairs and Maintenance 92 Restaurant Supplies 549 Supplies 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 Tota! 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) 2016 Actual Revenue Est. 2017 Total/ 2018 Total/ 2019 Tota!/ 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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!