Posts by: Guest 1
Circular reference calculation not refrehsing automatically
In my financial model, there is a circular reference calculation for finance lease. I have selected "enable iteration" in the Excel settings, and the calculation runs well in normal circumstances. However, whenever there are some invalid cell references, say I delete an input row (which is... Read More
In my financial model, there is a circular reference calculation for finance lease. I have selected "enable iteration" in the Excel settings, and the calculation runs well in normal circumstances. However, whenever there are some invalid cell references, say I delete an input row (which is... Read More
Company Overview: Typo $3.34 not $3.33
Errata: Please note that at approximately 9:42 of the Financial Summary - Part 2 video the correct input should be $3.34 not $3.33 as the video mistakenly inputs.
Errata: Please note that at approximately 9:42 of the Financial Summary - Part 2 video the correct input should be $3.34 not $3.33 as the video mistakenly inputs.
WMT CapEx schedule - All new capex depreciated?
I was just curious why all new capex is being depreciated in future years. Shouldn't there be some allocation of new capex to land, which would not be depreciated? If so, would it be a safe assumption to allocate new capex on a pro rata basis based on existing gross pp&e and then just depreciate... Read More
I was just curious why all new capex is being depreciated in future years. Shouldn't there be some allocation of new capex to land, which would not be depreciated? If so, would it be a safe assumption to allocate new capex on a pro rata basis based on existing gross pp&e and then just depreciate... Read More
Inventory Writedown
Hello, I'm trying to integrate an inventory writedown to the fully integrated financial model that I've used from Hamilton. The model currently balances w/o any inventory writedown feature. I was wondering how I can add in an inventory writedown into the IS/BS/CF and still have the entire model b... Read More
Hello, I'm trying to integrate an inventory writedown to the fully integrated financial model that I've used from Hamilton. The model currently balances w/o any inventory writedown feature. I was wondering how I can add in an inventory writedown into the IS/BS/CF and still have the entire model b... Read More
Advanced Financial Modeling - Core Model: Minority Interest
I'm working on a company called Central European Media Enterprises and on the balance sheet there is minority interest. I know in the video we did not project that account because we did not have enough information. However, I do have quite a bit of information on the ownership interests of CME, s... Read More
I'm working on a company called Central European Media Enterprises and on the balance sheet there is minority interest. I know in the video we did not project that account because we did not have enough information. However, I do have quite a bit of information on the ownership interests of CME, s... Read More
How to model for existing revolver
Having worked through core model and enhancement classes, I am now trying to recreate this model for a new company. My question is that the new company already has an existing revolver with an outstanding balance. My initial instinct is to treat the outstanding balance on the revolver as a term loan... Read More
Having worked through core model and enhancement classes, I am now trying to recreate this model for a new company. My question is that the new company already has an existing revolver with an outstanding balance. My initial instinct is to treat the outstanding balance on the revolver as a term loan... Read More
Asset and Expense Valuation
In the Accounting Bootcamp Series, I think I understood him to say that the historical cost principal states that we should [u:i24l2u7i]ALWAYS [/u:i24l2u7i]use the actual cost we paid for an expense rather than market price. For example, if we bought 10,000 gallons of diesel at $5.00 a gallon and th... Read More
In the Accounting Bootcamp Series, I think I understood him to say that the historical cost principal states that we should [u:i24l2u7i]ALWAYS [/u:i24l2u7i]use the actual cost we paid for an expense rather than market price. For example, if we bought 10,000 gallons of diesel at $5.00 a gallon and th... Read More
AFM Core Model: Common stock is held constant, APIC is...
While projecting the 'common stock' we are not adding the new issues but we are adding the new issues to APIC. I am speculating that you have avoided updating the common stock as the impact is minimal due to low par value.
Your feedback is appreciated.
Sincerely,
Tushar
While projecting the 'common stock' we are not adding the new issues but we are adding the new issues to APIC. I am speculating that you have avoided updating the common stock as the impact is minimal due to low par value.
Your feedback is appreciated.
Sincerely,
Tushar
Intermed-Adv merger model
Where do you get the 2006A tax rate, and interest rate on cash, and interest rate on debt from? (2007-2010E projections use the 2006A metrics/data)
The model/module simply uses stated hardcoded/assumptions/manual inputs.
Where do you get the 2006A tax rate, and interest rate on cash, and interest rate on debt from? (2007-2010E projections use the 2006A metrics/data)
The model/module simply uses stated hardcoded/assumptions/manual inputs.
First, thanks for the quick response. Let me repeat what I think you said to make sure I've got it straight. First, the only time we really need to worry about excluding debt and debentures that are not IBNS's from liabilities is in certain industries like airlines, real estate, etc., where th... First, thanks for the quick response.
Let me repeat what I think you said to make sure I've got it straight.
First, the only time we really need to worry about excluding debt and debentures that are not IBNS's from liabilities is in certain industries like airlines, real estate, etc., where there could be a high proportion of debt that would not normally be seen in typical capital structures.
Second, regardless of the industry (as considered above), Interest Expense on the Income Statement ALWAYS includes all debt and debentures.
Did I get that right?
Rick Read More