Posts by: WST Expert 1
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
Re: Mutual Fund Taxes
Our understanding is that mutual funds are taxed on the appreciation (or loss) of your basis. Therefore you don't have to worry about churn from a tax reporting perspective.
Our understanding is that mutual funds are taxed on the appreciation (or loss) of your basis. Therefore you don't have to worry about churn from a tax reporting perspective.
Re: Marginal Interest Rate (A/D Analysis example)
The marginal interest rate is the marginal rate of borrowing, not the savings/treasury rate. The latter can be used for interest income rate, but not for debt borrowing in an M&A deal. We would use the weighted average YTM of existing debt of the acquiror as the best initial proxy.
The marginal interest rate is the marginal rate of borrowing, not the savings/treasury rate. The latter can be used for interest income rate, but not for debt borrowing in an M&A deal. We would use the weighted average YTM of existing debt of the acquiror as the best initial proxy.
Re: Auto Fill Right
The key benefit is that it will automatically keep going to the right until the data in the column above it comes to an end. This happens just by selecting one cell (the starting cell that you want to copy). For example, suppose that you have revenue numbers for 20 years going across (horizontall... Read More
The key benefit is that it will automatically keep going to the right until the data in the column above it comes to an end. This happens just by selecting one cell (the starting cell that you want to copy). For example, suppose that you have revenue numbers for 20 years going across (horizontall... Read More
Re: External File Links
Assuming all the cells in the BU tabs are what you want to pull in from, you can concatenate (via the ampersand, or & symbol) in conjunction with the INDIRECT function to get the references you need. Let us know if you need any more specific guidance -- if so, feel free to describe your data in a bi... Read More
Assuming all the cells in the BU tabs are what you want to pull in from, you can concatenate (via the ampersand, or & symbol) in conjunction with the INDIRECT function to get the references you need. Let us know if you need any more specific guidance -- if so, feel free to describe your data in a bi... Read More
Re: WST macro query
This was an issue with an older version of the WST Macros add-in. We've since updated it such that it displays more of the formula (plus a workaround for very long formulas). You can download the latest version from the Excel Setup Tutorial course (under WST Self-Study Instructions), or from the Abo... Read More
This was an issue with an older version of the WST Macros add-in. We've since updated it such that it displays more of the formula (plus a workaround for very long formulas). You can download the latest version from the Excel Setup Tutorial course (under WST Self-Study Instructions), or from the Abo... Read More
Re: Template of DCF
This section actually serves as a preview of the full course. If you enjoyed the Basic Financial Modeling free trial, we suggest you purchase a subscription. The standard duration is 6 months of video-on-demand access, while you get to download all supporting materials (including the Excel files) to... Read More
This section actually serves as a preview of the full course. If you enjoyed the Basic Financial Modeling free trial, we suggest you purchase a subscription. The standard duration is 6 months of video-on-demand access, while you get to download all supporting materials (including the Excel files) to... Read More
Re: Selecting non-adjacent cells in Excel using only the keyboard
Very good! Except the F8 is not required. Shift+F8 is the magic answer!
Very good! Except the F8 is not required. Shift+F8 is the magic answer!
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... 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% assumption is not a flat, hard-coded 0.5%, it's actually a bit higher and that's why it turns out to be $3,171, which is bigger than $2,903. Read More