Forum Search: capital markets
An alternative needed to a multi-select drop-down list
I am in search of a way to convert multiple selections in a drop-down list into a single field with the selections separated by a semicolon. Background: I need to get contact data into a specific format that is importable into a particular on-line software app. I was contemplating having a user-f... Read More
I am in search of a way to convert multiple selections in a drop-down list into a single field with the selections separated by a semicolon. Background: I need to get contact data into a specific format that is importable into a particular on-line software app. I was contemplating having a user-f... Read More
Re: Minority Interest
We are always trying to get value of COMMON equity, hence we want to remove all forms of capital other than equity. The only reason why MI shareholders participate in the ownership of assets on the BS as well as earnings on the IS is because of consolidation rules (no proportionate consolidation. M... Read More
We are always trying to get value of COMMON equity, hence we want to remove all forms of capital other than equity. The only reason why MI shareholders participate in the ownership of assets on the BS as well as earnings on the IS is because of consolidation rules (no proportionate consolidation. M... Read More
Five questions (merger premiums, capex, leveraged beta, etc.)
1. Do merger of equals usually have premiums paid close to zero? 2. Page 41, to calculate Unlevered Free Cash Flow, it is used net capital expenditure, but to calculate Unlevered Free Cash Flow in the Hilb, Rogal & Hamilton case, it is used capital expenditure instead. Why? 3. When do you use... Read More
1. Do merger of equals usually have premiums paid close to zero? 2. Page 41, to calculate Unlevered Free Cash Flow, it is used net capital expenditure, but to calculate Unlevered Free Cash Flow in the Hilb, Rogal & Hamilton case, it is used capital expenditure instead. Why? 3. When do you use... 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: 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: 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
BS line item treatment for determining TEV
If a company lists restricted cash not for working capital purposes, but instead for covenants adherence, would you be allowed to subtract it in the TEV like normal cash? Also, what is the difference between Investment in Unconsolidated Affairs (asset side) versus minority interest (on the liability... Read More
If a company lists restricted cash not for working capital purposes, but instead for covenants adherence, would you be allowed to subtract it in the TEV like normal cash? Also, what is the difference between Investment in Unconsolidated Affairs (asset side) versus minority interest (on the liability... Read More
Mutual Fund Taxes
If you're invested in a mutual fund, how does the rate at which the mutual fund churns affect your taxes? In other words, when paying taxes on a mutual fund, does it matter how long you've been invested in the fund (more than a year and you're taxed at capital gains rate instead of ordinary income t... Read More
If you're invested in a mutual fund, how does the rate at which the mutual fund churns affect your taxes? In other words, when paying taxes on a mutual fund, does it matter how long you've been invested in the fund (more than a year and you're taxed at capital gains rate instead of ordinary income t... Read More
Re: Capital charge under EVA
We would agree with you here per the thread on Residual Income. For folks stumbling upon this post, please go here as well: https://www.wstuniversity.com/forum/wst_self_study_q_a-2/package_3:_advanced_financial_modeling-91/enhancements_to_the_core_model___part_ii-94/residual_income_-100?single=20... Read More
We would agree with you here per the thread on Residual Income. For folks stumbling upon this post, please go here as well: https://www.wstuniversity.com/forum/wst_self_study_q_a-2/package_3:_advanced_financial_modeling-91/enhancements_to_the_core_model___part_ii-94/residual_income_-100?single=20... Read More
I am trying to value a company for an IPO (proceeds strictly used for expansion, not for the existing shareholders to exit), using DCF (on the FCFF). I have done financial forecast on the company, taking into account the improved performance after it receives new capital from the IPO. After I deriv... I am trying to value a company for an IPO (proceeds strictly used for expansion, not for the existing shareholders to exit), using DCF (on the FCFF). I have done financial forecast on the company, taking into account the improved performance after it receives new capital from the IPO. After I derive the enterprise value of the company, is this Enterprise Value post-money or pre-money? Tend to argue that it is post-money valuation as the financial forecast already takes into account the improved performance. If it is post-money, am I right to say that we should not add the cash proceed (from IPO) to derive the equity value? Read More