NU12 Week4 K Abrugena Improved Financial Analysis

Good afternoon Sir, please see below. Thanks and have a great weekend! ABRUGENA, KRISTINE C. April 27, 2012   NU12_Week4 New process at work   I am part of the Commercial Banking Group wherein we deal with top corporate clients. We package credit facilities, or what is commonly known as corporate loans based on the needs of the clients, whether they are importers or exporters. Afterwhich, we do prepare credit proposals to be presented to and approved by the Credit Committee and the Executive Committee, respectively. Managing corporate accounts entail financial analysis of the Financial Statements of the companies. In doing so, I prepare the spreadsheets of the submitted Audited and Interim FS with the use of MS Excel and analyze the Profitability, Liquidity and Efficiency of the accounts.     Different corporations have different entries in their books as dictated by the nature of their businesses thus the spreadsheets have to be revised for each corporation that has to be analyzed. I realized that the editing of the excel file to fit the character of the company is already taking much time. So that's what made me think of a system that would allow the user to encode the figures only in the entries that are related to a particular company. In this system would be a list of all accounting entries, whether the company pertains to service or manufacturing, and it gives out the flexibility that the only ones to be filled up are only those relevant to the books of the corporation. Just like the excel file, the system shall present at least the three-year performance of the company. I think that this will also lessen the occurrence of errors as there would be no more editing in terms of adding and deleting accounting entries. Also, I noticed that the movements of figures in cells are prone to errors as links in various computations may shift. With the use of the system, we can be more confident in inputting the data since everything is already listed and the end-result will just come out once the figures encoded are verified as balanced. Moreover, I believe that this will save more time in counterchecking as well as in determining the accuracy of the data. Furthermore, I would suggest that the system is open to adjustments of accounting entries such that "Due to/from Affiliates" and "Advances from Officers" can easily be classified as part of Equity instead of Liabilities for better analysis of the financial position. What I am pointing at is in the process of doing financial analysis, there should be more time allotted in analyzing rather than preparing the spreadsheets. I believe that this will improve the working process of the employees hence having more outcome due to time saved and efficiency. 4