I need help deciding whether or not i should invest in this companys stock.
Page 5 1. The following information is available for the Blizzard Corporation for 20x3: Materials inventory decreased $4,000 during 2ox3. Materials inventory on December 31, 20X3, was 50% of materials inventory on January 1, 20x3. Beginning work in process inventory was $140,000. Ending finished goods inventory was $65,000. Purchases of direct materials were $150,000. Direct materials used were 2.5 times the cost of direct labor. Manufacturing overhead was 50% of the cost of direct labor. Total manufacturing costs incurred were $25,400, 30% of cost of goods manufactured and $150,000 less than cost of goods sold. Compute: a} finished goods inventory on January 1, 20x3 bi work in process inventory on December 31, 20x3 c} direct labor incurred d} manufacturing overhead incurred e] direct materials used f} materials inventory on January 1, 20x3 g} materials inventory on December 31, 20x3 Note to students: The solutions to this problem are not necessarily calculated in alphabetical order. Jan - Doc 07 Jan - Dec 08 Ordinary Income/Expense Income Revenue 372.951.45 100.00% 410.246.60 100.00% 37,295.15 10.00%% Total Income 872.951.45 100.00% #10.246.60 100.00% 37,295.15 10.00% Cost of Goods Sold 0.00% 0.00% 0.00 #DIV/O! Direct Labor 0.00% 0.00% 0.00 #DIV/O! Wages - Warehouse 16,630.00 5.00% 19 188.80 4.68% 558.90 3.00% Total Dimet Labor 8.630 00 5.00% 19.188.90 4.68% 558.90 3.00% Freight Costs 1,810 00 0.49% 1,918.60 0.47% 108.60 6.00% Packaging Materials 1,752 50 0.47% 1,675 18 0.46% 122.65 7.00% Purchases (Cost of Goods) 181.945.83 43.42% 171,862.54 41.84% 9,716.75 6.00% Sales Commission (outside mops) 3,990 80 1.07% 8,204 93 2.00% 4.214.13 105.60% Total COGS 188.129.13 50.44% 202.850.19 49.45% 14,721.06 7.82% Gross Profit 184,822 32 49.56% 207.396.41 50.55% 22,574.09 12.21 Expanan 0.00% 0.00% 0.00 #DIV/O! Advertising Expense 2,000 00 0.54% 2,600.00 0.63% 600.00 30.00% Business License & Foos 710.23 0.19% 710.23 0.17% 0.00 0.00% Car/Truck Expanse 0.00% 0.00% 0.00 #DIV/O! Car Loman 6,756.00 1.81% 6,756.00 1.65% 0.00 0.00% Gas 907.64 0.24% 1,361.48 0.33% 453.82 50.00% Insurance-Auto 1440 00 0.39% 1,440 00 0.35% 0.00 0.00% Registration & License 546.00 0.15% 546.00 0.13% 0.00 0.00% Repairs & Maintenance 1,700 23 0.46% 2,500.00 0.61% 799.77 47.04% Total Can Truck Expense 11.349.87 3.04% 2.603,46 3.07% 1,253.59 11.04% Conferences and Seminars 4,700.00 1.26% 5,000 00 1.22% 300.00 6.38% Contributions 2,500 00 0.67% 2,000.00 0.49% (500.00) -20.00% Depreciation Expense 923.04 0.25% 910,48 0.22% (12.56) -1.36% Dues and Subscriptions 1,900.00 0.51% 1,900.00 0.46% 0.00 0.00% Insurance 0.00% 0.00% 0_00 # #DIV/O! General Liability Insurance 2,760.00 0.74% 2,760.00 0.67% 0.00 0.00% Owner's Health Insurance 4,272 00 1.15% 4,336.08 1.06% 64.08 1.50% Professional Liability Insuranc 6,875 00 1.84% 6,875 00 1.65% 0.00 0.00% Worker's Compensation 2,782 08 0.75% 2,782 08 0.68% 0.00 0.00% Total Insurance 16.689.06 4.47% 16,753.16 4.05% 64.08 0.35% Maintenance/Janitorial 2,841.95 0.76% 3,000.00 0.73% 158.05 5.56% Marketing Expanse 4,982 00 1.34% 5,500.00 1.34% 518.00 10.40% Meals 1,376.35 0.37% 2,000.00 0.49% 623.65 45.31% Office Equipment 1,100 00 0.29% 1,500.00 0.37% 400.00 36.36% Postage and Delivery 1,098.00 0.29% 1,300.00 0.32% 202.00 18.40% Professional Fees 0.00% 0.00% 0.00 # #DIV/O! Accounting Fans 2,544 00 0.68% 3,000.00 0.73% 456.00 17.92% Legal Foos 600,00 0.16% 500.00 0.12% (100.00) -16.67%Legal Foos 600,00 0.16% 500,00 0.12% (100.00) -16.67% Payroll Service Fees 1,529.24 0.41% 2,000 00 0.49% 470.76 30.78% Total Professional Foes ,673 24 1 25% 5,500 00 1.34% 826.76 17.69% Promotional Expense 2,021.00 0.54% 2,000.00 0.49% (21.00) -1.04% Rant 7,005.00 1.85% 7,005.00 1.71% 0.00 0.00% Repairs 0.00% 0.00% 0.00 #DIV/O! Computer Repairs 390,00 0.10% 500,00 0.12% 110.00 28.21% Total Ropairs 390,00 0.10% 500.00 0.12% 110.00 28.21% Supplies 6,199.38 1.66% 7,000.00 1.71% 800.64 12.91% Telephone 4.003 44 1.07% 4,500 00 1.10% 496.56 12.40% Travel & Entertainment 0.00% 0.00% 0.00 `#DIV/O! Travel 9,452 23 0.93% 4,090 00 0.98% 547.77 15.87% Total Travel & Entertainment 3,452 23 0.93% 4,090.00 0.95% 547.77 15.87% Utilities 501.59 0.13% 0.00% (501.59) -100.00% Wages 0.00% 0.00% 0.00 # #DIV/O! Employee Benefits 2,253.96 0.60% 2,321 58 0.57% 67.62 3.00% Payroll Tax Expenses 3,751.05 1.01% 3,863 58 0.94% 112.53 3.00% Sick/Holiday & Vacation Pay 0,00 0.00% 0.00 0.00% 0.00 # #DIV/O! Wages - Office Staff 5,632 00 1.56% 5,006 96 1.46% 174.95 3.00% Total Wages 11.837.01 3.17% 2.192.12 2.97% 355.11 3.00% Total Expanse 12 253.39 24.74% 18 474,45 24.00% 6.221.06 6.74% Net Ordinary Income 92 568.93 24.82% 108.921.96 26.55% 16,353.03 17.67% Other Income Expense 0.00% 0.00% 0.00 #DIV/O! Other Expense 0.00% 0.00% 0.00 #DIV/O! Other Expense 0.00% 0.00% 0.00 # #DIV/O! Interest Expense 2,206 45 0.62% 2,500 00 0.61% 203.55 5.86% Total Other Expense 2,208 45 0.62% 2,500 00 0.61% 203.55 B.86% Total Other Expense 2.206 45 0.62% 2,500 00 0.61% 203.55 B.86% Not Other Income -2.256.45 -0.62% 2.500.00 -0.61% (203.55) 8.86% Net Income 90 272.48 24.20% 106,421.96 25.94% 16,149.45 17.89%Dec 31, 07 Dec 31, 08 ASSETS Current Assets Checking Savings Company Checking Account 36 857.86 15.00%% 84 444.87 21.90% 47,587.21 129.11% Company Savings Account 25,000.00 10-17% 25,000,00 5.48% 0.00 0.00% Petty Cash Account 500,00 0.20%% 500.00 0.13% 0.00 0.00% Total Checking Savings 2 357.86 25 37% 109.944.87 28 51% 47,587.21 76.31% Accounts Receivable 0.00% 0.00% 0.00 #DIV/O! Accounts Receivable 10 202.50 16 36% 56.835.69 14.74% 16,633.19 41.37% Total Accounts Receivable 10 202.50 16 36% 58 835.69 14.74% 16,633.19 41.37% Other Current Assets 0.00% 0.00% 0.00 #DIV/O! Inventory Asset 51.060,47 20 78%% 127.651.18 33.10% 76,590.71 150.00% Propaids 0.00%% 0.00% 0.00 #DIV/O! Prepaid Insurance 0,00 0.00%% 1.00%% 0.00 #DIV/O! Prepaid Taxes 100,00 0.33%% 300.00 0.21% 0.00 0.00% Total Prepaids 300.00 0.33% 900.00 0.21%% 0.00 0.00% Security Deposits 1,200 00 0.49% 1,200.00 0.31% 0.00 0.00% Total Other Current Assets 13 080 47 21.59% 129.651.18 33 62% 76,590.71 144.35% Total Current Assets 155.620.63 63 33% 296.431.74 76 87% 140,811.11 90.48% Fixed Assets 0.00% 0.00% 0.00 #DIV/O! Accumulated Depreciation (923 04) 0.38% (1.433.52) -0.48% (910.48) 98.64% Automobiles & Trucks 45 632.00 18 57% 45,632.00 11.83% 0.00 0.00% Computer & Office Equipment 19.453.00 7.92% 19.453.00 5.04% 0.00 0.00% Machinery & Equipment 25,963.00 10 56% 25,963.00 6.73%% 0.00 0.00% Total Fixed Assets 10.124.96 36.67% 89 214,48 23.13% (910.48) -1.01% TOTAL ASSETS 245,745.59 100.00% 385,646.22 100.00% 139,900.63 56.93% LIABILITIES & EQUITY 0.00% 0.00% 0.00 #DIV/O! Liabilities 0.00% 0.00% 0.00 # #DIV/O! Current Liabilities 0.00% 0.00% 0.00 #DIV/O! Accounts Payable 0.00% 0.00% 0.00 #DIV/O! Accounts Payable 3,590 80 1.62% 5,986 20 1.55% 1,995.40 50.00% Total Accounts Payable 3,900 80 1.62% 5,986 20 1.55% 1,995.40 50.00% Credit Cards 0.00%% 0.00% 0.00 #DIV/O! QuickBooks Credit Card 1,249.12 0.51% 1,300.00 0.34% 50.58 4.07% Total Credit Cards 1.249.12 0.51% 1,300.00 0.34% 50.88 4.07% Other Current Liabilities 0.00% 0.00% 0.00 #DIV/O! Line of Credit 104.618.08 42 57% 136.003.50 35.27% 31,385.42 30.00% Payroll Liabilities 0.00% 0.00% 0.00 #DIV/O!Payroll Liabilities 0.00% 0.00% 0.00 #DIV/O! Payroll Taxes Payable 1,565.31 0.64% 1,612 27 0.42% 46.96 3.00% SEC125 Payable 100.00 0.04% 100.00 0.03%% 0.00 0.00% Total Payroll Liabilities 605.31 0.68% 1,712 27 0.44% 46.96 2.82% Total Other Current Liabilities 106.283.39 43 25% 137.715.77 35.71% 31,432.38 29.57% Total Current Liabilities 111.523,31 45 38% 145.001.97 37 .60% 33,478.66 30.02% Total Liabilities 111.523.31 45 38% 145,001.97 37 60%% 33,475.66 30.02% Equity 0.00% 0.00% 0.00 #DIV/O! Common Stock 10 000,00 4.07 10 000.00 2.59% 0.00 0.00% Additional Paid in Capital 33,949.80 13 82 33,949.80 8.80% 0.00 0.00% Retained Earnings 0,00 0.00% 90 272.48 23 41% 90,272.48 #DIV/0 Net Income 90 272.48 36.73% 106,421.98 27-50% 16,149.48 17.89% Total Equity 34.272.28 54 62 240.644.24 62 40% 106,421.96 79.29% TOTAL LIABILITIES & EQUITY 245.745.50 100.00% 385,646.21 100.00% 139,900.62 56.93%% 0.00 (0.00) Current Ratio 1.40 2.04 Quick Ratio 0.92 1.15 Inventory Turns 7.37 2.27 Days in Inventory 49.53 160.75 Gross Profit % 0.50 0.51 AR Turnover 18.55 8.46 Days Sales in Rev 19.67 43.17 Debt Ratio 0.45 0.35 Debt to Equity 0.83 0.60 X Interest Earned 40.31 43.57 Rate Return on Sales 0.24 0.26 Rate Roturn on Assets 0.73 0.34 Asset Turnover 3.04 1.30 Rate Rotrun CS 18.05 10.64 EPS 9.03 10.64 PE Ratio Dividend Yield Dividend Payout BV CS 13.42 24.06