Question: Please Calculate the Following: a) Common-size balance sheet calculation for ABC Companys Inventory account in 2021 B) Calculation of the Inventory / Net Working Capital

 Please Calculate the Following: a) Common-size balance sheet calculation for ABCCompanys Inventory account in 2021 B) Calculation of the Inventory / Net

Please Calculate the Following:

a) Common-size balance sheet calculation for ABC Companys Inventory account in 2021

B) Calculation of the Inventory / Net Working Capital ratio for ABC Company for 2021:

C) Based on the above ratios that you have calculated for ABC Company, does it appear that they are managing their inventory better or worse than the average firm in their industry? Please describe.

ABC COMPANY, INC. Income Statement for Year Ended December 31, 2021 Sales Revenue Cost of Goods Sold Gross Profit Selling Expense General and Administrative Expense Depreciation Expense Operating Profits (EBIT) Interest Expense Profit Before Taxes Less: Taxes @ 40% Net Profit After Taxes -----2021----- DOLLARS 275,000 182,000 93,000 36,000 28,000 8,000 21,000 7,500 13,500 5,400 8,100 ABC COMPANY, INC. Balance Sheet As of December 31, 2021 ------2021---- DOLLARS ASSETS: Cash Accounts Receivable Inventories Total Current Assets 24,000 68,000 72,000 164,000 Net Fixed Assets TOTAL ASSETS 55,000 219,000 LIABILITIES AND EQUITY: Accounts Payable Notes Payable Accruals Total Current Liabilities 25,000 50,000 29,500 104,500 Long-Term Debt TOTAL LIABILITIES 17,500 122,000 Common Stock at Par Value Paid-in Capital in Excess of Par Value Retained Earnings TOTAL STOCKHOLDERS' EQUITY 5,000 20,000 72,000 97,000 TOTAL LIABILITIES AND EQUITY 219,000 ABC COMPANY, INC. Income Statement for Year Ended December 31, 2021 Sales Revenue Cost of Goods Sold Gross Profit Selling Expense General and Administrative Expense Depreciation Expense Operating Profits (EBIT) Interest Expense Profit Before Taxes Less: Taxes @ 40% Net Profit After Taxes -----2021----- DOLLARS 275,000 182,000 93,000 36,000 28,000 8,000 21,000 7,500 13,500 5,400 8,100 ABC COMPANY, INC. Balance Sheet As of December 31, 2021 ------2021---- DOLLARS ASSETS: Cash Accounts Receivable Inventories Total Current Assets 24,000 68,000 72,000 164,000 Net Fixed Assets TOTAL ASSETS 55,000 219,000 LIABILITIES AND EQUITY: Accounts Payable Notes Payable Accruals Total Current Liabilities 25,000 50,000 29,500 104,500 Long-Term Debt TOTAL LIABILITIES 17,500 122,000 Common Stock at Par Value Paid-in Capital in Excess of Par Value Retained Earnings TOTAL STOCKHOLDERS' EQUITY 5,000 20,000 72,000 97,000 TOTAL LIABILITIES AND EQUITY 219,000

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!