巧妙利用Excel进行财务分析.docx

巧妙利用Excel进行财务分析 At the time of financial analysis, most financial personnel are using manual computing to calculate the amount of work? In addition, the enterprise is in accordance with the requirements for the superior financial indicators calculation, rarely design enterprise, so it is difficult to more comprehensive and systematic analysis of the financial, difficult to give full play to the enthusiasm and initiative of itself, is not conducive to the improvement of management leve1. The other is that the unit that achieves accounting computerization may have some financial analysis indicators in its accounting software? But if these indicators cannot be added or modified, it is often difficult to meet the different needs of various companies? Aiming at the problems above, we advocate the use of Excel (spreadsheet) were analyzed, and its advantage is analysis method is unlimited, unlimited analysis indicators, analysis of the content is uniimited? Using Excel for analysis, it goes through several stages: Design report format? To be on the basis of the current financial statements, and make some necessary changes on the project, such as increasing variable costs, contribution Mao Yi, fixed costs, profit before interest and tax, quick assets, Iong-term assets, etc? Note: if using the method of automatically filled up financial data, adjust the project must be listed in the accounting software or Excel template to provide the reports, in order to prevent automatic filling column when financial data for uplink? Seco nd, to the main column, add the necessary colum n. Including the column of this period, the upper or the planned column, the trade average column, the comparison column, the comparison column can be divided into the relative number, the difference and the percentage? Of course, for clarity, don，t set too many columns, you can put different comparisons in different worksheets of the same workbook? Three, target the main column, determine the analysis inde