Feedback Form
Home Features Mastermind Forums About Advertise Blog Network Contact Be An Author

RISK ASSESSMENT THE NEW REALITY SHOW

RISK ASSESSMENT THE NEW REALITY SHOW

As he tried to quench his
thirst ... he saw an image in the
pool, and fell in love with that
embodied hope, and found a
substance in what was only
shadow."
Narcissus
Continuing a theme started last month,
we are going to explore a method of using
spreadsheets that gives the end user
better insight into the risks going forward
in the business rather than the usual rosy
view that most portray.
THE PROJECT
On a recent assignment, we developed a standard
financial model with the usual balance sheet, cash
flow and income statement in a spreadsheet format.
The business had invested in a new facility, which it
had acquired for $10,000,000 in debt and we now
had to decide on the amount of equity required to
attract bank financing.
We took a less conventional approach in trying to
decide on the right amount of equity. For the main
cost and revenue drivers, rather than pick just one
value, we set up a range of values for each one so
that the spreadsheet picked a different value from
each of the ranges each time it ran. We then ran it
1000 times. The chart below shows the resulting
range of EBITDA values, showing a future that is
more of a distribution of probabilities than a march
forward to financial heaven.
We had good market data from the industry to set
the range of values for the main cost and revenue
drivers. We then increased the ranges on each side
to get a better feel for what could go wrong…..or
right.
WHERE IS THIS TYPE OF
ANALYSIS USEFUL?
· A company can look at the amount of equity
that it currently has, and determine in what percentage
of cases will it be adequate for the financial
metrics being imposed by its banks or
lenders. It can apply this analysis to any metric
for that matter.
· Venture Capitalists determining the appropriate
amount to invest and what percentage of the
company they should get in order to earn an acceptable
return.
· Treasurers determining the risks in investing in a
new plant or an acquisition.
· Project managers in bidding situations to determine
the likely probability of a potential project
being profitable, and then deciding whether to
submit a bid.
· Bank managers considering approval of a loan
might recommend the appropriate equity to be
invested prior to approving a loan.
THE ANALYSIS
We used the above type of approach to estimate
the following;
· The amount of equity that should be invested in
this business;
· The rate of return that could be expected in
most cases;
· The chances of several things going wrong at
once.
EQUITY REQUIRED
To estimate the amount of equity required, we set
the equity amount to ‘0’ to start and ran the spreadsheet
1000 times. We then looked at the generated
potential values for Current Assets, Current Liabilities,
Current Ratio and Bank Line. The first run
showed that 80% of the time the Current Ratio was
worse than our minimum target of 1.25.
The chart below shows the maximum amount of equity
required to meet the Current Ratio target of
1.25 in the percentage of cases shown. In other
words, if one invests $2.9 million in the business,
the current ratio target will be met in 95% of the
cases. In any exercise like this there will always be
outlying values that are much higher or lower than
the norm. As long as the equity is acceptable in the
vast majority of cases, then one should be satisfied
that the risk is adequately covered off.
We added the $2.9 million in equity to the spreadsheet
and ran the scenarios again. With the addition
of the equity, the current ratio was actually met
94% of the time. In further analyzing the data set
we took a look at Cash Flow Coverage and found
that prior to an equity injection it was only acceptable
78%% of the time based on a target ratio of
1.5. After the investment, the Cash Flow Coverage
was above 1.5 in 92% of the cases. We should now
satisfied that with an injection of $2.9 million that
the company would likely be onside with the lenders
and the bank.
RATE OF RETURN ON
INVESTMENT
To estimate the rate of return we will take a 5 year time
horizon from investment, and calculate it based on 5
times EBITDA plus the excess cash in the bank after paying
down the debt.
You can see that the majority of the returns are in
the 16-64% range which is adequate if you own
100% of the business. If you were asked to be less
than a 50% owner, it may not represent an attractive
rate of return based on the spread of risks
shown. This should give an investor, a better perspective
on what the range of returns might be on
an investment.
WHAT ARE THE CHANCES??
In our example there were three main cost drivers
accounting for 75% of the costs in this particular
business. What is the probability of all three cost
drivers going against the company at any one time?
We had a little over 8000 values in this sample set
and on 9 occasions all three cost drivers were at
their worst at the same tim e. Those are pretty
good odds!
CONCLUSION
This analysis can give the user greater insight into
the risks present in his business. However, it is in
the end, only a sophisticated “what if’ analysis and
is only as good as the ranges put in. Management
still counts and reality has a way of going beyond
what we thought were the widest of possible outcomes.
If unrealistic ranges are put in for the cost
and revenue drivers then you still run the risk of falling
love with your own reflection. We highly recommend
this type of analysis anytime that management
is considering a significant investment of resources.





RISK ASSESSMENT THE NEW REALITY SHOW - To learn more about this author, visit Jim Adams's Website.

Like this article? Share it with your friends

Article Feedback
 Article Feedback No article feedback found.
  Leave Your Feedback
article feedback

