Posts by: Guest 1
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
Re: WACC of a private company?
Hi i have the same valuation question for Private companies. the private company is based in china. how do i play with WACC? - specifically the kd portion when moving forward as the target debt is very low or zero. industry debt is also very small at 3.7%. also comps are not easy to come by in thi... Read More
Hi i have the same valuation question for Private companies. the private company is based in china. how do i play with WACC? - specifically the kd portion when moving forward as the target debt is very low or zero. industry debt is also very small at 3.7%. also comps are not easy to come by in thi... Read More
Oil and Gas Valuation
Ware there any rules of thumbs for valuing oil and gas reserves in the ground on both P1, P2 and P3 bases? Such that there are 100m barrles in the ground, what is it worth? Are assumptions made on how is extractabel etc? Same things for gas. Would appreicate a rule of thumb as well as overview ... Read More
Ware there any rules of thumbs for valuing oil and gas reserves in the ground on both P1, P2 and P3 bases? Such that there are 100m barrles in the ground, what is it worth? Are assumptions made on how is extractabel etc? Same things for gas. Would appreicate a rule of thumb as well as overview ... Read More
att and t-mobile deal
Hi, I am a rookie and have some questions in understanding the att and t-mobile deal. 1. purchase price of 39b is comprised of 25b in cash and 14b in att stocks. What would be the balance sheet effect to att? ( my thoughts: att 's cash is going to be reduced by 25b less the increase t... Read More
Hi, I am a rookie and have some questions in understanding the att and t-mobile deal. 1. purchase price of 39b is comprised of 25b in cash and 14b in att stocks. What would be the balance sheet effect to att? ( my thoughts: att 's cash is going to be reduced by 25b less the increase t... Read More
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