","image":{"@type":"ImageObject","@id":"https://platodata.net/how-smart-private-equity-managers-getting-their-performance-reporting-deciphering-irr/#primaryimage","url":"https://platodata.net/wp-content/uploads/2020/08/how-smart-private-equity-managers-getting-their-performance-reporting-deciphering-irr.jpg","width":290,"height":174},"primaryImageOfPage":{"@id":"https://platodata.net/how-smart-private-equity-managers-getting-their-performance-reporting-deciphering-irr/#primaryimage"},"datePublished":"2017-11-15T12:37:00+00:00","dateModified":"2017-11-15T12:37:00+00:00"},{"@type":"Article","@id":"https://platodata.net/how-smart-private-equity-managers-getting-their-performance-reporting-deciphering-irr/#article","isPartOf":{"@id":"https://platodata.net/how-smart-private-equity-managers-getting-their-performance-reporting-deciphering-irr/#webpage"},"author":{"@id":"https://platodata.net/author/plato/#author"},"headline":"How Smart Private Equity Managers Getting their Performance Reporting – Deciphering IRR!","datePublished":"2017-11-15T12:37:00+00:00","dateModified":"2017-11-15T12:37:00+00:00","commentCount":0,"mainEntityOfPage":{"@id":"https://platodata.net/how-smart-private-equity-managers-getting-their-performance-reporting-deciphering-irr/#webpage"},"publisher":{"@id":"https://platodata.net/#organization"},"articleSection":"Private Equity, private-equity","image":{"@type":"ImageObject","@id":"https://platodata.net/how-smart-private-equity-managers-getting-their-performance-reporting-deciphering-irr/#primaryimage","url":"https://platodata.net/wp-content/uploads/2020/08/how-smart-private-equity-managers-getting-their-performance-reporting-deciphering-irr.jpg","width":290,"height":174}},{"@type":"Person","@id":"https://platodata.net/author/plato/#author","name":"Republished by Plato","sameAs":[],"image":{"@type":"ImageObject","@id":"https://platodata.net/#personlogo","url":"https://secure.gravatar.com/avatar/e2e75f1ad4f45751196ea73f5f6d1b65?s=96&d=wp_user_avatar&r=g","width":96,"height":96,"caption":"Republished by Plato"}},{"@type":"BreadcrumbList","@id":"https://platodata.net/how-smart-private-equity-managers-getting-their-performance-reporting-deciphering-irr/#breadcrumblist","itemListElement":[{"@type":"ListItem","position":1,"item":{"@type":"WebPage","@id":"https://platodata.net/","url":"https://platodata.net/","name":"PlatoData.net"}},{"@type":"ListItem","position":2,"item":{"@type":"WebPage","@id":"https://platodata.net/how-smart-private-equity-managers-getting-their-performance-reporting-deciphering-irr/","url":"https://platodata.net/how-smart-private-equity-managers-getting-their-performance-reporting-deciphering-irr/","name":"How Smart Private Equity Managers Getting their Performance Reporting - Deciphering IRR!"}}]}]}
Connect with us

Private Equity

How Smart Private Equity Managers Getting their Performance Reporting – Deciphering IRR!

PE Performance on Excel- Rocks You Like a Hurricane!

For a Private Equity Fund like any other business Performance Measurement remains the key focal point apart from other important aspects of business like raising the fund, valuations, deal making, compliances etc.

