Posts by: Richard S
Re: Using book value in Residual Income
Thanks! I will take a look at everything you said. I think the terminal value is based only on the premium over the book value at the end of the forecast period, not the entire book value (which would be double-counting). I used a premium from 1.5x to 2.5x, which is the same as a P/B ratio betwee... Read More
Thanks! I will take a look at everything you said. I think the terminal value is based only on the premium over the book value at the end of the forecast period, not the entire book value (which would be double-counting). I used a premium from 1.5x to 2.5x, which is the same as a P/B ratio betwee... Read More
Capital charge under EVA
Hi, I think the capital charge is supposed to be calculated using the prior year's ending total capital. So, 2006's capital charge should be 11% of 2005's total capital or $87,949, or $9,674; 2007's should be $10,956, and so on. This is using the figures from the core model not from the video. Is th... Read More
Hi, I think the capital charge is supposed to be calculated using the prior year's ending total capital. So, 2006's capital charge should be 11% of 2005's total capital or $87,949, or $9,674; 2007's should be $10,956, and so on. This is using the figures from the core model not from the video. Is th... Read More
Using book value in Residual Income
I think you made three mistakes in how you calculated equity value using RI. 1) You forgot to add the current book value to your valuation estimate. You should either add cell I12 to K25-L25, or better, bring in the 2005 book value from the core model ($53,171) in cell H12. 2) Equity charges s... Read More
I think you made three mistakes in how you calculated equity value using RI. 1) You forgot to add the current book value to your valuation estimate. You should either add cell I12 to K25-L25, or better, bring in the 2005 book value from the core model ($53,171) in cell H12. 2) Equity charges s... Read More
Selecting non-adjacent cells in Excel using only the keyboard
1) Select the first cell or group of cells. Press F8, then press shift F8. The cells should become highlighted.
2) Navigate to the next cell or group of cells. Highlight them, press F8 and shift F8.
3) Repeat as necessary.
1) Select the first cell or group of cells. Press F8, then press shift F8. The cells should become highlighted.
2) Navigate to the next cell or group of cells. Highlight them, press F8 and shift F8.
3) Repeat as necessary.
Redundancy and repeated page numbers?
Why does the 10-K go for about 23 pages, then start all over again with pretty much the same information and starting with new page numbers? It seems really redundant and confusing.
Why does the 10-K go for about 23 pages, then start all over again with pretty much the same information and starting with new page numbers? It seems really redundant and confusing.
Re: HRH 10-k filing
Understood, but it is a 10-K is a public document. Here is the one I wound up using:
https://www.sec.gov/Archives/edgar/data/814898/000100210503000094/f2002hrh10kav2.htm
Understood, but it is a 10-K is a public document. Here is the one I wound up using:
https://www.sec.gov/Archives/edgar/data/814898/000100210503000094/f2002hrh10kav2.htm
HRH 10-k filing
Where is the HRH 10-K filing?
Where is the HRH 10-K filing?
How is the macro (Ctrl+Shift+Alt+R) different from the built-in fill right (Ctrl+R)?