Construction of Portfolio

 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.



Comments

Post a Comment

Popular posts from this blog

Power BI Dashboard

 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.
Read more

WACC Modelling

Image
WACC (Weighted Average Cost of Capital) modeling involves calculating the average cost of a company's debt and equity, weighted by their respective proportions in the capital structure. This figure is used to discount future cash flows in financial valuation, helping determine a company's intrinsic value and assisting in investment decision-making. Data source for creating Model: Yahoo finance Industry: Automotive  *This is only for the educational purpose.
Read more