Scroll down to unravel the story

Risky Business
What Private Capital Firms
Need to Know about

Using Spreadsheets

For Portfolio Monitoring

Spreadsheets help private capital firms and investors track investments and make key decisions. But how reliable are they? Here’s what you need to know about the risks and how to minimize them when using spreadsheets to manage investment data.

Recent Spreadsheet Blunders

Cut-and-Paste Error

TransAlta

trading losses

$24

million

Coding Error

AXA Rosenburg

Investor settlements and SEC fines

$242

million

Spreadsheet Error

Fannie Mae

overstatement of profitability

$1.3

billion

Missing Minus Sign

Fidelity

overstatement of profitability

$2.4

billion

Spreadsheet Error

JPMorgan Chase

trading losses

$6.2

billion

Nearly 3 in 4 private capital firms use spreadsheets to collect and analyze portfolio company data, but...

Did You Know?

Those Spreadsheet Errors can appear in...

Investor Reports

Valuation Models

Regulatory Filings

The Result:

Private capital firms may impact their credibility in front of investors and regulators.

Watch Out

For These 3 Top Risks

Top 3

Ways to reduce errors

3 More reporting best practices for private capital

Risky Business
What Private Capital Firms
Need to Know about

Using Spreadsheets

For Portfolio Monitoring

Spreadsheets help private capital firms and investors track investments and make key decisions. But how reliable are they? Here’s what you need to know about the risks and how to minimize them when using spreadsheets to manage investment data.

Recent Spreadsheet Blunders

Cut-and-Paste Error

TransAlta

trading losses

$24

million

Coding Error

AXA Rosenburg

Investor settlements and SEC fines

$242

million

Spreadsheet Error

Fannie Mae

overstatement of profitability

$1.3

billion

Missing Minus Sign

Fidelity

overstatement of profitability

$2.4

billion

Spreadsheet Error

JPMorgan Chase

trading losses

$6.2

billion

Nearly 3 in 4 private capital firms use spreadsheets to collect and analyze portfolio company data, but...

Did You Know?

Those Spreadsheet Errors can appear in...

Investor Reports

Valuation Models

Regulatory Filings

The Result:

Private capital firms may impact their credibility in front of investors and regulators.

Watch Out

For These 3 Top Risks

Top 3

Ways to reduce errors

Reporting best practices for private capital

Recent Spreadsheet Blunders / Did You Know? / Top Risks / Ways to Reduce Errors / Reporting Best Practices

Scroll down to unravel the story

Risky Business:

What Private Capital Firms

Need to Know About

Using Spreadsheets

For Portfolio Monitoring

Spreadsheets help private capital firms and investors track investments and make key decisions. But how reliable are they? Here’s what you need to know about the risks and how to minimize them when using spreadsheets to manage investment data.

Recent Spreadsheet Blunders

Cut-and-Paste Error

$24million

Trans Altatrading
losses

Coding Error

$242million

AXA Rosenburginvestor settlements and SEC filings

Spreadsheet Error

$1.3billion

Fannie Maeoverstatement of profitability

Missing Minus Sign

$2.4billion

Fidelityoverstatement of profitability

Spreadsheet Error

$6.2billion

JP Morgan Chasetrading losses

Nearly 3 in 4 private capital firms use spreadsheets to collect and analyze portfolio company data, but...

Did You Know?

Those spreadsheet errors can appear in...

Investor Reports

Valuation Models

Regulatory Filings

The Result:

Private capital firms may impact their credibility in front of investors and regulators.

Watch Out For TheseTop 3 Risks

Top 3 Ways To Reduce Errors

3 More Reporting Best Practices For Private Capital