Posts by: Guest 1
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
Re: Cost of Debt Sources
Cap IQ doesn't compute costs of debt...Thanks for the help. I am trying to check with other sources. And I have come up with a tentative model for in-house calculations
Cap IQ doesn't compute costs of debt...Thanks for the help. I am trying to check with other sources. And I have come up with a tentative model for in-house calculations
RE: Is DCF a pre- or post-tax value?
Thanks. that's interesting: so you're saying: (1) the terminal multiple approach assumes a sale of the company, thus implying a change of control valuation (2) the perpetuity growth terminal value approach assumes steady state, no sale of the company. Therefore, are the terminal multiple a... Read More
Thanks. that's interesting: so you're saying: (1) the terminal multiple approach assumes a sale of the company, thus implying a change of control valuation (2) the perpetuity growth terminal value approach assumes steady state, no sale of the company. Therefore, are the terminal multiple a... Read More
Re: Modeling ADR shares
I am trying to model GOL, a brazilian airline, but the 20F numbers are in $BRLs (Reals). Once I come up with a price target using DCF, how do i translate that back into dollars? Do I simply use the spot price for today? Also, how does the price of an ADR connect with the stock price of the company i... Read More
I am trying to model GOL, a brazilian airline, but the 20F numbers are in $BRLs (Reals). Once I come up with a price target using DCF, how do i translate that back into dollars? Do I simply use the spot price for today? Also, how does the price of an ADR connect with the stock price of the company i... 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... 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
problem reading the format as a percentage.
Thanks for letting me pick your brain. This may have to remain a mystery. Read More