Posts by: Guest 1
Negative Free Cash Flow in DCF
I am trying to do a 5 years DCF on an early stage tech company. It will have negative EBIT in next 2 years (also the FCF after the D&A, Capex, NWC adjustment) and becoming positive in 3rd year. So in caculating the Free Cash Flow from EBIT, does it still make send to still use the formula of EBI... Read More
I am trying to do a 5 years DCF on an early stage tech company. It will have negative EBIT in next 2 years (also the FCF after the D&A, Capex, NWC adjustment) and becoming positive in 3rd year. So in caculating the Free Cash Flow from EBIT, does it still make send to still use the formula of EBI... Read More
Re: Building models from scratch?
czar - have you done this course yet? How long does it take? Is it more difficult than the advanced modeling course?
czar - have you done this course yet? How long does it take? Is it more difficult than the advanced modeling course?
How do I shade every 3rd row instead of alternate rows?
Full Question:
I had a follow-up question to the auto row shading taught in the Advanced Excel for Data Analysis class - what would the formula be if I wanted every 3, (or 4 or 5) rows colored, rather than every other row?
Full Question:
I had a follow-up question to the auto row shading taught in the Advanced Excel for Data Analysis class - what would the formula be if I wanted every 3, (or 4 or 5) rows colored, rather than every other row?
All Stock M&A transaction...Timing Question
Ex. BofA acquisition of MER. It was announced that BofA would exchange 0.8595 BofA shares for each MER share. This was announced on 9/16/08 so was based on BofA's share price then and MER price then. However, when does the actual exchange occur? BofA's share price has plummetted in the past few days... Read More
Ex. BofA acquisition of MER. It was announced that BofA would exchange 0.8595 BofA shares for each MER share. This was announced on 9/16/08 so was based on BofA's share price then and MER price then. However, when does the actual exchange occur? BofA's share price has plummetted in the past few days... Read More
Re: Cost of Debt Sources
The issue is that the data source is needed for an organisation. And given the volume of companies evaluated by the organisation, it is not possible to spend too much time on subjective estimation of debt ...
Read More
The issue is that the data source is needed for an organisation. And given the volume of companies evaluated by the organisation, it is not possible to spend too much time on subjective estimation of debt ...
Read More
Re: Building models from scratch?
Is the capstone model transferrable to our daily work or is it just to build a model to learn different excel tools? Is it as detailed as the advanced core model?
Is the capstone model transferrable to our daily work or is it just to build a model to learn different excel tools? Is it as detailed as the advanced core model?
How do I create a long underline?
Full Question:
How do I create a long underline?
Full Question:
How do I create a long underline?
Excel 2003 to Excel 2007
Can you guys assist my company with the transition and migration from Excel 2003 to Excel 2007?
thank you.
Can you guys assist my company with the transition and migration from Excel 2003 to Excel 2007?
thank you.
How do I create a data table? - and limitations
Full Question:
What is the [=TABLE] function that I see and how do I re-create this "data table"
Full Question:
What is the [=TABLE] function that I see and how do I re-create this "data table"
Full Question:
What is the keyboard command for the right mouse click?