About Us Take My Online Class

Question.3062 - Income Statement 2008 & 2007 1/1/2008-12/31/2008Revenue $3,249,580.53 Direct Expenses Salaries & Wages $487,437.08 Vehicle Maintenance $64,991.61 Fuel $20,449.80 Traps & Chemicals $1,378,203.63 $1,951,082.12 Indirect Expenses Rent $39,338.17 Licenses $2,480.00 Insurance $103,613.43 Administrative Salaries $150,250.00 Commissions $16,991.61 Payroll Taxes $72,014.66 Legal Expenses $12,000.00 Accounting Fees $7,000.00 Office Supplies $7,800.00 Utilities $10,806.40 Advertising Expenses $116,000.00 Bad Debts $122,138.64 Depreciation Expense $94,925.75 Misc. Expense $50,000.00 $805,358.66 Total Expenses $2,756,440.78 Net Income $493,139.751/1/2007-12/31/2007Revenue $3,893,027.78 Direct Expenses Salaries& Wages $583,954.17 Traps & Chemicals $1,651,100.81 Fuel $19,177.32 Vehicle Maintenance $77,860.56 $2,332,092.85 Indirect Expenses Rent $38,192.40 Licenses $2,480.00 Interest Expense $0.00 Insurance $103,613.43 Admin. Salaries $133,500.00 Commissions $52,860.49 Payroll Taxes $84,734.61 Legal Expenses $12,000.00 Accounting Fees $7,000.00 Office Supplies $7,800.00 Utilities $9,824.00 Advertising Expenses $81,510.00 Bad Debts $103,493.45 Depreciation Expense $94,925.75 Misc. Expenses $60,000.00 $791,934.13 $3,124,026.98 Net Income $769,000.80Balance Sheet 2008 & 2007 12/31/2008Current Assets Cash $818,440.68 Accounts Receivable $812,395.13 Inventory $205,934.30 Total Current Assets $1,836,770.12 Fixed Assets Vehicles $268,750.00 Tools $110,953.00 Less Accumulated Depreciation ($284,431.95) Total Fixed Assets $95,271.05 Total Assets $1,932,041.17 Liabilities Current Liabilities Accrued Payroll Taxes $36,007.33 Accounts Payable $270,798.38 Total Current Liabilities $306,805.71 Long-Term Liabilities $0.00 Total Liabilities $306,805.71 Stockholders’ Equity Common Stock (1,000,000 authorized shares at $1 par) $70,000.00 Retained Earnings $1,062,095.71 Net Income $493,139.75 Total Stockholders’ Equity $1,625,235.46 Total Liabilities & Stockholders’ Equity $1,932,041.1712/31/2007Current Assets Cash $291,703.44 Accounts Receivable $811,047.45 Inventory $205,934.30 Total Current Assets $1,308,685.20 Fixed Assets Vehicles $268,750.00 Tools $110,953.00 Less Accumulated Depreciation ($189,506.20) Total Fixed Assets $190,196.80 Total Assets $1,498,882.00Liabilities Current Liabilities Accrued Payroll Taxes $42,367.31 Accounts Payable $324,418.98 Total Current Liabilities $366,786.29 Long?Term Liabilities Auto Loans $0.00 Total Long?Term Liabilities $0.00 Total Liabilities $366,786.29 Stockholders’ Equity Common Stock (1,000,000 authorized shares at $1 par) $70,000.00 Retained Earnings $293,094.91 Net Income $769,000.80 Total Stockholders’ Equity $1,132,095.71 Total Liabilities & Stockholders’ Equity $1,498,882.00Instructions: Using the 2007 & 2008 Income Statement and Balance Sheet provided, calculate the following… Liquidity ratios ? Current ratio ? Acid-test, or quick, ratio ? Receivables turnover ? Inventory turnover Profitability ratios ? Asset turnover ? Profit margin ? Return on assets ? Return on common stockholders’ equity Solvency ratios ? Debt to total assets ? Times interest earned Please be sure to also do the following… 1. Show your calculations for each ratio 2. Create a horizontal and vertical analysis for the balance sheet and the income statement 3. Write a 350- to 700-word memo to the CEO of your selected organization (Berry’s Bug Busters) in which you discuss your findings from your ratio calculations and your horizontal and vertical analysis. In your memo, address the following questions: a) What do the liquidity, profitability, and solvency ratios reveal about the financial position of the company? b) Which users may be interested in each type of ratio? c) What does the collected data reveal about eh performance and position of the company

Answer Below:

