1. Catalog
  2. Finance
  3. Return On Investment (ROI)
  4. EXCESS IRR Excel Model
EXCESS IRR Excel Model
  • EXCESS IRR Excel Model
  • EXCESS IRR Excel Model
  • EXCESS IRR Excel Model
Originally published: 23/05/2018 08:06
Publication number: ELQ-76804-1
View all versions & Certificate
certified

EXCESS IRR Excel Model

The model computes the EXCESS IRR for a set of cashflows at distinct cashflow dates above the market returns.

Satish Ramanathanby Satish Ramanathan
Quantitative AnalystFollow 15
811 views|Start the discussion!|Bookmark Add to cart - $10.00
net asset valueinternal rate of returnalphaexcess irr
Description
The model computes the EXCESS IRR for a set of cashflows at distinct cashflow dates above the market returns. This metric is calculated using secant method ( a numerical method) and validated using Goal Seek for a set of cash flows and market indices.

This Best Practice includes
1 Excel Model

Acquire business license for $10.00

Add to cart

Add to bookmarks

Discuss

Further information

To calculate the above market return of a investment with distinct cashflows at set dates

Return objectives of an investment, performance metric of an investment manager and to truly get the excess return over and above a reference market index.


0.0 / 5 (0 votes)

please wait...