Question
Assignment Tasks Details: You are required to research and analyse a real public-listed firm on LSE of your choice, addressing issues as described in specific
Assignment Tasks Details: You are required to research and analyse a real public-listed firm on LSE of your choice, addressing issues as described in specific guidelines relating to the assignment task, in conjunction with the marking rubric. This is an individual assignment, which will require the creation of a Financial Business Plan with simple financial model in Excel, based on a case study and on the analysis of a real public-listed firm on LSE you choose.
1) Include a financial ratio analysis using data in the financial statements of the chosen company. Comment on profitability, liquidity, debt and asset activity ratios. Detailed calculations should be included in an appendix; include key findings in a table in the body of the text.
2) Provide financial projections for the company, using alternative assumptions to identify the areas that warrant consideration or potential revisions. Use Excel spreadsheets to model the financial projections.
3) Include a breakeven analysis using appropriate assumptions based on the business context of the chosen company.
4) Critically evaluate the appropriate main sources of finance for the company whether through debt or equity and discuss their requirements for financial projections, advantages, disadvantages and suitability. Include citations for literature review where appropriate.
5) Based on your analysis, discuss whether the company would be better off to go for debt or equity financing, if it would like to expand its business.
Other information Use graphs and/or tables to present key results effectively. Attach Excel screenshots in the Appendices to demonstrate results of analysis for alternative assumptions.
1) Appropriate assignment cover sheet for your business financing plan. State the word count of your report in the Word Count section of the cover sheet rather than the required word count. Refer to the relevant information in the module handbook about word count requirements.
2) Title page, including the given title in full.
3) Executive summary An executive summary is a one-page maximum document which summarises the whole report. An executive summary should follow the order of the report and outline: the purpose of the report; the key analyses; the main conclusions; recommendations.
4) Table of contents
5) Introduction An introduction clearly introduces the purpose of the report and gives a brief relevant background. It also sets out the structure of the report.
6) Main body, which should be organised under appropriate headings for the tasks. The literature review section should provide an overview of previous research in the area you are writing about. A literature review summarises prior publications in the field and should also include your own evaluation/analysis of the research.
7) Conclusion A conclusion should be a short section with no new arguments or evidence. The conclusion sums up the main points of your research or analysis.
8) A list of references in accordance with APA Referencing style.
9) A reasonable number of appendices may be used for relevant supporting information and to demonstrate your calculations and analysis. If you include them, make sure you refer your reader to them as required. You should demonstrate evidence of critical thinking. You should also cite or reference your sources using the university APA referencing style.
Maximum: 3,000 words (excluding references and appendices
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started