1. a) 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.

b) 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.

c) Make an analysis of the companys financial statements for the years 2011, 2012 and 2013 (actual), 2014 (year-end estimates), and 2015 (forecast). This information can be drawn from the following templates:

Template 4: Statement of Sources and Uses of Funds

Template 5: Statement of Cash Flows

Template 6: Vertical Analysis of the Statement of Income

Template 7: Horizontal Analysis of the Statement of Income

Template 8: Vertical Analysis of the Statement of Financial Position

Template 9: Horizontal Analysis of the Statement of Financial Position

Template 10: Financial Ratios

Template 11: Du Pont System

Template 12: Cash Flow and EBITDA

Template 13: Economic Value Added

Template 14: Sustainable Growth Rate

Template 15: Financial Health Zone

2. Open Part B - Decision-Making Tools spreadsheet templates. Input the revenue and cost information for 2013-2015 from Micro Tiles financial statements into Template 2 (Break-Even Analysis using the PV ratio). Based on this information and break-even planning assumptions, what are the companys break-even points for the years 2013, 2014 and 2015? How much sales revenue should Micro Tiles have to sell in 2015 in order to reach a $300,000, $350,000, and $400,000 before-tax profit objective?

3. Open Part B - Decision-Making Tools spreadsheet Templates. Based on the monthly cost breakdown and by using Template 7 (Monthly Cash Budget), produce a cash budget for the year 2015.