It is important for both, the GP’s who would like to choose upon the metric which can project the fund as top quartile and for the LP’s who would like to dig with other metrics to reach to the actual evaluation of their investments and returns, for their investment decisions!
The fund performance evaluations hold an equal interest with investment advisers who would be interested in knowing more than just the performance of a particular project but would be interested in comparing these investments with other funds which bring in the complexity as there are challenges like comparing an apple to apple to reach a logical conclusion. The challenges arise due to the size of the different projects being compared, geographies, their mutual exclusivity quotients, different investment strategies, the industry verticals identified for the investments, the structure of the funds being compared to list a few. These entail the compelling need for different metrics being employed to asses the performance of different projects and compare the fund performances.
Like it or not but the fact remains, that there are no benchmark metrics as industry standard to evaluate the Private equity fund performance measurement. This makes it a subjective matter, and an individual’s choice to have his own set of metrics to be employed intelligently with each individual fund to understand the performance. The most common measures in the industry to report the fund performance with the GP’s remain IRR which has its own strengths and weaknesses, and may not accurately be able to depict the actual returns of the funds due to the assumptions employed, but so remains the challenges with the other approaches like MIRR, Money Multiples (DPI, RVPI & TVPI which are often reported by the funds), PME or PME+.
Though none of the methods described above can in isolation give a complete picture of PE performance, nor is there a single ‘right’ way to measure it. One of the challenges associated with this is the fact that managers can claim to be “top quartile” by creatively choosing benchmarks that position themselves favourably.  LP needs to fully understand the constituents of any benchmark that a manager is using in order to fully assess the relevance to the manager’s strategy, in addition there are potentially significant biases in the available benchmark data.
There are also many questions around the detail behind the performance metrics. Like whether cash-on-cash multiples are more meaningful than IRRs, how to gauge impressive performance as a result of unrealised versus realised results, the impact of the “J-curve” and the gross to net performance spread.
While the performance measurement techniques described above are a useful tool for assessing PE fund performance, individual investors need to decide which metrics are most appropriate for each situation. Though the comparison of performance statistics is very important for intelligent investment decisions, it is not the end of the road but extends beyond to detailed analyses such as value creation attribution, capital efficiency including the gross-to-net ratio, consistency over multiple time periods and individual analyses focusing on sectors, geographies, sizes, types and key professionals.
Let us take a deeper dive into reporting for evaluating the fund performance and comparison of the funds which go along way into intelligent investment decisions and analysis to ensure success for the fund managers and investors alike.
IRR remains the favorite with Private equity industry as one of the top metric to report and to compare the performances of funds and their fund managers, despite the known pitfalls and shortcomings.
Let’s focus on the challenges which are encountered by the stakeholders of private equity with calculations of IRR of a fund and the individual projects which remain a key performance indicator metric, in conjunction with other important metrics like money multiples and PME & PME+ which are de-facto industry reporting practices when it comes to the Private equity fund performance and evaluations.
IRR calculations are simple and based on the mathematical formula and can be easily calculated with the help of computer and spreadsheet, is how generally it is spoken about but, still the reporting possesses the challenge! For the right picture of the fund performance to emerge it is imperative that the calculations of IRR are dealt with utmost care keeping in mind the inherent shortcomings of the metric itself generally arising due to the assumption on which it is based – The distributed cash is reinvested back at the same IRR. The cash flow over the period of time taken into account for arriving at the IRR may at times lead to skewed results which may not be intentional or planned most of the times. It also depends on the process, methodology employed and collected data taken into account to reach the right meaningful IRR values.
As IRR is solving the polynomial, at times can have more than one value of IRR satisfying the equation and one can land up with multiple values which are both positive and negative! Also there can be case when the cash flow is negative and yet IRR is positive, these situations arise due to the mathematical formula employed to solve the polynomial on spreadsheet. Consolidation of quarterly IRR to arrive at annual IRR, When computed and aggregated throws different values and are not the same as the time value of money comes into play The quarterly and annual IRR’s will not be the same because of dates of the cash flows change. This is where the acumen of the fund manager is to be employed. We have two functions on excel which are employed to reach the solution the IRR function(For cash flows at regular intervals a dream coming true for any fund manager) and XIRR function(which allows for the irregular time interval to be taken into account to make the calculations), nevertheless the perennial anomalies like the one listed below remain unsolved in the Excel and keep posing challenges for the asset managers and keep giving them headaches.
The #NUM ERROR
  • The IRR function will give a #NUM! error when it takes more than 20 iterations to find the discount rate (IRR)
  • Also if the IRR function does not find at-least one positive and one negative cash flow, it would again throw #NUM! error Unfortunately there isn’t a solution to this problem while solving on excel.
Multiple IRR – In case the IRR formula encounters multiple IRRs it would return the IRR value which is closer to the guess.
  • If the first cash flow isn’t negative, the IRR will have more than one solution, and Excel will only display the first one which it finds.
  • Similarly, each time the cash flow changes from negative to positive, another possible solution for the IRR is created and Excel will only display the first one which it finds.
  • The Function on Excel for calculations of IRR, allows the Expected IRR argument which can be passed and is optional. In cases where it is not specified it assumes it to be 10% by default. Reaching a right value depends on your passed expected rate of return to make the calculations and reach the genuine values. So again the problem’s solution lies in the judgemental plane then on the fixed rules and the better the guess more accurate are the results!
Cash Flow intervals
  • One has to be vigilant and keep a check while working on excel as to what are the cash flows like, that is to say if they are at equal intervals or if they can be assumed to be happening at equal intervals then and only then your IRR function on excel shall give you the right results.
  • However most of the times the cash flow intervals are not equal and in such cases one should always resort to using XIRR function on the excel. Ahh pain remembering it all the times isn’t it? Ones again solving on excel you have no option but follow this.
  • For excel to be able to successfully calculate the IRR it should have minimum one +ve cash flow and one -ve cash flow, with a negative cash flow in the starting or at the zeroth instance on the timeline of the cash flow.
