Question

In: Finance

Balance Sheets (in millions of dollars) 2020 2019 Assets Cash and cash equivalents $600 $495 Accounts...

Balance Sheets (in millions of dollars)	2020	2019
*Assets*
Cash and cash equivalents	$600	$495
Accounts receivable	$626	$525
Inventories	$285	$240
Total current assets	$1,511	$1,260
Net fixed assets	$1,590	$1,470
Total assets	$3,101	$2,730
*Liabilities and equity*
Accounts payable	$248	$195
Accruals	$195	$180
Notes payable	$189	$195
Total current liabilities	$632	$570
Long-term debt	$356	$300
Total liabilities	$987	$870
Common stock	$570	$570
Retained Earnings	$1,544	$1,290
Total common equity	$2,114	$1,860
Total liabilities and equity	$3,101	$2,730

Use the amounts you calculated for the 2020 income statement as needed.

Income Statements (in millions of dollars)	2020	2019
Sales		$2,376
Costs+Exp excl. D&A		$1,782
EBITDA		$594
Depr. & amort.		$90
EBIT		$504
Interest expense		$60
EBT		$444
Taxes		$120
Net Income		$324

1.What is the Cash from Operating Activities in 2020 ($millions)?

2.What is the Cash from Investing Activities in 2020 ($millions)?

3.What are the Dividends in 2020 ($millions)?

4.What is the Net Change in Cash in 2020 ($millions)?

5.Calculate the Free Cash Flow. What is the Change in Net Operating Working Capital in 2020 ($millions)?

6.What is the Free Cash Flow in 2020 ($millions)?

Expert Solution

Tutorial Note :

1. There is a mistake in the Problem. For the year 2020 the summation of the figures provided in Total Liabilities is wrong. As per the given data the total liabilities should have been $988 millions (i.e., $632+$356). However, the total provided in the problem is $987 millions. Therefore, we are going to solve the question assuming the figure of Long term debt as $355 instead of $356.

2. We are going to make the Cash Flow Statement irst and then we will find out the required answers to questions asked in the problem.

Cash Flow Statement for the year 2020

A : Cash from Operating Activities in 2020 ($millions) :

Net Income after tax 324
Less: Tax paid    120
EBT      444
Add: Interest Paid       60
EBIT 504
Add: Depreciation & Amortisation     90
Operating Cash Flow before changes in working Capital    594

Add: Increase in Total Current Liabilities
- Accounts Payable [248-195]     53
- Accruals [195-180]     15
Add: Decrease in Current Assets   Nil

Less: Increase in Current Assets (excluding Cash & Cash Equivalent)
- Accounts Receivables [626-525] (101)
   - Inventories [285-240]   (45)
Less: Decrease in Current Liabilities
- Notes Payable [189-195]      (6)
Change in Net Operating Working Capital (Part-5) (84)
510
Less: Income Tax (120)
Cash Generated from Operating Activities    (A) (Part-1)    390

B : Cash from Investing Activities in 2020 ($millions)

Purchase of Fixed Assets [1590-1270] (120)
Cash outflow due to Investing Activities (B) (Part-2) (120)

C : Cash from Financing Activities in 2020 ($millions)

Receipt of Long term Debt [355-300]   55
Dividend paid (Balancing Figure)    (Part-3)    (220)
Cash flow from Financing Activities (Refer Working Note-1) (C)   (165)

Net Change in Cash in 2020 (Part-4) 105

Working Note-1 : Computation of Cash Flow from Financing Activities

From Part-4 of our answer we can see that the Net change in Cash flow during 2020 shall be $105 millions

Again, From the above statement we have found following data-
Cash flow from Operating Acitivities $390 millions
Cash flow from Investing Activities ($120) millions

Therefore, the Cash generated from Financing Activities shall be result in such an amount that would make the Net Change in Cash Flow as $105 millions.

Hence, Cash Flow from Financing Activities would be ($165) millions [$105 - $390-($120) ]

Therefore,

Part-1 : Cash from Operating Activities in 2020 = $390 millions

Part-2 : Cash from Investing Activities in 2020 = ($120) millions

Part-3 : Dividends paid during the year 2020 = $165 millions

