test form – Drake Financial Services

a) Reporting Period

Period 1 – End Date

Period 2 – End Date

b) Equal Period Length in Months

(Period 1 and Period 2 lengths need to be the same length in months)

Period 1 – Length in Months(Required)

Please enter a number from 1 to 60.

Period 2 – Length in Months(Required)

Please enter a number from 1 to 60.

c) Profit & Loss

Period 1 – Revenue

Period 2 – Revenue

Period 1 – Gross Margin

Period 2 – Gross Margin

Period 1 – Nett Profit/(Loss)

Period 2 – Nett Profit/(Loss)

d) Other Information

Period 1 – Depreciation & Amortisation

Period 2 – Depreciation & Amortisation

Period 1 – Interest Paid

Period2 – Interest Paid

Period 1 – Tax Paid

Period 2 – Tax Paid

Period 1 – Extraordinary Income/Expenses

Period 2 – Extraordinary Income/Expenses

Period 1 – Distributions/Dividends

Period 2 – Distributions/Dividends

e) Assets

Period 1 – Total Assets

Period 2 – Total Assets

Period 1 – Cash

Period 2 – Cash

Period 1 – Accounts Receivable

Period 2 – Accounts Receivable

Period 1 – Inventory

Period 2 – Inventory

Period 1 – Total Current Assets

Period 2 – Total Current Assets

Period 1 – Fixed Assets

Period 2 – Fixed Assets

f) Liabilities

Period 1 – Total Liabilities

Period 2 – Total Liabilities

Period 1 – Accounts Payable

Period 2 – Accounts Payable

Period 1 – Total Current Liabilities

Period 2 – Total Current Liabilities

g) Funding

Period 1 – Bank Loans – Current

Period 2 – Bank Loans – Current

Period 1 – Bank Loans – Non Current

Period 2 – Bank Loans – Non Current

h) Current results

Operating profit

Nett cashflow

i) 7 Levers of Profit and Cash Flow

1) Price increase %

% Input

Operating profit impact annually

Impact on cashflow annually

2) Volume increase %

% Input

Operating profit impact annually

Impact on cashflow annually

3) Direct cost reduction %

% Input

Operating profit impact annually

Impact on cashflow annually

4) Overheads reduction %

% Input

Operating profit impact annually

Impact on cashflow annually

Hidden

Accounts receivable – AR

Hidden

Accounts receivable – WIP

Hidden

Accounts receivable – AP

Hidden

Inventory – AR

Hidden

Inventory – WIP

Hidden

Inventory – AP

Hidden

Accounts payable – AR

Hidden

Accounts payable – WIP

Hidden

Accounts payable – AP

5) Reduction in accounts receivable days

Input in Days

Operating profit impact annually

Impact on cashflow annually

6) Reduction in inventory days

Input in Days

Operating profit impact annually

Impact on cashflow annually

7) Increase in accounts payable days

Input in Days

Operating profit impact annually

Impact on cashflow annually

j) Enhanced results

Operating profit impact

Impact on cashflow

k) Business Value

EBITDA Calc

Hidden

Operating Profit Impact

Hidden

Impact on Cashflow

Adjustment/extraordinary items

Hidden

Operating Profit Impact

Hidden

Impact on Cashflow

Adjusted EBITDA

Hidden

Operating Profit Impact

Hidden

Impact on Cashflow

Profit multiple

Weighted average adjusted EBITDA

(Weighted 75% current period and 25% previous period)

Gross Business Value

Nett Cash

Current Business Value

Enhanced Business Value

Would you like to email yourself the results?

Yes, Please

Email address for Results(Required)

Company Name(Required)

Profit & Cashflow Calculator

a) Reporting Period

b) Equal Period Length in Months

c) Profit & Loss

d) Other Information

e) Assets

f) Liabilities

g) Funding

h) Current results

i) 7 Levers of Profit and Cash Flow

1) Price increase %

2) Volume increase %

3) Direct cost reduction %

4) Overheads reduction %

5) Reduction in accounts receivable days

6) Reduction in inventory days

7) Increase in accounts payable days

j) Enhanced results

k) Business Value

EBITDA Calc

Adjustment/extraordinary items

Adjusted EBITDA