Microsoft Excel
- There is an excellent site at Leila Gharani on YouTube with great videos showing you great features in Excel that you perhaps haven’t used or known about.
For example: Properly Convert PDF to Excel - Another site with an excellent series of videos on the capabilities of Excel is at Chandoo.
For example: 10 things you thought Excel couldn’t do …
Accounting Standards
All teaching on the module conforms with the requirements of current International Accounting Standards. A detailed knowledge of each standard is not required. However, the following websites may, at times, be useful in supplementing your understanding.
International Financial Reporting Standards – official site of the International Accounting Standards Board
IASplus – a useful site maintained by Deloitte with news and summaries of International Accounting Standards.
Content of the Corporate Report
KPMG publish a page of excellent ‘Guides to Financial Statements‘ – an excellent guide to disclosure requirements (with examples) as well as resources on current issues such as the impact of climate change and uncertainty on financial reporting.
PwC has an excellent page of resources on Corporate Reporting.
Preparation of financial statements – single limited companies
You should concentrate on the preparation of an income statement and statement of financial position for a private limited company. e.g.
- Rothebud Ltd from last year’s exam, with full suggested solution.
- Varlie Ltd A good revision question which can be downloaded from here. Full suggested solution and workings are included.
- Sharlot Ltd The case study can be downloaded from here and includes a suggested solution and full workings.
- Widor Ltd Another case study similar to the one above. Download from here.
- Defta Ltd A case study incorporating simple deferred taxation.
Note: outline pro formas will be supplied for questions on the preparation of the primary financial statements. Refer to the link on the notes for Week 12 for further information (link to follow).
The lectures supporting this topic were Lectures 1, 2 and 3. The seminar supporting this topic was Seminar 1.
Preparation of financial statements – groups of companies
Combined income statement and balance sheet
For a holding company with one subsidiary
Combined income statement and balance sheet for holding company, subsidiary and associated company.
Note: pro formas will not be supplied for consolidated financial statements.
The lectures and materials covering consolidated financial statements were in weeks 9, 10 and 11.
Consolidated income statement only
Consolidated balance sheet (statement of financial position) only
Consolidated financial statements – calculation of goodwill
Statements of Changes in Equity
Tutorial/lecture notes are here.
Interactive guide (requires Flash).
Revision questions
Working capital management
Revision questions
- Onyx
- Suggested outline solution to Onyx is here.
- Blogger plc
See lectures and materials for week 6.
Investor ratios
- Myrial plc: earnings per share (rights issue) and other investor information (covered during the course)
- Zufoz plc: earnings per share (rights issue) and other investor information
- Larkton plc: earnings per share (rights issue) and other investor information
- Champlon: earnings per share (rights issue)
——————————–
- Crumple: earnings per share (issue at full market price + bonus issue)
- Brora: earnings per share (issue at full market price + bonus issue)
- Staystyx: earnings per share (issue at full market price + bonus issue)
——————————–
See materials for week 8 and 7.
Interpretation of cash flow statements
- Big Yellow Group – from the June 2016 exam – available via BlackBoard, Assessments section.
- Podoflix
- Luca plc – interpretating a three year time series
- Football Club – a more complex example where the cash flow statements are interim one.
See also the material covered in Seminar 2 – especially the form that was used to review the cash flow statements of two companies as an aid to comparing and contrasting their cash flow performance.
Interpretation of financial statements
- Interpretation of ratios pension fund
- Question on investor and operating ratios (Treyboar)
- Question on interpreting the PE ratio
- Interpretation of ratios and preparation of revised projected financial statements – Eeskost plc
- Neorite – calculation of ratios for most recent year, plus interpretation of time series
- Maplin – defining, calculating and interpreting a series of ratios for a set of published accounts for a company.
- Richer Sounds plc – defining, calculating and interpreting a series of ratios for a set of published accounts for a company.
There’s a suggested solution here. - Time series analyses – Roofer plc
See weeks 4 and 5.
Mark up and Margins
Having trouble calculating these? This short elearning presentation will help you. It will take you through things slowly, in a structured way, and there are lots of questions for you to assess your progress.
The presentation is here.