Posts

Showing posts from December, 2023

Sales forecasting

Image
 

Portfolio risk and return

Image
 

Portfolio Project

Image
  I have taken the values of schemes/ portfolios of 5 different companies and Nifty, during the past 3 months. At present, risk free rate of return is 7.31%. Based on this information, I have ranked these schemes on the basis of Sharpe’s and Treynor’s ratios and also on the basis of Jensen’s model and commented on their performance relative to the market. I have also determined that which of these schemes has the highest unsystematic risk and whether any portfolio has outperformed the market.

Simulation for analysing a portfolio (Palisade)

Image
 

Calculation of maximum profit through Solver in excel

Image
 

Loan Amortization Schedule

 

Scooba Toys Company Power BI report

Image
 

Export Data of Country/Region

Image
 

AMFI NAV History Data

Image
 

Association of mutual funds in India (AMFI) Data

Image
 

Current Daily price of various commodities from various markets (Mandi)- Data through power query

Image
 

Northwind (Fictitious company) Data analysis Report

 

Age Calculator using Excel

 

Family Budget using Excel