View the step-by-step solution to:

A B C D E 2 1997 Actual 1998 Forecast 1998 Actual F Change Change 97 vs Forecast G H I J 97 vs Actual 3 Income Statement 4 Net Sales 1,555,800

hi can you check what happened to my Cash flow statement?
1997 Actual 1998 Forecast 1998 Actual Income Statement Net Sales 1,555,800 1,873,000 2,540,600 (317,200) (984,800) Cost of Goods Sold (COGS) 1,012,500 1,183,000 1,685,200 (170,500) (672,700) Gross Profit 543,300 690,000 855,400 (146,700) (312,100) Operating expenses 434,800 522,000 670,400 (87,200) (235,600) Operating Profit 108,500 168,000 185,000 (59,500) (76,500) Tax 52,000 80,000 89,300 (28,000) (37,300) Net Income 56,500 88,000 95,700 (31,500) (39,200) Dividend 30,000 45,000 45,000 (15,000) (15,000) Retained Earnings 26,500 43,000 50,700 (16,500) (24,200) Other relevant information Purchases 1,052,000 1,217,000 1,924,500 (165,000) (872,500) Depreciation 2,600 5,000 5,500 (2,400) (2,900) Balance Sheet Current Assets Cash & Equivalents 83,700 40,000 42,700 43,700 41,000 Receivables 198,100 228,000 278,200 (29,900) (80,100) Inventories 265,300 300,000 504,600 (34,700) (239,300) - Total Current Assets 547,100 568,000 825,500 (20,900) (278,400) Gross Fixed Assets 72,500 117,500 148,500 (45,000) (76,000) Accumulated Depreciation 31,500 16,500 17,000 15,000 14,500 Net Fixed Assets 41,000 101,000 131,500 (60,000) (90,500) Deferred Charges 10,000 12,000 12,300 (2,000) (2,300) Total Assets 598,100 681,000 969,300 Current Liabilities Accounts Payable 34,600 34,000 213,500 (600) 178,900 Accruals 7,100 5,000 11,900 (2,100) 4,800 Prov for tax 32,400 47,000 49,200 14,600 16,800 Short-term Debt - - 40,000 - 40,000 - Total Current Liabilities 74,100 86,000 314,600 11,900 240,500 Long-term Debt - 28,000 80,000 28,000 80,000 Total Liabilities 74,100 114,000 394,600 39,900 320,500 Shareholders' Equity Common Stock 180,000 180,000 180,000 - - Retained Earnings 344,000 387,000 394,700 43,000 50,700 Total Shareholders Equity 524,000 574,700 574,700 50,700 50,700 Total Liab. & Share. Equity 598,100 681,000 969,300 Receivables turnover Surplus (Shortfall) - - - _______S_a_le_s_______ Accounts receivable Ratios Receivables turnover 7.9 8.2 9.1 * = Sales / Account Receivable Days sales outstanding 46.5 44.4 40.0 Payables turnover 30.4 35.8 9.0 Days payables outstanding 12.0 10.2 40.5 * = 365 days / Payable Turnover Inventory turnover 3.8 3.9 3.3 * = COGS / Inventory Day inventories 95.6 92.6 109.3 * = 365 days / Inventory Turnover Fixed assets turnover 37.9 18.5 19.3 * = Sales / Net Fixed Assets NWC turnover 3.3 3.9 5.0 * = Sales / NWC = Sales / (CA - CL) Gross margin 34.9% 36.8% 33.7% * = [Revenue - COGS] / Revenue Operating margin 7.0% 9.0% 7.3% * = Operating Income / Net Sales Net profit margin 3.6% 4.7% 3.8% * = Net Income / Net Sales For proforma statements COGS/Sales 65.1% 63.2% 66.3% Operating expense/Sales 27.9% 27.9% 26.4% Purchases/COGS 103.9% 102.9% 114.2% Tax/Operating Profit 47.9% 47.6% 48.3% 97 vs Forecast 97 vs Actual Change 97 vs Forecast Change 97 vs Actual * = 365 days / Receivable Turnover * = purchase / Account Payable A B C D E F G H I J K L M N 2 3 4 5 6 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 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74
Background image of page 1
Statement of Cash Flow 1998 Forecast 1998 Actual Net Income 88,000 95,700 Depreciation 5,000 5,500 Working capital (32,800) (518,900) Receivables (29,900) (80,100) Inventory (34,700) (239,300) Accounts payable (600) 178,900 Accruals (2,100) 4,800 Prov Income Tax 14,600 16,800 Cash Flow from Operations 136,700 621,100 Fixed Assets (60,000) (90,500) Deferred Charges (2,000) (2,300) Cash Flow from Investments (62,000) (92,800) Bank Loan 28,000 80,000 Dividend 45,000 45,000 Cash Flow from Financing (17,000) 35,000 Total Cash Flow 57,700 563,300 Beginning Cash 83,700 83,700 Ending cash 40,000 42,700 Change in Cash (43,700) (41,000) A B C 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25
Background image of page 2

Recently Asked Questions

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question