Great Deal! Get Instant $25 FREE in Account on First Order + 10% Cashback on Every Order Order Now

FS to FCF Template Solution Legend Value given in problem Formula/Calculation/Analysis required Qualitative analysis or Short answer required Financial Data Year 1Year 2Year 3Year 4Year 5 Assets...

1 answer below »

FS to FCF Template
                                                Solution Legend
                                                Value given in problem
                                                Formula/Calculation/Analysis required
                                                Qualitative analysis or Short answer required
        Financial Data
            Year 1    Year 2    Year 3    Year 4    Year 5
        Assets
        Cash & Cash Equivalents
        Short-term Investments
        Receivables
        Inventories
        Prepaid Expenses
        Total Cu
ent Assets
        Net Property, Plant & Equipment
        Total Assets
        Liabilities
        Accounts payable
        Cu
ent maturities of long-term debt
        Income taxes payable
        Total cu
ent liabilities
        Long-term debt
        Total Liabilities
        Total stockholders’ equity (deficit)
        Total Liabilities & Shareholder's Equity
        Income Statement    Year 1    Year 2    Year 3    Year 4    Year 5
        Revenue
        Total revenues
        Expenses
        Cost of Goods Sold
        General, administrative and othe
        Depreciation and amortization
        Total expenses
        Operating income
        Interest expense
        Income before income taxes
        Income tax benefit (expense)
        Net income
        Dividends Paid
        Non-distributed Income
        Find Changes in NWC
            Year 1    Year 2    Year 3    Year 4    Year 5
        Cu
ent Assets, other than Cash and Marketable Securities
        Cu
ent Liabilities, excluding Debt
        Net Working Capital (CA-CL)
        Change in NWC (NWC Investment)
        Find CapEx
            Year 1    Year 2    Year 3    Year 4    Year 5
        Net Property, Plant & Equipment
        Depreciation and amortization
        Capex
        You can read more using the following link    Howard Keen, Clearing Up Confusion over calculation of FCF.
        Estimate FCF
        Tax Rate
            
DL: If you have difficulty estimating company's tax rate you may assume statutory tax rate of 35% before 2018 and 21% thereafte
    Yea
            Year 1    Year 2    Year 3    Year 4    Year 5
        EBIT
        EBIT(1-T) = NOPAT
        Plus: Depreciation Expense
        Less: CAPEX
        Less: Working Capital Investment
        Firm Free Cash Flow
Based on historical financial data, find FCF for the company of your choice.
1. In week 1 you were asked to choose a publicly traded company and submit its name for instructor's approval. Assuming
2. Download annual financial data for the last 5 years from Edgar Website (forms 10-K). Attention: if your company became public less than 5 years ago, you will also have to download data from its IPO filing prospectus (form 424B4). Template below is approximate, you may modify it (change, delete, or add rows), to suit your company
3. Using approach similar to the one described in this module's Excel file you will have to calculate the FCF for the company of your choice
If you have difficulty estimating company's tax rate you may assume statutory tax rate of 35% for years before 2018.
For submission, Excel file is enough
http:
www.jgbm.org/page/1%20Howard%20Keen.pdf
Answered Same DayMar 13, 2022

Solution

Prince answered on Mar 13 2022
43 Votes
FS to FCF Template
                                                Solution Legend
                                                Value given in problem
                                                Formula/Calculation/Analysis required
                                                Qualitative analysis or Short answer required
        Financial Data
            2017    2018    2019    2020    2021
            Year 1    Year 2    Year 3    Year 4    Year 5
        Assets
        Cash & Cash Equivalents    $2,464    $866    $899    $3,449    $4,709
        Short-term Investments    $0    $0    $0    $0    $0
        Receivables    $1,976    $2,442    $2,224    $2,110    $1,872
        Inventories    $59    $51    $50    $51    $56
        Prepaid Expenses    $828    $695    $385    $633    $511
        Total Cu
ent Assets    $5,327    $4,053    $3,558    $6,243    $7,149
        Net Property, Plant & Equipment    $22,448    $22,843    $24,160    $24,958    $24,721
        Total Assets    $27,776    $26,896    $27,718    $31,201    $31,869
        Liabilities
        Accounts payable    $925    $1,208    $988    $741    $1,007
        Cu
ent maturities of long-term debt    $0    $0    $59    $2,244    $0
        Income taxes payable    $266    $228    $332    $741    $361
        Total cu
ent liabilities    $1,191    $1,436    $1,379    $3,726    $1,368
        Long-term debt    $29,536    $31,075    $34,118    $35,197    $35,623
        Total Liabilities    $30,727    $32,512    $35,497    $38,923    $36,990
        Total stockholders’ equity (deficit)
    ($3,268)    ($6,258)    ($8,210)    ($7,825)    ($4,601)
        Total Liabilities & Shareholder's...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here