Posts by: WST Expert 1
Re: Dividend payment for Debt Paydown
You answered your own question. How you treat dividends assumptions depends on your goal. If building a transaction oriented model (i.e. investment banking) or run-rate model and dividends are fairly steady, then you incorporate the dividends as we did in the models. That is, dividends are essenti... Read More
You answered your own question. How you treat dividends assumptions depends on your goal. If building a transaction oriented model (i.e. investment banking) or run-rate model and dividends are fairly steady, then you incorporate the dividends as we did in the models. That is, dividends are essenti... Read More
RE: Limitation on number or rows in excel 2003
Thank you for your inquiry. in excel 2003 there are only 65,536 rows and 256 columns. you are thinking about excel 2007 in which there are over 1 million rows and 16,000+ columns.
Thank you for your inquiry. in excel 2003 there are only 65,536 rows and 256 columns. you are thinking about excel 2007 in which there are over 1 million rows and 16,000+ columns.
RE: AFM Core Model: mandatory debt payment for commercial paper
The assumption for CP is that the net change is zero - we assume that we borrow the same as any repayments. In reality, the CP is the revolver for WMT.
The assumption for CP is that the net change is zero - we assume that we borrow the same as any repayments. In reality, the CP is the revolver for WMT.
Re: Completed Model: Advanced Bank Model
Unfortunately, you won't like the answer to your question. We do not disseminate completed models.
We do, however, have our Verification option:
http://www.wstselfstudy.com/certification.html
Unfortunately, you won't like the answer to your question. We do not disseminate completed models.
We do, however, have our Verification option:
http://www.wstselfstudy.com/certification.html
Re: Modeling Questions for Mature Company
Thank you for your inquiries. 1) Oftentimes, we will indeed model out CP as the revolver. Some companies, including WMT, use CP market as their revolver (of course, they still have an actual revolver facility in place as well). 2) Depending on the nature of the investments, we like to place Short-... Read More
Thank you for your inquiries. 1) Oftentimes, we will indeed model out CP as the revolver. Some companies, including WMT, use CP market as their revolver (of course, they still have an actual revolver facility in place as well). 2) Depending on the nature of the investments, we like to place Short-... Read More
RE: Linking between files
short answer: don't link between files; this is a fatal error! medium length answer: go to EDIT => LINKS and click on Change Source (only later versions of Excel); be careful to check links are still valid in case independent source file was modified to add/delete rows/columns long answer: ... Read More
short answer: don't link between files; this is a fatal error! medium length answer: go to EDIT => LINKS and click on Change Source (only later versions of Excel); be careful to check links are still valid in case independent source file was modified to add/delete rows/columns long answer: ... Read More
RE: AFM Core Model: Current Portion of LT Debt
Keep in mind that commercial paper is split out separately. Our assumptiom says no change in CP- so no borrowing or paydown. However if there was a paydown, we would consider it as part of your required repayment. In reality there is a paydown of CP since it is short term debt for working capital pu... Read More
Keep in mind that commercial paper is split out separately. Our assumptiom says no change in CP- so no borrowing or paydown. However if there was a paydown, we would consider it as part of your required repayment. In reality there is a paydown of CP since it is short term debt for working capital pu... Read More
Re: Merger Modeling & LBO Modeling - FASB 141r
Transaction costs are now expensed. for simplicity, we treat it the same as tendor costs, that is, via Retained Earnings on the BS. If you want to be really correct, you would have a tax savings on that which we'd run through our NOL schedule. Ditto for tender costs, but it's so immaterial, we chose... Read More
Transaction costs are now expensed. for simplicity, we treat it the same as tendor costs, that is, via Retained Earnings on the BS. If you want to be really correct, you would have a tax savings on that which we'd run through our NOL schedule. Ditto for tender costs, but it's so immaterial, we chose... Read More
Re: Modeling Questions for Mature Company
You're quite welcome. We're glad you enjoyed.
Don't forget to contact us for a discount, especially if you're interested in multiple online packages.
You're quite welcome. We're glad you enjoyed.
Don't forget to contact us for a discount, especially if you're interested in multiple online packages.
Yes, take a look at the pv graph on the profile which we didn't get to. create a new series next to stock prices with just numbers filled in for the dates you want. Then chart type is line, formatted as no line, but with marker. Make the marker big enough and then manually point your arrow to the ex... Yes, take a look at the pv graph on the profile which we didn't get to. create a new series next to stock prices with just numbers filled in for the dates you want. Then chart type is line, formatted as no line, but with marker. Make the marker big enough and then manually point your arrow to the exact point, making sure to touch the line. Then when all done, remove marker. All set. There are ways to automate using custom developed macros and programs but short of that, that's the easiest, fastest and most accurate way. Read More