Core Financial Modeling Formulas and Metrics

Revenue: Unit selling price A* Quantity A +Unit selling price B* Quantity B

Purchases: - ((Quantity A* Unit cost of sale A + Quantity B* Unit cost of sale B)+ Chang invent)

Change of inventory: Inventory Year 1 - Inventory Year 0

Consume cost of good sold: Purchases + Change of inventory.

Gross Profit: Revenue + Consume cost of goods sold.

Overheads: - overheads (table)

Ebitda: Gross profit + overheads

Am & depreciation: - gross asset + COSTOF DEBT of debt (table)

Ebit-BAII: Ebitda + Am & depreciation.

Financial result: - Total debt (table) * COSTOF DEBT of debt (table)

EBT- BAI: Ebit + Financial result

Taxes: - EBT * TAX rate (table)

Net earning: EBT + Taxes

Gross asset Y1 : Gross asset year 0 + CAPEX

Accumulated amortitation Y1: Accumulated amortitation year 0 + Am & Depreciation

Current Assets: suma de

• Customer receivables: (revenue/12)*ARP month (table)*(1+VAT Rate)
• Inventory: ASP(table)*( Unit Cost of sale A*Unit Cost of sale B + Quantity A* Quantity B)/360
• VAT recoverable

Total cash: operating + non-operating cash

• Operating cash:
• Non-Operating cash: Equity capital + Fc e

Shareholder´s Equity: suma de

• Equity capital: equity capital year 0 + year 1
• Reserves: reserves year 0 + net earning year 0
• Reserves (Pay out Div): Reserves (Pay out Div) year 0 - DIVIDEND
• Net earning: el calculado anteriormente

Long term debt: Total debt (table) * (1- % Short Term) (table)

Current liabilities: suma de

• Short term debt: Total debt (table) * % Short Term (table)
• Payables: - (purchases/360) * Average Payables Periods ( days) * (1+ VAT rate)
• VAT payable: =SI(Output VAT-Imput Vat >0; Output VAT-Imput Vat;0)

Equity + liabilities: Shareholder´s Equity + Long term debt + Current liabilities

Adjusted taxes: - Ebit * Tax rate (table)

Nopat: Ebit + Adjusted taxes

Capex: - capex (table)

V owc: - V Operational  working Capital

FCF: Nopat+ Am & depreciation + Capex + V owc

V Debt: Long Term Debt 1 + Short Term Debt 1 - Long Term Debt 0 - Short Term Debt 0

V capital: equity capital 1 – equity capital 0

V div: Short Term Debt 1 - Short Term Debt 0

FC e: suma desde Net earning a V div