Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need help deciding whether or not to purchase stock in this company . Jan - Doc 07 Jan - Dec 08 Ordinary Income/Expense Income

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

I need help deciding whether or not to purchase stock in this company

.

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed
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.06Attached are the Balance Sheet and Income Statement for Wholesale Distributors for the years 20X7 & 20X8. Additional Information. Capital Stock Issued and Outstanding 10,000 shares. This company is offering an additional 5,000 shares of stock at $25 per share Required: Based on the analysis provided and any other information you deem necessary would you purchase the stock and why. Your answer needs to be at least one page in length . Give examples and refer back to the analysis I am looking for a well thought out and detailed

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

Managerial Accounting for Managers

Authors: Eric Noreen, Peter Brewer, Ray Garrison

3rd edition

78025427, 978-0077736460, 007773646X, 978-0078025426

More Books

Students also viewed these Accounting questions