Problem 2-32 Spreadsheet Problem: Statement of Cash Flows (LG2-5)

Use the balance sheet and income statement below:

VALIUMS MEDICAL SUPPLY CORPORATION
Balance Sheet as of December 31, 2024 and 2023
(in millions of dollars)
Assets	2024	2023	Liabilities and Equity	2024	2023
Current assets:			Current liabilities:
Cash and marketable securities	$ 71	$ 70	Accrued wages and taxes	$ 48	$ 40
Accounts receivable	195	180	Accounts payable	150	140
Inventory	320	290	Notes payable	130	130
Total	$ 586	$ 540	Total	$ 328	$ 310
Fixed assets:			Long-term debt	$ 576	$ 554
Gross plant and equipment	$ 1,070	$ 880	Stockholders equity:
Less: Accumulated depreciation	144	112	Preferred stock (6 thousand shares)	$ 6	$ 6
Net plant and equipment	$ 926	$ 768	Common stock and paid-in surplus (100 thousand shares)	120	120
Other long-term assets	132	132	Retained earnings	614	450
Total	$ 1,058	$ 900	Total	$ 740	$ 576
Total assets	$ 1,644	$ 1,440	Total liabilities and equity	$ 1,644	$ 1,440

VALIUMS MEDICAL SUPPLY CORPORATION
Income Statement for Years Ending December 31, 2024 and 2023
(in millions of dollars)
	2024	2023
Net sales	$ 890	$ 800
Less: Cost of goods sold	388	351
Gross profits	$ 502	$ 449
Less: Other operating expenses	46	40
Earnings before interest, taxes, depreciation, and amortization (EBITDA)	$ 456	$ 409
Less: Accumulated depreciation	32	30
Earnings before interest and taxes (EBIT)	$ 424	$ 379
Less: Interest	47	41
Earnings before taxes (EBT)	$ 377	$ 338
Less: Taxes	79	71
Net income	$ 298	$ 267
Less: Preferred stock dividends	$ 6	$ 6
Net income available to common stockholders	$ 292	$ 261
Less: Common stock dividends	128	128
Addition to retained earnings	$ 164	$ 133
Per (common) share data:
Earnings per share (EPS)	$ 2.92	$ 2.61
Dividends per share (DPS)	$ 1.28	$ 1.28
Book value per share (BVPS)	$ 7.34	$ 5.70
Market value (price) per share (MVPS)	$ 8.37	$ 6.18

Prepare a statement of cash flows for Valiums Medical Supply Corporation.

Note: Enter your answers in millions of dollars. Amounts to be deducted should be indicated with a minus sign.

Statement of Cash Flows for Year Ending December 31, 2024
(in millions of dollars)
Cash flows from operating activities
Additions (sources of cash):
Subtractions (uses of cash):
Net cash flow from operating activities
Cash flows from investing activities
Subtractions:
Net cash flow from investing activities
Cash flows from financing activities
Additions:
Subtractions:
Net cash flow from financing activities
Net change in cash and marketable securities

*Please fill in all blanks for statement of cash flows.