False Solution
  • Even if net cash flows are negative, Excel can produce a positive IRR.
  • If cashflows don’t occur in the ‘correct’ order, i.e. negative followed by positive, then the IRR produced can be false. For example, if cash flows at the beginning of a project are small and positive, and at the end of the project are large and negative, the IRR will necessarily need to be high to reduce the net present value of the later cash flows.
Operational Difficulties in Handling with Excel
  • Gathering Updated Comprehensive Cash Flows – Every time a latest IRR has to be calculated most Excel sheets require updation of cash flows, a tedious, error prone, time consuming process. This requires constant reconciliation to source of data. Adding a new Asset, missing cash cash flows from Asset, updating cash flows that changed during course of business, are some of the critical tasks that can give jitters to even a highly skilled Excel specialist.
  • Size Does Matter –  For Funds that have investment sizes of over 20 Assets and more than a year’s worth of cash flows, this task of organizing and maintaining a spreadsheet becomes a full time effort of a prized resource. It is further compounded by the fact that cash flows for many instruments including fixed income assets or credit assets happen at the end of a month or quarter which is also the time the IRR’s need to be published. The timeframes for getting the results are compressed. This leads to accuracy issues and missed cash flows.
  • Slice and Dice IRR Returns on Excel? You must be Kidding – This is the dream of any Portfolio Manager, virtually impossible to bring to reality with Excel! Most IRR spreadsheets calculate IRR’s at Asset and a few pre-designed aggregated levels like a strategy or an industry. Any changes to this spreadsheet can spell doom with weeks activity to sometimes a month long saga.
  • Assets crossing multiple Portfolios – The assets crossing multiple portfolios could result from myriad of reasons including reorganization of a fund, portfolio allocation, new strategies, merging assets from a warehouse facility etc. Each of these situation pose challenges combining and putting together the cash flows. The resulting IRR’s can further be complicated by requirement of performance allocations. Such situations require dedicated efforts and can be done seldomly on Excel.
  • Deals with many complex assets – It is a herculean task for an analyst to know all the cash flows and the deals in granular details comprising of multiple assets. These assets undergo complex reorganizations like mergers or splits which leads to further complexities and is a nightmare for even an expert on Excel to run up IRR’s on such deals!
What can be a possible solutions to the problems or the workarounds, for a few listed above there are hardly any solutions with excel and the workarounds for the others may not be viable solutions when the size of the fund grows.
There are a few solutions available in the market, which have been specifically targeted at IRR reporting, but none of the solutions have a more comprehensive approach than Pepper which has the most robust IRR engine.

Pepper Solutions

Pepper’s IRR engine is a robust technology platform that keeps the golden source of all the historical and current cash flows creating a near perfect, no hassle calculation engine that can allow a user to slice and dice a portfolio and still create an accurate IRR. Here are five complex scenarios where the Pepper IRR engine helps in Performance reporting:
  1. Gathering Updated Comprehensive Cash Flows – Most Excel sheets need to update cash flows when the latest IRR’s has to be calculated. This is a tedious, time consuming process and invariably has multiple errors. It further requires constant reconciliation to source of data. Gathering the details of every single cash flow and organizing it on any spreadsheet is a chore not relished by any middle office manager. Adding a new Asset, missing cash cash flows from Asset, updating cash flows that changed during course of business, are some of the critical tasks that require extreme efforts even for a highly skilled Excel specialist. Pepper’s IRR engine can traverse the history of every investment, and gather all the applicable cash flows in an automated rules based way, that totally eliminates the tedious chore of gathering the cash flows.
  2. Size Does Matter! Nay not with Pepper- For Funds that have investment sizes of over 20 Assets and more than a year’s worth of cash flows, this task of organizing and maintaining a spreadsheet becomes a full time effort of a prized resource. It is further compounded by the fact that cash flows for many instruments including fixed income assets or credit assets happen at the end of a month or quarter which is also the time the IRR’s need to be published. The timeframes for getting the results are compressed. This leads to accuracy issues and missed cash flows. Pepper’s IRR engine can take a portfolio of any size and create IRR’s instantly using its cloud based compute engines
  3. Slice and Dice IRR Returns – It’s a child’s play on Pepper- This is the dream of any Portfolio Manager, which till Pepper came along, was not even possible. Most IRR spreadsheets calculate IRR’s at Asset and a few pre-designed aggregated levels like a strategy or an industry. Any changes to this spreadsheet is a week sometimes a month long investment. Consider the scenario an Asset Manager needs to add a new strategy to his portfolio, retag all assets that are affected and create IRR for each of the new strategy. It’s a weeks worth of effort just to add this strategy to a spreadsheet. Pepper relishes these opportunities giving Asset Managers the flexibility to “play” with the portfolios and slice and dice it with any level of aggregation.
  4. Assets crossing multiple Portfolios! Let them – There are complex cases in a Portfolio when assets would be crossing multiple portfolio. This could be due to a myriad of reasons including reorganization of a fund, portfolio allocation, new strategies, merging assets from a warehouse facility etc. Each of these situations create challenges in combining and putting together cash flows. There may be requirements for performance allocations which may complicate the resulting IRRs. Most of these situations require dedicated effort and can be done only a few times. This is another situation where Pepper’s engine crushes the challenge and can be used to address every such situation.
  5. Deals with many complex assets, But that’s what Pepper is there for – Portfolio Managers think in deals and these deals can have a number of assets. That private assets have complex valuation structures and cash flows is given. But what also happens is these assets undergo highly complex reorganizations including mergers or splits, morphing them further. All of these activities create complex challenges for putting together cash flows and returns. Not only must the analyst know all about the cash flows he needs to know about the deal in very granular detail. Pepper manages these situations smoothly and can run up IRRs for the Deal with no intervention.
