Posts by: WST Expert 1
Re: Automated S&P Debt Rating
In our Advanced Financial Modeling - Enhancements course, on the Credit tab, we have the automated S&P ratios that dynamically illustrate the potential rating based purely on quantitative factors. If you have that file/worksheet, then it's a series of complex conditional formatting. If you don't... Read More
In our Advanced Financial Modeling - Enhancements course, on the Credit tab, we have the automated S&P ratios that dynamically illustrate the potential rating based purely on quantitative factors. If you have that file/worksheet, then it's a series of complex conditional formatting. If you don't... Read More
Re: Reference Range (Corporate Valuation)
If you recall from class, the blue cells are hard-coded inputs, not black calculations. Correct, you base your "final" valuation range based on all the qualitative and quantitative factors of the industry, sector and company-specific. The tendency is to estimate based on the Stock Price ... Read More
If you recall from class, the blue cells are hard-coded inputs, not black calculations. Correct, you base your "final" valuation range based on all the qualitative and quantitative factors of the industry, sector and company-specific. The tendency is to estimate based on the Stock Price ... Read More
RE: Excel 2007 adoption
Excel 2007 is horrendous and we would support a campaign called "Fight Excel 2007" should anyone care to join us vs. Microsoft. If you are on our mailing list, we sent out an email listing all the reasons why Excel 2007 is inferior. Banks are NOT switching to Excel 2007 but probably would in a f... Read More
Excel 2007 is horrendous and we would support a campaign called "Fight Excel 2007" should anyone care to join us vs. Microsoft. If you are on our mailing list, we sent out an email listing all the reasons why Excel 2007 is inferior. Banks are NOT switching to Excel 2007 but probably would in a f... Read More
Re: daily number and quarterly data on chart
Since you have daily stock price data, you have stock price dates. Make sure your inventory numbers are as of date, and not in format of 2012 Q1, but a date. First column is dates Second column is stock prices Third column is a vlookup function that brings in inventory, make sure to say "1&quo... Read More
Since you have daily stock price data, you have stock price dates. Make sure your inventory numbers are as of date, and not in format of 2012 Q1, but a date. First column is dates Second column is stock prices Third column is a vlookup function that brings in inventory, make sure to say "1&quo... Read More
Re: D&A is different on the I/S and CF, which to use ??
What is your beginning figure, ending figure and number of years increment?
What is your beginning figure, ending figure and number of years increment?
RE: LBO enhanced model question
You would need to build a stub period into your model. Add a new column after 2007 full year and use that to add with adjustments for pro forma. Your financials (IS and CF etc) would need to make sure 2008 column are stub year (say sept to dec 2008).
You would need to build a stub period into your model. Add a new column after 2007 full year and use that to add with adjustments for pro forma. Your financials (IS and CF etc) would need to make sure 2008 column are stub year (say sept to dec 2008).
Re: I need a Function to Start With (Summing alternate row)
piece of cake. use the SUMIF function.
=sumif(range, criteria,sum_range)
=sumif(columnA,"Completed",columnB)
Completed can be either hard coded or cell referenced (the latter is obviously preferred)
piece of cake. use the SUMIF function.
=sumif(range, criteria,sum_range)
=sumif(columnA,"Completed",columnB)
Completed can be either hard coded or cell referenced (the latter is obviously preferred)
RE: Minority Interest in LBO Model
Your question is a great one! Minority Interest treatment is summarized as follows: 1) In standalone valuation context, INCLUDE MI as part of TEV (Total Enterprise Value) because it is considered a form of capital since greater than 50% ownership forces consolidation 2) In credit analysis (... Read More
Your question is a great one! Minority Interest treatment is summarized as follows: 1) In standalone valuation context, INCLUDE MI as part of TEV (Total Enterprise Value) because it is considered a form of capital since greater than 50% ownership forces consolidation 2) In credit analysis (... Read More
Re: LBO - Quick & Dirty - for a early stage investment
Sounds like you are valuing a start-up. Our traditional simplistic approach to determining capital structure of start-ups is to figure out the run-rate expenses required for say, 1-2 years or whatever comfortable buffer + required capital expenditures (if any). Then map out your potential cash flo... Read More
Sounds like you are valuing a start-up. Our traditional simplistic approach to determining capital structure of start-ups is to figure out the run-rate expenses required for say, 1-2 years or whatever comfortable buffer + required capital expenditures (if any). Then map out your potential cash flo... Read More
Please make sure you view our courses previously stated. These are fundamentally simple concepts to DCF. Terminal Value values the company at end of terminal year. But what about the interim cash flows? Those have value as well.