EXAMPLE OF MODELS

 “Here’s to the Crazy ones. The misfits. The rebels. The trouble-makers. The round pegs in the square holes. The ones who see things differently. They’re not fond of rules, and they have no respect for the status-quo. You can quote them, disagree with them, or vilify them. About the only thing you can’t do is ignore them. Because they change
things. They push the human race forward. And while some may see them as the crazy ones, we see genius. Because the people who are crazy enough to think they can change the world – are the ones who DO!”  – Steve Jobs
 So what are you waiting for? Get a financial model done today and paint a financial picture of success!
OPERATIONAL MODELS

A customized Managerial Financial Performance Dashboard is designed so that key financial indicators 

Financial Performance Dashboard Report

Financial Performance Dashboard Report

of your business (i.e. cash, revenue growth, gross/profit margin, ROI, capital needs, headcount staging & compensation expense, debt servicing, working capital, liquidation assumptions, etc.) can be updated in real-time to determine the impact from changes to assumptions. If multiple divisions and/or projects are projected, user can toggle to see impact on key financial metrics from either including, or not including, a particular project.

Revenue/Expense Estimator

Revenue/Expense Estimator

A Revenue/Expense estimator is added to financial models in cases where management wants to re-forecast the initial budget. User is able to change future period projections by using positive or negative percentages from the drill down menu. Benefits: 1) more consistent evaluation and visibility over financial results (i.e. cash, revenue, working capital, gross margin % and profit margin %, capital needs, etc. ) and, 2) increased management over operations.        

_______________________________________________________

PRIVATE EQUITY/VENTURE CAPITAL MODELS

In addition to building financial models for operational companies, Globe Matrix Consulting also builds financial models to launch and manage Private Equity/Venture Capital firms:

Executive Dashboard  - Based on set of key drivers, models generate: lRR, Carrying Value of Investments, Capital Called from LPs, SBA Borrowings and Debt Position (if SBA Fund), Running Cash Balance, Detail of Fund Expenses, Total Distributions,  Portfolio Company Performance, etc.

Executive Dashboard – Based on set of key drivers, models generate: lRR, Carrying Value of    Investments, Capital Called from LPs, SBA Borrowings and Debt Position (if SBA Fund), Running Cash Balance, Detail of Fund Expenses, Total Distributions, Portfolio Company Performance, etc.

_______________________________________________________

CASH CALCULATOR: “The Brain of the Financial Models”

Cash Calculator

Cash Calculator

All models include a running cash calculator based on assumptions and ‘what-if’ toggle function. All cash inflows and outflows are factored into the calculator, giving the effect of a real checkbook. This gives more control over cash, understanding both actual and projected cash balances. Furthermore, for startup ventures, entrepreneurs are able to gain insight into amount of capital needed to fund operations.

_______________________________________________________

PERFORMANCE GRAPHS

All models include graphs and charts to illustrate quantitative data.

REVENUE PERFORMANCE GRAPHS

REVENUE PERFORMANCE GRAPH 

Screenshot-4_NPV-chart-at-various-discount-rates

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s