These are a few listed of many challenges which Pepper handles. To learn more  Book Your Live Demo Now or write us at info@onpepper.com
or call us +1-732-735-1491 We are listening















Co-Author: Vivek Saxena                                                                        Co-Author: Pulak Sinha
India Head On Pepper LLC                                                                      Founder CEO On Pepper LLC
New York, NY, USA                                                                                 New York, NY, USA


Avatar

Published

on

PE Performance on Excel- Rocks You Like a Hurricane!

For a Private Equity Fund like any other business Performance Measurement remains the key focal point apart from other important aspects of business like raising the fund, valuations, deal making, compliances etc.

It is important for both, the GP’s who would like to choose upon the metric which can project the fund as top quartile and for the LP’s who would like to dig with other metrics to reach to the actual evaluation of their investments and returns, for their investment decisions!
The fund performance evaluations hold an equal interest with investment advisers who would be interested in knowing more than just the performance of a particular project but would be interested in comparing these investments with other funds which bring in the complexity as there are challenges like comparing an apple to apple to reach a logical conclusion. The challenges arise due to the size of the different projects being compared, geographies, their mutual exclusivity quotients, different investment strategies, the industry verticals identified for the investments, the structure of the funds being compared to list a few. These entail the compelling need for different metrics being employed to asses the performance of different projects and compare the fund performances.
Like it or not but the fact remains, that there are no benchmark metrics as industry standard to evaluate the Private equity fund performance measurement. This makes it a subjective matter, and an individual’s choice to have his own set of metrics to be employed intelligently with each individual fund to understand the performance. The most common measures in the industry to report the fund performance with the GP’s remain IRR which has its own strengths and weaknesses, and may not accurately be able to depict the actual returns of the funds due to the assumptions employed, but so remains the challenges with the other approaches like MIRR, Money Multiples (DPI, RVPI & TVPI which are often reported by the funds), PME or PME+.
Though none of the methods described above can in isolation give a complete picture of PE performance, nor is there a single ‘right’ way to measure it. One of the challenges associated with this is the fact that managers can claim to be “top quartile” by creatively choosing benchmarks that position themselves favourably.  LP needs to fully understand the constituents of any benchmark that a manager is using in order to fully assess the relevance to the manager’s strategy, in addition there are potentially significant biases in the available benchmark data.
There are also many questions around the detail behind the performance metrics. Like whether cash-on-cash multiples are more meaningful than IRRs, how to gauge impressive performance as a result of unrealised versus realised results, the impact of the “J-curve” and the gross to net performance spread.
While the performance measurement techniques described above are a useful tool for assessing PE fund performance, individual investors need to decide which metrics are most appropriate for each situation. Though the comparison of performance statistics is very important for intelligent investment decisions, it is not the end of the road but extends beyond to detailed analyses such as value creation attribution, capital efficiency including the gross-to-net ratio, consistency over multiple time periods and individual analyses focusing on sectors, geographies, sizes, types and key professionals.
Let us take a deeper dive into reporting for evaluating the fund performance and comparison of the funds which go along way into intelligent investment decisions and analysis to ensure success for the fund managers and investors alike.
IRR remains the favorite with Private equity industry as one of the top metric to report and to compare the performances of funds and their fund managers, despite the known pitfalls and shortcomings.
Let’s focus on the challenges which are encountered by the stakeholders of private equity with calculations of IRR of a fund and the individual projects which remain a key performance indicator metric, in conjunction with other important metrics like money multiples and PME & PME+ which are de-facto industry reporting practices when it comes to the Private equity fund performance and evaluations.
IRR calculations are simple and based on the mathematical formula and can be easily calculated with the help of computer and spreadsheet, is how generally it is spoken about but, still the reporting possesses the challenge! For the right picture of the fund performance to emerge it is imperative that the calculations of IRR are dealt with utmost care keeping in mind the inherent shortcomings of the metric itself generally arising due to the assumption on which it is based – The distributed cash is reinvested back at the same IRR. The cash flow over the period of time taken into account for arriving at the IRR may at times lead to skewed results which may not be intentional or planned most of the times. It also depends on the process, methodology employed and collected data taken into account to reach the right meaningful IRR values.
As IRR is solving the polynomial, at times can have more than one value of IRR satisfying the equation and one can land up with multiple values which are both positive and negative! Also there can be case when the cash flow is negative and yet IRR is positive, these situations arise due to the mathematical formula employed to solve the polynomial on spreadsheet. Consolidation of quarterly IRR to arrive at annual IRR, When computed and aggregated throws different values and are not the same as the time value of money comes into play The quarterly and annual IRR’s will not be the same because of dates of the cash flows change. This is where the acumen of the fund manager is to be employed. We have two functions on excel which are employed to reach the solution the IRR function(For cash flows at regular intervals a dream coming true for any fund manager) and XIRR function(which allows for the irregular time interval to be taken into account to make the calculations), nevertheless the perennial anomalies like the one listed below remain unsolved in the Excel and keep posing challenges for the asset managers and keep giving them headaches.
The #NUM ERROR
  • The IRR function will give a #NUM! error when it takes more than 20 iterations to find the discount rate (IRR)
  • Also if the IRR function does not find at-least one positive and one negative cash flow, it would again throw #NUM! error Unfortunately there isn’t a solution to this problem while solving on excel.
