Financial Statement Analysis Project
This project is to be used in conjunction with the Brickey Electronics Financial Statements we converted
into excel in class. Completing this assignment in excel is not required, but it is encouraged. Some of
the numbers have been changed in Brickey’s financial statements. The changes are highlighted in red on
the FS Analysis pdf included with the assignment posting. Either use the attached pdf or make the
changes to the Brickey Electronics financial statements you have in Microsoft excel. Refer to chapter 15
for ratios that we may not have covered in class as well as additional information about financial
Perform a horizontal analysis of the financial statements, both income statement and balance sheet, for
amount change and percentage change.
Calculate the following ratios for Brickey Electronics for This Year. Hint: Last year’s ending balance is the
same as this year’s beginning balance when calculating averages.
‐Accounts receivable turnover
‐Average collection period
‐Average sale period
‐Total asset turnover
‐Times interest earned
‐Net profit margin percentage
‐Return on equity
‐Earnings per share
‐Price‐earnings ratio – Assume a $25 per share market price
‐Dividend yield ratio
For each Liquidity and Asset Management measure, decide if a higher or lower result is more desirable
and give a brief description of what the measurement represents. Only do this for the Liquidity and
Asset Management measures.