In a company, partnership, or sole proprietorship venture, its financial statement shows the financial well being or condition of the company. A balance sheet constitutes 3 basic aspects: assets, liabilities, and equity. Needless to say, for a company to be profitable, the liabilities need to be lesser than the assets. The difference in amount shows the 'net worth' of the company. If you are new to such sheets and wondering how it is done, you can search the internet for many sheet examples. A typical company statement of financial position presents assets and liabilities in 2 different sections and the total should always balance. If the sheet does not show the same amount in both assets and liabilities, it has to be redrawn.
Part of the fundamental financial analysis of any company, investment security, or business project entails the computation of cash flows. This is typically done in a cash flow template Excel spreadsheet which is pre_built for the purpose. The reason for this is that this type of template is not a simple calculator you build on the fly with little effort. It requires a lot of thinking, organizing the spreadsheets and formulas, and some planning about how to model cash in and cash out for each potential investment. In other words, there is no cookie cutter approach because each potential investment has different profit and loss drivers.