Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedimage text in transcribed

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 Inventories

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Hotel And Restaurant Accounting

Authors: Cole Raymond

8th Edition

0866125531, 9780866125536

More Books

Students also viewed these Accounting questions

Question

1.4 Identify tools to help makeevidence-based HRM decisions.

Answered: 1 week ago