[ORDER SOLUTION] Financial Modelling
I have finished writing the assigment just need proofreading and doing the changes needed also need help balancing the excel sheet.Assignment brief:Industry and Company Analysis1. Provide a summary of the companys business activities, and an analysis of its industry. Review the competitive landscape of this industry and examine the macro environmental factors that could affect the industrys performance.2. Undertake a financial analysis and evaluation of the historical performance over the past five years. Modelling and Valuation 3. Develop a pro-forma forecast of the chosen company as a basis for estimating its intrinsic price. Your spreadsheet should include: a. a set of forecasted financial statements based on a pro-forma (latest financial year),b. key assumptions and drivers that influence each of the components of the forecasted balance sheet, income statement and cash flow statements,c. key parameters to be used for valuation,d. the valuation model (e.g. Discounted cash flow, Market based valuation etc)4. Explain and justify the reasons underlying the assumptions and forecasts you made in your valuation model5. Conduct scenario and sensitivity analyses [i.e. how future business decisions and strategies can change the valuation outcome. Also how changes in the specific environment of the business such as response to competitive threats, or preparing for different possible outcomes for the wider economy (boom or return to recession) can change the valuation outcome]Changes Needed: In the industry analysis, you are expected to discuss environmental factors affecting the entire apparel industry and NEXTs relative positioning. This discussion could have been structured based on common frameworks such as PESTLE and Porters five forces. You have not conducted a financial analysis as per the coursework brief. In terms of financial analysis, you should analyse the performance of the company using either trend analysis or cross-sectional analysis or both. The variables you discussed, seven drivers, are clearly from the SVA model (i.e., from a model in Corporate Finance module). You didnt discuss modelling variables related to your own pro forma model. Your pro forma model in Excel is incomplete. No valuation model has been provided. Furthermore, it is poor modelling practice to enter hard-coded values as your assumptions; the entire model should be largely driven by formulas from other sheets in the workbook. Also, Your balance sheets did not balance suggesting that a number of fundamental and pervasive errors are present in your workbook.Your discussions on the valuation model and sensitivity analysis are not valid. You should use relevant academic theories from the literature to critique different valuation models. As a starting point, the sensitivity analysis should be based on different WACC and long-term growth combinations. Refer to the Caterpillars examples as shown in the workshop.