Article Feedback
Dianne Crampton

Dianne Crampton is an executive leadership coach, team culture consultant, author and president of TIGERS Success Series, Inc. Dianne has been helping CEO's and Executives connect their employees to their core values and goals for over 20 years using the trademarked TIGERS team culture process, which stands for trust, interdependence, genuineness, empathy, risk and success. To download a free white paper on behaviors that build strong teams and behaviors that will predictably tear them down go here.

Dianne's contribution to the 2010 Pfeiffer Consulting Journal (an imprint of John Wiley and Sons Publishers) entitled TIGERS Hearted Teams is available in November 2009.  Her new book TIGERS Among Us: 5 Winning Business Team Cultures And Why, Three Creeks Publishing will release in March 2010.  To receive publishing discounts, subscribe to the free TigerTracks Newsletter here.

- Visit Dianne Crampton's Website


To learn more about the Evan Elite Author Program please contact us.

About The Author


Jim Adams
(Visit Jim's Website) Mr. Adams provides a wealth of experience in marketing, journalism, finance, government and general business. This well-rounded experience provides the insight to develop clear and effective strategies.

Jim Adams is a Gold author on EvanCarmichael.com
About The Author

View Author Blog
View Author Blog

View Author Video
View Author Video

Free Downloads


Jim Adams's

Complete
List Of
Marketing
Articles

Name
Email
If you enjoyed this article, get Jim Adams's Complete List of Marketing Articles For FREE!

More Jim Adams
Canadas Global Face New Market Opportunities at Home
FINANCIAL MODELLING VS SIMPLE SPREADSHEETS
RISK ASSESSMENT THE NEW REALITY SHOW
Succeeding in a Flat World How to gain an advantage when the playing field is level
Insourcing Outsourcing Grows Up
Emile Zolas 1883 Guide to Marketing
Managing Under Conditions of Uncertainty
Gen Y is Here
Integrated Marketing
Free Downloads


 
 
 


Evan Elite Authors
John Power  
John Brennan  
David Barr  
Evan Elite Authors

Become An Author
Have you written articles that would be of value to entrepreneurs? Become an expert on our site by publishing them! Expose yourself to a wide audience, drive more traffic to your website and get more sales! Click Here for details.
Become An Author

Evan's Latest Video
Modeling the Masters: Learn the true secrets behind Walt Disney's business success factors & grow your company! Video produced by Phanta Media
Evan's Latest Video

Business Opportunities
"Learn straight from Evan how you can Make a Full Time Income (And More) from a Website"

How to Start An Online Business

Click Here To Learn More
Business Opportunities



Evan's Newsletter
Get advice & tips from famous business owners, new articles by entrepreneur experts, my latest website updates, & special sneak peaks at what's to come!
Name:
Email:
Evan`s Newsletter

Free Downloads
10 Areas of Differentiation Icon 10 Areas of Differentiation
Future Networking Icon Future Networking
SEO Made Simple Sample Chapter Icon SEO Made Simple Sample Chapter
Instant Yellow Pages Icon Instant Yellow Pages
Why MLMs Fail Icon Why MLMs Fail
Free Downloads - Complete List

Entrepreneur Tools and Guides
The Top 10 GTD Times Posts - Best Posts for Productivity
The Top 10 GTD Times Posts
Best Posts for Productivity
 
Top 50 HR Blogs 2009
Top 50 HR Blogs 2009
Top 50 HR Blogs 2009
 
Entrepreneur Tools and Guides

SEO For Africa
SEO For Africa
Grace Atutu Lagos State, Nigeria,
Grace Atutu
Lagos State, Nigeria
SEO For Africa

If I Were A Startup...
Travis Hartley, 426% Growth in 2 Years
Travis Hartley
426% Growth in 2 Years
Frank Cianciulli, $2.3 to $7.5 Mil in 2 years
Frank Cianciulli
$2.3 to $7.5 Mil in 2 years
If I Were A Startup... - Complete List

Famous Entrepreneurs
Henry Heinz, HJ Heinz
Henry Heinz
HJ Heinz
Issy Sharp, Four Seasons
Issy Sharp
Four Seasons
Famous Entrepreneurs - Complete List

Entrepreneur Advice
Michael Gerber, The E Myth
Michael Gerber
The E Myth
Jack Canfield, Chicken Soup
Jack Canfield
Chicken Soup
Entrepreneur Advice - Complete List

Popular Articles
(Premium Authors)

     How Entrepreneurs will Succeed by Doing Less
By Bill Dueease
     How to Prosper Because of Your Competition
By Bill Dueease
     8 Secrets to Marketing Success
By Bill Dueease

Have A Suggestion?
Toronto Salsa Classes / Toronto Salsa Lessons Email us your ideas on how to make our website more valuable! Thank you Sharon from Toronto Salsa Lessons / Classes for your suggestions to make the newsletter look like the website and profile younger entrepreneurs like Jennifer Lopez and Sean Combs!
Have A Suggestion?

More Evan Carmichael
More Information