My responsibility as a Financial Analyst in L'Oreal corporation forecasting and Budgeting Finance Team on a day to day Operation is to retrieve financial documentation from Business Objects and Convert the Documents into a pivot Table format analyzing and interpreting Actual vs. Budget Comparison. For an example, I would compare the prior year's Budget to the Present Year's Budget comparison of retained Earnings of How much of the earnings is utilized in a particular area such as Favorable and Adverse Analysis. The sectors are Direct Materials, Direct Labor, Materials, And Vendor Invoices of Merchandise bought and Sold. After all of the information gathered and converted into a pivot table format I would prepare a particular Line and bar graph of explanation of how Much budget is remaining in relation to the deviation between Net Income and Revenue.
The reason for constructing a Pivot Table is to save Time and Effort for Financial Manager, instead of the manager skimming through workbook to workbook of thousands of documents to be approved. Also we would undergoes a excel test of various formulas such as V-lookups, Sum-if's, and macros to find solutions to our assumptions.
For Example, as an analyst I had to find out each regions total sales for the month and the total Sales Managers total output on a given criteria. If a criteria of >=$50,000 is given, then I would perform a V-lookup Analysis to retrieve all Sale Managers equivalent to the criteria of each Region such as WEST, East, Southeast, North East, South west, And North West. Finally perform a sum-if Formula to find the total managers output of $50,000.
A total number of 6 members were involved in a group discussion in the Finance Treasury Team. We would give our perspective on a particular exception or verification that came along a discussion. As an analyst I would give my perspective on my thoughts and mindset.