Calculate your companys Free Cash Flow for each of the last 4 fiscal years (2018-2021). Use a
Fantastic news! We've Found the answer you've been seeking!
Question:
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
Expert Answer:
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
Related Book For
Financial Management for Public Health and Not for Profit Organizations
ISBN: 978-0132805667
4th edition
Authors: Steven A. Finkler, Thad Calabrese
Posted Date:
Students also viewed these finance questions
-
The expected annual free cash flow for the GPS tracker investment from is computed as follows: Construct a spreadsheet model to compute free cash flow that relies on the following assumptions or...
-
Calculate net income for tax purposes for each of the three taxpayers. Income tax reference: ITA 3. Taxpayer A Taxpayer B axpayer C Employment income Business income (loss) Property income (loss)...
-
For each of the accounts listed, indicate whether it is an asset (A), a liability (L), or an owners equity (OE) account. If it is an account that affects owners equity, indicate whether it is a...
-
On 31 March 1980, Philip acquired a 48-year copyright at a cost of 85,000. The copyright was valued at 92,000 on 31 March 1982. On 31 March 2021, Philip sold the copyright for 47,000. Compute the...
-
A charge Q is located at x = 0 and a charge 4Q is at x = 12.0 cm. The force on a charge of 2C is zero if that charge is placed at x = 4.0 cm and is 126.4 N in the positive x direction if placed at x...
-
The following information has been extracted from the books of a trader at 1 July 20X2: ................................................................... Amount owing by credit customers...
-
Give three guides for the allocation of service department costs.
-
Present Value and Multiple Cash Flows What is the present value of $2,000 per year, at a discount rate of 10 percent, if the first payment is received 9 years from now and the last payment is...
-
45 22.5 45 If mZAOB 45 in circle 0, what is mZACB? BR 67.5 6 90
-
Reconsider the Lockhead Aircraft Co. problem presented in Problem 16.15 regarding a project to develop a new fighter airplane for the U.S. Air Force. Management is extremely concerned that current...
-
A data set list the number of olives on each pizza ordered in the last few hours at a pizza shop. For this data set, the minimum is 4, the median is 16, the third quartile is 19, the interquartile...
-
What is concurrency control and why does a DBMS need a concurrency control facility? Discuss the importance of concurrency control and explain the various levels of locking.
-
1. The diagram shown AFB and BEC are equilateral triangles and AGDC is a rectangle. Write the following as a single vector. Show your steps. a) GF+ FL + FB+ BC c) DC+ BE b) AF+BA+FB d) G F E D A B C...
-
An engineer measures the time (in milliseconds) it takes for an electrical current to pass through a medium. She performed this experiment 30 times and recorded the results below. 737 735 529 828 423...
-
Accounting software Courses 1. Re cord all the transactions previously done manually into 2. Sage 50 and QuickBooks and create and print the identical financial statements, aged accounts...
-
Stockman, Turbo and United are three small firms producing specialized products, equipment, and research for the scientific and medical communities. As this has become such a critical, high-growth...
-
please help, and please comment with yes whi is going to solve it, its help Question 2: [IRR Independent] A cash flow occurs as follows: first cost of $1,000, receipt of $800 at Year 1, disbursement...
-
In Exercises 1-2, rewrite each verbal statement as an equation. Then decide whether the statement is true or false. Justify your answer. 1. The logarithm of the difference of two numbers is equal to...
-
Individual Rehabilitation Services (IRS) is a not-for-profit organization that assists individuals returning to society following a substance abuse conviction. IRS has been greatly successful in its...
-
Does the difficulty in determining the current value of an asset create a problem in determining the depreciation expense that should be charged for a year?
-
The primary purpose of an audit is to discover fraud. True or false? Explain.
-
Why are the most profitable companies the ones that gain the most by issuing new shares?
-
Should there be an issue of new shares whenever the share price is overvalued?
-
What techniques can be used for choosing shareholders?
Study smarter with the SolutionInn App