Answered step by step
Verified Expert Solution
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.
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 equitiesStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started