Consider the following balance sheets for the Philippe Corporation. Calculate the changes in the various accounts and, where applicable, identify the change as a source or use of cash. What were the major sources and uses of cash? Did the company become more or less liquid during the year? What

Question

Consider the following balance sheets for the Philippe Corporation. Calculate the changes in the various accounts and, where applicable, identify the change as a source or use of cash. What were the major sources and uses of cash? Did the company become more or less liquid during the year? What happened to cash during the year?

PHILIPPE CORPORATION Balance Sheets as of December 31, 2001 and 2002 ($ in millions)
	2001	2002
Assets
Current assets
Cash	$210	$215
Accounts receivable	355	310
Inventory	[latex] \underline{507} [/latex]	[latex] \underline{328}[/latex]
Total	[latex] \underline{\underline{\$1,072}}[/latex]	[latex] \underline{\underline{\$853}} [/latex]
Fixed assets
Net plant and equipment	[latex] \underline{\$6,085} [/latex]	[latex] \underline{\$6,527}[/latex]
Total assets	[latex] \underline{\$7,157} [/latex]	[latex] \underline{\$7,380} [/latex]
Liabilities and Owners’ Equity
Current liabilities
Accounts payable	$207	$298
Notes payable	[latex] \underline{1,715} [/latex]	[latex] \underline{1,427} [/latex]
Total	[latex] \underline{\$1,922} [/latex]	[latex] \underline{\$1,725} [/latex]
Long-term debt	[latex] \underline{\underline{\$1,987}} [/latex]	[latex] \underline{\underline{\$2,308}} [/latex]
Owners’ equity
Common stock and paid-in surplus	$1,000	$1,000
Retained earnings	[latex] \underline{2,248} [/latex]	[latex] \underline{2,347} [/latex]
Total	[latex] \underline{\$3,248} [/latex]	[latex] \underline{\$3,347} [/latex]
Total liabilities and owners’ equity	[latex] \underline{\underline{\$7,157}} [/latex]	[latex] \underline{\underline{\$7,380}} [/latex]

Accepted Answer

We’ve filled in the answers in the following table. Remember, increases in assets and decreases in liabilities indicate that we spent some cash. Decreases in assets and increases in liabilities are ways of getting cash.
Philippe used its cash primarily to purchase fixed assets and to pay off short-term debt. The major sources of cash to do this were additional long-term borrowing, reductions in current assets, and additions to retained earnings.

PHILIPPE CORPORATION Balance Sheets as of December 31, 2001 and 2002 ($ in millions)
	2001	2002	Change	Source or Use of Cash
Assets
Current assets
Cash	$210	$215	+$ 5
Accounts receivable	355	310	- 45	Source
Inventory	[latex] \underline{507} [/latex]	[latex] \underline{328}[/latex]	[latex] \underline{ - 179} [/latex]	Source
Total	[latex] \underline{\underline{\$1,072}} [/latex]	[latex] \underline{\underline{\$853}} [/latex]	[latex] \underline{\underline{-\$219}} [/latex]
Fixed assets
Net plant and equipment	[latex] \underline{\$6,085} [/latex]	[latex] \underline{\$6,527}[/latex]	[latex] \underline{+\$442}[/latex]	Use
Total assets	[latex] \underline{\$7,157} [/latex]	[latex] \underline{\$7,380} [/latex]	[latex] \underline{+\$223}[/latex]
Liabilities and Owners’ Equity
Current liabilities
Accounts payable	$207	$298	+$ 91	Source
Notes payable	[latex] \underline{1,715} [/latex]	[latex] \underline{1,427} [/latex]	[latex] \underline{-288}[/latex]	Use
Total	[latex] \underline{\$1,922} [/latex]	[latex] \underline{\$1,725} [/latex]	[latex] \underline{-\$197}[/latex]
Long-term debt	[latex] \underline{ \underline{\$1,987}} [/latex]	[latex] \underline{ \underline{\$2,308}} [/latex]	[latex] \underline{ \underline{+\$321}} [/latex]	Source
Owners’ equity
Common stock and paid-in surplus	$1,000	$1,000	+$ 0	-
Retained earnings	[latex] \underline{2,248} [/latex]	[latex] \underline{2,347} [/latex]	[latex] \underline{+ 99} [/latex]	Source
Total	[latex] \underline{\$3,248} [/latex]	[latex] \underline{\$3,347} [/latex]	[latex] \underline{+\$ 99} [/latex]
Total liabilities and owners’ equity	[latex] \underline{\underline{\$7,157}} [/latex]	[latex] \underline{\underline{\$7,380}} [/latex]	[latex] \underline{\underline{+\$223}} [/latex]

The current ratio went from $1,072/1,922 = .56 to $853/1,725 = .49, so the firm’s liquidity appears to have declined somewhat. Overall, however, the amount of cash on hand increased by $5.

Question 3CRS-TP1: Consider the following balance sheets for the Philippe Corpo...

Related Answered Questions

Based on the balance sheets and income statement in the previous two problems, calculate the following ratios for 2002: ...

Verified Answer:

Below is the most recent income statement for Philippe. Prepare a common-size income statement based on this information. How do you interpret the standardized net income? What percentage of sales goes to cost of goods sold? ...

Verified Answer:

Calculate the 2002 ROE for the Philippe Corporation and then break down your answer into its component parts using the Du Pont identity. ...

Verified Answer:

Take a look at the most recent numbers reported for Sales/Receivables and EBIT/Interest in Table 3.11. What are the overall median values? What are these ratios? ...

Verified Answer:

Because ROE and ROA are usually intended to measure performance over a prior period, it makes a certain amount of sense to base them on average equity and average assets, respectively. For Prufrock, how would you calculate these? ...

Verified Answer:

Suppose you find that a particular company generates $.40 in sales for every dollar in total assets. How often does this company turn over its total assets? ...

Verified Answer:

Here is a variation on the receivables collection period. How long, on average, does it take for Prufrock Corporation to pay its bills? To answer, we need to calculate the accounts payable turnover rate using cost of goods sold. We will assume that Prufrock purchases everything on credit. ...

Verified Answer:

Suppose a firm pays off some of its suppliers and short-term creditors. What happens to the current ratio? Suppose a firm buys some inventory. What happens in this case? What happens if a firm sells some merchandise? ...

Verified Answer: