Please show all Excel formulas.

Background information:

2. Apache sells maintenance services to various private jet operators. For these, Apache's demands payment within 30 days. Apache is considering changing this policy to 1/5, net 30. What is the implicit effective annual rate in this payment policy? a) Effective Annual Rate (EAR) Notional purchase Discount (%) Days difference Discount ($) Rate (%) Days difference in 1 year EAR 1Q19 Income Statement (in M$) Sales Cost of Goods Sold Gross Margin Sales, General, and Admin Interest Expense Taxable income Taxes Net Income Jan 123 78 45 12 3 30 6 24 Feb 131 83 48 13 2 33 7 26 Mar 144 89 55 12 2 41 9 32 1Q19 Balance Sheet (in M$) Jan 625 160 105 890 1,176 2,066 120 Feb 814 177 123 1,114 1,176 2,290 122 Mar 900 200 124 1.224 1,176 2,400 131 Cash Receivables Inventory Current Assets PP&E Total Assets Payables Notes Payable Accruals LTD Current Liabilities LTD Equity Total L&E 30 50 200 300 1,566 2,066 34 50 206 300 1.784 2,290 38 50 219 300 1,881 2,400 Mar. 2 3 4 5 123 131 1919 Income Statement in M$) lan. Feb Sales Cost of Goods Sold 78 83 Gross Margin 45 48 Sales, general & admin 12 13 Interest expense 3 2 Taxable income 30 33 Taxes 6 7 Net Income 24 26 Cash Receivbles Inventory 89 55 12 2 41 9 32 1919 Balance Sheet (in MS) Jan. Feb. 625 814 160 177 105 123 Curr. Assets 890 1114 1176 1176 2066 2290 Mar 900 200 124 1224 1176 2400 PP&E Total Assets Key Ratios Jan. 40.33 41.73 82.06 47.69 34.36 Payables Accruals LTD Curr. Liabilities LTD Equity Total L&E Feb 37.83 41.49 79.33 41.16 38.17 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 1201 30 SO 200 300 1566 2066 Mar. 43.06 43.19 86.25 45.63 40.621 122 34 SO 206 300 1784 2290 Days Receivable Days Inventory Operating Cycle Days Payable Cash Cycle 131 38 so 219 300 1881 2400 Key Ratios (Excel Formulas Ref.) Jan. Feb Mar Days Receivable(a) (H5/04)*31 (05/D4)*28 (5/E4)31 Days Inventory (b) (H6/C5)*31 (16/05)*28 06/E5) "31 Operating Cycle a+b a.b ab Days Payable) H11/0531 (11/05) 2011/05) 31 Cash Cycle a+b+c a+b+c a+b+c Formulas. Days Receivable - (Receivable / Sales) Days in a period. Days inventory Inventory/Cost of Slaes) Days in a period. Operating Cycle Days Receivable + Days inventory Days Payable = (Payable / Cost of Slaes) Days in a period. Cash Cycle = Operating Cycle-Days Payable. Note: Days in Jan. & Mar. are 31 days and Feb. are 28 days in 2019. Note: Please Comment down for any further clarifications