Posts by: WST Expert 1
Re: DCF Mid-Year Convention
It is not common practice to use mid-year convention for DCF discounting; however it would be perfectly fine to do so.
It is not common practice to use mid-year convention for DCF discounting; however it would be perfectly fine to do so.
Re: DCF Correct Time Period inputs
You're quite welcome and keep up the good work!
You're quite welcome and keep up the good work!
Re: DCF Correct Time Period inputs
YES - that is a perfect summary and we couldn't have summarized it better than you did! Side Note: Generally, we like a solid five (5) years of projections, therefore we would add in a 2023 year into the model. However, if your model only goes to 2022, it would be still ok, just recognize it's on... Read More
YES - that is a perfect summary and we couldn't have summarized it better than you did! Side Note: Generally, we like a solid five (5) years of projections, therefore we would add in a 2023 year into the model. However, if your model only goes to 2022, it would be still ok, just recognize it's on... Read More
Re: DCF Correct Time Period inputs
Hello there, not a silly question at all! If you have latest financials, in this case through 2018 Q3, we would highly recommend doing a stub period, that is the one remaining quarter of 2018 + four (or five) more full projection years. Then we should definitely use net debt and capitalization fi... Read More
Hello there, not a silly question at all! If you have latest financials, in this case through 2018 Q3, we would highly recommend doing a stub period, that is the one remaining quarter of 2018 + four (or five) more full projection years. Then we should definitely use net debt and capitalization fi... Read More
Re: Trump's Tax Law - Interest Expense deduction limit?
The new law states that companies with annual gross receipts of at least $25 million now face a ceiling for their interest expense deductible: 30% of EBITDA. For highly leveraged companies who both (a) pay "a lot" in interest payments, and (b) earn "a lot", this could mean a higher tax bill (and thu... Read More
The new law states that companies with annual gross receipts of at least $25 million now face a ceiling for their interest expense deductible: 30% of EBITDA. For highly leveraged companies who both (a) pay "a lot" in interest payments, and (b) earn "a lot", this could mean a higher tax bill (and thu... Read More
Trump's Tax Law - Interest Expense deduction limit?
How does one account for the updated Interest Expense deduction limit in financial models?
How does one account for the updated Interest Expense deduction limit in financial models?
Re: New Student Question
Of course! We are here to help with any questions you may have.
Of course! We are here to help with any questions you may have.
Re: % Change
After converting daily data to monthly/yearly data (i.e. the price for July is defined as the price on July 31), you can just do a traditional percent change:
=A1/B1-1
(where A1 is the new value and B1 is the old value)
After converting daily data to monthly/yearly data (i.e. the price for July is defined as the price on July 31), you can just do a traditional percent change:
=A1/B1-1
(where A1 is the new value and B1 is the old value)
Re: Data Manipualtion
Hi Jay, If I'm understanding your question correctly, it might be best to just re-download the data on a monthly basis. Otherwise, you could use a Pivot Table and group everything by each month's average. A further dynamic solution would be to create a list of dates, and then use =AVERAGEI... Read More
Hi Jay, If I'm understanding your question correctly, it might be best to just re-download the data on a monthly basis. Otherwise, you could use a Pivot Table and group everything by each month's average. A further dynamic solution would be to create a list of dates, and then use =AVERAGEI... Read More
Our pleasure!
Just to clarify how to do mid-year discounting with NPV formula:
=NPV(WACC,range)*(1+WACC)^0.5
Please see our Free Resources section for DCF mid-year discounting:
http://wallst.training/about/resources.html