Access Analytic: financial modelling, management reporting and training to help companies make decisions with confidence
<IMG SRC="/images/bw_images1.gif" WIDTH=312 HEIGHT=62 usemap="#bw_images1" BORDER=0>
decisions with confidence
financial modelling, management reporting and Excel auditing services
in-house and open learning training courses
Free Excel products, templates and add-ins to download
knowledge, research and whitepapers
contact us
about us
 

Knowledge

> Knowledge Home
> White papers
> Lunch & Learn Events
> Newsletter
> Success Stories
> Article Topics:
 + Arrays (7)
 + Charts (6)
 + Data Handling (46)
 + Excel 2007 (11)
 - Financial Modelling (16)
 > Auto Outline
 > Calculating with months
 > Days in Financial Year
 > Days into the year
 > Formula auditing
 > Full Screen
 > Going Backwards
 > Grouping shortcut
 > How many months between two dates
 > IRR vs RRR vs WACC
 > Random Numbers
 > Spreadsheet Risk Factors
 > Thousands format
 > Valuing Assets & Cash Flows
 > View range names
 > Week Numbers
 + Formatting (41)
 + Functions (54)
 + Keyboard (13)
 + Mouse (12)
 + Printing (17)
 + VBA - Macros (17)

"For myself I am an optimist--it does not seem to be much use being anything else."

-- Sir Winston Churchil

 
 

Newsletter: Sample

 

IRR vs RRR vs WACC

What is the difference between IRR, WACC and RRR?

By Jeff Robson, 20 Jul 10

IRR is the internal rate of return. RRR is the required rate of return.

1. IRR

The IRR is simply the discount rate, which, when applied to a series of cashflows, gives a net present value (NPV) of zero.

i.e. NPV(IRR, [cashflows]) = 0

Normally there's just one IRR however, in some instances, there's no IRR, sometimes there are two IRR's (more on this in another article).

2. RRR

The RRR (or hurdle rate) is the return a company requires on its projects in order to proceed with them. This is a fairly arbitrary number and differs from company to company. It is not necessarily related to the cost of funds.

Put another way, if NPV(RRR, [cashflows]) > 0 for a given project then that project passes the required rate of return (RRR) test and may be evaluated further.

If NPV(RRR, [cashflows]) < 0 the project could still be a great project and generate value for shareholders, but it doesn't pass the company's required rate of return test.

3. WACC

The Weighted Average Cost of Capital (WACC) represents the average cost of funds for a company. Companies must get capital from investors and/or debt providers.

Both have many options as to where they will invest/lend their funds and as such, they weigh up the risks and potential returns offered by a company.

As a result, companies must offer to pay a rate of return (dividend or interest) commensurate with the risk borne by investors or debt providers.

If NPV(WACC, [cashflows]) > 0 then the project generates returns that exceed the company's cost of capital i.e. the project generates value. The opposite is also true.

Normally: WACC < RRR

The IRR can take any value.

Learn more:
Financial Modelling Training

Invest for Excel - financial modelling software

Print this article></a> <a href=Print  E-mail this article Email Share:      

Be the First to Comment!

Comment Title:*
Comments:*
Comments may be edited for clarity, relevance or brevity.
Only <b> and <i> HTML tags recognised. Spam etc will not be published.
First Name:*
Last Name:*
E-mail:*  
(not displayed publicly)
Location: (optional)
Options: Remember me
Notify me when other comments on this article are published
Anti-spam:*

MathGuard security question, please solve:

88P         G5C      
  I    5    2     5N6
DBC   K6I   5C6      
  H    X    9 8   XDG
7QK         EXB      
 
 Privacy Policy | Terms & Conditions
top


Copyright © Access Analytic Solutions Pty Ltd 2002-2010 ACN 091 625 697. All rights reserved.
Access Analytic® and its logo are registered trademarks of Access Analytic Solutions Pty Ltd
Ground Floor, Unit 110/131 Adelaide Tce, East Perth WA 6004, Australia. Phone +61 8 6210 8500

Excel® is a registered trademark of Microsoft Corporation

Javascript must be enabled to use this site as all e-mail addresses have been encrypted
to protect against spam-bots. You can use this free tool too!