Posts by: Guest 1
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.
Re: Inventory Writedown
THANK YOU SO MUCH!!! WST IS A LIFE SAVER!!!
THANK YOU SO MUCH!!! WST IS A LIFE SAVER!!!
Re: How to model for existing revolver
Thanks for the response and it makes sense to me. My only other question then is how do you handle the borrowing limit on the revolver. In my example, based on current assumptions the company's funding requirements would exceed its current borrowing limits. Is there a mechanism in the model that add... Read More
Thanks for the response and it makes sense to me. My only other question then is how do you handle the borrowing limit on the revolver. In my example, based on current assumptions the company's funding requirements would exceed its current borrowing limits. Is there a mechanism in the model that add... Read More
Balancing my M&A Model
Hello, I don't even know where to begin...but I'm trying to use the super advanced M&A model to evaluate an M&A. However, I tried to follow more or less the same design as what Hamilton initially constructed but am having a hard time balancing my model for my projection period. I was able... Read More
Hello, I don't even know where to begin...but I'm trying to use the super advanced M&A model to evaluate an M&A. However, I tried to follow more or less the same design as what Hamilton initially constructed but am having a hard time balancing my model for my projection period. I was able... Read More
Modeling an Equity Raise (IPO/FO)
This may be a stupid question since you don't cover it in your first 6 modules, but I was wondering what other considerations there are when modeling the pro forma impact of an IPO, follow-on or even a PIPE. Clearly the big items are the increase in cash and the corresponding increase to Common Stoc... Read More
This may be a stupid question since you don't cover it in your first 6 modules, but I was wondering what other considerations there are when modeling the pro forma impact of an IPO, follow-on or even a PIPE. Clearly the big items are the increase in cash and the corresponding increase to Common Stoc... Read More
How to set grey background in Windows 8?
Please kindly help!
Please kindly help!
AFM Core Model: Cash Flow Class
Hi, I have got some doubts related to the Cash Flow class: (1). Why are we considering the "Debt Repayment" (line 32 in the CF spreadsheet) after Dividends and Shareholders' Equity related activities (Repurchases, issuances, etc) in the model? I mean, Debt as a 3rd party source of funds should ha... Read More
Hi, I have got some doubts related to the Cash Flow class: (1). Why are we considering the "Debt Repayment" (line 32 in the CF spreadsheet) after Dividends and Shareholders' Equity related activities (Repurchases, issuances, etc) in the model? I mean, Debt as a 3rd party source of funds should ha... Read More
RE: SHLD Inputs on complex tr comps
Hi, thanks for your answers. Just two more points here: (3). When I ask a question to WST, be sure I always have watched the video at least twice (in the part I'm not sure of the concepts tought). So, here in question 3, please, I would like to hear WST comments on the fact that the amounts are v... Read More
Hi, thanks for your answers. Just two more points here: (3). When I ask a question to WST, be sure I always have watched the video at least twice (in the part I'm not sure of the concepts tought). So, here in question 3, please, I would like to hear WST comments on the fact that the amounts are v... 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... 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 then if diesel goes up to $6.00 a gallon we should not show the higher price.
How does this jive with GAAP guidelines that stipulate different valuation methods for different assets? (Acquisition Cost, Current Replacement Cost, Current Net Realizable Value and Present Value of Future Net Cash Flows)
Fore example:
- Accounts Receivables appear at Present Value
- Inventory, equipment and land apprear at acquisition costs (less depreciation)
Are these different topics that I'm confusing?
Thanks
Rick Read More