projectportfolio

Saloni's Project Portfolio

Excel VBA

Get link
Facebook
X
Pinterest
Email
Other Apps

December 26, 2023

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

Get link
Facebook
X
Pinterest
Email
Other Apps

Comments

Financial Model on Reliance Industries Ltd.

December 24, 2023

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

WACC Modelling

January 21, 2024

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.

Construction of Portfolio

December 24, 2023

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.

Powered by Blogger

Theme images by Michael Elkan

Saloni Sharma: US-CMA professional currently pursuing an MBA in Finance from Manipal University, Jaipur. Possessing technical expertise in financial modeling, advanced Excel, and MySQL and Power BI. Proficient in financial planning and analysis, corporate finance, budgeting and forecasting, data analysis, visualization and interpretation. Eager to contribute to the finance sector, she is open to leveraging her skills and knowledge in the finance work environment.

Visit profile