Answered step by step
Verified Expert Solution
Question
1 Approved Answer
How to do a full Financial Projection, and an explanation of the cashflow using the EBITA model because I'm not entirely sure about that 2016
How to do a full Financial Projection, and an explanation of the cashflow using the EBITA model because I'm not entirely sure about that
2016 2017 2018 2019 P&L Revenues COGS 13.668 (5.711) (4.849) (762) OPEX Depreciation Financial Expenses Tax 15.200 (6.318) (5.315) (839) (9) (706) 16.768 (6.969) (5.859) (935) (10) (798) 18.492 (7.686) (6.456) (1.051) (12) (881) Estimated Sales Growth (%): Yr20 11,5%; Yr21 8,0%; Yr22 9% Gross Margin % Revenues: Yr20 58,0% and then decrease 1% each year Opex growth rate (%): Yrs20-22:10,2% each year Depreciation: 15% of NFA each year Financial expenses: 6% of total debt each year Tax %: same as Yr17 Long term debt: remains constant Equity: remains constant Days receivable: 12 days Days payable: 205 days Days inventory: sames as Yr19 Days in a year: 365 days CAPEX: for Yrs 20-22 is 0 (593) BALANCE SHEET Acc. Receivable Inventories NFA Acc. Payable Long Term Debt Equity 547 1.235 4.891 3.318 177 7.213 580 1.366 4.979 3.612 177 8.179 609 1.507 5.188 3.927 177 9.072 639 1.662 5.501 4.275 177 9.947 P&L Rev Inc. Revenues COGS Gross Margin % GM OPEX Inc. OPEX EBITDA Depreciation % NFA EBIT Financial Expenses % debt EBT Tax % Tax Net Profit Retained Earnings CASH FLOW BALANCE SHEET Check OTHERS WC 365 days/yr NEA InventoriesStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started