Solve 4th problem only and if possible create a spreadsheet for it and share it in the answer section.

Company 1: Nestl India

Company 2: Procter & Gamble Hygiene and Health Care Limited

1. Compare the capital structure of both the companies by considering data for 2018-19 and 2019-20. 2. Compare the dividend policy of both the companies by considering data for 2018-19 and 2019-20. 3. Find out if the company has gone for the following in 2018-19 and 2019-20 and provide information. a. Share buyback b. Public offer of equity shares c. Issue of bonds and debentures d. Rating of long term bonds (if issued by the company) in 2019-20 4. Find out the beta of the equity of both the companies for 2018-19 and 2019-20 by considering weekly returns and compare the results. File Names: Group XX.pdf (for analysis etc.) supported by Group XX.xls (spreadsheet). Please use multiple sheets as necessary in the spreadsheet file