Calculate your company’s Free Cash Flow for each of the last 4 fiscal years (2018-2021). Use a tax rate of 25% and use the depreciation and amortization from the Cash Flow statement. Please do not use any other data from the Cash Flow statement, calculate changes in the relevant balance sheet accounts from year to year (for example: total current assets, gross property plant & equipment, accounts payable & accrued expenses).

Transcribed Image Text:

Income Statement For the Fiscal Period Ending Currency Revenue Finance Div. Revenue Other Revenue Total Revenue Cost Of Goods Sold Finance Div. Operating Exp. Interest Expense - Finance Division Gross Profit Selling General & Admin Exp. R & D Exp. Depreciation & Amort. Other Operating Expense/(Income) Other Operating Exp., Total Operating Income Interest Expense Interest and Invest. Income Net Interest Exp. Income/(Loss) from Affiliates Currency Exchange Gains (Loss) Other Non-Operating Inc. (Exp.) EBT Excl. Unusual Items Restructuring Charges Impairment of Goodwill Gain (Loss) On Sale Of Invest. Other Unusual Items EBT Incl. Unusual Items Income Tax Expense Earnings from Cont. Ops. Earnings of Discontinued Ops. Extraord. Item & Account. Change Net Income to Company Minority Int. in Earnings Net Income Pref. Dividends and Other Adj. NI to Common Incl Extra Items NI to Common Excl. Extra Items Reclassified 12 months Dec-31-2017 USD 133,449.0 12,139.0 145,588.0 116,229.0 8,389.0 2,566.0 18,404.0 8,254.0 8,254.0 10,150.0 (575.0) 266.0 (309.0) 1,959.0 (52.0) 171.0 11,919.0 (56.0) 11,863.0 11,533.0 330.0 (4,212.0) (3,882.0) 18.0 (3.864.0) 16.0 (3,880.0) 332.0 Reclassified 12 months Dec-31-2018 USD 133,045.0 14,004.0 147,049.0 120,656.0 8,890.0 3,225.0 14,278.0 7,985.0 7,985.0 6,293.0 (655.0) 335.0 (320.0) 1,980.0 (168.0) 506.0 8,291.0 258.0 8,549.0 474.0 8,075.0 (70.0) 8,005.0 9.0 8.014.0 98.0 7,916.0 7,986.0 Reclassified 12 months Dec-31-2019 USD 122,697.0 14,540.0 137,237.0 110,651.0 8,807.0 3,641.0 14,138.0 7,694.0 7,694.0 6,444.0 (782.0) 429.0 (353.0) 1,102.0 85.0 (76.0) 7,202.0 234.0 7,436.0 769.0 6,667.0 6,667.0 65.0 6.732.0 151.0 6,581.0 6,581.0 12 months Dec-31-2020 USD 108,673.0 13,812.0 122,485.0 96,856.0 8,104.0 3,023.0 14,502.0 5,943.0 5,943.0 8,559.0 (1,098.0) 241.0 (857.0) 527.0 (203.0) 348.0 8,374.0 (683.0) 404.0 8,095.0 1,774.0 6,321.0 6,321.0 106.0 6.427.0 180.0 6,247.0 6,247.0 12 months Dec-31-2021 USD 113,590.0 13,414.0 127,004.0 100,544.0 5,835.0 2,546.0 18,079.0 6,645.0 6,645.0 11,434.0 (950.0) 146.0 (804.0) 1,100.0 17.0 82.0 11,829.0 887.0 12,716.0 2,771.0 9,945.0 9,945.0 74.0 10.019.0 182.0 9,837.0 9,837.0 Income Statement For the Fiscal Period Ending Currency Revenue Finance Div. Revenue Other Revenue Total Revenue Cost Of Goods Sold Finance Div. Operating Exp. Interest Expense - Finance Division Gross Profit Selling General & Admin Exp. R & D Exp. Depreciation & Amort. Other Operating Expense/(Income) Other Operating Exp., Total Operating Income Interest Expense Interest and Invest. Income Net Interest Exp. Income/(Loss) from Affiliates Currency Exchange Gains (Loss) Other Non-Operating Inc. (Exp.) EBT Excl. Unusual Items Restructuring Charges Impairment of Goodwill Gain (Loss) On Sale Of Invest. Other Unusual Items EBT Incl. Unusual Items Income Tax Expense Earnings from Cont. Ops. Earnings of Discontinued Ops. Extraord. Item & Account. Change Net Income to Company Minority Int. in Earnings Net Income Pref. Dividends and Other Adj. NI to Common Incl Extra Items NI to Common Excl. Extra Items Reclassified 12 months Dec-31-2017 USD 133,449.0 12,139.0 145,588.0 116,229.0 8,389.0 2,566.0 18,404.0 8,254.0 8,254.0 10,150.0 (575.0) 266.0 (309.0) 1,959.0 (52.0) 171.0 11,919.0 (56.0) 11,863.0 11,533.0 330.0 (4,212.0) (3,882.0) 18.0 (3.864.0) 16.0 (3,880.0) 332.0 Reclassified 12 months Dec-31-2018 USD 133,045.0 14,004.0 147,049.0 120,656.0 8,890.0 3,225.0 14,278.0 7,985.0 7,985.0 6,293.0 (655.0) 335.0 (320.0) 1,980.0 (168.0) 506.0 8,291.0 258.0 8,549.0 474.0 8,075.0 (70.0) 8,005.0 9.0 8.014.0 98.0 7,916.0 7,986.0 Reclassified 12 months Dec-31-2019 USD 122,697.0 14,540.0 137,237.0 110,651.0 8,807.0 3,641.0 14,138.0 7,694.0 7,694.0 6,444.0 (782.0) 429.0 (353.0) 1,102.0 85.0 (76.0) 7,202.0 234.0 7,436.0 769.0 6,667.0 6,667.0 65.0 6.732.0 151.0 6,581.0 6,581.0 12 months Dec-31-2020 USD 108,673.0 13,812.0 122,485.0 96,856.0 8,104.0 3,023.0 14,502.0 5,943.0 5,943.0 8,559.0 (1,098.0) 241.0 (857.0) 527.0 (203.0) 348.0 8,374.0 (683.0) 404.0 8,095.0 1,774.0 6,321.0 6,321.0 106.0 6.427.0 180.0 6,247.0 6,247.0 12 months Dec-31-2021 USD 113,590.0 13,414.0 127,004.0 100,544.0 5,835.0 2,546.0 18,079.0 6,645.0 6,645.0 11,434.0 (950.0) 146.0 (804.0) 1,100.0 17.0 82.0 11,829.0 887.0 12,716.0 2,771.0 9,945.0 9,945.0 74.0 10.019.0 182.0 9,837.0 9,837.0

Answer rating: 100% (QA)

To calculate the Free Cash Flow FCF for each of the last 4 fiscal years 20182021 we will follow the following formula Free Cash Flow FCF Operating Inc... View the full answer