Customer Service Chat
Get quote & make Payment
Project, Basic Statistics
The trial balance of the Parton Wholesale Company contained the following accounts at December 31, 2010 the end of the company’s calendar year.
PARTON WHOLESALE COMPANY
Cash $ 34,400
Accounts Receivable 36,600
Merchandise Inventory (Beginning) 62,400
Accumulated Depreciation-Buildings $ 54,000
Accumulated Depreciation-Equipment 42,400
Notes Payable 50,000
Accounts Payable 37,500
Common Stock 200,000
Retained Earnings 67,800
Sales Discounts 4,600
Purchase Discounts 16,000
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
Depreciation is $10,000 on buildings and $9,000 on equipment. (Both are administrative expenses.)
Interest of $7,000 is unpaid on notes payable at December 31.
Merchandise inventory on hand at December 31, 2010 is $90,000.
Salaries are 80% selling and 20% administrative.
Utilities expense, repair expense, and insurance expense are 100% administrative.
$15,000 of the notes payable are payable next year.
Gas and oil expense is a selling expense.
The beginning balance of accounts receivable is $34,750.
The amount of total assets at the beginning of the year is $469,225.
Journalize the adjusting entries.
Prepare a multiple-step income statement and a retained earnings statement for the year ended, as well as a classified balance sheet as of December 31, 2010.
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
4) Based on the ratios computed in 3) 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.
2007 2008 2009 Industry Average
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
Debt to Total Assets (%) 20.97% 21.98% 22.89% 20.89%
Times Interest Earned 8.75 9.12 9.56 10.22
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
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%
Posted Date: 4/17/2012 7:54:36 PM | Location : United States
Ask an Expert
Project, Assignment Help, Ask Question on Project, Get Answer, Expert's Help, Project Discussions
Write discussion on Project
Your posts are moderated
Write your message here..
Anova, How to interpret Anova
How to interpret Anova
State the profit maximization problem of firm, Consider two firms producing...
Consider two firms producing an identical product in a market where the demand is described by p = 1; 200 - 2Y. The corresponding cost functions are c1 (y1) = y 2 1 and c2 (y2) =
Reference number 20110907, I am not able to log in again to retrieve my ass...
I am not able to log in again to retrieve my assignment that I paid for
Responsiblity accounting significance, What is significance of Responsiblit...
What is significance of Responsiblity accounting in divisional performance statement measurement?
Eye, the near point of hypermetropic person is 75cm if the person uses eyeg...
the near point of hypermetropic person is 75cm if the person uses eyeglasses having power +1.0 D,calculate the distance of distinct vision
Historigrams and histograms, #difference between historigrams and histogram...
#difference between historigrams and histograms
Differance between categorical and dependent variable, Choose a topic that ...
Choose a topic that interests you that you can explore either with the 2006 GSS. You should have one primary "dependent" variable that you are interested in (Y). This variable shou
Evaluate the probability, Question 1: (a) 75 percent of all people in a...
Question 1: (a) 75 percent of all people in a population are vaccinated against a par-ticular disease. During an epidemic, the probability that a vaccinated person is infected
Singular statistics, what is singular statistics
what is singular statistics
Electric fields, what is the electric field at point x if q=7*10^-6 C d=6m
what is the electric field at point x if q=7*10^-6 C d=6m
Accounting Assignment Help
Economics Assignment Help
Finance Assignment Help
Statistics Assignment Help
Physics Assignment Help
Chemistry Assignment Help
Math Assignment Help
Biology Assignment Help
English Assignment Help
Management Assignment Help
Engineering Assignment Help
Programming Assignment Help
Computer Science Assignment Help
IT Courses and Help
Why Us ?
~24x7 hrs Support
~Quality of Work
~Time on Delivery
~Privacy of Work
Human Resource Management
Literature Review Writing Help
Follow Us |
T & C
Copyright by ExpertsMind IT Educational Pvt. Ltd.