Q4 (Excel spreadsheet is available). From the data given in the following table, please construct as many of the financial ratios discussed in this chapter as you can and then indicate what dimension of a business firms performance each ratio represents. Make sure write down the formula and the results in word file.

Business Assets			Annual revenue and Expense Items
Cash account	60.00		Net sales	600.00
Accounts receivable	155.00		Cost of goods sold	445.00
Inventories	128.00		Wages and salaries	52.00
Fixed assets	286.00		Interest expense	28.00
Miscellaneous assets	96.00		Overhead expenses	29.00
Total assets	725.00		Depreciation expenses	12.00
Liabilities and Equity			Selling, administrative, and other expenses	28.00
Short-term debt:			Before-tax net income	6.00
Accounts payable	108.00		Taxes owed	1.00
Notes payable*	117.00		After-tax net income	5.00
Long-term debt (bonds)*	325.00
Miscellaneous liabilities	15.00
Equity capital	160.00
Total Liabilities and Equity	725.00
*Annual principal pmts on bonds and nps	55.00
marginal tax rate	35.00%