Posts

Preparation of Salary sheet, Purchase Bill and Sales Bill

Image
 

Excel VBA

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

Solver

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

EMI Model

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

DCF Model

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

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.

EBIT-EPS Analysis

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