Posts by: Hamilton L

Re: Current liabilities
Yes, for purposes of calculating working capital from the finance perspective, we would definitely exclude cash from Current Assets and debt related items from Current Liabilities. Keep in mind that the Accounting definition would have us do a straight Current Assets / Current Liabilities.
Go to post added 8 years ago
Re: Current Liabilities
Yes, for purposes of calculating working capital from the finance perspective, we would definitely exclude cash from Current Assets and debt related items from Current Liabilities. Keep in mind that the Accounting definition would have us do a straight Current Assets / Current Liabilities.
Go to post added 8 years ago
Re: Credit/Leverage Statices
Hello, we didn't go over the credit ratios because it was covered separately in the Quick & Dirty LBO course. While we cannot send the models out, we would be happy to review your credit ratios and let you know if there are any errors in your model. Please email it to us and we will check the credit... Read More
Go to post added 8 years ago
Re: equity IRR
Once again, for IRR, calculations, they are always done on a cash-on-cash basis. FCFF and horribly, FCFE, are for DCF valuation and not true cash-on-cash. Your calculation would be similar to modeling out LBO returns - equity investment at time 0 (cash outflow), followed by any actual cash dividends... Read More
Go to post added 9 years ago
Re: Macros not installing properly
No problem. Changing the world one macro at a time!
Go to post added 10 years ago
Re: Macros not installing properly
Please make sure you don't have conflicting macros, such as FactSet or Capital IQ installed. You would have to navigate to their ribbon menu option, then hit Settings. For FactSet, select HotKey Manager (or something to that effect) and select Disable All (or similar). For CapIQ, select Shortcuts on... Read More
Go to post added 10 years ago
Re: Adjusting Diluted shares for convertible bonds
This is covered in the chapter explaining COST and how to treat converts for the purpose of TEV calculation. If you have a specific question, please reply and we will be happy to address it directly. Thank you.
Go to post added 10 years ago