Posts by: WST Expert 1
Re: Identifiable Intangible Assets
1) You the man! You win! Thank you for digging that up.
Forget naught that in addition to tax experts, you will have accountants on the job as well.
The short answer is that you need to know enough, but you d...
Read More
1) You the man! You win! Thank you for digging that up.
Forget naught that in addition to tax experts, you will have accountants on the job as well.
The short answer is that you need to know enough, but you d...
Read More
Re: How can Excel pull stock quotes?
You can use a variety of third party services, including Bloomberg, FactSet, etc via their built in Excel add-ins. Even an etrade or other retail brokerage account will be able to handle that (on a real-time basis too!) However, if you are looking for a completely non-paid service, Yahoo Finance s... Read More
You can use a variety of third party services, including Bloomberg, FactSet, etc via their built in Excel add-ins. Even an etrade or other retail brokerage account will be able to handle that (on a real-time basis too!) However, if you are looking for a completely non-paid service, Yahoo Finance s... Read More
Re: Print Tiles - Entire Workbook
Unfortunately, you have to do this one sheet at a time or do a record macro and run the macro.
Once you group sheet, the freeze panes option is grayed out and unaccessible.
Unfortunately, you have to do this one sheet at a time or do a record macro and run the macro.
Once you group sheet, the freeze panes option is grayed out and unaccessible.
RE: Merger Modeling Basics: Questions on Merger model
Good follow-up questions! You can issue stock direct to the target shareholders which doesn't necessarily preclude you from issuing more stock to the market in a secondary market. Perfect example is today's (9/9/2008) news that Commerzbank is issuing stock to fund its acquistion of Dresdner and w... Read More
Good follow-up questions! You can issue stock direct to the target shareholders which doesn't necessarily preclude you from issuing more stock to the market in a secondary market. Perfect example is today's (9/9/2008) news that Commerzbank is issuing stock to fund its acquistion of Dresdner and w... Read More
Re: CFA certification
Super important for certain aspects of finance (research, portfolio and asset mgmt, etc) But not as relevant for IB or PE. CFA is very critical to demonstrating that at one point you knew something about all major aspects of finance. Despite the fact we know you forget everything after the exam, it... Read More
Super important for certain aspects of finance (research, portfolio and asset mgmt, etc) But not as relevant for IB or PE. CFA is very critical to demonstrating that at one point you knew something about all major aspects of finance. Despite the fact we know you forget everything after the exam, it... Read More
Re: Identifiable Intangible Assets
No worries, and that's what we're here for. Keep in mind that you want to focus on what's material. It's more important to get your projection model and valuation correct than this very fine specific nuance on purchase price allocation. That doesn't mean we don't want to be correct, but sometimes i... Read More
No worries, and that's what we're here for. Keep in mind that you want to focus on what's material. It's more important to get your projection model and valuation correct than this very fine specific nuance on purchase price allocation. That doesn't mean we don't want to be correct, but sometimes i... Read More
Re: Scatter Plot Data
If I'm understanding correctly, you have a lot of data points, and each one has three properties: Asset Class, Maturity, and Region. Naturally, there isn't a one-to-one-to-one relationship, as you mentioned. Given the complexity of such data, we'd recommend first establishing what kind of informatio... Read More
If I'm understanding correctly, you have a lot of data points, and each one has three properties: Asset Class, Maturity, and Region. Naturally, there isn't a one-to-one-to-one relationship, as you mentioned. Given the complexity of such data, we'd recommend first establishing what kind of informatio... Read More
Re: CFA certification
Stalla
Stalla
Re: Software for Financial Analyst
We highly encourage you to have Windows, specifically Excel for PC. In the corporate world, it is Excel for PC not Mac. The shortcut and menus are also different (although similar). If you insist on Excel for Mac, then please download our Mac Excel shortcut sheet so you know the comparable keystroke... Read More
We highly encourage you to have Windows, specifically Excel for PC. In the corporate world, it is Excel for PC not Mac. The shortcut and menus are also different (although similar). If you insist on Excel for Mac, then please download our Mac Excel shortcut sheet so you know the comparable keystroke... Read More
projecting R&D expenditure as % of total sales sounds legit to us. but how did you justify the % split you used for expense vs capitalize portion? that is pretty important. AND then don't forget, you need to expense the capitalized portion. keep in mind, if the company is at run-rate (doesn't ... projecting R&D expenditure as % of total sales sounds legit to us.
but how did you justify the % split you used for expense vs capitalize portion?
that is pretty important.
AND then don't forget, you need to expense the capitalized portion.
keep in mind, if the company is at run-rate (doesn't sound like it - sounds like they are growth phase), then the numbers should balance out. similar to the relationship between capex and depreciation in long run. Read More