Posts by: Michael D

Quarterly Modeling - Current Portion LT Debt
When modeling a company and making projections using quarterly financials, should the quarterly balance sheet item for Current Portion of LT Debt include the next 4 quarters of mandatory payments? If so, to not add debt to the balance sheet, do you then decrease the Long Term Debt liability by the ... Read More
Go to post added 4 years ago
Part 3 - LOB: QS
Why are you continuously locking cell $F$102 rather than letting it float across to the corresponding year? Shouldn't the cells referencing the Quota % (row 102) float with the year? For example, cell G90 would read "G9*F$102" rather than "G9*$F$102" ? Thanks
Go to post added 5 years ago
Re: Derivative Assets for E&P Companies
Thank you
Go to post added 5 years ago
JCP LBO Template
In the JCP LBO template self-study, Long Term debt on the balance sheet is linked from the debt sweep (I77), which includes preferred debt along with senior unsecured debt. Should preferred debt notional always be included in that manner or should it be included in shareholders equity? For the JCP... Read More
Go to post added 5 years ago
Derivative Assets for E&P Companies
When modeling an E&P company and the derivative assets listed on the balance sheet are expected to be monetized in the projection period, do we decrease the derivative asset balance to zero and run the figure through the income statement for the related period? And then project zero for the derivat... Read More
Go to post added 5 years ago