Default H28 Keep Exit 4 X fx 1 2 3 Units On AIR (in Market) 4 Expected Demand 5 6 7 8 9 HW Cost per unit 10 Avg Service Cost New Options HW Revenue per unit Avg Service Revenue per unit Avg Contract tenure 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 24 Opening Cash Balance 25 26 27 28 29 30 31 32 33 Task A Data - Inputs + Normal Page Break Page Custom Preview Layout Views oboro Bacto $ $ $ $ $ ss $ $ $ $ $ $ $ $ B Dec-22 Ruler 25,000 250 30.00 150 10.00 2,500 20% Formula Bar Gridlines Headings 36 months 80,00,000 7,50,000 80,000 C Jan-23 5,00,00,000 27,000 2,000 D Zoom 130% 100 Zoom to 100% 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 30 days $25,00,000 18,75,000 40% E 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 Zoom to Selection F Apr-23 33,500 2,500 New Window R&D Sales Arrange Freeze Freeze Freeze First All Panes Top Row Column Existing Headcount Leadership Marketing R&D Sales G May-23 36,000 2,500 Marketing manager Head of R&D Expected Hike for 2023 Additional HC expected to be added Head of Finance Benefits on the base salary for new employee FTE Cost per month as of Dec'22 inclusive of benefits Leadership 35,000 Marketing 15,000 16,000 17,000 $ S $ S H Month Mar 23 June 23 Mar 23 Split Hide Unnide Windows Switch Jun-23 38,500 2,500 i Dec-22 2 15 37 45 99 8% 40% 0 Jul-23 41,500 3,000 Base Salary $3,00,000 $ 1,50,000 $ 3,00,000 View Record Use Relative Macros Macro References J Comments Aug-23 44,500 3,000 K Sept-23 47,500 3,000 Q OD Share L Oct-23 50,500 3,000 + 130%

in this we have to build a P&l statement from the given information.

let me know which part you are not understanding