Multiple IRR – In case the IRR formula encounters multiple IRRs it would return the IRR value which is closer to the guess.
  • If the first cash flow isn’t negative, the IRR will have more than one solution, and Excel will only display the first one which it finds.
  • Similarly, each time the cash flow changes from negative to positive, another possible solution for the IRR is created and Excel will only display the first one which it finds.
  • The Function on Excel for calculations of IRR, allows the Expected IRR argument which can be passed and is optional. In cases where it is not specified it assumes it to be 10% by default. Reaching a right value depends on your passed expected rate of return to make the calculations and reach the genuine values. So again the problem’s solution lies in the judgemental plane then on the fixed rules and the better the guess more accurate are the results!
Cash Flow intervals
  • One has to be vigilant and keep a check while working on excel as to what are the cash flows like, that is to say if they are at equal intervals or if they can be assumed to be happening at equal intervals then and only then your IRR function on excel shall give you the right results.
  • However most of the times the cash flow intervals are not equal and in such cases one should always resort to using XIRR function on the excel. Ahh pain remembering it all the times isn’t it? Ones again solving on excel you have no option but follow this.
  • For excel to be able to successfully calculate the IRR it should have minimum one +ve cash flow and one -ve cash flow, with a negative cash flow in the starting or at the zeroth instance on the timeline of the cash flow.
False Solution
  • Even if net cash flows are negative, Excel can produce a positive IRR.
  • If cashflows don’t occur in the ‘correct’ order, i.e. negative followed by positive, then the IRR produced can be false. For example, if cash flows at the beginning of a project are small and positive, and at the end of the project are large and negative, the IRR will necessarily need to be high to reduce the net present value of the later cash flows.
Operational Difficulties in Handling with Excel
  • Gathering Updated Comprehensive Cash Flows – Every time a latest IRR has to be calculated most Excel sheets require updation of cash flows, a tedious, error prone, time consuming process. This requires constant reconciliation to source of data. Adding a new Asset, missing cash cash flows from Asset, updating cash flows that changed during course of business, are some of the critical tasks that can give jitters to even a highly skilled Excel specialist.
  • Size Does Matter –  For Funds that have investment sizes of over 20 Assets and more than a year’s worth of cash flows, this task of organizing and maintaining a spreadsheet becomes a full time effort of a prized resource. It is further compounded by the fact that cash flows for many instruments including fixed income assets or credit assets happen at the end of a month or quarter which is also the time the IRR’s need to be published. The timeframes for getting the results are compressed. This leads to accuracy issues and missed cash flows.
  • Slice and Dice IRR Returns on Excel? You must be Kidding – This is the dream of any Portfolio Manager, virtually impossible to bring to reality with Excel! Most IRR spreadsheets calculate IRR’s at Asset and a few pre-designed aggregated levels like a strategy or an industry. Any changes to this spreadsheet can spell doom with weeks activity to sometimes a month long saga.
  • Assets crossing multiple Portfolios – The assets crossing multiple portfolios could result from myriad of reasons including reorganization of a fund, portfolio allocation, new strategies, merging assets from a warehouse facility etc. Each of these situation pose challenges combining and putting together the cash flows. The resulting IRR’s can further be complicated by requirement of performance allocations. Such situations require dedicated efforts and can be done seldomly on Excel.
  • Deals with many complex assets – It is a herculean task for an analyst to know all the cash flows and the deals in granular details comprising of multiple assets. These assets undergo complex reorganizations like mergers or splits which leads to further complexities and is a nightmare for even an expert on Excel to run up IRR’s on such deals!
