60.1K

Verified Solution

Link Copied!

Please help. I'm stuck

Inbox 11:27 PM @* 28%.-- VEC.F17.bba.mail Home Insert Draw Formulas Data ReviewView Arial ABC 123 fx 2 Cashflow Forecast shortage or redundant 2017 2018 7 Sales 8 Variable costs 9 Fixed cash op costs 11 EBITDA 12 13 EBITDA(1-t) 14 tnon-cash charges 16 C [replacement] 17 C [expansion] Net result oper CF 0.0 0.0 0.0 0.0 19 20 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 22 Set-up(1-t) 24 25 Net decision CF 26 NET OPERATING C 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 28 Interest(1-t) 29 Principal pmts 30 Common dividends 31 Pref dividends 32 Lease pmts(1- 34 Fixed financial CF 0.0 0.0 0.0 0.0 36 Debt 37 Preferred Stock 38 -Equity 39 Dividend 40 11 Net decision fin CF 12 DECISION FIXED 43 0.0 0.0 0.0 0.0 FINANCIAL CFs 0.0 0.0 0.0 0.0 45 16 CATO (Free CF) Gross Debt 48 49 50 GROWTH enter your g INFLATOR #VALUE! #VALUE! #VALUE! #VALUE! 54 SALES 0.0 56 Vacillators EBITDA Forecast M... UNRA Valuation Sum :0 Inbox 11:27 PM @* 28%.-- VEC.F17.bba.mail Home Insert Draw Formulas Data ReviewView Arial ABC 123 fx 2 Cashflow Forecast shortage or redundant 2017 2018 7 Sales 8 Variable costs 9 Fixed cash op costs 11 EBITDA 12 13 EBITDA(1-t) 14 tnon-cash charges 16 C [replacement] 17 C [expansion] Net result oper CF 0.0 0.0 0.0 0.0 19 20 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 22 Set-up(1-t) 24 25 Net decision CF 26 NET OPERATING C 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 28 Interest(1-t) 29 Principal pmts 30 Common dividends 31 Pref dividends 32 Lease pmts(1- 34 Fixed financial CF 0.0 0.0 0.0 0.0 36 Debt 37 Preferred Stock 38 -Equity 39 Dividend 40 11 Net decision fin CF 12 DECISION FIXED 43 0.0 0.0 0.0 0.0 FINANCIAL CFs 0.0 0.0 0.0 0.0 45 16 CATO (Free CF) Gross Debt 48 49 50 GROWTH enter your g INFLATOR #VALUE! #VALUE! #VALUE! #VALUE! 54 SALES 0.0 56 Vacillators EBITDA Forecast M... UNRA Valuation Sum :0

Answer & Explanation Solved by verified expert

See Answer