Ratio Analysis and Financial Statements
Calculate the Ratios (Part 1)
Using the financial statements for a mystery company provided on the assignment spreadsheet below, calculate all of the ratios for all five years. When you use excel and link the equations in the first year, you can drag them across and excel will calculate all the other years for you. This is a great time saver! See the help video if you dont know how to do this. .
Ratio Analysis SpreadsheetPreview the document
Calculate Common-Size Financial Statements and Complete a Financial Statement Analysis (Part 2)
Common size financial statements will help you in your time-series analysis and will give you a better idea of what is going on in the company. Go to the Income Statement and the Balance Sheet tabs and create a common-size statement out to the side of the original ones. (I have included a blank format for you). Then complete a financial statement analysis listing a few points of interest. You shoul
Using the financial statements for a mystery company provided on the assignment spreadsheet below, calculate all of the ratios for all five years. When you use excel and link the equations in the first year, you can drag them across and excel will calculate all the other years for you. This is a great time saver! See the help video if you dont know how to do this. .
Ratio Analysis SpreadsheetPreview the document
Calculate Common-Size Financial Statements and Complete a Financial Statement Analysis (Part 2)
Common size financial statements will help you in your time-series analysis and will give you a better idea of what is going on in the company. Go to the Income Statement and the Balance Sheet tabs and create a common-size statement out to the side of the original ones. (I have included a blank format for you). Then complete a financial statement analysis listing a few points of interest. You shoul