What can be a possible solutions to the problems or the workarounds, for a few listed above there are hardly any solutions with excel and the workarounds for the others may not be viable solutions when the size of the fund grows.
There are a few solutions available in the market, which have been specifically targeted at IRR reporting, but none of the solutions have a more comprehensive approach than Pepper which has the most robust IRR engine.

Pepper Solutions

Pepper’s IRR engine is a robust technology platform that keeps the golden source of all the historical and current cash flows creating a near perfect, no hassle calculation engine that can allow a user to slice and dice a portfolio and still create an accurate IRR. Here are five complex scenarios where the Pepper IRR engine helps in Performance reporting:
  1. Gathering Updated Comprehensive Cash Flows – Most Excel sheets need to update cash flows when the latest IRR’s has to be calculated. This is a tedious, time consuming process and invariably has multiple errors. It further requires constant reconciliation to source of data. Gathering the details of every single cash flow and organizing it on any spreadsheet is a chore not relished by any middle office manager. Adding a new Asset, missing cash cash flows from Asset, updating cash flows that changed during course of business, are some of the critical tasks that require extreme efforts even for a highly skilled Excel specialist. Pepper’s IRR engine can traverse the history of every investment, and gather all the applicable cash flows in an automated rules based way, that totally eliminates the tedious chore of gathering the cash flows.

  2. Size Does Matter! Nay not with Pepper- For Funds that have investment sizes of over 20 Assets and more than a year’s worth of cash flows, this task of organizing and maintaining a spreadsheet becomes a full time effort of a prized resource. It is further compounded by the fact that cash flows for many instruments including fixed income assets or credit assets happen at the end of a month or quarter which is also the time the IRR’s need to be published. The timeframes for getting the results are compressed. This leads to accuracy issues and missed cash flows. Pepper’s IRR engine can take a portfolio of any size and create IRR’s instantly using its cloud based compute engines
  3. Slice and Dice IRR Returns – It’s a child’s play on Pepper- This is the dream of any Portfolio Manager, which till Pepper came along, was not even possible. Most IRR spreadsheets calculate IRR’s at Asset and a few pre-designed aggregated levels like a strategy or an industry. Any changes to this spreadsheet is a week sometimes a month long investment. Consider the scenario an Asset Manager needs to add a new strategy to his portfolio, retag all assets that are affected and create IRR for each of the new strategy. It’s a weeks worth of effort just to add this strategy to a spreadsheet. Pepper relishes these opportunities giving Asset Managers the flexibility to “play” with the portfolios and slice and dice it with any level of aggregation.
  4. Assets crossing multiple Portfolios! Let them – There are complex cases in a Portfolio when assets would be crossing multiple portfolio. This could be due to a myriad of reasons including reorganization of a fund, portfolio allocation, new strategies, merging assets from a warehouse facility etc. Each of these situations create challenges in combining and putting together cash flows. There may be requirements for performance allocations which may complicate the resulting IRRs. Most of these situations require dedicated effort and can be done only a few times. This is another situation where Pepper’s engine crushes the challenge and can be used to address every such situation.
  5. Deals with many complex assets, But that’s what Pepper is there for – Portfolio Managers think in deals and these deals can have a number of assets. That private assets have complex valuation structures and cash flows is given. But what also happens is these assets undergo highly complex reorganizations including mergers or splits, morphing them further. All of these activities create complex challenges for putting together cash flows and returns. Not only must the analyst know all about the cash flows he needs to know about the deal in very granular detail. Pepper manages these situations smoothly and can run up IRRs for the Deal with no intervention.
These are a few listed of many challenges which Pepper handles. To learn more  Book Your Live Demo Now or write us at info@onpepper.com
or call us +1-732-735-1491 We are listening















Co-Author: Vivek Saxena                                                                        Co-Author: Pulak Sinha
India Head On Pepper LLC                                                                      Founder CEO On Pepper LLC
New York, NY, USA                                                                                 New York, NY, USA


Source: http://altassetmanagmentdisrupted.blogspot.com/2017/11/Private-Equity-Performance.html

Private Equity

Boston startups expand region’s venture capital footprint

