Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Please post all Excel formulas.
image text in transcribed
image text in transcribed
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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions

Question

Did you write a special beginning that makes the reader want more?

Answered: 1 week ago

Question

5. If yes, then why?

Answered: 1 week ago

Question

6. How would you design your ideal position?

Answered: 1 week ago