Part-4 : Net Change in Cash
= Closing Cash Balance - Opening Cash Balance = $600 - $495 = $105

Part-5 : Change in Net Operating Working Capital in 2020 = ($84) millions

Part-6 : Free Cash Flow in 2020

To find out Free cash flow we have to add non cash expenses with Net Income
Hence, Free Cash Flow = Net Income + Depreciation & Amortisation = $324 + $90 = $414 millions

jeff jeffy answered 1 year ago

Balance Sheets Assets 2019 2018 Cash and equivalents $100 $85 Accounts receivable 275 300 Inventories 375 ...

Balance Sheets Assets 2019 2018 Cash and equivalents $100 $85 Accounts receivable 275 300 Inventories 375 250 Total current assets $750 $635 Net plant and equipment 2,300 1,490 Total assets $3,050 $2,125 Liabilities and Equity Accounts payable $150 $85 Accruals 75 50 Notes payable 150 75 Total current liabilities $375 $210 Long-term debt 450 290 Total liabilities 825 500 Common stock 1,225 1,225 Retained earnings 1,000 400 Common equity 2,225 1,625 Total liabilities and equity $3,050 $2,125 Income Statements 2019...

Assets 2019 2018 Amount Cash & equivalents $20,000.00 Cash & equivalents $10,000.00 Accounts Receivable $15,000.00 Accounts...

Assets 2019 2018 Amount Cash & equivalents $20,000.00 Cash & equivalents $10,000.00 Accounts Receivable $15,000.00 Accounts Receivable $25,000.00 Inventory $10,000.00 Inventory $15,000.00 Total current assets $45,000.00 Total current assets $50,000.00 Net Plant and equipment $50,000.00 Net Plant and equipment $60,000.00 Total assets $95,000.00 Total assets $110,000.00 Liabilities and equity Liabilities and equity Accounts payable $5,000.00 Accounts payable $7,000.00 Accruals $2,000.00 Accruals $3,000.00 Notes payable $10,000.00 Notes payable $5,000.00 Total current liabilities $17,000.00 Total current liabilities $15,000.00 Long term debts $25,000.00...

Aires Corporation Comparative Balance Sheets December 31, 2020 and 2019 Assets 2020 2019 Change Cash $...

Aires Corporation Comparative Balance Sheets December 31, 2020 and 2019 Assets 2020 2019 Change Cash $ 21,000 $ 54,000 Accounts receivable (net) 421,000 480,000 Inventory 310,000 340,000 Prepaid expenses 17,000 15,000 Long Term Investments 70,000 80,000 Land 400,000 300,000 Equipment 1,730,000 1,590,000 Accumulated depreciation-equipment (610,000) (600,000) Patent 40,000 50,000 Total assets $2,399,000 $2,309,000 Liabilities Accounts payable $ 328,000 $ 335,000 Accrued liabilities 171,000 170,000 Income taxes payable 22,000 34,000 Bonds payable 410,000 700,000 Long-term note payable 130,000 0 Total liabilities...

Windsor, Inc. Comparative Balance Sheets December 31 Assets 2020 2019 Cash $36,000 $21,000 Accounts receivable 32,700...

Windsor, Inc. Comparative Balance Sheets December 31 Assets 2020 2019 Cash $36,000 $21,000 Accounts receivable 32,700 18,900 Inventory 30,100 20,100 Equipment 59,600 77,600 Accumulated depreciation—equipment (29,400 ) (23,300 ) Total $129,000 $114,300 Liabilities and Stockholders’ Equity Accounts payable $28,000 $16,800 Income taxes payable 7,200 8,400 Bonds payable 26,700 32,100 Common stock 17,700 13,400 Retained earnings 49,400 43,600 Total $129,000 $114,300 Windsor, Inc. Income Statement For the Year Ended December 31, 2020 Sales revenue $242,500 Cost of goods sold 175,200 Gross...

Balance Sheet For LMN Corporation Year ended: 2019 2018 Assets Cash and equivalents $320 $295 Accounts...

