- Видео 12
- Просмотров 70 405
Terry Tate
США
Добавлен 22 окт 2015
I provide financial tips for anyone that wants to expand their financial skills, especially topics that relate to financial modeling, investment banking, private equity, and using Microsoft Excel for building models. I have earned BA and MBA degrees from Jackson State University and Jones International University and currently pursing an Doctoral of Business Administration from Walden University. I am currently seeking employment in Investment Banking or Private Equity and creating videos on the subject helps me to perfect my craft. I hope that you learn and enjoy my videos. Thanks for watching.
-Terry
-Terry
Valuation Comparable Companies and Precedent Transactions
In this video I calculated the Implied Enterprise Value, Implied Equity Value and Implied Share Price from comparable public companies and precedent transactions. For the comparable companies I intentionally chose companies that were not the best to compare to illustrate how selecting the wrong companies can result in an erroneous valuation. I assumed precedent transaction because the difficulty of locating precedent transactions and their data.
Просмотров: 6 920
Видео
Enterprise Value Calculation
Просмотров 1,6 тыс.8 лет назад
I calculated Diluted Equity and Enterprise Value in this short video.
LTM Calculation
Просмотров 3,3 тыс.8 лет назад
I performed a Last Twelve Month (LTM) Calculation in Excel from data gathered from the SEC for Revenue, EBITDA, and Net Income for GE.
Calculating Dilution and Diluted Equity
Просмотров 1,8 тыс.8 лет назад
In this video I calculated dilution from warrants and options, Basic Equity, and Diluted Equity
FCF UFCF LFCF
Просмотров 4348 лет назад
In this video I utilize an Income Statement and Cash Flow Statement to calculate Free Cash Flow, Unlevered Free Cash Flow, and Levered Free Cash Flow
Building and Correcting 3 Statement Model
Просмотров 9048 лет назад
Building and Correcting 3 Statement Model
IRR Calculation and IRR Sensitivity Table
Просмотров 47 тыс.8 лет назад
Internal Rate of Return calculation and Internal Rate of Return Sensitivity Table Creation
Purchase Price Allocation Section of Merger Model
Просмотров 4,3 тыс.8 лет назад
Purchase Price Allocation Section of Merger Model
Sources and Uses of Funds Section of Merger Model
Просмотров 3 тыс.8 лет назад
Sources and Uses of Funds Section of Merger Model
M&A Transaction Assumptions Section of Merger Model
Просмотров 5918 лет назад
Transaction Assumptions Section of Merger Model
bad
I UNDERSTAND NOTHING!
ممكن شيت الاكسيل
very well Explained Thanks from India.
where can i get the excel model?
Where can i get the excel model?
Where can i get the excel model?
where can i get the excel model you using?
Liked the video very informative. Are you able to share that excel file with the formulas included?
Hi Terry, Thanks for sharing this useful video. Can you please share the excel sheet if possible. portfolio.pal@gmail.com
Wouldn't you add debt issuance to the levered cash flow?
How would you determine the PPE write up if it's not given to you?
Hi Terry, I'm using Excel 2016 - what should I hit instead of "ALT+D+T" to create the tabel? Br Thomas
the best. period
Nice model.
Hi Tarry .. Thanks for this great tutorial video Have a question related to precedent transaction valuation the figures on the sheet are of acquirer or target company ? Please revert ASAP and would like to know your twitter handle if you are there to connect with you on this