Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1.) Fill in the following 16 Financial Ratio's for 2003, 2002 & 2001 Financial Ratio's 2003 2002 2001 Avg Current Ratio 2.7 Cash Ratio 0.45

1.) Fill in the following 16 Financial Ratio's for 2003, 2002 & 2001

Financial Ratio's 2003 2002 2001 Avg
Current Ratio 2.7
Cash Ratio 0.45
Inventory Turnover in Days 60 days
Accounts Receivable Turnover in Days 32 days
Accounts Payable Turnover in Days 15 days
Cash Conversion Cycle 77 days
Fixed Assets Turnover 7
Total Assets Turnover 2.5
Debt Ratio 0.4
Times Interest Earned 8
Cost of Borrowing 0.068
Gross Profit Margin 0.22
Operating Profit Margin 0.13
Net Profit Margin 0.06
Return on Assets 0.15
Return on Equity 0.25

Income Statement 2003 2002 2001
Sales 6,854,000 5,128,800 2,954,000
Cost of Goods Sold 5,825,900 4,308,192 2,422,280
Gross Profit 1,028,100 820,608 531,720
Depreciation 120,000 116,960 18,900
Others Operating Expenses 685,400 512,880 236,320
Earnings Before Interest and Taxes 222,700 190,768 276,500
Interest 215,683 140,847 37,875
Earnings Before Taxes 7,017 49,921 238,625
Income Taxes 2,807 19,969 95,450
Net Income 4,210 29,953 143,175
Units Sold 527,230 366,340 196,930

Balance Sheet 2003 2002 2001
Cash 24,00 10,00 9,000
Short-term Investments 53,519 0 295,340
Accounts Receivable 878,776 617,160 301,200
Inventories 1,716,480 1,287,360 518,460
Total Current Assets 2,672,775 1,914,520 1,124,000
Property, Plant, and Equipment 1,706,363 1,402,500 691,000
Less: Accumulative Depreciation -383,160 -263,160 -146,200
Total Assets 3,995,978 3,053,860 1,668,800
Accounts Payable 948,802 511,267 145,600
Line of Credit 875,635 510,582 200,000
Current Portion of Long-term Debt 100,000 32,340 30,050
Total Current Liabilities 1,924,437 1,054,189 375,650
Long-term Debt 1,067,660 1,000,000 323,432
Common Shares 660,000 660,000 660,000
Retained Earnings 343,881 339,671 309,718
Total Liabilities and Equity 3,995,978 3,052,860 1,668,800

Cash Flow Statement 2003 2002
Operations
Net Income 4,210 29,953
Add: Depreciation 120,000 116,960
Change in Accounts Payable 437,535 365,667
Less: Change in Accounts Receivabe 261,616 315,960
Change in Inventory 429,120 768,900
Total -128,991 -572,280
Investments
Purchase of Property, Platn &Equipment -303,863 -711,500
Financing
Change in Line of Credit 365,053 310,582
Change in Long Term Debt 135,320 678,858
Total 500,373 989,440
Change in Cash/Cash Equivalents 67,519 -294,340

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

Information Technology Control And Audit

Authors: Angel R. Otero

5th Edition

1498752284, 9781498752282

More Books

Students also viewed these Accounting questions

Question

PMs and DMs can be viewed by anyone. True False

Answered: 1 week ago