Lord of the Ratios Contest Homework

As promised in my “Be A Speaker” contest entry, I have some fun Lord of the Rings prizes to giveaway during my presentation. To be eligible to win, however, you will need to be a Lord of the Ratios…or at least familiar with the Ratio That Rules Them All. That would be Return on Equity, or ROE.

If you are not the accounting type, have no fear! I have developed an ROE calculator that makes determining your ROE a simple exercise that just requires a call report and five minutes. To be able to participate in the contest during my presentation you need to be A) a credit union employee, and B) have calculated your credit union’s ROE.

The first item is easy…are you representing a credit union at CUWCS? Then check you have the first part done.

The second item is almost as easy…just download my calculator and a copy of the 12/31/2010 financial performance report from the NCUA website for your credit union and fill out the calculator.

To help out even more, here are the step by step instructions to get you started.

  1. Download my calculator from: http://dl.dropbox.com/u/11582967/ROE%20Calculator.xlsx
  2. Go to the Find a Credit Union area of NCUA website: http://cuonline.ncua.gov/CreditUnionOnline/CU/FindCreditUnions.aspx
  3. Enter your credit union name and click “Find”.
  4. Once you are on your credit union’s information page click on “Financial Performance Reports” on the left side of the page.
  5. Choose the last option “I want to view a 2-page FPR summary for one credit union online.” And click “OK.”
  6. Choose the 12/31/2010 reporting cycle and click “Financial Summary.”
  7. Print the document and you have what you need to calculate your ROE…juts be careful to use the numbers in the Dec-2010 column or your ROE will come out funky.

If you have trouble figuring out which performance report number goes where drop me an email at jcraig@1stadvantage.org or dm me on Twitter (@jimncraig)…just be sure you are following me so that I can reply.

Bring your completed ROE calculator with you to CUWCS for a chance to win one of three very cool (okay cool if you are a LOR geek like me) prizes. Happy calculating!


Posted on September 14, 2011 .