Problem
I. Open Part A - Financial Statement Analysis spreadsheet templates. Input the information contained in the Micro Tiles 2011 to 2014 financial statements that are attached to this case into Templates 1, 2, and 3.
Note: Because the spreadsheet templates have a maximum of three years, you will have to input the financial statements for years 2011, 2012 and 2013 using one set of templates and years 2013, 2014 and 2015 using another set.
II. Using the financial planning assumptions in this case, produce the statement of income, statement of changes in equity, and statement of financial position for Micro Tiles in the year 2015.
III. Make an analysis of the company's financial statements for the years 2013 (actual), 2014 (year-end estimates), and 2015 (forecast). This information can be drawn from the other templates in the excel file: