Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please provide explanation and formula if possible to use in excel. B A 1 Question 1) 2 In cell D5 calculate August Revenue for In-Person
Please provide explanation and formula if possible to use in excel.
B A 1 Question 1) 2 In cell D5 calculate August Revenue for In-Person 3 4 Question 2a-c) 5 In cells B7-D7 calculate Percent of Revenue for In- 6 7 Question 3) 8 In cell B10 calculate Revenue for Remote Support 9 10 Question 4) 11 In cell D26 calculate Expenses for Contractor Wages. 12 13 Question 5a-c) 14 In cells B32-D32 calculate Profit Margin in June, 15 16 C E B June 2020 D August 2020 July 2020 180% Growth 4.320.00 100% Growth 1,200.00 $ 320.00 $ 1,520.00 $ 2b) 200% Growth 2,400.00 $ 640.001) 3,040.00 $ 2c) S S S 2a) Std. Price $ Prm. Price $ 60.00 80.00 4,320.00 3) S S 100% Growth $ 240.00 $ 240.00 $ 220% Growth 3,960.00 $ 528.00 $ 4,488.00 $ 200% Growth 7.920.00 1,056.00 8.976.00 Std. Price $ Prm. Price $ 45.00 60.00 $ 1,760.00 $ 7,528.00 $ 13,296.00 1 FINANCIAL MODEL 2 Revenue 3 In-Person Service 4 Standard 5 Premium 6 Total In-Person Service 7 % of Revenue 8 9 Remote Service 10 Standard 11 Premium 12 Total Remote Service 13 14 Total Revenue 15 16 Expenses 17 Marketing & Sales 18 Facebook Campaigns 19 Canva Pro 20 Hubspot Premium 21 Total M&S 22 % of Expenses 23 24 General & Admin 25 Incorporation 26 Contracted Technicians Wages 27 Total G&A 28 29 Total Expenses 3D 31 Profit 32 Profit margin 33 34 35 S S S S 500.00 $ 65.00 $ $ 565.00 $ 22.03% 1,000.00 $ 78.00 $ 135.00 $ 1,213.00 $ 31.05% 1,000.00 78.00 135.00 1,213.00 100.00% Monthly Per User $ Monthly $ 13.00 135.00 S S S 2,000.00 $ $ 2,000.00 $ $ 2,693.20 4) 2,693.20 $ $ 2,565.00 $ 3,906.20$ 1,213.00 (805.00 12.083.00 3,621.80 $ 5c) 5a) 5b)Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started