Question: Please post all Excel formulas. Prob. 1 Prob. 2 Mar. Mar. 1019 Income Statement (in MS) Jan. Feb. Sales Cost of goods sold Gross margin

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 1919 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 Mar 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 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 Taxable income 30 33 41 Taxes 6 7 Net Income 24 26 2 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
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
