Posts by: Guest 1
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... Read More
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... Read More
Revolver Priority in Bankruptcy
According to a recent training session that I attended, the instructor repeated that revolvers almost always get paid first before unsecured creditors. But my understanding is that revolvers are normally unsecured, and thus, rank pari passu with other unsecured creditors. Unless the revolving cred... Read More
According to a recent training session that I attended, the instructor repeated that revolvers almost always get paid first before unsecured creditors. But my understanding is that revolvers are normally unsecured, and thus, rank pari passu with other unsecured creditors. Unless the revolving cred... Read More
Tax implications on Cash vs Stock deal
Do Stock deals enjoy a distinct financial advantage over cash deals due to U.S. tax policy (since stock-for-stock deals are not considered taxable events)? If so, what are the tax implications of stock vs. cash (besides the fact that cash clearly has forgone interest income or the interest expense f... Read More
Do Stock deals enjoy a distinct financial advantage over cash deals due to U.S. tax policy (since stock-for-stock deals are not considered taxable events)? If so, what are the tax implications of stock vs. cash (besides the fact that cash clearly has forgone interest income or the interest expense f... Read More
lookup vs pivot table
I am trying to figure out the best way to combine several data sets and calculate an average for each field (ROE, ROA, etc quarterly going back 3 years). Not all of the data sets include the same quarters depending on whether they have reported yet. For example one set starts with Q2 2005 and... Read More
I am trying to figure out the best way to combine several data sets and calculate an average for each field (ROE, ROA, etc quarterly going back 3 years). Not all of the data sets include the same quarters depending on whether they have reported yet. For example one set starts with Q2 2005 and... Read More
Re: Text to Row
Thank you so much for response. That was very detailed and I definitely did learn from it. However, when I was most of the way through this, I realized my explanation must not have gotten a certain detail across. I apologize for the error. Each operator/address/phone combo are in its own cell. What ... Read More
Thank you so much for response. That was very detailed and I definitely did learn from it. However, when I was most of the way through this, I realized my explanation must not have gotten a certain detail across. I apologize for the error. Each operator/address/phone combo are in its own cell. What ... Read More
Tangible Book Value calculation for Goodwill
Quick question from the war room - We are having a debate about Tangible Book Value used in calculating Goodwill. One faction says that: Tangible book value = Shareholders equity - intangible assets (Intangible assets include patents, trademarks and goodwill) The other faction says: Tang... Read More
Quick question from the war room - We are having a debate about Tangible Book Value used in calculating Goodwill. One faction says that: Tangible book value = Shareholders equity - intangible assets (Intangible assets include patents, trademarks and goodwill) The other faction says: Tang... Read More
Charts suddenly not visible/filled in box of one colour
All of a sudden all of my charts in my model are exhibiting the following problem: - they are completely filled up in grey - as if one box but the chart is not visible - I can only see the chart data/output when i click on the chart - as soon as i click anywhere else in the model the chart is autom... Read More
All of a sudden all of my charts in my model are exhibiting the following problem: - they are completely filled up in grey - as if one box but the chart is not visible - I can only see the chart data/output when i click on the chart - as soon as i click anywhere else in the model the chart is autom... Read More
Technical Question: Excel for PC vs Excel for Mac shortcuts
What are the major differences in Excel for PC vs Excel for Mac shortcuts?
What are the major differences in Excel for PC vs Excel for Mac shortcuts?
Treatment of Revolver as Debt for TEV
I wanted to ask your view on a discussion we had here at the firm. The topic was how to calculate the Net Debt of a company for the purpose of subtracting it to the enterprise value and getting to a purchase price. The firm is a small growing company with approximately 1.6m in Accounts Receivabl... Read More
I wanted to ask your view on a discussion we had here at the firm. The topic was how to calculate the Net Debt of a company for the purpose of subtracting it to the enterprise value and getting to a purchase price. The firm is a small growing company with approximately 1.6m in Accounts Receivabl... Read More
Is there a way to match hard coded text from a referenced cell on one worksheet to a corresponding cell on an adjacent worksheet as a letter? I.e. Cell B5 on Tab 1 says “Marinello” and I want that to trigger the exact same cell, except on Tab 2, to say “A” Its probably really easy, but ... Is there a way to match hard coded text from a referenced cell on one worksheet to a corresponding cell on an adjacent worksheet as a letter?
I.e. Cell B5 on Tab 1 says “Marinello” and I want that to trigger the exact same cell, except on Tab 2, to say “A”
Its probably really easy, but im frustrated. Read More