Published
May 9, 2020
Category
Fundamental Analysis
Works on
Indian Stock Market

01. Balance Sheet Analysis Excel Sheet

OThis Excel Sheet will help us analysis the Health of a Company using the Balance Sheet. The objective is the spot a company for long term Horizon using the companies Debt structure , Equity Capital and Reserves. The goal is to see if the company is quipped to handle stressed Economic Scenario, wether the company can operate well in Bad Economic Conditions and how safe would the company be in those situations along with possibility analysis of a situations such as Bankruptcy.

“ The health of a Company Lies in its Balance Sheet, the stronger it is , the more return it gives in the long Run .”

02. How to Use the Excel Sheet

The First thing you need to do is Download the Excel Sheet ” Balance Sheet Analysis ” from this Website.

Things that you Need to Get Started –

1. Balance Sheet Analysis – Download the Excel Sheet ( Click  )

2.  Balance Sheet Data – http://www.screener.in ( Click ) 

Then Follow the Steps One by One .

03. Balance Sheet Analysis

This Will give you the Automated Data of the Balance sheet like the Curve of Equity Capital , Reserves and Debt, and with this report we will be able to analyse if the Stock that we are analysing has a Healthy Balance Sheet or not. This gives us an idea for the future outlook of the company and how safe it is for us to invest in it. 

Download Link of the Excel Sheet –  Balance Sheet Analysis ( Download this )