Posts by: Guest 1
Array formula
I attended your Excel Advanced course on the last day of the Financial Analysis Series (7 Nov 08) There is an array formula which I tried to replicate but have problem. I have a series of monthly returns in % and would like to multiply by 0.5 instead of adding 1 to the array range T11:T32. But the ... Read More
I attended your Excel Advanced course on the last day of the Financial Analysis Series (7 Nov 08) There is an array formula which I tried to replicate but have problem. I have a series of monthly returns in % and would like to multiply by 0.5 instead of adding 1 to the array range T11:T32. But the ... Read More
GAAP or cash
I'm making an LBO model of a public company but relying on analyst report forecasts (including bloomberg consensus) which I assume are non-GAAP. Should I adjust the analyst forecasts as much as I can for one times (amort of intangibles, restructuring) and use these for the P/L model with the GAAP ... Read More
I'm making an LBO model of a public company but relying on analyst report forecasts (including bloomberg consensus) which I assume are non-GAAP. Should I adjust the analyst forecasts as much as I can for one times (amort of intangibles, restructuring) and use these for the P/L model with the GAAP ... Read More
Re: Cannot FULLY use WSTMacros3.4.2.xla on Excel 2013
Yes you are right. It was not installed properly. After downloading the .xla, I opened Excel 2013 and then straight on to "Options", "Add-Ins", etc. However, what I did not do after downloading was to make Excel "recognize" the .xla file. I double clicked on the .xl... Read More
Yes you are right. It was not installed properly. After downloading the .xla, I opened Excel 2013 and then straight on to "Options", "Add-Ins", etc. However, what I did not do after downloading was to make Excel "recognize" the .xla file. I double clicked on the .xl... Read More
RE: AFM Enhancements: Printing Set Up
Thanks a lot
Btw, Do you have any course that teach about combination of Fin. Statements for a number of entities? That is combining numerious companies's statement for a structure of a holding company?
Thanks a lot
Btw, Do you have any course that teach about combination of Fin. Statements for a number of entities? That is combining numerious companies's statement for a structure of a holding company?
Super-advanced merger modeling
Hi there, Could you please explain me in more detail what is the rationale behind those percentages on cells F42:F44 used to allocate the purchase price in the Super-advanced merger modeling? (2). To be more specific, why is it a percentage of Equity and not a percentage of the purchase price??? (... Read More
Hi there, Could you please explain me in more detail what is the rationale behind those percentages on cells F42:F44 used to allocate the purchase price in the Super-advanced merger modeling? (2). To be more specific, why is it a percentage of Equity and not a percentage of the purchase price??? (... Read More
Re: Debt Extinguishment - Equity offered
Understood. Thanks Two more questions: 1.) I assume we would need to add another line to the CFS -- Proceeds from debt offering = $150MM 2.) Here is my original text again for convenince... question is below $125 MM ABL Revolver $360 MM Sub notes 9% due 2012 $700 MM Secured Notes 11.75% due 20... Read More
Understood. Thanks Two more questions: 1.) I assume we would need to add another line to the CFS -- Proceeds from debt offering = $150MM 2.) Here is my original text again for convenince... question is below $125 MM ABL Revolver $360 MM Sub notes 9% due 2012 $700 MM Secured Notes 11.75% due 20... Read More
Re: GAAP or cash
If its a large cap, well covered company, shouldn't analyst projection be used as the base case?
In general, if using analyst projections, does it make sense to mix GAAP historicals with analyst (non-GAAP) forecasts?
If its a large cap, well covered company, shouldn't analyst projection be used as the base case?
In general, if using analyst projections, does it make sense to mix GAAP historicals with analyst (non-GAAP) forecasts?
M&A Debt Sweep CF Recapture Feature
Hello,
I was just wondering what the rationale behind the CF Recapture feature (switch) is on the Debt Sweep for the advanced M&A model. What is the rationale? How does it work and its practicality? Thank you.
Hello,
I was just wondering what the rationale behind the CF Recapture feature (switch) is on the Debt Sweep for the advanced M&A model. What is the rationale? How does it work and its practicality? Thank you.
Merger modeling - Purchase price allocation
Hi there, a couple of doubts here: 1. In the purchase price allocation, why do we allocate the excess (Purchase price of equity – Tangible Book value) without the transaction costs? Any specific rule here? 2. In the same purchase price allocation, shouldn’t we have to add a line in that purcha... Read More
Hi there, a couple of doubts here: 1. In the purchase price allocation, why do we allocate the excess (Purchase price of equity – Tangible Book value) without the transaction costs? Any specific rule here? 2. In the same purchase price allocation, shouldn’t we have to add a line in that purcha... Read More
Hi there, Hope this is not too trivial - I realised that the printing setup for the template includes the row & column numbers. I tried many ways to eliminate that but still couldn't solve this issue. Appreciate your advice in doing so. Thanks Stanley Darby Private Equity Fran... Hi there,
Hope this is not too trivial - I realised that the printing setup for the template includes the row & column numbers. I tried many ways to eliminate that but still couldn't solve this issue.
Appreciate your advice in doing so.
Thanks
Stanley
Darby Private Equity
Franklin Templeton Investments
p.s. the course is really useful - very lucky I found your course! Read More