Posts by: WST Expert 1
Re: TEV and ¨significant¨Cap/Op Leases
Just because company has to pay significant amounts for leases does not automatically qualify for "Adjusted TEV". Primarily, it's for industries in which there is a significant buy vs. lease decision (again, mostly transport) and comparison of traditional EBITDA would be distorted because of the ren... Read More
Just because company has to pay significant amounts for leases does not automatically qualify for "Adjusted TEV". Primarily, it's for industries in which there is a significant buy vs. lease decision (again, mostly transport) and comparison of traditional EBITDA would be distorted because of the ren... Read More
Re: DCF Analysis: Using Tax-Effected EBIT as Perpetuity in the Perpetuity Growth Method (PGM) to calculate Terminal Value
Hello Peter, This is covered in one of the packages that you did not purchase, specifically Package 2, under Basic Financial Modeling, which is the very first spot that we cover DCF Modeling if one were starting from our more basic courses. The short explanation is that in order for perpetuity... Read More
Hello Peter, This is covered in one of the packages that you did not purchase, specifically Package 2, under Basic Financial Modeling, which is the very first spot that we cover DCF Modeling if one were starting from our more basic courses. The short explanation is that in order for perpetuity... Read More
Re: Quarterly Modeling - Current Portion LT Debt
Yes, the Current Portion of LTD is the next 4 quarters of mandatory payments for the quarterly BS ending balances. The reason is because Current Portion is defined as the next 12 months. In an annual model, it's easy - just next year's mandatory payment. As you have already observed and deciphere... Read More
Yes, the Current Portion of LTD is the next 4 quarters of mandatory payments for the quarterly BS ending balances. The reason is because Current Portion is defined as the next 12 months. In an annual model, it's easy - just next year's mandatory payment. As you have already observed and deciphere... Read More
Re: Stupid Grouping Question
It's possible that you have some of your worksheets grouped, perhaps by accident by holding Ctrl or Shift when clicking around tabs.
Try right-clicking on any sheet tab and select Ungroup Sheets, then see if that solves anything.
It's possible that you have some of your worksheets grouped, perhaps by accident by holding Ctrl or Shift when clicking around tabs.
Try right-clicking on any sheet tab and select Ungroup Sheets, then see if that solves anything.
Re: Advanced Excel for Data Analysis Course Questions
1. If we're understanding your question correctly: this depends on the keyboard that you have. Most standard keyboards have a separate Home key, but smaller ones or laptop keyboards may have the Home key as an alternate function somewhere near the top row (one of the F function keys) or by the arrow... Read More
1. If we're understanding your question correctly: this depends on the keyboard that you have. Most standard keyboards have a separate Home key, but smaller ones or laptop keyboards may have the Home key as an alternate function somewhere near the top row (one of the F function keys) or by the arrow... Read More
Re: Ibbotson Equity Risk Premium
Unfortunately, due to copyright reasons, we cannot post or disseminate - you'll have to inquire directly with Ibbotson, which is now owned by Morningstar.
Unfortunately, due to copyright reasons, we cannot post or disseminate - you'll have to inquire directly with Ibbotson, which is now owned by Morningstar.
Re: Industry choice
Yes, we would definitely agree with you about the industry specific items in financials services. For that reason, we have completely separate standalone deep dive analysis and financial modeling courses on commercial banks, insurance, etc. However, the reason for including some of the footnotes ... Read More
Yes, we would definitely agree with you about the industry specific items in financials services. For that reason, we have completely separate standalone deep dive analysis and financial modeling courses on commercial banks, insurance, etc. However, the reason for including some of the footnotes ... Read More
Re: STVP
We usually download the data directly from a data vendor such as FactSet, Bloomberg or CapIQ. Absent access to a data vendor that automatically calculates the STVP data, you would need obtain the raw data manually. First, download the closing stock price and volume data (from any source, even... Read More
We usually download the data directly from a data vendor such as FactSet, Bloomberg or CapIQ. Absent access to a data vendor that automatically calculates the STVP data, you would need obtain the raw data manually. First, download the closing stock price and volume data (from any source, even... Read More
Re: Illustrative Valuation Summary Section
Since we are building a dynamic model that works for standalone (status quo, no deal) and for LBO (and later for recap), the projected figures in column D will update as you change your deal scenario. In particular, Net Income will change as your interest changes when you add on debt in the capital ... Read More
Since we are building a dynamic model that works for standalone (status quo, no deal) and for LBO (and later for recap), the projected figures in column D will update as you change your deal scenario. In particular, Net Income will change as your interest changes when you add on debt in the capital ... Read More
Hi Tom,
What are the shortcut keys that you've tried assigning? Is it possible there's a conflict between that and a keyboard shortcut from either WST Macros and/or some other Excel add-in that you have installed?