Relationship Between PNB housing finance & Nifty-50<\/p>\n
Author \u2013 Poonam Sharma
\nIntroduction \u2013
\nPNB Housing Finance Limited (PNB Housing) is a registered housing finance company with National Housing Bank (NHB) incorporated under the Companies Act 1956 and commenced its operations on November 11,1988. It is promoted by Punjab National Bank (PNB) which holds 32.8% of share capital in the company. The company offers its retail customers housing and non-housing loans. The company is also into construction finance loans to real estate developers for residential housing. PNB Housing Finance is a deposit taking Housing Finance Company. The company has a robust network of branches spread across the country which help its customers avail financial services (loans and deposits) seamlessly.
\nObjective \u2013
\nCalculate the Beta of the \u201cPNB Housing Finance\u201d and see its significance.<\/p>\n
Data Collection \u2013
\nFirstly, we have downloaded the data of PNB housing finance Nifty-50 dated from 1st April 2021 to 31st March 2022 from the website of National Stock Exchange(nseindia.com), Nifty equity is download by CSV file. Firstly, we have taken the data of Nifty-50 and after deleting all the column except date and closing stock, we have added the weekday column in the data using weekday function of excel, then we have deleted all rows except the 5th day (Friday) rows. Then we have added another column named as Returns column where we have found the returns by using the values in closing stock column and named it as X (which will be X for regression also). Similarly repeating all these steps for our selected company, we named it as Y (which will be Y for regression also). Here is how we have collected the X and Y values. <\/p>\n
Data Analysis \u2013
\nWe can write the equation in the form of Y = a + b(X)
\nWhere, Y = PNB Housing Finance Returns
\n X = Nifty-50 Returns
\n a = intercept and b = slope
\nHence, the equation becomes,
\nY =1.5911+ (1.8176)*X
\nVoltas Returns = (1.5911) + (1.8176)*(Nifty-50 Returns)
\n (2.2995)
\nn = 44 R2 = 0.1118 and F = 5.2880<\/p>\n
Conclusion \u2013
\nThe above equation tell us, the relationship between X & Y. If X rise by 1 unit Y will fall by 1.8176 vice versa given figure in 2.2995 is the T stat for b. P-value for which (0.02) which is less than 0.05, It means b is statistically significant at 5% level.
\nR2 is 0.118 which means 11% of Y is explained by X. F is 5.2280 and the value for which is 0.02, which is less than 0.05. It means the over all model is statistically significant at 5% level.<\/p>\n","protected":false},"excerpt":{"rendered":"
Relationship Between PNB housing finance & Nifty-50 Author \u2013 Poonam Sharma Introduction \u2013 PNB Housing Finance Limited (PNB Housing) is a registered housing finance company with National Housing Bank (NHB) incorporated under the Companies Act 1956 and commenced its operations on November 11,1988. It is promoted by Punjab National Bank (PNB) which holds 32.8% of… Continue reading Relationship between P&B housing finance & Nifty-50<\/span><\/a><\/p>\n","protected":false},"author":93122,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9],"tags":[355],"class_list":["post-16397","post","type-post","status-publish","format-standard","hentry","category-management","tag-jdbims","entry"],"_links":{"self":[{"href":"http:\/\/www.sachdevajk.in\/index.php?rest_route=\/wp\/v2\/posts\/16397","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.sachdevajk.in\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.sachdevajk.in\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.sachdevajk.in\/index.php?rest_route=\/wp\/v2\/users\/93122"}],"replies":[{"embeddable":true,"href":"http:\/\/www.sachdevajk.in\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=16397"}],"version-history":[{"count":1,"href":"http:\/\/www.sachdevajk.in\/index.php?rest_route=\/wp\/v2\/posts\/16397\/revisions"}],"predecessor-version":[{"id":16459,"href":"http:\/\/www.sachdevajk.in\/index.php?rest_route=\/wp\/v2\/posts\/16397\/revisions\/16459"}],"wp:attachment":[{"href":"http:\/\/www.sachdevajk.in\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=16397"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.sachdevajk.in\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=16397"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.sachdevajk.in\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=16397"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}