Ans xxxxxxxxx ratio xxxxxxx ratio xxxxxxx assets xxxxxxx liabilities xxxxxxx ratio xxxxxxx ratio xxxxx ratio xxxxxxx Assets x Inventories xxxxxxx Liabilities xxxxx ratio x Quick xxxxx - xxxxxxxxxxx turnover xxx Credit xxxxx Average xxxxxxxx Receivables xxxxxxxxxxx turnover xxxxxxxxxxx turnover xxxxxxxxx Turnover xxxx of xxxxx Sold xxxxxxx Inventory xxxxxxxxx Turnover xxxxxxxxx Turnover xxxxxxxxxxxxx ratios xxxxx turnover xxx Sales xxxxxxx Total xxxxxx Asset xxxxxxxx Asset xxxxxxxx Gross xxxxxx margin xxxxxxx ndash xxxx Revenue xxxxx profit xxxxxx - xxxxx profit xxxxxx - xxxxxx on xxxxx Annual xxx Income xxxxxxx Total xxxxx Return xx asset xxxxxx on xxxxx Return xx common xxxxxxxxxxxx rsquo xxxxxx Annual xxx Income xxxxxxx Stockholders xxx Equity xxxxxx on xxxxxx stockholders xxxxx equity xxxxxx on xxxxxx stockholders xxxxx equity xxxxxxxx ratios xxxx to xxxxx asset xxxxx term xxxx long xxxx debt xxxxx sales xxxx to xxxxx asset xxxx to xxxxx asset xxxxx Interest xxxxxx Earnings xxxxxx Interest xxx Tax xxxxxxxx Expense xxxxx Interest xxxxxx NA xx no xxxxxxxx paid xxxxx Interest xxxxxx NA xx no xxxxxxxx paidVertical xxxxxxxx AmountPercentage xxxxxxx Assets xxxx Accounts xxxxxxxxxx Inventory xxxxx Current xxxxxx Fixed xxxxxx Vehicles xxxxx Less xxxxxxxxxxx Depreciation x - xxxxx Fixed xxxxxx - xxxxx Assets xxxxxxxxxxx Current xxxxxxxxxxx Accrued xxxxxxx Taxes x Accounts xxxxxxx - xxxxx Current xxxxxxxxxxx - xxxxxxxxx Liabilities xxx DIV xxxxx Liabilities x Stockholders xxxxx Equity xxxxxx Stock xxxxxxxxxx shares xx par xxxxxxxx Earnings xxx Income x Total xxxxxxxxxxxx rsquo xxxxxx Total xxxxxxxxxxx amp xxx Stockholders xxxxx Equity xxxxxxx Sheet xxxxxxxxxx analysisVertical xxxxxxxx AmountPercentage xxxxxxx - xxxxxx Expenses xxxxxxxx amp xxx Wages x Vehicle xxxxxxxxxxx - xxxx Traps xxx amp xxxxxxxxx - xxxxxxxx Expenses xxxx Licenses xxxxxxxx Expense xxx Insurance xxxxxxxxxxxxxx Salaries xxxxxxxxxxx - xxxxxxx Taxes x Legal xxxxxxxx Accounting xxxx Office xxxxxxxx Utilities xxxxxxxxxxx Expenses xxx Debts xxxxxxxxxxxx Expense xxxx Expense x Total xxxxxxxx - xxx Income xxxxxxxxxx analysis xxxxxx StatementAns xx can xxx that xxx Current xxxxx has xxxxxxxxx from xx from xxxx to xxxx But x high xxxxxxx Ratio xxxxxxxx that xxxxxx the xxxxxxx is xx a xxxx position xx pay xxx its xxxxx but xx is xxxx bad xx a xxxx current xxxxx also xxxxx that xxx of xxxxx is xxxxxxxx in xxx Current xxxxxx which xxxxx have xxxx distributed xxxxx shareholders xx Dividends xx acid xxxx ratio xx quick xxxxx of xxxx is xxxx news xxx business xx well-placed xx be xxxx to xxx its xxxxx even xx it xxxxxx turn xxxxxxxxxxx into xxxx Thus xx can xxx that xxx if xx do xx analysis xx the xxxxx of xxxxx Ratio xxx company xxxxx in x favourable xxxxxxxx Also xxx ratio xxx increase xxxx to xxxx company xx in x better xxxxxxxx Accounts xxxxxxxxxx turnover xxxxxxxx the xxxxxxxxxx of x business xx collecting xxx credit xxxxx Generally x high xxxxx of xxxxxxxx receivable xxxxxxxx is xxxxxxxxx and xxxxx figure xxx indicate xxxxxxxxxxxx in xxxxxxxxxx outstanding xxxxx Increase xx accounts xxxxxxxxxx turnover xxxxxxxx generally xxxxxxxxx improvement xx the xxxxxxx of xxxx collection xx credit xxxxx The xxxxxxxx receivable xxxxxxxx ratio xxxxx a xxxxxxx from xx thus xx can xx assumed xxxx the xxxxxxx has xxxx lenient xx its xxxxxxxxx Inventory xxxxxxxx ratio xx used xx measure xxx inventory xxxxxxxxxx efficiency xx a xxxxxxxx In xxxxxxx a xxxxxx value xx inventory xxxxxxxx indicates xxxxxx performance xxx lower xxxxx means xxxxxxxxxxxx in xxxxxxxxxxx inventory xxxxxx A xxxxx inventory xxxxxxxx ratio xxx be xx indication xx over-stocking xxxxx may xxxx risk xx obsolescence xxx increased xxxxxxxxx holding xxxxx However x very xxxx value xx this xxxxx may xx accompanied xx loss xx sales xxx to xxxxxxxxx shortage xxx Inventory xxxxxxxx Ratio xx falling xxxx to xxx thus xxxxx inefficiency xx the xxxxxxxxx Levels xx a xxxxxxx can xxxxxxxx more xxxxx with xxxxx assets xx has x higher xxxxxxxx ratio xxxxx tells xx is x good xxxxxxx because xx is xxxxx its xxxxxx efficiently x lower xxxxxxxx ratio xxxxx that xxx company xx not xxxxx its xxxxxx optimally xxxxx asset xxxxxxxx ratio xx a xxx driver xx return xx equity xx discussed xx the xxxxxx analysis xx this xxxx between xxx the xxxxx Turnover xxxxx has xxxxxx drastically xxxxx shows xxxx utilization xx assets xxxxx is x very xxxxxx change xx profit xxxxxx from xx Though xxx margin xxx fallen xxxx a xxxx small xxxxxxxxxx but xxxxxxx margin xxxxx increase xx cost xxxxxxxx by xxx company xxxx declining xxxxxx margin xx negative xxx the xxxxxxx Return xx assets xxxxxxxxx the xxxxxx of xxxxx earned xx each xxxxxx of xxxxxx Thus xxxxxx values xx return xx assets xxxx that xxxxxxxx is xxxx profitable xxxx in xxxx case xx can xxx the xxxxxx of xxxxxx has xxxxxxxxx from xxxxx is xxxxxxxxxx for xxx company xxxxxx on xxxxxx stockholders xxxxx equity xxxxx measures xxx success xx a xxxxxxx in xxxxxxxxxx income xxx the xxxxxxx of xxxxxx stockholders xxxx in xxxx case xx observe xxxx return xx Equity xxx increased xxxxx is x good xxxx for xxxxxxx as xx will xxxx more xxxxxxxxx Debt xxxxx ranges xxxx to xxxxx value xx debt xxxxx is xxxxxxxxx and x higher xxxxx indicates xxxx higher xxxxxxx of xxxxxxx amp x assets xxx claimed xx its xxxxxxxxx which xxxxx higher xxxx in xxxxxxxxx since xxx business xxxxx find xx difficult xx obtain xxxxx for xxx projects xx this xxxx the xxxxx in xxxx the xxxxx remains xxx same xxxxxxxxx ratios xxx the xxxxxx that xxxxxxx the xxxxxxx of x company xx meet xxx short xxxx debt xxxxxxxxxxx These xxxxxx measure xxx ability xx a xxxxxxx to xxx off xxx short-term xxxxxxxxxxx when xxxx fall xxx Liquidity xxxxx is xxxxxx by xxxx internal xxx external xxxxxx The xxxxxxxx and xxxxxxxxx use xxxxx ratios xx gauge xxx company xxxxx s xxxxxxx to xxxx its xxxxx term xxxxxxxxx Profitability xxxxx is xxxx importantly xxxxx outside xxx firm xxxxx who xxxxxx money xxxx to xxxx a xxxxx whether xxx money xx being xxxxxxxxx to xxx them xxxxxxxxxx returns xxxxxxxx ratios xxx used xx financial xxxxxxxxxxxx that xxxxxx debt xx business xxxxx They xxx interested xx knowing xxx firms xxxxxxxx to xxxxxxx the xxxxx they xxxx taken xxx data xxxxxxxxx shows xxxx the xxxxxxx is xx good xxxxx and xxxxxxxxxxx is xx average xxxxxx in xxx places xxx performance xxx declined xxx the xxxx can xx improved xx working xxxx efficiently xxxx nbsp xxxxxx Statement xxxxxxxxxx analysis xxxxxxxx analysis xxxxxx Percentage xxxx Revenue xxxxxxx nbsp xxxx nbsp xxxx nbsp xxxx nbsp xxxx nbsp xxxx nbsp xxxx - xxxx Direct xxxxxxxx Direct xxxxxxxx Salaries xxx Wages xxxx Salaries xxx Wages xxxx nbsp xxxx nbsp x Vehicle xxxxxxxxxxx nbsp xxxxx amp xxxxxxxxx nbsp xxxx - xxxx nbsp xxxx nbsp xxxx nbsp xxxx nbsp xxxx nbsp xxxx nbsp xxxx nbsp xxxx nbsp xxxx nbsp xxxx nbsp xxxx nbsp xxxx nbsp xxxx nbsp xxxx nbsp xxxxx amp xxxxxxxxx Vehicle xxxxxxxxxxx nbsp xxxx nbsp x Indirect xxxxxxxx Indirect xxxxxxxx Rent xxxx nbsp xxxx nbsp xxxx nbsp xxxx nbsp xxxx nbsp xxxx nbsp xxxx nbsp xxxx nbsp xxxx nbsp xxxx Rent xxxx nbsp xxxx nbsp xxxx nbsp xxxx nbsp xxxx nbsp xxxx nbsp xxxxxxxx nbsp xxxx nbsp xxxx nbsp xxxx nbsp xxxx nbsp xxxx nbsp xxxx nbsp xxxx nbsp xxxx nbsp xxxx nbsp xxxxxxxx nbsp xxxx nbsp xxxx nbsp xxxx nbsp xxxx nbsp xxxx nbsp xxxx Interest xxxxxxx nbsp xxxx nbsp xxxx Interest xxxxxxx nbsp xxxx nbsp xxxx DIV xxxxxxxxx nbsp xxxx nbsp xxxx nbsp xxxx nbsp xxxx nbsp xxxx nbsp xxxx nbsp xxxx nbsp xxxx nbsp xxxx nbsp xxxx Insurance xxxx nbsp xxxx nbsp xxxx nbsp xxxx nbsp xxxx nbsp xxxxxxxxxxxxxx Salaries xxxx nbsp xxxxx Salaries xxxx nbsp xxxx nbsp xxxx nbsp xxxxxxxxxxx nbsp xxxx nbsp xxxx nbsp xxxx nbsp xxxx nbsp xxxx Commissions xxxx nbsp xxxx nbsp xxxx nbsp xxxx - xxxxxxx Taxes xxxx nbsp xxxx nbsp xxxx nbsp xxxx nbsp xxxx nbsp xxxxxxx Taxes xxxx nbsp xxxx nbsp xxxx nbsp xxxx - xxxxx Expenses xxxx nbsp xxxx nbsp xxxx nbsp xxxx nbsp xxxx nbsp xxxxx Expenses xxxx nbsp xxxx nbsp xxxx nbsp xxxxxxxxxx Fees xxxx nbsp xxxx nbsp xxxx nbsp xxxx nbsp xxxx Accounting xxxx nbsp xxxx nbsp xxxx Office xxxxxxxx nbsp xxxx nbsp xxxx nbsp xxxx nbsp xxxx nbsp xxxxxx Supplies xxxx nbsp xxxx nbsp xxxx Utilities xxxx nbsp xxxx nbsp xxxx nbsp xxxx nbsp xxxx nbsp xxxx nbsp xxxx nbsp xxxx nbsp xxxx nbsp xxxx Utilities xxxx nbsp xxxx nbsp xxxx nbsp xxxx nbsp xxxx nbsp xxxx Advertising xxxxxxxx nbsp xxxx nbsp xxxx nbsp xxxx Advertising xxxxxxxx nbsp xxxx nbsp xxx Debts xxxx nbsp xxxx nbsp xxxx nbsp xxxx nbsp xxxx nbsp xxxx nbsp xxxx nbsp xxxx nbsp xxxx nbsp xxx Debts xxxx nbsp xxxx nbsp xxxx nbsp xxxx nbsp xxxx Depreciation xxxxxxx nbsp xxxx nbsp xxxx nbsp xxxx nbsp xxxx Depreciation xxxxxxx nbsp xxxx Misc xxxxxxx nbsp xxxx nbsp xxxx nbsp xxxx nbsp xxxx Expenses xxxx nbsp xxxx nbsp x Total xxxxxxxx Total xxxxxxxx - xxx Income xxx Income xxxx nbsp xxxx nbsp xxxx nbsp xxxx nbsp xxxx nbsp

More Articles From Accounting

TAGLINE HEADING

More Subjects Homework Help