This year has shaken up venture capital, turning a hot early start to 2020 into a glacial period permeated with fear during the early days of COVID-19. That ice quickly melted as venture capitalists discovered that demand for software and other services that startups provide was accelerating, pushing many young tech companies back into growth […]

Avatar

Published

on

This year has shaken up venture capital, turning a hot early start to 2020 into a glacial period permeated with fear during the early days of COVID-19. That ice quickly melted as venture capitalists discovered that demand for software and other services that startups provide was accelerating, pushing many young tech companies back into growth mode, and investors back into the check-writing arena.

Boston has been an exemplar of the trend, with early pandemic caution dissolving into rapid-fire dealmaking as summer rolled into fall.

We collated new data that underscores the trend, showing that Boston’s third quarter looks very solid compared to its peer groups, and leads greater New England’s share of American venture capital higher during the three-month period.

For our October look at Boston and its startup scene, let’s get into the data and then understand how a new cohort of founders is cropping up among the city’s educational network.

A strong Q3, a strong 2020

Boston’s third quarter was strong, effectively matching the capital raised in New York City during the three-month period. As we head into the fourth quarter, it appears that the silver medal in American startup ecosystems is up for grabs based on what happens in Q4.

Boston could start 2021 as the number-two place to raise venture capital in the country. Or New York City could pip it at the finish line. Let’s check the numbers.

According to PitchBook data shared with TechCrunch, the metro Boston area raised $4.34 billion in venture capital during the third quarter. New York City and its metro area managed $4.45 billion during the same time period, an effective tie. Los Angeles and its own metro area managed just $3.90 billion.

In 2020 the numbers tilt in Boston’s favor, with the city and surrounding area collecting $12.83 billion in venture capital. New York City came in second through Q3, with $12.30 billion in venture capital. Los Angeles was a distant third at $8.66 billion for the year through Q3.

Source: https://techcrunch.com/2020/10/23/boston-startups-expand-regions-venture-capital-footprint/

Continue Reading

Private Equity

Alternative Investments/Real Estate: Housing Market Demand Is “Insane”

Speaking to CNBC on Power Lunch, Glenn Kelman, CEO of real estate brokerage Redfin (NASDAQ: RDFN), said he expected the current boom conditions in the housing market to last well into next year. He attributed the high demand to affluent professionals looking for remote homes as well as low interest rates. Also, he thinks some sellers will put their properties on the market only after the presidential election.

Avatar

Published

on

Alternative Investments/Real Estate: Housing Market Demand Is “Insane”

https://platodata.net/wp-content/uploads/2020/10/alternative-investments-real-estate-housing-market-demand-is-insane.jpg

Redfin CEO Glenn Kelman says the boom could last into next year.

Speaking to CNBC on Power Lunch, Glenn Kelman, CEO of real estate brokerage Redfin (NASDAQ: RDFN), said he expected the current boom conditions in the housing market to last well into next year. He attributed the high demand to affluent professionals looking for remote homes as well as low interest rates. Also, he thinks some sellers will put their properties on the market only after the presidential election. (CNBC)

Kelman: Too good to last forever

“This level of demand is absolutely insane. I would expect it to last into 2021, at least,” Kelman said.

Recent data from the National Association of Realtors shows up the strength in the housing market.

Existing home sales shot up 9.4% in September beating expectations. Even though the median purchase price of a home rose approximately 15% year over year, there is just a 2.7-month supply of for-sale homes, showing tight market inventory conditions.

The 30-year fixed-rate mortgage averaged 2.80% for the week ending Oct. 22, down from 2.81% in the previous week and 3.75% a year ago, according to the Freddie Mac Primary Mortgage Market Survey. Therefore, mortgage rates crept even lower in the latest week.

However, “there’s no way it can last forever,” Kelman warned of the bullish conditions.

Canada: Off the charts

Meanwhile, at the northern neighbor, home sales activity in September is described as “off-the-charts.”

Housing data released by the Canadian Real Estate Association (CREA) last week showed a nationwide year-over-year increase in sales of 45.6%.

This was a new all-time monthly record for the third month in a row.

“This is starting to sound like a broken record (about records being broken), but Canadian home sales and prices set records once again in September … as they did in July and August,” said Shaun Cathcart, senior economist at CREA, in a statement.

Real Estate ETFs in the U.S.

The year-to-date performance of some real estate ETFs is shown below:

iShares U.S. Home Construction ETF (ITB)              +24.61%

SPDR S&P Homebuilders ETF (XHB)                          +20.83%

Vanguard Real Estate Index Fund ETF                      -13.91%

It may be noted that despite the boom conditions in housing, real estate ETFs and stocks have declined in recent days.

According to Barron’s, this may be due to yields on the 10-year and 30-year Treasuries moving higher in recent weeks.

Other reasons could be fears of inflation ticking up in the future amidst an improving economic situation.

