Function and Limits This “Financial Report Analysis Model” (FRAM) is a workbook made from Microsoft Excel software. This model could not be simplified simply using the function “Chinese Conversion” in Microsoft Excel, because there are formulas containing traditional Chinese which would be out of function after conversion. Three versions would be provided here, containing 6 years, 10 years and 16 years respectively. One way to reduce the size is to delete unused columns of years. This file is heavy mainly due to the worksheet “TB” which contains many columns to store data for many years. Do not open other files since this model is so heavy that working on multiple files might make your computer slow. These would be illustrated in the sections followed. Because only several worksheets need input, and not all cells in those worksheet need input, either. Also making sure that the cell you are changing do not contain formula is very important. It is strongly recommended to read this “User Manual” through before using it. In fact, this model was produced on Microsoft Excel 2013. It is strongly recommended to run this file on Microsoft Excel 2010 or above. Last but not least, I must thank my family, they provide great support for my efforts. They are my treasured experience in my life. Thanks to my colleagues and leaders, and my previous companies, from which and in where I learn a lot. Lexiang Yu「于 樂翔 先生」, CICPA, the joy and encouragement you give me always fill me with pleasure and power. Eric Cheung「張 楊 先生」, CICPA, and other friends, discussion with them help to make this model much better. The discussion with them helps me realize the techniques, art and difficulties in valuation. Cunhua Chow「周 存華 先生」, a researcher, who provides me with the important raw material for testing the model, and Mr.
Iask ishare software#
Ivan Li「李 金華 先生」, a software engineer, teaches me knowledge and techniques about data base. Jinhua Lee「李 金華 先生」 (CICPA, helps me make clear about many accounting issues and the structure of Managerial Financial Report, especially the Supplement Notes to the Statement of Cash Flow. There are two person with the same name “Jinhua Lee” I must thank to. Jun Soo「蘇 俊 先生」, also a software engineer, teaches me the design principle of separating input, process and output, and this solves the great difficulty of the structure of this file, greatly push the work forward. Without his advice, this model would be rewritten once again. For example, whether cash in bank and bank deposit with fixed term, deferred tax assets and liabilities (DTA & DTL) should be reported as two parts, and later I found it discussed in an amendment to “IAS 12 Income Taxes”. His unintended words guide me to find out the supporting and the reason of the current and non-current framework of financial reporting.
A special thanks goes to the support of Mr.
Many incredible ideas which are beyond my intelligence run to my mind, especially when I am confused.
Iask ishare manual#
User Manual Thank you, Supernatural powers! I believe there are Supernatural powers who are almighty and helping me working on this file. Here i’d like share a financial report analysis model i developed mainly in the past two months.įolder FRAM FRAM用戶手冊(請閱此先).docx FRAM User Manual (Readme first please).docx FRAM (6y) -ShenKai(002278.SHE).xlsx FRAM (10y) -ShenKai(002278.SHE).xlsx FRAM (16y) -ShenKai(002278.SHE).xlsx
0 kommentar(er)
