Home / Expert Answers / Finance / problem-2-32-spreadsheet-problem-statement-of-cash-flows-lg2-5-use-the-balance-sheet-and-income-s-pa223

(Solved): Problem 2-32 Spreadsheet Problem: Statement of Cash Flows (LG2-5) Use the balance sheet and income s ...



Problem 2-32 Spreadsheet Problem: Statement of Cash Flows (LG2-5) Use the balance sheet and income statement below: VALIUM’S MEDICAL SUPPLY CORPORATIONBalance Sheet as of December 31, 2024 and 2023(in millions of dollars)Assets20242023Liabilities and Equity20242023Current assets: Current liabilities: Cash and marketable securities$ 71$ 70Accrued wages and taxes$ 48$ 40Accounts receivable195180Accounts payable150140Inventory320290Notes payable130130Total$ 586$ 540Total$ 328$ 310Fixed assets: Long-term debt$ 576$ 554Gross plant and equipment$ 1,070$ 880Stockholders’ equity: Less: Accumulated depreciation144112Preferred stock (6 thousand shares)$ 6$ 6Net plant and equipment$ 926$ 768Common stock and paid-in surplus (100 thousand shares)120120Other long-term assets132132Retained earnings614450Total$ 1,058$ 900Total$ 740$ 576Total assets$ 1,644$ 1,440Total liabilities and equity$ 1,644$ 1,440 VALIUM’S MEDICAL SUPPLY CORPORATIONIncome Statement for Years Ending December 31, 2024 and 2023(in millions of dollars) 20242023Net sales$ 890$ 800Less: Cost of goods sold388351Gross profits$ 502$ 449Less: Other operating expenses4640Earnings before interest, taxes, depreciation, and amortization (EBITDA)$ 456$ 409Less: Accumulated depreciation3230Earnings before interest and taxes (EBIT)$ 424$ 379Less: Interest4741Earnings before taxes (EBT)$ 377$ 338Less: Taxes7971Net income$ 298$ 267Less: Preferred stock dividends$ 6$ 6Net income available to common stockholders$ 292$ 261Less: Common stock dividends128128Addition to retained earnings$ 164$ 133Per (common) share data: Earnings per share (EPS)$ 2.92$ 2.61Dividends per share (DPS)$ 1.28$ 1.28Book value per share (BVPS)$ 7.34$ 5.70Market value (price) per share (MVPS)$ 8.37$ 6.18 Prepare a statement of cash flows for Valium’s Medical Supply Corporation. Note: Enter your answers in millions of dollars. Amounts to be deducted should be indicated with a minus sign.



We have an Answer from Expert

View Expert Answer

Expert Answer


We have an Answer from Expert

Buy This Answer $5

Place Order

We Provide Services Across The Globe