Nevertheless, the view is that interest rates are likely to remain low for longer. So demand may remain strong.

“Part of what is fueling this boom is that the economy has just split into two and rich people are able to access capital almost for free, so, of course, they’re going to use that money to buy homes,” said Redfin’s Kelman.

Related Story:   Mortgage Rates Set Another Record Low; Real Estate ETFs Could Benefit

Free Industry News

Subscribe to our free newsletter for updates and news about alternatives investments.

Shape

Latest Alternative Investment News

Source: https://dailyalts.com/alternative-investments-real-estate-housing-market-demand-is-insane/

Continue Reading

Private Equity

Asda’s new owner EG Group seeks new leadership ahead of IPO – report

EG Group is owned by the billionaire Issa brothers and the private equity firm TDR Capital, who teamed up for a £6.8 billion takeover of Asda last month

Avatar

Published

on

UK grocer Asda Group’s new owner EG Group is looking for a new chairman and independent directors as it prepares for a £10bn initial public offering, The Timesreports.

EG Group is owned by the billionaire Issa brothers and the private equity firm TDR Capital, who teamed up for a £6.8 billion takeover of Asda last month.

The move comes after Deloitte resigned last week as the company’s auditor because of concerns over the group’s governance and lack of internal controls, according to the publication.

A decision on candidates will be taken before the end of this year, although roles haven’t been finalised yet as the company is in the process of deciding whether to float in the UK or the US, The Times reports.

Write to Barcelona editors at barcelonaeditors@dowjones.com

From Dow Jones Newswires

Source: https://www.penews.com/articles/asdas-new-owner-eg-group-seeks-new-leadership-ahead-of-ipo-reports-20201023

Continue Reading
Saas21 mins ago

Saas21 mins ago

Saas21 mins ago

Saas21 mins ago

Saas21 mins ago

Saas21 mins ago

Saas21 mins ago

Saas21 mins ago

Saas21 mins ago

Saas21 mins ago

Press Releases41 mins ago

ROSEN, A RESPECTED AND LEADING FIRM, Reminds LexinFintech Holdings Ltd. Investors of Important Deadline in Securities Class Action Lawsuit First Filed by the Firm – LX

Press Releases42 mins ago

Huawei spouští služby Petal Search, Petal Maps, HUAWEI Docs a další

Press Releases1 hour ago

LA CASA DE LOS ASESINATOS DE “AMERICAN HORROR STORY” SE ABRE AL PÚBLICO POR PRIMERA VEZ PARA LA TRANSMISIÓN EN VIVO DEL FIN DE SEMANA PARANORMAL DE HALLOWEEN

Press Releases1 hour ago

“AMERICAN HORROR STORY” MURDER HOUSE ABRE PARA O PÚBLICO PELA PRIMEIRA VEZ PARA UM FIM DE SEMANA DE HALLOWEEN PARANORMAL AO VIVO

Press Releases2 hours ago

Dunkin’ & Area Rotary Districts Raise More Than $1.2 Million Throughout Alabama & Tennessee Benefitting End Polio Now

Startup2 hours ago

The US Navy stealth destroyer Zumwalt successfully fire off an SM-2 missile for the first time

Saas4 hours ago

Saas4 hours ago

Saas4 hours ago

Saas4 hours ago

Saas4 hours ago

Saas4 hours ago

Saas4 hours ago

Saas4 hours ago

Saas4 hours ago

Saas4 hours ago

Startup4 hours ago

Dr. Fauci says it might be time to mandate masks as coronavirus cases surge across the US

Venture Capital4 hours ago

The Startup Trap Quibi Fell Into (and I Almost Did Too)

Press Releases5 hours ago

Tata Consultancy Services (TCS) Partners With dotin Inc. to Create Workforce Insight Solution

Startup6 hours ago

David Barrett, founder and CEO of San Francisco tech company Expensify, emailed 10 million customers urging them to vote for Biden and stop Evil Trump

Startup6 hours ago

Tired of searching jobs near me on the internet? 6 tips to find jobs near you quickly

Press Releases6 hours ago

TK60 Eliminates Human Coronavirus In 30 Seconds, 4x Faster Than Lysol, Independent Laboratory Confirms

Press Releases6 hours ago

(GOCO) ALERT: GoHealth Investors Reminded of Class Action Deadline; Investors with Losses Over $100,000 Encouraged to Contact Firm – Johnson Fistel, LLP

Press Releases7 hours ago

“World’s Firsts” Catching Eyes at Asia’s Largest Medical Equipment Exhibition

Saas7 hours ago

Saas7 hours ago

Saas7 hours ago

Saas7 hours ago

Saas7 hours ago

Saas7 hours ago

Trending