Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Analysis of Free Cash FlowsFrits Seegers Inc.: Review Exhibit P1.3 for Frits Seegers Inc. and measure the free cash flow for Seegers for Year 0

Analysis of Free Cash FlowsFrits Seegers Inc.: Review Exhibit P1.3 for Frits Seegers Inc. and measure the free cash flow for Seegers for Year 0 and six years of forecasts (Year +1 to Year +6) shown. The company does not hold any excess cash, so the change in the cash balance is equal to the change in required cash. The change in Retained Earnings in a year is equal to the company's net income minus the dividends declared by the company in that year. Discuss the major factors that caused the free cash flows to change from year to year.

image text in transcribed
FRITS SEEGERS INC. Income Statement and Balance Sheet Forecasts (for the years ended December 31) Actual Forecast Year -1 Year 0 Year Year 2 Year 3 Year 4 Year 5 Year 6 Income Statement Revenue . . . $1,000.0 $1, 100.0 $1,650.0 $2,310.0 $3,003.0 $3,303.3 $3,402.4 $3,504.5 Cost of goods sold. -610.0 -671.0 -1,006.5 -1,409.1 -1,831.8 -2,015.0 -2,075.5 -2,137.7 Gross margin . .. $ 390.0 $ 429.0 $ 643.5 $ 900.9 $1,171.2 $1,288.3 $1,326.9 $1,366.7 Selling, general & administrative -120.0 -132.0 -198.0 -277.2 -360.4 -396.4 -408.3 -420.5 Operating income. . .. $ 270.0 $ 297.0 $ 445.5 $ 623.7 $ 810.8 $ 891.9 $ 918.6 $ 946.2 Interest expense. . -77.0 -96.0 -112.0 -128.0 -136.0 -144.0 -152.0 -160.0 Income before taxes. 193.0 $ 201.0 $ 333.5 495.7 $ 674.8 $ 747.9 $ 766.6 $ 786.2 Income tax expense. . -77.2 -80.4 -133.4 -198.3 -269.9 -299.2 -306.7 -314.5 Net income . $ 115.8 $ 120.6 $ 200.1 $ 297.4 $ 404.9 $ 448. $ 460.0 $ 471.7 Balance Sheet Cash balance $ 50.0 $ 56.0 $ 82.5 $ 115.5 $ 150.2 $ 165.2 $ 170.1 $ 175.2 Accounts receivable. 166.7 183.3 275.0 385.0 500.5 550.6 567.1 584.1 Inventory. . . 118.6 130.5 195.7 274.0 356.2 391.8 403.6 415.7 Total current assets $ 335.3 $ 368.8 $ 553.2 $ 774.5 $1,006.8 $1,107.5 $1,140.7 $1,175.0 Land . . . 1,550.0 1,825.0 2,155.0 2,501.5 2.651.7 2,701.2 2,752.2 2,804.8 Total assets. $1,885.3 $2,193.8 $2,708.2 $3.276.0 $3,658.5 $3,808.7 $3,893.0 $3,979.8 Accounts payable. . . S 50.8 $ 55.9 $ 83.9 $ 117.4 $ 152.7 $ 167.9 $ 173.0 $ 178.1 Other current operating liabilities . . . 35.0 38.5 57.8 80.9 105.1 115.6 119.1 122.7 Total current liabilities. . . $ 85.8 $ 94.4 $ 141.6 $ 198.3 $ 257.8 $ 283.5 $ 292.0 $ 300.8 Debt .. 1,200.0 1,400.0 1,600.0 1,700.0 1,800.0 1,900.0 2,000.0 2,100.0 Total liabilities $1,285.8 $1,494.4 $1,741.6 $1,898.3 $2,057.8 $2,183.5 $2,292.0 $2,400.8 $ 383.6 $ 383.6 $ 450.7 $ 564.5 $ 564.5 $ 564.5 $ 564.5 $ 564.5 Common stock. . 315.7 1,036.5 1,014.5 Retained earnings 215.8 515.8 813.3 1,036.3 1,060.7 $1,579.0 Total shareholders equity . . . . . $ 599.4 $ 699.4 966.6 $1,377.7 $1,600.7 $1,625.2 $1,600.9 $1,885.3 $2, 193.8 $2,708.2 $3,276.0 $3,658.5 $3,808.7 $3,893.0 $3,979.8 Total liabilities and equities

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Entrepreneurship

Authors: Andrew Zacharakis, William D Bygrave

5th Edition

1119563097, 9781119563099

Students also viewed these Accounting questions

Question

Describe the inputs needed for capacity requirements planning.

Answered: 1 week ago