This format is for the company Bestbuy, please help me.

12. Prepare a common sized Balance Sheet for your firm for two years. Identify the amounts that your firm reported for each of the following categories and the percentage of total assets that each represents Amount Percent Current Assets 8870000 1980000 Property, Plant & Equipment Goodwill and other intangible assets S $ Other long term assets Total 12901000 100% Current Liabilities 7513000 Long-term liabilities Contributed capital Retained Earnings Total 100% 13. If you were a creditor of a firm you would be interested in whether the firm had enough resources to pay you when you bill came due, which can be determined by two indicators: A. The amount of working capital, the cushion by which total current assets exceed total current liabilities WC = current assets - current liabilities B. The current ratio, which reveals how many dollars of current assets are available to pay off each dollar of current liabilities. CR = Current Assets Current Liabilities What amount of working capital did your company have as of the date of its two most recent balance sheets? What was the current ratio at the end of the two most recent years? Most Recent Balance Sheet Next Most Recent Balance Sheet Working Capitals Current Ratio 14. For comparison to other firms, check RMA and determine the industry average for current and quick ratios the industry the firm operates within. Record the results below and on the next page. Quick Ratio List industry and NAICS code List industry average and corresponding year. Current Ratio Industry Average 12. Prepare a common sized Balance Sheet for your firm for two years. Identify the amounts that your firm reported for each of the following categories and the percentage of total assets that each represents Amount Percent Current Assets 8870000 1980000 Property, Plant & Equipment Goodwill and other intangible assets S $ Other long term assets Total 12901000 100% Current Liabilities 7513000 Long-term liabilities Contributed capital Retained Earnings Total 100% 13. If you were a creditor of a firm you would be interested in whether the firm had enough resources to pay you when you bill came due, which can be determined by two indicators: A. The amount of working capital, the cushion by which total current assets exceed total current liabilities WC = current assets - current liabilities B. The current ratio, which reveals how many dollars of current assets are available to pay off each dollar of current liabilities. CR = Current Assets Current Liabilities What amount of working capital did your company have as of the date of its two most recent balance sheets? What was the current ratio at the end of the two most recent years? Most Recent Balance Sheet Next Most Recent Balance Sheet Working Capitals Current Ratio 14. For comparison to other firms, check RMA and determine the industry average for current and quick ratios the industry the firm operates within. Record the results below and on the next page. Quick Ratio List industry and NAICS code List industry average and corresponding year. Current Ratio Industry Average