Friday, September 26, 2008

walking down the bank route...

Aswath Damodaran is the author of Corporate Finance: Theory & Practice, one of the required textbooks used in my 'university' days and one that I found very contentful. This piece is from his blog. /  EJ
 
The End of Investment Banking?
Aswath Damodaran
 
* 22-Sep-08 *  THE BIG NEWS of the morning is that Goldman Sachs and Morgan Stanley will reorganize themselves as bank holding companies, thus ending a decades-long experiment with stand-alone public investment banking. Before we buy into the hyperbole that this represents the end of of investment banking as we know it, it behooves to us to look both back in time and into the future and examine the implications. 
 
Independent investment banks have been in existence for a long time, but for much of their existence, they were private partnerships that made the bulk of their profits from transactions and as advisors. They seldom put their own capital at risk, largely because they had so little to begin with and it was their own money (partners). Part of the impetus in their going public was the need to raise more capital, which in turn, freed them to indulge in more capital-intensive businesses including proprietary trading. That model worked well for much of the last two decades, but three things (in my view) destroyed it.
 
The first was that it became easier to access low cost, short term debt (especially in the last few years) to fund the capital bets that these firms were making, whether in mortgage backed securities or in other investments. The second was that the compensation structure at investment banks encouraged bad risk-taking, since it rewarded risk-takers for upside gains (extraordinary bonuses tied to trading profits) and punished them inadequately for the downside (at worst, you lost your job but you were not required to disgorge bonuses in prior years... in many cases, finding another trading job on the Street or at a hedge fund was not difficult to do even for the most egregious violators). The third was a patchwork of government regulation that was often exploited by investors to make risky bets and to pass the risk on elsewhere, while pocketing the returns. The combination worked in deadly fashion these last two years to devastate the capital bases at these institutions. Lehman, Bear Stearns and Merrill have fallen...
 
So, what will change now that Goldman and Morgan Stanley have chosen the bank route? The plus is that it opens more sources of long term capital since they can now attract deposits from investors. Having never done this before, they start off at a disadvantage. The minus is that they will now be covered by banking regulation, where the equity capital they be required to have will be based upon the risk of their investments. This will effectively mean that they will need more equity capital, if they want to keep taking high risk investments, or that they will have to bring down the risk exposure on their investments. My guess is that they would have gone down one of these roads anyway. In pragmatic terms, it will also mean that their returns on equity at investment banks will drop to banking levels - more in the low teens than in the low twenties. I think the stock prices for both investment banks already reflects this expectation.
 
Ultimately, Goldman and Morgan Stanley have sent a signal to the market that they are willing to accept a more restrictive risk taking system. In today's market, that may be the best signal to send. There will be times in the future, where I am sure that they will regret the restrictions that come with this signal, but they had no choice. (http://aswathdamodaran.blogspot.com/2008/09/end-of-investment-banking.html)
 

Wednesday, September 24, 2008

Dealing with AutoFilter

EXCEL TIPS: AutoFilter in a Messy Data Table

Work situation:
You have just exported a large amount of data into Excel or converted a .txt file into an .xls file. The data automatically sits in a table-like manner on your spreadsheet but it looks disorganised. You want to manipulate the data table using AutoFilter to speed up removing the blank rows that clutter around and through the entire range of the table.

Problem:
However, when you activate the AutoFilter & click the drop-down arrows of the column headings, they only display the basic criteria (Sort Ascending/Descending, All, Top 10, Custom) but where is the data? This is due to the blank rows between the headers and the first row of data.

Solution:
Turn off AutoFilter first. In order for Excel to treat your whole range of data as being one single table, highlight the entire table range. And turn the AutoFilter back on. Done! Now each column heading should show all the data underneath it. (EJ)

Friday, August 08, 2008

TGIF 8-8-8

Sydney, 8th August 2008

To a great number of people worldwide, today may be an auspicious day thanks to the unusually consecutive 8-8-8 in the numerical system of international date that we use (both AD & BC). And hence these couples intentionally preset this special date as their nuptials & say their once-only sacred vow.

To the greatest nation on earth centred in Beijing, this date marks the end of their long-awaited day being the host of the world's biggest event and the proud beginning of massive demonstration of the rich, splendid Chinese culture and civilisation embedded in the festive Opening Ceremony currently underway at these hits of letters on my keyboard.

To all nations and even a greater number of people, it is time to revel & be merry as mankind are united in this universal Olympic spirit as well as cheer their national sports warriors on to go swifter, higher, and stronger for more golds than any other country to top the medal tally of this Games of the XXIX Olympiad.

To me, I wish it were just another day, another TGIF day to look forward to for the morrow. But somehow I've got myself a bit carried away by the globally ubiquitous delight... with quite a distinct, personal reason, though. That it is on this very day too I have been privileged to officially become a CPA (Certified Practising Accountant) of CPA Australia.

So, what else to utter than a relieved, lengthy "finally...... thank You, Lord! I can't believe this."

(Emil Jayaputra CPA)