I am seeking a skilled financial analyst or modeler to develop a comprehensive financial statement model for a publicly listed company. This project requires a detailed understanding of financial accounting, corporate finance, and financial modeling.
Objectives: Creation of a Dynamic Model: Develop a dynamic financial statement model that can forecast income statements, balance sheets, and cash flow statements for the next 10 years on monthly basis. the model will be based on 5 years of actual figures on annual basis. Scenario Analysis: Include capabilities for scenario analysis to assess the impact of various financial and operational strategies on the company's future financial health. Dashboard and Reporting: Create an interactive dashboard for easy visualization and analysis of financial data, including key performance indicators (KPIs) and financial ratios. Requirements:
Expertise in Financial Modeling: Proven experience in building complex financial models, particularly for listed companies. Welling to put in the work and read the annual reports published by the company to identify all relevant information that will be used to drive the model Understanding of Financial Reporting Standards: Strong understanding of IFRS or GAAP, as applicable. Attention to Detail: Ability to work with precision and accuracy in handling large sets of financial data. Software Proficiency: Proficient in Microsoft Excel or other relevant financial modeling tools.
Deliverables: A fully functional financial model in Excel or the agreed-upon software. A user guide or documentation explaining the model's structure, assumptions, and how to update it. A presentation deck summarizing key findings and insights from the model. Timeline: The complete model is expected to be delivered within 4 weeks from the start of the project.
Budget: 200$
Please provide examples of previous financial models you have developed, especially those relevant to publicly listed companies. Looking forward to your proposals and hoping to collaborate on this critical project!
