For a good rating, please provide the Excel formulas.

Problem Set 8 - Short-Term Finance 1. Apache's first quarter's 2019 financials are being prepared and the CFO wants you to use them to calculate days receivable, days inventory, operating cycle, days payable, and cash cycle for each of the three months of 1Q19. The financials are below: 1Q19 Income Statement (in M$) Jan Feb Mar Sales 123 131 144 Cost of Goods Sold 78 83 89 Gross Margin 45 48 55 Sales, General, and Admin. 12 13 12 Interest Expense 3 2 2 Taxable income 30 33 41 Taxes 6 7 9 Net Income 24 26 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 38 30 50 200 300 1,566 2,066 34 50 206 300 1.784 2,290 219 300 1,881 2,400 Prob. 1 Prob. 2 Mar. Mar. 1019 Income Statement (in MS) Jan. Feb. Sales Cost of goods sold Gross margin Sales, general & admin. Interest expense Taxable income Taxes Net income 1019 Balance Sheet (in MS) Jan. Feb. Cash Receivables Inventory Curr. Assets PP&E Total Assets Key Ratios Jan. Feb. Mar. Payables Notes Payable Accruals LTD Curr. Liabilities LTD Equity Total L&E Days Receivable Days Inventory Operating Cycle Days Payable Cash Cycle