Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

How do I find the NPV value for each of the following investments (A&B) using the following information and predictions. Thank you. 2017 Total/ YOY

How do I find the NPV value for each of the following investments (A&B) using the following information and predictions. Thank you.

image text in transcribed

image text in transcribed

2017 Total/ YOY Rev 2018 Total/ YOY Rev 2019Total/ YOY Rev. 2016 Actual Revenue Investment $9,000$122,000/$35,000 $162,000/$40,000 $212,000/$50,000 (A) Expand Street Food $87,000 (B) Add Catering and Maintain Street Food $87,000 Tohn research assumed: $25,000 $147,000/$60,000 $217,000/$70,000 $307,000/$90,000 20%-25% (A) & 40%-45% (B) profit before taxes discount rate range 5%-18% 20% YOY "normal" 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) Ordinary Income/Expense (S US) - Accrual Basis January through Decembeir 2014 2015 2016 Comments Income 24,56886,921 Food Sales Total Income 18,000 18,00024,56886,921|2014: 8 special public events & seasonal weekend street service; 2015: 15 special public events, 2016: 40 s ublic 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 $3,613 (2015) and $6,470 (2016)) 4,93710,675 2015: Cody (450 hrs) & sub- contract labor 2016: Cody (650 hrs) & sub- contract labor Business Licenses,/ Permits/Insurance Total COGS Gross Profit Operating Expense (Fixed 4,005 Per event basis 6,000 12,000 18,90447,081 5,664 39,840 Advertising & Promotion Automobile Expenses Bank Service Charges Computer and Internet 1,105 369 287 228 2,131 4,700 |Fuel and maintenance 1,000 Expenses Office Supplies Professional Fees Propane Reimbursement 283 043 2,300 |Client meetin 286 Acct, R&D 109 se 1,4121,500 Leased kitchen space pairs and Maintenance Restaurant Supplies 1,454 382 549 es Uniforms Utilities Total Operating Expense 255 15,000 7,849 14,7662014 Operating Expense not itemized Net Or Other Income/Expense Ask My Accountant Total Other Expense Net Operating Income Income 185 25,074 1,604 1,604 (3,000(2,21823,470 John paid himself a salary from Net Income after reinvesting back in business (201 2017 Total/ YOY Rev 2018 Total/ YOY Rev 2019Total/ YOY Rev. 2016 Actual Revenue Investment $9,000$122,000/$35,000 $162,000/$40,000 $212,000/$50,000 (A) Expand Street Food $87,000 (B) Add Catering and Maintain Street Food $87,000 Tohn research assumed: $25,000 $147,000/$60,000 $217,000/$70,000 $307,000/$90,000 20%-25% (A) & 40%-45% (B) profit before taxes discount rate range 5%-18% 20% YOY "normal" 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) Ordinary Income/Expense (S US) - Accrual Basis January through Decembeir 2014 2015 2016 Comments Income 24,56886,921 Food Sales Total Income 18,000 18,00024,56886,921|2014: 8 special public events & seasonal weekend street service; 2015: 15 special public events, 2016: 40 s ublic 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 $3,613 (2015) and $6,470 (2016)) 4,93710,675 2015: Cody (450 hrs) & sub- contract labor 2016: Cody (650 hrs) & sub- contract labor Business Licenses,/ Permits/Insurance Total COGS Gross Profit Operating Expense (Fixed 4,005 Per event basis 6,000 12,000 18,90447,081 5,664 39,840 Advertising & Promotion Automobile Expenses Bank Service Charges Computer and Internet 1,105 369 287 228 2,131 4,700 |Fuel and maintenance 1,000 Expenses Office Supplies Professional Fees Propane Reimbursement 283 043 2,300 |Client meetin 286 Acct, R&D 109 se 1,4121,500 Leased kitchen space pairs and Maintenance Restaurant Supplies 1,454 382 549 es Uniforms Utilities Total Operating Expense 255 15,000 7,849 14,7662014 Operating Expense not itemized Net Or Other Income/Expense Ask My Accountant Total Other Expense Net Operating Income Income 185 25,074 1,604 1,604 (3,000(2,21823,470 John paid himself a salary from Net Income after reinvesting back in business (201

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

More Books

Students also viewed these Finance questions