Please help me with the following problem set. It is question 2 (Q2) in the image. Please include formulas used so I can transfer to excel spreadsheet for calculations. Thank you.

X AutoSave Off ( + 07 5 0 W1 Assignment v Search Guel, David GD X File Home Insert Page Layout Formulas Data Review View Automate Developer Help Acrobat Upcoming Features. Try It Now. Learn more about features coming utoSum soon and share feedback Fill Sort & Find & Analyze Sensitivity Clear v Filter * Select Data Editing Analysis Sensitivity V W Your sales force is asking for more administrative support. You have estimated you can hire a new person in this role at an all in cost of $30 per hour for 180 hrs per month with an upfront hiring and training expense of $5,000. You have 3 sales people, and are guessing each sales person can gain 2 Q2 additional new customers per month. Assume each customer acquired has an estimated total lifetime present value (at the time of the new sale) of $1,000 in profits. You have been asked to consider only 1 year of new sales in making this decision (the average turnover of these positions is once per year). Assume the company considers it's opportunity cost to be 8% per year compounded monthly. This lucky company pays no taxes. What is your decision, will you make this hire? Why or why not? Time (months) 0 6 8 10 11 12 Customers per mo. (new) Value of customers Cost of customers Training investment Total Cash Flows Discount Factor PV of the CF Sum of benefits NPV Inputs and Assumptions used Final Calculations All in hourly cost NPV Hours per month IRR Value of New customer # sales people Payback Customers per sales Decision: Label 6 Required return per month Use and change these as needed Other supporting calculations 20 Q1 Q2 Q3 Q4 Q5 + Ready EO Accessibility: Investigate 80% 85F Q Search W 9:56 AM 7/3/2023 3 Mostly sunny