Details of this Paper

The Wiley Department Store is located near the...

Description

Solution


Question

The Wiley Department Store is located near the Village shopping mall. At the close of the year ended December 31, 2007, the following accounts appeared in two of its trial balances. Trial Balances Unadjusted Adjusted Accounts Payable $ 89,300 $ 89,300 Accounts Receivable 50,300 50,300 Accumulated Depreciation-Building 42,100 52,500 Accumulated Depreciation-Equipment 29,600 42,900 Building 190,000 190,000 Cash 23,000 23,000 Depreciation Expense-Building 10,400 Depreciation Expense-Equipment 13,300 Equipment 110,000 110,000 Freight-in 3,600 3,600 Insurance Expense 7,200 Interest Expense 3,000 11,000 Interest Payable 8,000 Interest Revenue 4,000 4,000 Merchandise Inventory (Beginning Inventory) 40,500 40,500 Mortgage Payable 80,000 80,000 Office Salaries Expense 32,000 32,000 Prepaid Insurance - 9,600 2,400 Property Taxes Payable 4,800 Purchases 462,000 462,000 Purchase Discounts 12,000 12,000 Purchase Returns and Allowances 6,400 6,400 Sales Salaries Expense? 76,000 76,000 Sales 618,000 618,000 Sales Commissions Expense 11,000 14,500 Sales Commissions Payable 3,500 Sales Returns and Allowances 8,000 8,000 Common Stock 150,000 150,000 Retained Earnings 26,600 26,600 Dividends 28,000 28,000 Property Taxes Expense 4,800 Utilities Expense 11,000 11,000 Analysis reveals the following additional data: 1. A physical inventory was conducted for year ended December 31, 2007 and the inventory was valued at $70,000. 2. Insurance expense and utilities expense are, 60% selling and 40% administrative. 3. $20,000 of the mortgage payable is due for payment next year. 4. Depreciation on the building and property tax expense are administrative expenses; depreciation on the equipment is a selling expense. 5. The beginning balance of accounts receivable is $64,750. 6. The amount of total assets at the beginning of the year is $321,725. 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 1.05 1.23 1.56 1.35 Quick 0.56 0.85 0.99 1.02 Working Capital $ 19,500.00 $ 20,900.00 $ 22,000.00 $ 22,000.00 Leverage Debt to Total Assets (%) 46.32% 49.56% 52.12% 44.00% Times Interest Earned 1.96 2.85 3.99 5.2 Activity Inventory Turnover (sales) 6.51 7.05 8.01 12.50 Fixed Asset Turnover 2.86 3.68 4.02 6.23 Total Asset Turnover 1.56 2.64 2.99 3.59 Average Collection Period (days) 30.05 27.99 25.73 22.61 Accounts Receivable Turnover 11.98 12.86 13.99 15.92 Days in Inventory 56.07 51.77 45.57 52.13 Profitability Gross Profit Margin (%) 29.58% 31.42% 32.89% 42.26% Net Profit (%) 2.34% 3.87% 4.08% 5.89% Return on Total Assets (%) 4.34% 4.76% 5.36% 6.01% Return on Equity (%) 9.27% 10.68% 10.99% 11.05% Payout Ratio 62.00% 81.00% 95.00% 50.00%,The Wiley Department Store is located near the Village shopping mall. At the close of the year ended December 31, 2007, the following accounts appeared in two of its trial balances. Trial Balances Unadjusted Adjusted Accounts Payable $ 89,300 $ 89,300 Accounts Receivable 50,300 50,300 Accumulated Depreciation-Building 42,100 52,500 Accumulated Depreciation-Equipment 29,600 42,900 Building 190,000 190,000 Cash 23,000 23,000 Depreciation Expense-Building 10,400 Depreciation Expense-Equipment 13,300 Equipment 110,000 110,000 Freight-in 3,600 3,600 Insurance Expense 7,200 Interest Expense 3,000 11,000 Interest Payable 8,000 Interest Revenue 4,000 4,000 Merchandise Inventory (Beginning Inventory) 40,500 40,500 Mortgage Payable 80,000 80,000 Office Salaries Expense 32,000 32,000 Prepaid Insurance - 9,600 2,400 Property Taxes Payable 4,800 Purchases 462,000 462,000 Purchase Discounts 12,000 12,000 Purchase Returns and Allowances 6,400 6,400 Sales Salaries Expense? 76,000 76,000 Sales 618,000 618,000 Sales Commissions Expense 11,000 14,500 Sales Commissions Payable 3,500 Sales Returns and Allowances 8,000 8,000 Common Stock 150,000 150,000 Retained Earnings 26,600 26,600 Dividends 28,000 28,000 Property Taxes Expense 4,800 Utilities Expense 11,000 11,000 Analysis reveals the following additional data: 1. A physical inventory was conducted for year ended December 31, 2007 and the inventory was valued at $70,000. 2. Insurance expense and utilities expense are, 60% selling and 40% administrative. 3. $20,000 of the mortgage payable is due for payment next year. 4. Depreciation on the building and property tax expense are administrative expenses; depreciation on the equipment is a selling expense. 5. The beginning balance of accounts receivable is $64,750. 6. The amount of total assets at the beginning of the year is $321,725. 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 1.05 1.23 1.56 1.35 Quick 0.56 0.85 0.99 1.02 Working Capital $ 19,500.00 $ 20,900.00 $ 22,000.00 $ 22,000.00 Leverage Debt to Total Assets (%) 46.32% 49.56% 52.12% 44.00% Times Interest Earned 1.96 2.85 3.99 5.2 Activity Inventory Turnover (sales) 6.51 7.05 8.01 12.50 Fixed Asset Turnover 2.86 3.68 4.02 6.23 Total Asset Turnover 1.56 2.64 2.99 3.59 Average Collection Period (days) 30.05 27.99 25.73 22.61 Accounts Receivable Turnover 11.98 12.86 13.99 15.92 Days in Inventory 56.07 51.77 45.57 52.13 Profitability Gross Profit Margin (%) 29.58% 31.42% 32.89% 42.26% Net Profit (%) 2.34% 3.87% 4.08% 5.89% Return on Total Assets (%) 4.34% 4.76% 5.36% 6.01% Return on Equity (%) 9.27% 10.68% 10.99% 11.05% Payout Ratio 62.00% 81.00% 95.00% 50.00%,thx,i got it , thx

 

Paper#2909 | Written in 18-Jul-2015

Price : $25
SiteLock