Raw materials and purchased parts inventories 0 45

This preview shows page 59 - 62 out of 154 pages.

Raw Materials and Purchased Parts Inventories 270,000 9.4% 80,000 4.5% 100,000 5.0% Goods in Process 4,500 0.2% 12,000 0.7% 30,000 1.5% Finished Goods Inventory 300,000 10.4% 180,000 10.2% 266,000 13.2% Prepaid Expenses Current 8,000 0.3% 5,900 0.3% 7,800 0.4% Total Current Assets $ 894,600 31.2% $ 440,800 24.9% $ 686,800 34.1% Plant Assets Net 1,620,000 56.4% 1,210,000 68.4% 1,200,000 59.6% Intangible Assets Net 350,000 12.2% 115,000 6.5% 120,000 6.0% Other Assets 7,000 0.2% 4,000 0.2% 6,000 0.3% Total Fix Assets $ 1,977,000 68.8% $ 1,329,000 75.1% $ 1,326,000 65.9% Total Assets $ 2,871,600 100.0% $ 1,769,800 100.0% $ 2,012,800 100.0% Notes Payable Trade $ 2,000 0.1% $ 7,000 0.4% $ 3,000 0.1% Accounts Payable Trade 199,086 6.9% 113,586 6.4% 120,000 6.0% Taxes Payable 8,000 0.3% 6,000 0.3% 20,000 1.0% Accrued Liabilities 5,800 0.2% 6,500 0.4% 7,800 0.4% Mortgage Note Payable Current 200,000 7.0% 200,000 11.3% 147,000 7.3% Note Payable - 10% - Current 100,000 3.5% 0.0% 0.0% Note Payable - 10% - Due 19x9 900,000 31.3% 0.0% 0.0% Mortgage Note Payable - 8% 400,000 13.9% 520,000 29.4% 720,000 35.8% Total Liabilities $ 1,814,886 63.2% $ 853,086 48.2% $ 1,017,800 50.6% Common Stock - No Par 300,000 10.4% 300,000 17.0% 300,000 14.9% Additional Paid in Capital 120,000 4.2% 120,000 6.8% 120,000 6.0% Retained Earnings 636,714 22.2% 496,714 28.1% 575,000 28.6% Total Stockholders $ 1,056,714 36.8% $ 916,714 51.8% $ 995,000 49.4% Total Liabilities & Stockholders $ 2,871,600 100.0% $ 1,769,800 100.0% $ 2,012,800 100.0%
Image of page 59
LEARDO ARLES DOCUMENT 2014 60 Equity Hanlon, Inc Income Statement Unaudited Audited Audited 12/31/X7 Percentage 12/31/X6 Percentage 12/31/X5 Percentage Sales $ 1,800,000 100.0% $ 1,300,000 100.0% $ 2,860,000 100.0% Cost of Goods Sold 800,000 44.4% 620,000 47.7% 1,700,000 59.4% Gross Profit 1,000,000 55.6% 680,000 52.3% 1,160,000 40.6% Operating Expenses 600,000 33.3% 488,954 37.6% 520,000 18.2% Income Before Income Taxes 400,000 22.2% 191,046 14.7% 640,000 22.4% Income Taxes 180,000 10.0% 154,332 11.9% 250,000 8.7% Net Income 220,000 12.2% 36,714 2.8% 390,000 13.6% Retained Earnings BOY 496,714 27.6% 575,000 44.2% 300,000 10.5% Total 716,714 39.8% 611,714 47.1% 690,000 24.1% Dividends 80,000 4.4% 115,000 8.8% 115,000 4.0% Retained Earnings - EOY $ 636,714 35.4% $ 496,714 38.2% $ 575,000 20.1% b. Berikut rasio-rasio untuk 3 tahun di atas Selected Industry Average: Industry Average Unaudited Audited Audited 12/31/X7 Ket 12/31/X6 Ket 12/31/X5 Ket Inventory Turnover 3 1.89 Jelek 1.86 Jelek 4.29 Bagus Account Receivable Turnover 10 8.45 Jelek 7.58 Jelek 13.95 Bagus Operating Margin - 0.12 0.03 0.14 Long Term : Equity Ratio 50% 57.3% Jelek 79.3% Jelek 87.9% Jelek Current Ratio 200% 74.0% Jelek 348.2% Bagus 480.3% Bagus Quick Ratio - 26.5% 133.3% 203.4% Profit Margin 5% 12.2% Bagus 2.8% Jelek 13.6% Bagus c. 1) Bandingkan rata-rata industri antara Hanlon, Inc dengan industry lain 1. Inventory turnover Inventory Turn Over (12/31/X7) = Inventory Turn Over = Harga Pokok Penjualan Rata rata Inventory
Image of page 60
LEARDO ARLES DOCUMENT 2014 61 800.000 270.000 + 4.500 + 300.000 + 80.000 + 12.000 + 180.000 /2 = 800.000 846.500/2 = 1.89 Rasio ini juga dapat menunjukkan berapa kali jumlah barang persediaan diganti dalam satu tahun. Semakin tinggi rasio ini maka hal ini menunjukkan perusahaan bekerja semakin efisien dan likuid persediaan semakin baik. Demikian pula apabila sebaliknya, maka perusahaan bekerja secara tidak efisien atau tidak produktif dan banyak barang persediaan yang menumpuk, hal ini akan mengakibatkan investasi dalam tingkat pengembalian yang rendah. Tingkat perputaran atau turnover 1.8x menunjukkan bahwa setiap tahun rata- rata persediaan Hanlon, Inc. mengalami penurunan atau kurang bisa mengatur perputaran persediaannya. 2. Account Receivable Turnover AR Turn Over (12/31/X7) = 1.800.000 300.000+( 12.000) + 150.000+( 12.000) /2 = 1.800.000 426.000/2 = 8.45 Turnover atau ratio antara penjualan dan piutang rata-rata adalah 8.4 menunjukkan bahwa penagihan piutang kira-kira 8.4 kali dalam satu tahun.
Image of page 61
Image of page 62

You've reached the end of your free preview.

Want to read all 154 pages?

  • Fall '19

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern

Stuck? We have tutors online 24/7 who can help you get unstuck.
A+ icon
Ask Expert Tutors You can ask You can ask ( soon) You can ask (will expire )
Answers in as fast as 15 minutes
A+ icon
Ask Expert Tutors