PRINCIPLES OF FINANCIAL ANALYSIS, CHAPTER 4 PROBLEM

EXTRA CREDIT ASSIGNMENT: Podrasky Corporation

1. Retrieve the file CFM0406P.XLS and enter the appropriate

equation for cell B44 that specifically includes cells

B21, B30, and B41.

2. Enter the appropriate equations, not values, into cells B19,

B21, B30, and B41.

3. Enter the appropriate numerical values in cells B7, B12, B13,

B14, B28, B37, B39, B46, and B48.

4. The solution to the Podrasky Corporation problem requires that

the additional debt and/or equity financing value be inserted

in cell B35. Enter the required value in cell B35 by referring

to the information provided in cells B21, B30, B37, B39, B41,

B46, and B48. (Hint: The value computed in cell B41 enables

verification of the change in cash.)

5. Save the worksheet

.

PODRASKY CORPORATION STATEMENT OF CASH FLOWS (Indirect Method) CASH FLOWS FROM OPERATING NCTIVITIES Net income Reconciliation of net income to net cash provided by operating activities: . Depreciation Accounts receivable Inventories Accounts payable Other current liabilitlen Deferred income taxes Total adjustments Net cash provided from (used by) operating activities CASH FLOWS FROM INVESTING NCTIVITIES Proceeds from sale of assets Capital expenditures Net cash provided from (used by) investing activities CASH FLONS FROM FINANCING ACTIVITIES Proceeds from issuance of debt and/or equity Repayments of debt Dividends paid Net cash provided from (used by) financing activities Net Increase (Decrease) in Cash Cash, Beginning of Year Cash, End of Year PODRASKY CORPORATION STATEMENT OF CASH FLOWS (Indirect Method) CASH FLOWS FROM OPERATING NCTIVITIES Net income Reconciliation of net income to net cash provided by operating activities: . Depreciation Accounts receivable Inventories Accounts payable Other current liabilitlen Deferred income taxes Total adjustments Net cash provided from (used by) operating activities CASH FLOWS FROM INVESTING NCTIVITIES Proceeds from sale of assets Capital expenditures Net cash provided from (used by) investing activities CASH FLONS FROM FINANCING ACTIVITIES Proceeds from issuance of debt and/or equity Repayments of debt Dividends paid Net cash provided from (used by) financing activities Net Increase (Decrease) in Cash Cash, Beginning of Year Cash, End of Year