What is the free cash flow for each year General Assumptions Forecast Scenario Transaction Date Fiscal Year-End
Fantastic news! We've Found the answer you've been seeking!
Question:
What is the free cash flow for each year
Transcribed Image Text:
General Assumptions Forecast Scenario Transaction Date Fiscal Year-End Days Per Year Current Capitalization Cash-on-Hand PP&E Total Debt Total Equity Valuation Assumptions Tax Rate Perpetual Growth Rate EBITDA Exit Multiple Risk-Free Rate Equity Risk Premium Interest Rate WACC Investment Amount 8/1/2021 12/31/2021 365 LITT $5,000 $60,000 $35,000 $100,000 28% 2% 8.5x 3% 4% 6.668% $105,000 Income Statement Sales Revenue Cost of Sales Gross Profit SG&A Expense Depreciation Expense Interest Expense Income Before Income Taxes Income Taxes Net Income EBITDA Balance Sheet Items PP&E Schedule PP&E, Opening Balance Capital Expenditures Depreciation Expense PP&E, Ending Balance Debt Schedule Total Debt, Opening Balance Issuance (Repayment) Total Debt, Ending Balance Interest Expense Equity Schedule Total Equity, Opening Balance Net Income Dividends Share Issuance (Buy-Back) Total Equity, Ending Balance $36,000 $36,900 $37,823 $38,768 $39,737 $40,731 $41,749 $42,793 $43,863 $44,959 ($24,480) ($25,092) ($25,719) ($26,362) ($27,021) ($27,697) ($28,389) ($29,099) ($29,827) ($30,572) $11,520 $11,808 $12,103 $12,406 $12,716 $13,034 $13,360 $13,694 $14,036 $14,387 ($7,200) ($7,380) ($3,600) ($3,690) ($1,400) ($1,400) ($680) $190 ($662) $185 ($490) ($477) $4,320 $4,428 ($7,565) ($7,754) ($7,947) ($8,146) ($8,350) ($8,559) ($8,773) ($3,782) ($3,877) ($3,974) ($4,073) ($4,175) ($4,279) ($4,386) ($1,400) ($1,400) ($1,340) ($1,220) ($1,160) ($1,160) ($1,160) ($644) ($625) ($545) ($405) $175 $153 $114 ($450) ($393) ($292) $4,652 $4,768 $4,888 $180 ($463) ($325) ($304) ($283) $91 $85 $79 ($234) ($219) ($204) $5,010 $5,135 $5.264 $4,539 PO JUAT $100,000 ($490) $35,000 $35,000 $35,000 $35,000 $0 $0 $0 $0 $35,000 $35,000 $35,000 $35.000 $1,400 $1,400 $1,400 $1,400 $0 $0 $99,510 $68,152 $69,444 $70,714 $71,960 $60,000 $61,400 $62,785 $64,154 $65,505 $66,839 $5,000 $5,075 $5,151 $5,228 $5,307 $5,386 $5,467 $5,549 $5,632 $5,717 ($3,600) ($3,690) ($3,782) ($3,877) ($3,974) ($4,073) ($4,175) ($4,279) ($4,386) ($4,496) $61,400 $62,785 $64,154 $65,505 $66,839 $68,152 $69,444 $70,714 $71,960 $73,181 $0 $0 $98,570 $99,510 $99,034 $98,570 $98,121 ($477) ($463) ($450) ($393) ($292) $0 $0 $0 $0 $0 $0 $99,034 $98,121 $97,728 $97,728 $97,436 $97,202 $96,983 ($234) ($219) ($204) $0 $0 $0 $0 $0 $0 $96.983 $96,780 $35,000 $32,000 $29,000 $29,000 $29,000 $29,000 ($3,000) ($3,000) $0 $0 $0 ($2,000) $32,000 $29,000 $29,000 $29,000 $29,000 $27,000 $1,340 $1,220 $1,160 $1,160 $1,160 $1,120 ($8,992) ($4,496) ($1,120) ($221) $62 $0 $0 $97,436 ($159) $5,395 $97,202 $97,202 $96,780 ($159) $0 $0 $96,621 General Assumptions Forecast Scenario Transaction Date Fiscal Year-End Days Per Year Current Capitalization Cash-on-Hand PP&E Total Debt Total Equity Valuation Assumptions Tax Rate Perpetual Growth Rate EBITDA Exit Multiple Risk-Free Rate Equity Risk Premium Interest Rate WACC Investment Amount 8/1/2021 12/31/2021 365 LITT $5,000 $60,000 $35,000 $100,000 28% 2% 8.5x 3% 4% 6.668% $105,000 Income Statement Sales Revenue Cost of Sales Gross Profit SG&A Expense Depreciation Expense Interest Expense Income Before Income Taxes Income Taxes Net Income EBITDA Balance Sheet Items PP&E Schedule PP&E, Opening Balance Capital Expenditures Depreciation Expense PP&E, Ending Balance Debt Schedule Total Debt, Opening Balance Issuance (Repayment) Total Debt, Ending Balance Interest Expense Equity Schedule Total Equity, Opening Balance Net Income Dividends Share Issuance (Buy-Back) Total Equity, Ending Balance $36,000 $36,900 $37,823 $38,768 $39,737 $40,731 $41,749 $42,793 $43,863 $44,959 ($24,480) ($25,092) ($25,719) ($26,362) ($27,021) ($27,697) ($28,389) ($29,099) ($29,827) ($30,572) $11,520 $11,808 $12,103 $12,406 $12,716 $13,034 $13,360 $13,694 $14,036 $14,387 ($7,200) ($7,380) ($3,600) ($3,690) ($1,400) ($1,400) ($680) $190 ($662) $185 ($490) ($477) $4,320 $4,428 ($7,565) ($7,754) ($7,947) ($8,146) ($8,350) ($8,559) ($8,773) ($3,782) ($3,877) ($3,974) ($4,073) ($4,175) ($4,279) ($4,386) ($1,400) ($1,400) ($1,340) ($1,220) ($1,160) ($1,160) ($1,160) ($644) ($625) ($545) ($405) $175 $153 $114 ($450) ($393) ($292) $4,652 $4,768 $4,888 $180 ($463) ($325) ($304) ($283) $91 $85 $79 ($234) ($219) ($204) $5,010 $5,135 $5.264 $4,539 PO JUAT $100,000 ($490) $35,000 $35,000 $35,000 $35,000 $0 $0 $0 $0 $35,000 $35,000 $35,000 $35.000 $1,400 $1,400 $1,400 $1,400 $0 $0 $99,510 $68,152 $69,444 $70,714 $71,960 $60,000 $61,400 $62,785 $64,154 $65,505 $66,839 $5,000 $5,075 $5,151 $5,228 $5,307 $5,386 $5,467 $5,549 $5,632 $5,717 ($3,600) ($3,690) ($3,782) ($3,877) ($3,974) ($4,073) ($4,175) ($4,279) ($4,386) ($4,496) $61,400 $62,785 $64,154 $65,505 $66,839 $68,152 $69,444 $70,714 $71,960 $73,181 $0 $0 $98,570 $99,510 $99,034 $98,570 $98,121 ($477) ($463) ($450) ($393) ($292) $0 $0 $0 $0 $0 $0 $99,034 $98,121 $97,728 $97,728 $97,436 $97,202 $96,983 ($234) ($219) ($204) $0 $0 $0 $0 $0 $0 $96.983 $96,780 $35,000 $32,000 $29,000 $29,000 $29,000 $29,000 ($3,000) ($3,000) $0 $0 $0 ($2,000) $32,000 $29,000 $29,000 $29,000 $29,000 $27,000 $1,340 $1,220 $1,160 $1,160 $1,160 $1,120 ($8,992) ($4,496) ($1,120) ($221) $62 $0 $0 $97,436 ($159) $5,395 $97,202 $97,202 $96,780 ($159) $0 $0 $96,621 General Assumptions Forecast Scenario Transaction Date Fiscal Year-End Days Per Year Current Capitalization Cash-on-Hand PP&E Total Debt Total Equity Valuation Assumptions Tax Rate Perpetual Growth Rate EBITDA Exit Multiple Risk-Free Rate Equity Risk Premium Interest Rate WACC Investment Amount 8/1/2021 12/31/2021 365 LITT $5,000 $60,000 $35,000 $100,000 28% 2% 8.5x 3% 4% 6.668% $105,000 Income Statement Sales Revenue Cost of Sales Gross Profit SG&A Expense Depreciation Expense Interest Expense Income Before Income Taxes Income Taxes Net Income EBITDA Balance Sheet Items PP&E Schedule PP&E, Opening Balance Capital Expenditures Depreciation Expense PP&E, Ending Balance Debt Schedule Total Debt, Opening Balance Issuance (Repayment) Total Debt, Ending Balance Interest Expense Equity Schedule Total Equity, Opening Balance Net Income Dividends Share Issuance (Buy-Back) Total Equity, Ending Balance $36,000 $36,900 $37,823 $38,768 $39,737 $40,731 $41,749 $42,793 $43,863 $44,959 ($24,480) ($25,092) ($25,719) ($26,362) ($27,021) ($27,697) ($28,389) ($29,099) ($29,827) ($30,572) $11,520 $11,808 $12,103 $12,406 $12,716 $13,034 $13,360 $13,694 $14,036 $14,387 ($7,200) ($7,380) ($3,600) ($3,690) ($1,400) ($1,400) ($680) $190 ($662) $185 ($490) ($477) $4,320 $4,428 ($7,565) ($7,754) ($7,947) ($8,146) ($8,350) ($8,559) ($8,773) ($3,782) ($3,877) ($3,974) ($4,073) ($4,175) ($4,279) ($4,386) ($1,400) ($1,400) ($1,340) ($1,220) ($1,160) ($1,160) ($1,160) ($644) ($625) ($545) ($405) $175 $153 $114 ($450) ($393) ($292) $4,652 $4,768 $4,888 $180 ($463) ($325) ($304) ($283) $91 $85 $79 ($234) ($219) ($204) $5,010 $5,135 $5.264 $4,539 PO JUAT $100,000 ($490) $35,000 $35,000 $35,000 $35,000 $0 $0 $0 $0 $35,000 $35,000 $35,000 $35.000 $1,400 $1,400 $1,400 $1,400 $0 $0 $99,510 $68,152 $69,444 $70,714 $71,960 $60,000 $61,400 $62,785 $64,154 $65,505 $66,839 $5,000 $5,075 $5,151 $5,228 $5,307 $5,386 $5,467 $5,549 $5,632 $5,717 ($3,600) ($3,690) ($3,782) ($3,877) ($3,974) ($4,073) ($4,175) ($4,279) ($4,386) ($4,496) $61,400 $62,785 $64,154 $65,505 $66,839 $68,152 $69,444 $70,714 $71,960 $73,181 $0 $0 $98,570 $99,510 $99,034 $98,570 $98,121 ($477) ($463) ($450) ($393) ($292) $0 $0 $0 $0 $0 $0 $99,034 $98,121 $97,728 $97,728 $97,436 $97,202 $96,983 ($234) ($219) ($204) $0 $0 $0 $0 $0 $0 $96.983 $96,780 $35,000 $32,000 $29,000 $29,000 $29,000 $29,000 ($3,000) ($3,000) $0 $0 $0 ($2,000) $32,000 $29,000 $29,000 $29,000 $29,000 $27,000 $1,340 $1,220 $1,160 $1,160 $1,160 $1,120 ($8,992) ($4,496) ($1,120) ($221) $62 $0 $0 $97,436 ($159) $5,395 $97,202 $97,202 $96,780 ($159) $0 $0 $96,621
Expert Answer:
Answer rating: 100% (QA)
Year Free Cash Flow 2021 490 2022 477 2023 463 2024 450 2025 393 2026 292 20... View the full answer
Related Book For
Financial Reporting and Analysis
ISBN: 978-1259722653
7th edition
Authors: Lawrence Revsine, Daniel Collins, Bruce Johnson, Fred Mittelstaedt, Leonard Soffer
Posted Date:
Students also viewed these finance questions
-
3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 Mo's Motor Corp. issued $ 380,000 of 7%, 5-year bonds on April 1, 2021. Interest is payable semi-annually on April 1 and October 1. On April 1, 2023,...
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...
-
4. In cells B4:B15, type a yearly salary for each staff member. Format these values as Currency with no decimal places. 5. Calculate the new salary with a 10% increase in column C. 6. Calculate the...
-
Tom has a successful business with $100,000 of taxable income before the election to expense in 2016. He purchases one new asset in 2016, a new machine which is 7-year MACRS property and costs...
-
Vickis company can produce digital recorders at a cost of $40 apiece. It is estimated that if the recorders are sold for p dollars apiece, consumers will buy 120 p of them a month. Express Vickis...
-
True or False: For personal investment decision making, rates of return are used more frequently than present worth.
-
On October 31, the stockholders equity section of Pele Companys balance sheet consists of common stock $648,000 and retained earnings $400,000. Pele is considering the following two courses of...
-
The accompanying data represent the approximate population, in millions, of the 20 most populous cities in the world. 13.5 11.7 10.4 8.4 7.8 13.3 11.6 9.4 8.4 7.7 12.7 11.5 9.3 8.2 7.4 12.3 11.3 8.7...
-
A C corporation is considering expanding its facilities with the purchase of an office for USD $400,000. Currently, the firm is majority owned by two individuals, with a joint shareholding of 51%,...
-
A company is evaluating a project that requires an initial investment of $80,000 pesos. In the first year, it will generate profits of $30,000, and these earnings will increase by 10% each year. The...
-
A heat pump absorbs 10 kW of heat from outside environment at 250 K while absorbing 15 kW of work. It delivers the heat to a room that must be kept warm at 300 K. The Coefficient of performance (COP)...
-
Check your eLMS for all the topics discussed from prelim to final period. Create a proposal on how you would like to showcase any art as your best practice. The art you choose should be related to...
-
Christian Pawl holds the opinion that the Black Diamond Skylight three-person three-season tent is the most amazing tent on the market. Pawl is so convinced of the tent's versatility that he would...
-
You are preparing for your role as an international marketing manager and want to get a deeper understanding of high context cultures. Explain what a high-context culture is, what are its...
-
Determine the amount of magnetic induction at point P if the current flowing in the conductor is 5 amperes in the direction shown in the figure below. 5.0 A 2.0 cm 1.0 cm
-
Complete problem P10-21 using ASPE. Data from P10-21 Original cost ................................................................. $7,000,000 Accumulated depreciation...
-
In mid-2000, Enron Corporation and Blockbuster (a division of Viacom) set up a pilot project, streaming videos to a few dozen apartments in Portland, Oregon, from servers set up in the basement of...
-
On December 31, 2017, Toms River Rafting, Inc. (TRR), has a deferred tax asset related to a $250,000 net operating loss carryforward. The enacted tax rate (and substantively enacted tax rate) at the...
-
Karr, Inc., reported net income of $300,000 for 2017. Changes occurred in several balance sheet accounts as follows: Additional Information: a. During 2017, Karr sold equipment costing $25,000, with...
-
Name and briefly explain the three key components of a modern financial system.
-
What are non-banking financial intermediaries? List the different types and briefly explain their role in connecting savers with borrowers in the financial system.
-
Briefly explain the process of asset securitization in the financial system.
Study smarter with the SolutionInn App