Posts by: Guest 1
CAGR Question?
if you calculate CAGR and it returns a #NUM!, what shall I do?
if you calculate CAGR and it returns a #NUM!, what shall I do?
RE: DCF EBITDA multiple approach
Sorry to bother you on this. I understand the perpetuity method which, of course, we have to add the interim cash flow to the terminal value because the terminal value represents the cash flows that the company would generate, say, to infinity from the terminal year. However, the EBITDA multiple... Read More
Sorry to bother you on this. I understand the perpetuity method which, of course, we have to add the interim cash flow to the terminal value because the terminal value represents the cash flows that the company would generate, say, to infinity from the terminal year. However, the EBITDA multiple... Read More
Re: Reference Range: Valuation of other industries
Hello,
Do you expect to integrate these future industry specific models into the self study video course? Also, do you expect to have TMT industry in the future as well? Thanks
Hello,
Do you expect to integrate these future industry specific models into the self study video course? Also, do you expect to have TMT industry in the future as well? Thanks
I need a Function to Start With (Summing alternate row)
I’m not sure what function to use for my issue. I desire a formula I can enter into a cell, and I don’t want to use filters. 1.) I want excel to search down a column and identify the status “Completed.” 2.) After it finds all instances, I want it to go to the next column (this is a numbe... Read More
I’m not sure what function to use for my issue. I desire a formula I can enter into a cell, and I don’t want to use filters. 1.) I want excel to search down a column and identify the status “Completed.” 2.) After it finds all instances, I want it to go to the next column (this is a numbe... Read More
Valuation of fair market value of debt converting to equity
Question.... How do you fair maket value debt that is converting to equity post a bankruptcy? Meaning, the senior lenders are goign to have all of the equity post restructuring and you're trying to figure out the value of the equity day 1 of chapter 11 emergence... Here's what I know so far.. (... Read More
Question.... How do you fair maket value debt that is converting to equity post a bankruptcy? Meaning, the senior lenders are goign to have all of the equity post restructuring and you're trying to figure out the value of the equity day 1 of chapter 11 emergence... Here's what I know so far.. (... Read More
Re: Automated S&P Debt Rating
thank you.
thank you.
Zoom in Excel
What are the shortcut keys for zooming in and out of EXCEL using only the keyboard?
Thanks,
What are the shortcut keys for zooming in and out of EXCEL using only the keyboard?
Thanks,
Re: D&A is different on the I/S and CF, which to use ??
-10.8, 45.5, 10yrs
-10.8, 45.5, 10yrs
Modifying the Debt Sweep to Target a Debt/Capital Ratio
Hi - Can you help me figure out how to modify the Debt Sweep Schedule to target a specific debt/capital ratio? You explain this in your Credit & Leverage Statistics videos without an excel example. Could you provide an example in Excel?
Joseph
Hi - Can you help me figure out how to modify the Debt Sweep Schedule to target a specific debt/capital ratio? You explain this in your Credit & Leverage Statistics videos without an excel example. Could you provide an example in Excel?
Joseph
Hi, i hv say a few years of daily stock price and i want to overlay some quarterly inventory number or the yoy change on the inventory number to see how it moves with the share price. but since i maybe hv 10-15 rows of quarterly number, but i hv thousands of row in the daily stock price, how can i l... Hi, i hv say a few years of daily stock price and i want to overlay some quarterly inventory number or the yoy change on the inventory number to see how it moves with the share price. but since i maybe hv 10-15 rows of quarterly number, but i hv thousands of row in the daily stock price, how can i line the up together so that i can make a 2-line chart? Thanks Read More