Posts by: Guest 1
Undistributed Earnings Allocated to Participating Securities
I saw a company reduces its net income by removing "undistributed earnings allocated to participating securities" in its basic or diluted EPS calculation. It explains in its note: Net income attributable to common shareholders Less: undistributed earnings allocated to participating securit... Read More
I saw a company reduces its net income by removing "undistributed earnings allocated to participating securities" in its basic or diluted EPS calculation. It explains in its note: Net income attributable to common shareholders Less: undistributed earnings allocated to participating securit... Read More
How do I group/ungroup cells?
Full Question:
I see in Wall Street sell-side models that "+"/"-" buttons ( near the row and column headings) and "1"/"2" buttons (in the upper left hand corner) are created to unhide/hide a bunch of columns/rows by simply clicking on the buttons. How do I create these buttons ?
Full Question:
I see in Wall Street sell-side models that "+"/"-" buttons ( near the row and column headings) and "1"/"2" buttons (in the upper left hand corner) are created to unhide/hide a bunch of columns/rows by simply clicking on the buttons. How do I create these buttons ?
RE: Pesky Technical Question
Well,that's fine once there is data in the cell. But since it won't autofill, the formatting issue is sort of collateral. I was just fumbling for a theory and wondering if there was some reason the "enable automatic percent entry" was not firing off as it does elsewhere. I guess it is not a prob... Read More
Well,that's fine once there is data in the cell. But since it won't autofill, the formatting issue is sort of collateral. I was just fumbling for a theory and wondering if there was some reason the "enable automatic percent entry" was not firing off as it does elsewhere. I guess it is not a prob... Read More
How do I move a row without the mouse?
Full Question: I want a quick way to move entire row with no mouse. I know to highlight and cut you would do Shift space bar -- then hit Ctrl + C. How do I put it in the proper place? When I highlight the row in which i want my selection to go above, it simply copys over that row instead of inser... Read More
Full Question: I want a quick way to move entire row with no mouse. I know to highlight and cut you would do Shift space bar -- then hit Ctrl + C. How do I put it in the proper place? When I highlight the row in which i want my selection to go above, it simply copys over that row instead of inser... Read More
RE: vlookup question
I understand what you did, I think. But that doesn’t help either. Maybe it will help if I give you the backdrop. This particular workbook is a temporary ledger of all of our bankers Institutional contacts. Not individual names, merely fund names. Now we have 14 bankers covering 1500 hedge fund... Read More
I understand what you did, I think. But that doesn’t help either. Maybe it will help if I give you the backdrop. This particular workbook is a temporary ledger of all of our bankers Institutional contacts. Not individual names, merely fund names. Now we have 14 bankers covering 1500 hedge fund... Read More
Sum + If Array
I recently attended your excel for data analysis class. I have a question regarding the sum+if example. Can you please walk me through the logic behind the array in the sum + boolean example (approach 4)? In other words, how does * connect the three formulas? Everything else makes sense and I get it... Read More
I recently attended your excel for data analysis class. I have a question regarding the sum+if example. Can you please walk me through the logic behind the array in the sum + boolean example (approach 4)? In other words, how does * connect the three formulas? Everything else makes sense and I get it... Read More
Re: Undistributed Earnings Allocated to Participating Securities
Thanks!! There is no footnote explains participating securities. The only place where participating securities were explained were under "earnings per share": "Basic and diluted net income attributable to Vertex per common share are presented in conformity with the two-class method ... Read More
Thanks!! There is no footnote explains participating securities. The only place where participating securities were explained were under "earnings per share": "Basic and diluted net income attributable to Vertex per common share are presented in conformity with the two-class method ... Read More
SUMIF problem
Full Question: What am I doing wrong with this formula it keeps returning “0”? =SUMIF(A7:A21,"MONTH(3)",C7:C21) Notes: A7:A21 are dates in this format (3/5) Condition is to see if the Month is March (thus I use 3) C7:C21 is the sale amount to add if condition is true I also tried the f... Read More
Full Question: What am I doing wrong with this formula it keeps returning “0”? =SUMIF(A7:A21,"MONTH(3)",C7:C21) Notes: A7:A21 are dates in this format (3/5) Condition is to see if the Month is March (thus I use 3) C7:C21 is the sale amount to add if condition is true I also tried the f... Read More
RE: LBO enhanced model question
I am confused on how to modify the model assuming the following deal characteristics: 1) The target is a private company 2) The company will be bought on 8/30/08, using asset-backed debt financing via an LBO; that is, the company is bought as an asset deal with no debt 3) Management gets upf... Read More
I am confused on how to modify the model assuming the following deal characteristics: 1) The target is a private company 2) The company will be bought on 8/30/08, using asset-backed debt financing via an LBO; that is, the company is bought as an asset deal with no debt 3) Management gets upf... Read More
Full Question: Helping someone work on a powerpoint project, and I was wondering if there is a better way (other than moving the arrow along the stock chart line) to link an arrow to a certain stock price on the graph. I hope all is well, I have loaded your macros, and I have the shortcuts on my w... Full Question:
Helping someone work on a powerpoint project, and I was wondering if there is a better way (other than moving the arrow along the stock chart line) to link an arrow to a certain stock price on the graph. I hope all is well, I have loaded your macros, and I have the shortcuts on my wall! Read More