Posts by: WST Expert 1
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
Re: Investment income in 2003
If you look back to the source of the 0.5% assumption in 2003 (cell I46), it is referenced from 2002's calculation in cell H46, which is a calculation of 2002's Investment Income / Commissions and Fees. That figure is actually 0.546...% when you show all significant digits. As such, the 0.5% assumpt... Read More
If you look back to the source of the 0.5% assumption in 2003 (cell I46), it is referenced from 2002's calculation in cell H46, which is a calculation of 2002's Investment Income / Commissions and Fees. That figure is actually 0.546...% when you show all significant digits. As such, the 0.5% assumpt... Read More
Re: BS line item treatment for determining TEV
Restricted cash, whether for covenants or LOC or escrow, etc would be treated as part of the required minimum cash balance in your financial model. For purposes of TEV, the standard practice is to take total debt less cash on the BS (i.e. entire cash balance), so the short answer is, no, do not incl... Read More
Restricted cash, whether for covenants or LOC or escrow, etc would be treated as part of the required minimum cash balance in your financial model. For purposes of TEV, the standard practice is to take total debt less cash on the BS (i.e. entire cash balance), so the short answer is, no, do not incl... Read More
Re: Saving function across workbooks in Excel 2010
You aren't doing anything wrong per se, because any function that you write in a module will, by default, only be valid on the workbook containing that module. If you'd like to use it in other workbooks, one option is to save the original custom code as your own Excel add-in (when saving the file... Read More
You aren't doing anything wrong per se, because any function that you write in a module will, by default, only be valid on the workbook containing that module. If you'd like to use it in other workbooks, one option is to save the original custom code as your own Excel add-in (when saving the file... 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... 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 deciphered, the next 12 months in the quarterly model would require you to add the next 4 quarters.
Keep in mind that the actual mandatory payment on the Debt Sweep would be for that individual quarter only; otherwise the actual debt sweep would be wrong which would also spill over incorrectly to the Current Portion sum on the BS itself.
If you are building your Debt Sweep and Balance Sheet per our Core Model methodology, then the Long Term Portion of Long Term Debt on the BS should be a reference to the appropriate cell on the Debt Sweep that has already been calculated for that period (in this case, quarterly period). Recall, the best practice on the Debt Sweep would be as follows:
- add up Beginning Balance of ALL debt
- subtract all mandatory payments made that quarter
- subtract out any Revolver changes or TL ECF if applicable
=> this is Ending Balance of ALL debt for that quarterly period
- subtract out next 4 quarters mandatory (this is Current Portion)
- subtract out Ending Revolver Balance
=> this is Long Term Portion of Long Term Debt
The BS line for LTD (net of Current Portion) would reference that Long Term Portion of Long Term Debt from the Debt Sweep. Read More