Balance Sheet For LMN Corporation Year ended: 2019 2018 Assets Cash and equivalents $320 $295 Accounts receivable 750 660 Inventories 560 480 Total current assets 1,630 1,435 Gross fixed assets 3,275 2,700 Accumulated depreciation (1,200) (900) Net fixed assets 2,075 1,800 Total assets $3,705 $3,235 Liabilities and shareholders’ equity Accounts payable $390 $370 Notes payable 250 240 Accrued taxes and expenses 180 140 Total current liabilities 820 750 Long-term debt 1,200 1,108 Total long-term debt 1,200 1,108 Common stock 505...

Joshua & White Technology: December 31 Balance Sheets (Thousands of Dollars) 2019 2018 Assets Cash $...

Joshua & White Technology: December 31 Balance Sheets (Thousands of Dollars) 2019 2018 Assets Cash $ 21,000 $ 20,000 Short-term investments 3,759 3,240 Accounts receivable 52,500 48,000 Inventories 84,000 56,000 Total current assets $161,259 $127,240 Net fixed assets 223,097 200,000 Total assets $384,356 $327,240 Liabilities and Equity Accounts payable $ 33,600 $ 32,000 Accruals 12,600 12,000 Notes payable 19,929 6,480 Total current liabilities $ 66,129 $ 50,480 Long-term debt ...

WIPER INC. Condensed Balance Sheets December 31, 2020, 2019, 2018 (in millions) 2020 2019 2018 Current...

WIPER INC. Condensed Balance Sheets December 31, 2020, 2019, 2018 (in millions) 2020 2019 2018 Current assets $ 681 $ 906 $ 753 Other assets 2,415 1,922 1,721 Total assets $ 3,096 $ 2,828 $ 2,474 Current liabilities $ 566 $ 805 $ 712 Long-term liabilities 1,521 995 842 Stockholders’ equity 1,009 1,028 920 Total liabilities and stockholders' equity $ 3,096 $ 2,828 $ 2,474 WIPER INC. Selected Income Statement and Other Data For the year Ended December 31, 2020...

ARDUOUS COMPANY Comparative Balance Sheets December 31, 2021 and 2020 ($ in millions) 2021 2020 Assets...

ARDUOUS COMPANY Comparative Balance Sheets December 31, 2021 and 2020 ($ in millions) 2021 2020 Assets Cash $ 109 $ 81 Accounts receivable 190 194 Investment revenue receivable 6 4 Inventory 205 200 Prepaid insurance 4 8 Long-term investment 156 125 Land 196 150 Buildings and equipment 412 400 Less: Accumulated depreciation (97 ) (120 ) Patent 30 32 $ 1,211 $ 1,074 Liabilities Accounts payable $ 50 $ 65 Salaries payable 6 11 Interest payable (bonds) 8 4 Income...

Rowan Company Comparative Balance Sheet (dollars in millions) Ending Balance Beginning Balance Assets Current assets: ?Cash...

Rowan Company Comparative Balance Sheet (dollars in millions) Ending Balance Beginning Balance Assets Current assets: ?Cash and cash equivalents $70 $91 ?Accounts receivable 536 572 ?Inventory ??620 ??580 Total current assets ?1,226 ?1,243 Property, plant, and equipment 1,719 1,656 ?Less accumulated depreciation ??640 ??480 Net property, plant, and equipment ?1,079 ?1,176 Total assets $2,305 $2,419 Liabilities and Stockholders’ Equity Current liabilities: ?Accounts payable $205 $180 ?Accrued liabilities 94 105 ?Income taxes payable ???72 ???88 Total current liabilities 371 373 Bonds...

PHAROAH COMPANY Balance Sheets December 31 (in thousands) 2022 2021 Current assets Cash and cash equivalents...

PHAROAH COMPANY Balance Sheets December 31 (in thousands) 2022 2021 Current assets Cash and cash equivalents $330 $360 Accounts receivable (net) 570 500 Inventory 640 570 Prepaid expenses 130 160 Total current assets 1,670 1,590 Property, plant, and equipment (net) 410 380 Investments 110 110 Intangibles and other assets 530 510 Total assets $2,720 $2,590 Current liabilities $920 $890 Long-term liabilities 660 560 Stockholders’ equity—common 1,140 1,140 Total liabilities and stockholders’ equity $2,720 $2,590 PHAROAH COMPANY Income Statements For the...