for material please msg me on rbansal700909@gmail.com, i will provide you the data like templates and 2011,2012 and other data that is required to make this and please complete it as soon as possible.

Case Assignments 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 company's 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 company's 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. Case Assignments 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 company's 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 company's 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