Saloni's Project Portfolio

 

 

 This is the VBA to record purchases and sales for a particular product and to keep track of inventory.

 I have solve linear programming objective function with the help of solver in excel.

 This is the EMI model which is based on variable interest rate. 

 This is the DCF Model on HUL which include the calculation of  free cash flows, terminal values, and equity value per share.

 The Dashboard explains the sales, cost of good sold and profit of the every product companies sold. Further it explains, which product has the highest sales and product every month. In the other words, dashboard gives brief overview about the product which is most profitable in last 12 months.

 This model explains how the increase in the financial leverage under various conditions affects the EBIT and EPS. 

 This model based on sensitivity analysis shows how the weighted average cost of capital changes as the beta changes and its impact on the Net present value and Internal rate of return of the project. Below is the snapshot of the model.

 I have constructed the portfolio by taking five companies namely TCS, PNB, Nestle India Ltd., Mahindra and Mahindra and Reliance Power Ltd. and calculated its risk and return and based on that I have suggested whether one should invest in the portfolio or not. Below is the model for the same.

 In this project, I have created a portfolio consists of four companies namely, HUL, Bajaj Finserv, Adani Enterprises and PNB and calculated their risk and return and rank them on the basis of Sharpe ratio, Treynor's ratio and Jensen Alpha performance index. 

In this project, I have predicted the sales for the year 9, 10 and 1 with the help of Regression technique. 

I have created the financial model of Reliance Industries Ltd based on Discounted cash flow method and forecasted the figures for next year.