34 35 36 37 38 39 40 1 2 3 4 5 AutoSave OFF In A24 Home Insert Draw Page Layout Formulas Data Default P Keep Exit X Units On AIR (in Market) Expected Demand 24 Opening Cash Balance 25 26 27 28 29 30 31 32 6 HW Revenue per unit 7 Avg Service Revenue per unit 8 Avg Contract tenure 9 HW Cost per unit New Options 10 Avg Service Cost 11 Avg Supply per month (units) 12 Advance paid for Units in FY'23 13 Total Advance paid 14 Outstanding AR as of Dec'22 15 Avg Credit period 16 Outstanding AP as of Dec'22 17 Avg period of payment 18 Deferred Revenue as of Dec'22 19 Deferred Cost as of Dec 22 20 Tax rate 21 Capital Infusion - Mar 23 22 Opex other expense per Month 23 Depreciation in Opex expenses Task fx Opening Cash Balance Data - Inputs + Normal Page Break Page Custom Preview Layout Views $ $ $ $ $ $ $ $ $ $ $ $ B Dec-22 25,000 250 30.00 150 10.00 2,500 20% 36 months 30 days Review 25,00,000 18,75,000 40% 80,00,000 7,50,000 80,000 5,00,00,000 C Jan-23 View Ruler Gridlines 27,000 2,000 Automate Formula Bar Headings D Feb-23 29,000 2,000 9,00,000 10,00,000 assume to be paid equally in next two months 60 Days 5,00,000 assume to be paid equally in next month E Tell me Mar-23 31,000 2,000 Task to be Completed 1 Prepare the PNL in columns based on the provided information 2 Create a brief MIS showing key metrics with commentary 3 List out your observations & recommendations FP&A Case Study Zoom 110% 100 Zoom to 100% F Apr-23 33,500 2,500 R&D Sales HO Zoom to Selection G Existing Headcount Leadership Marketing R&D Sales May-23 New Window 36,000 2,500 Expected Hike for 2023 Additional HC expected to be added Head of Finance. HH Arrange Freeze Freeze Freeze First All Panes Top Row Column Marketing manager Head of R&D Benefits on the base salary for new employee FTE Cost per month as of Dec'22 inclusive of benefits Leadership Marketing $ $ $ H $ Jun-23 38,500 2.500 Dec-22 2 15 37 45 99 35,000 15,000 16,000 17.000 Month Mar 23 June 23 Mar 23 8% 40% T Jul-23 41,500 3,000 Base Salary $ 3,00,000 $ 1,50,000 $ 3,00,000 J Aug-23 44,500 3,000 Split Hide Switch Unhide Windows K Sept-23 47,500 3,000 L Oct-23 50,500 3,000 View Record Use Relative Macros Macro References Background 1 Business Background - XYZ is a SaaS company, On the particular sale (1 Unit), it has two component, I.e. sale of Hardware(HW) and secondly a monthly charge(Service Revenue) to the customer 2 Accounting Background - As per ASC 606, HW is amortized over the contract tenure. For simplicity all the contracts are assumed to be standard 36 months 3 Hikes for the employees are effective Jan'23 M Comments -- Nov-23 53,500 3,000 N Dec-23 56,500 3,000

task to be done is mentioned in the end.

background is also mentioned in the end.

appropriate assumptions can be taken

Task to be Completed 1 Prepare the PNL in columns based on the provided information 2 Create a brief MIS showing key metrics with commentary 3 List out your observations & recommendations Background 2 Accounting Background - As per ASC 606,1+W is amortized over the contract tenure. For simplicity all the contracts are assumed to be standard 36 months 3 Hikes for the employees are effective Jan'23 Task to be Completed 1 Prepare the PNL in columns based on the provided information 2 Create a brief MIS showing key metrics with commentary 3 List out your observations & recommendations Background 2 Accounting Background - As per ASC 606, HW is amortized over the contract tenure. For simplicity all the contracts are assumed to be standard 36 months 3 Hikes for the employees are effective Jan'23 Task to be Completed 1 Prepare the PNL in columns based on the provided information 2 Create a brief MIS showing key metrics with commentary 3 List out your observations & recommendations Background 2 Accounting Background - As per ASC 606,1+W is amortized over the contract tenure. For simplicity all the contracts are assumed to be standard 36 months 3 Hikes for the employees are effective Jan'23 Task to be Completed 1 Prepare the PNL in columns based on the provided information 2 Create a brief MIS showing key metrics with commentary 3 List out your observations & recommendations Background 2 Accounting Background - As per ASC 606, HW is amortized over the contract tenure. For simplicity all the contracts are assumed to be standard 36 months 3 Hikes for the employees are effective Jan'23