Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The trial balance of the Parton Wholesale Company contained the following accounts at December 31, 2007 the end of the company?s calendar year. PARTON WHOLESALE

image text in transcribed The trial balance of the Parton Wholesale Company contained the following accounts at December 31, 2007 the end of the company?s calendar year. PARTON WHOLESALE COMPANY Trial Balance 31-Dec-07 Debit Credit Cash $ 34,400 Accounts Receivable 36,600 Merchandise Inventory (Beginning) 62,400 Land 92,000 Buildings 197,000 Accumulated Depreciation-Buildings $ 54,000 Equipment 83,500 Accumulated Depreciation-Equipment 42,400 Notes Payable 50,000 Accounts Payable 37,500 Common Stock 200,000 Retained Earnings 67,800 Dividends 10,000 Sales 886,100 Sales Discounts 4,600 Purchases 725,100 Purchase Discounts 16,000 Freight-in 12,400 Salaries Expense 69,800 Utilities Expense 9,400 Repair Expense 5,900 Gas and Oil Expense 7,200 Insurance Expense 3,500 $ 1,353,800 $ 1,353,800 Adjustment data: 1. Depreciation is $10,000 on buildings and $9,000 on equipment. (Both are administrative expenses.) 2. Interest of $7,000 is unpaid on notes payable at December 31. Other data: 1. Merchandise inventory on hand at December 31, 2007 is $90,000. 2. Salaries are 80% selling and 20% administrative. 3. Utilities expense, repair expense, and insurance expense are 100% administrative. 4. $15,000 of the notes payable are payable next year. 5. Gas and oil expense is a selling expense. 6. The beginning balance of accounts receivable is $34,750. 7. The amount of total assets at the beginning of the year is $469,225. Instructions 1) Journalize the adjusting entries. 2) Prepare a multiple-step income statement and a retained earnings statement for the year and a classified balance sheet as of December 31, 2007. 3) Journalize the closing entries. 4) Prepare a post-closing trial balance. 5) Prepare the following ratios and show all support for your computations: a) Current Ratio b) Quick Ratio c) Working Capital d) Accounts Receivable Turnover e) Average Collection Period f) Inventory Turnover g) Days in Inventory h) Debt to Total Assets Ratio i) Gross Profit Ratio j) Profit Margin Ratio k) Return on Assets Ratio l) Asset Turnover Ratio 6) Based on the ratios computed in 5) above, answer the following questions and use the financial statement ratios to support your answers where appropriate: ? Do you feel that the company is able to meet its current and long term obligations as they become due? ? Comment on the profitability of the company with respect to the various profitability ratios that you computed. ? Would you lend money to this company for the long term? ? Comment on the ability of the company to collect its receivables and mange inventory. 2004 2005 2006 Industry Average Liquidity Current 2.39 2.68 2.90 3.12 Quick 1.10 1.16 1.21 1.56 Working Capital $ 98,750.00 $ 100,450.00 $ 103,000.00 $ 110,000.00 Leverage Debt to Total Assets (%) 20.97% 21.98% 22.89% 20.89% Times Interest Earned 8.75 9.12 9.56 10.22 Activity Inventory Turnover (sales) 8.21 9.91 10.12 10.52 Fixed Asset Turnover 3.43 3.51 3.59 3.64 Total Asset Turnover 2.15 2.20 2.25 2.56 Average Collection Period (days) 14.95 14.69 14.42 14.28 Accounts Receivable Turnover 24.08 24.50 24.97 25.21 Days in Inventory 44.46 36.83 36.07 43.21 Profitability Gross Profit Margin (%) 21.10% 22.50% 24.03% 24.56% Net Profit (%) 6.89% 7.25% 7.89% 8.03% Return on Total Assets (%) 15.50% 16.10% 16.24% 16.07% Return on Equity (%) 20.15% 21.89% 22.15% 22.06% Payout Ratio (%) 15.10% 15.84% 16.09% 16.86% image text in transcribed Project I The trial balance of the Parton Wholesale Company contained the following accounts at December 31, 2007 the end of the company's calendar year. PARTON WHOLESALE COMPANY Trial Balance 31-Dec-07 Cash Accounts Receivable Merchandise Inventory (Beginning) Land Buildings Accumulated Depreciation-Buildings Equipment Accumulated Depreciation-Equipment Notes Payable Accounts Payable Common Stock Retained Earnings Dividends Sales Sales Discounts Purchases Purchase Discounts Freight-in Salaries Expense Utilities Expense Repair Expense Gas and Oil Expense Insurance Expense Debit $ 34,400 36,600 62,400 92,000 197,000 Credit $ 54,000 83,500 42,400 50,000 37,500 200,000 67,800 10,000 886,100 4,600 725,100 16,000 12,400 69,800 9,400 5,900 7,200 3,500 $ 1,353,800 $ 1,353,800 Adjustment data: 1. Depreciation is $10,000 on buildings and $9,000 on equipment. (Both are administrative expenses.) 2. Interest of $7,000 is unpaid on notes payable at December 31. Other data: 1. Merchandise inventory on hand at December 31, 2007 is $90,000. 2. Salaries are 80% selling and 20% administrative. 3. Utilities expense, repair expense, and insurance expense are 100% administrative. 4. $15,000 of the notes payable are payable next year. 5. Gas and oil expense is a selling expense. 6. The beginning balance of accounts receivable is $34,750. 7. The amount of total assets at the beginning of the year is $469,225. Instructions 1) Journalize the adjusting entries. 2) Prepare a multiple-step income statement and a retained earnings statement for the year and a classified balance sheet as of December 31, 2007. 3) Journalize the closing entries. 4) Prepare a post-closing trial balance. 5) Prepare the following ratios and show all support for your computations: a) Current Ratio b) Quick Ratio c) Working Capital d) Accounts Receivable Turnover e) Average Collection Period f) Inventory Turnover g) Days in Inventory h) Debt to Total Assets Ratio i) Gross Profit Ratio j) Profit Margin Ratio k) Return on Assets Ratio l) Asset Turnover Ratio 6) Based on the ratios computed in 5) above, answer the following questions and use the financial statement ratios to support your answers where appropriate: Do you feel that the company is able to meet its current and long term obligations as they become due? Comment on the profitability of the company with respect to the various profitability ratios that you computed. Would you lend money to this company for the long term? Comment on the ability of the company to collect its receivables and mange inventory. 2004 Liquidity Current Quick Working Capital Leverage Debt to Total Assets (%) Times Interest Earned Activity Inventory Turnover (sales) Fixed Asset Turnover Total Asset Turnover Average Collection Period (days) Accounts Receivable Turnover Days in Inventory Profitability Gross Profit Margin (%) Net Profit (%) Return on Total Assets (%) Return on Equity (%) Payout Ratio (%) 2.39 1.10 $ 98,750.00 2005 2006 2.68 1.16 $ 100,450.00 Industry Average 2.90 1.21 $ 103,000.00 $ 110,000.00 3.12 1.56 20.97% 8.75 21.98% 9.12 22.89% 9.56 20.89% 10.22 8.21 3.43 2.15 9.91 3.51 2.20 10.12 3.59 2.25 10.52 3.64 2.56 14.95 24.08 44.46 14.69 24.50 36.83 14.42 24.97 36.07 14.28 25.21 43.21 21.10% 6.89% 15.50% 20.15% 15.10% 22.50% 7.25% 16.10% 21.89% 15.84% 24.03% 7.89% 16.24% 22.15% 16.09% 24.56% 8.03% 16.07% 22.06% 16.86%

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_2

Step: 3

blur-text-image_3

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

Financial Accounting

Authors: Robert Libby, Patricia Libby, Daniel G Short, George Kanaan, Maureen Sterling

6th Canadian edition

73208140, 1259105695, 978-1259105692

More Books

Students also viewed these Accounting questions