Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribedimage text in transcribed

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Multivariate Methods And Forecasting With IBM SPSS Statistics

Authors: Abdulkader Aljandali

1st Edition

3319564803,3319564811

More Books

Students also viewed these Finance questions