INDEX vs CHOOSE
Is there any reason to avoid using INDEX in a model? It's working out great for me in model but I'm cautious since I haven't used it before.

Re: Complex Trading Comps Analysis
Here is part of the note to consolidated financial statements from income tax section: "The effective income tax rate on earnings was 31.4% in fiscal 2005, 37% in fiscal 2004, and 37.8% in fiscal 2003. The decrease in the effective income tax rate in fiscal 2005 from fiscal 2004 is primarily... Here is part of the note to consolidated financial statements from income tax section:

"The effective income tax rate on earnings was 31.4% in fiscal 2005, 37% in fiscal 2004, and 37.8% in fiscal 2003. The decrease in the effective
income tax rate in fiscal 2005 from fiscal 2004 is primarily attributable to a $54,155 income tax benefit resulting from the settlement of a
transfer pricing dispute between the United States and Canada (covering the years 1996-2003) and a net tax benefit on unremitted foreign
earnings of $20,592. The Company recognized a tax benefit of $30,602, resulting from excess foreign tax credits on unremitted foreign
earnings and recognized a tax expense of $10,010, resulting from tax expense on translation gains accumulated to the date that the Company
determined that certain unremitted foreign earnings were no longer permanently reinvested. The net benefit of $20,592 relates to that portion of
unremitted foreign earnings that the Company plans to repatriate in the foreseeable future. Excluding these benefits the effective income tax
rate on earnings in fiscal 2005 was 36.2%.

For the fourth quarter of fiscal 2005 and 2004, the effective tax rate was 28.9% and 37.0%, respectively. The decrease in the fourth quarter tax
rate for fiscal 2005 is primarily attributable to a net tax benefit of $20,592, as noted above, and a tax benefit of $13,895 primarily associated
with lower state taxes. The state tax benefit recorded in the fourth quarter was primarily due to a reduction in the estimated effective state tax
rate utilized in the first through third quarters of fiscal 2005. Excluding the benefit of these two items, the fourth quarter tax rate for fiscal 2005
would be 35.8%. "

Should we adjust the $13,895? Read More

Macro formatting question
Hey, is it possible to change the macro you have for %, so that negative and positive %'s would align with one another? Is there a way I could do that or you could? Also, is there a way to get rid of the space between $ #,### format. I would rather have if $#,###.

Printing
How do a write a macro to print the entire worksheet except for page one and the last page. Each time I print, there will be a different number of pags so this needs to adjust as I add / delete tabs.

Information session at AEPi
I just wanted to thank you again for coming out and talking to the fraternity. As one who is very interested in the world of financial services, I will definitely be getting back to you shortly about joining your program. That being said, I have a question that you might be able to answer, and I hop... I just wanted to thank you again for coming out and talking to the fraternity. As one who is very interested in the world of financial services, I will definitely be getting back to you shortly about joining your program. That being said, I have a question that you might be able to answer, and I hope you don't mind me asking. While I want to make boatloads of money in the future (and if all goes well, I will), I don't know if I want to work for others or provide a service for the rest of my life. I want to own something that is mine, probably more real estate oriented. What kind of insight does wall street training offer in that regard, and how would you go about things if you were in my shoes?

Once again, I can't thank you enough for stopping by today and talking to AEPi. It was great to get insight from you, David and Steve. I hope that one day our paths cross under more profitable circumstances. Read More