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
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 1Q19 Balance Sheet (in MS) Jan. Feb. Cash Receivables Inventory Curr. Assets PP&E Total Assets Key Ratios Feb. Mar. Payables Notes Payable Accruals LTD Curr. Liabilities LTD Equity Total L&E Days Receivable Days Inventory Operating Cycle Days Payable Cash Cycle 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 1019. The financials are below. 1919 Income Statement (in M$) Jan Feb Mar Sales 123 131 Cost of Goods Sold 78 89 Gross Margin 45 48 55 Sales, General, and Admin 12 13 12 Interest Expense 3 2 Taxable income 30 41 Taxes 6 7 9 Net Income 24 26 32 2 1019 Balance Sheet (in MS) 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 1566 2,066 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

Recommended Textbook for

Personal Finance

Authors: Jeff Madura

3rd Edition

0321357973, 978-0321357977

More Books

Students also viewed these Finance questions