I recently tried to calculating PB ratio of UOB bank but my numbers seems quite far off from what I saw in your video (although it\’s 1 yr old -> https://www.youtube.com/watch?v=WDOCTOufwBs).
In your video, your calculated mean PB was 1.33 whereas my calculated mean PB is 0.99 (see attached PDF file). I used the “NAV per ordinary share” in the financial reports as the “Book value” in my excel file for calculation. Is this the correct parameter to use?
Will appreciate your help in identifying where I went wrong. Thanks!
P.S. Apologies for the messy PDF file. The website doesn’t allow me to upload the original excel file.
can you send the excel file to firstname.lastname@example.org
Let me take a look and get back to you here.
I have looked through your data point already.
Your methodology of inputting the data point is correct. You must change the price data point from adjusted close price to close price.
The PB chart should be based on ten years, not five years.
Apologies for the repeated questions. What is the difference between NAV and Revalued NAV? Which should I be using to calculate the Price/Book ratio?
Please login or Register to submit your answer