Question

Managerial Accounting ACC 122 Chapter 14 - Review Quiz Here are the financial statements for Puget Sound Boatworks Complete a

complete a vertical analysis for both the balance sheet and income statement in the column provided to the right

I want to make sure I'm doing this right

0 0
Add a comment Improve this question Transcribed image text
Answer #1

1) Working Capital Ratio = Sales / Working Capital

Working Capital = Current Assets - Current Liabilities

= ( Cash + Account receivable + Inventory + Prepaid exp. ) - Current Liabilities

= ( $ 8,000 + $ 36,000 + $ 40,000 + $ 2,000 ) - $ 40,000

= $ 46,000

Working Capital Ratio = $ 450,000 / $ 46,000 = 9.8 times

2) Current Ratio = Current Assets / Current Liabilities

= ( $ 8,000 + $ 36,000 + $ 40,000 + $ 2,000 ) / $ 40,000

= $ 86,000 / $ 40,000 = 2.2 : 1

3) Acid - Test Ratio = ( Cash + Account Receivable + Prepaid exp.) / Total current liabilities

= ( $ 8,000 + $ 36,000 + $ 2,000 ) / $ 40,000

= $ 46,000 / $ 40,000

= 1.6

4) Account Receivable Ratio = Net credit sales / Average account Receivables

= $ 450,000 / [ ( $ 36,000 + $ 34,000 ) / 2 ]

= $ 450,000 / $ 35,000

= 12.9 times

Add a comment
Know the answer?
Add Answer to:
complete a vertical analysis for both the balance sheet and income statement in the column provided...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Complete a vertical and horizontal analysis on both the income statement and balance sheet. use total...

    Complete a vertical and horizontal analysis on both the income statement and balance sheet. use total assets on the balance sheet and net sales on the income statement for your vertical analysis. Styles Consolidated Statements of 12 Months Ended Earnings (USD $) In Millions, except Per Share data, unless otherwise specified Income Statement (Abstract] NET SALES Cost of Sales Vertical Vertical Horizontal Feb. 01, 2015 Feb. 02, 2014 Analysis Analysis Analysis $83,176 54,222 $78,812 51,422 GROSS PROFIT Operating Expenses: Selling,...

  • Consider the following Balance Sheet and Income Statement for Bees Inc. Balance Sheet 2019 2018 Change...

    Consider the following Balance Sheet and Income Statement for Bees Inc. Balance Sheet 2019 2018 Change Assets Cash 117,990 20,000 97,990 Net Accounts Rec. 14,000 17,000 -3,000 Inventory 40,000 32,000 8,000 Equipment 350,000 300,000 50,000 Accum. Depr. -135,000 -120,000 -15,000 Natural Resources 70,000 45,000 25,000 Accum. Depl. -15,000 -10,000 -5,000 Total Assets 441,900 284,000 Liabilities & Equity Accounts Payable 26,000 24,200 1,800 Mortgage 80,000 136,300 -56,300 Common Stock 30,000 20,000 10,000 APIC 60,000 40,000 20,000 Retained Earnings 245,990 63,500 182,490...

  • 1. Prepare a vertical analysis for Ambrose for both its income statement and balance sheet. 2....

    1. Prepare a vertical analysis for Ambrose for both its income statement and balance sheet. 2. Compare the​ company's profit performance and financial position with the average for the industry. Ambrose Department Stores, Inc. Income Statement Compared with Industry Average Year Ended December 31, 2018 Industry Ambrose                               Average Net Sales Revenue                                        $780,000                                100.0 % Cost of Goods Sold                                          524,940                                     65.8 Gross Profit                                                   255,060                                            34.2 Operating Expenses                                      159,120                                             19.7 Operating Income                                           95,940                                               14.5 Other Expenses                                             7,020                                                  0.4 Net Income                                                $88,920                                              14.1...

  • Using the income statements and changes in balance sheet accounts provided for Firms A and B,...

    Using the income statements and changes in balance sheet accounts provided for Firms A and B, you will need to provide the following information: (c) Summary analysis of the statements of cash flows for Firms A and B (see Exhibit 4.6 on page 181 of your textbook): 1. Total inflows for Firm A 2. Total outflows for Firm A 3. Total inflows for Firm B 4. Total outflows for Firm B Income statement for year ended December 31,2015 Firm A...

  • please complete the balance sheet. Analyzing, Forecasting, and Interpreting Both Income Statement and Balance Sheet Following...

    please complete the balance sheet. Analyzing, Forecasting, and Interpreting Both Income Statement and Balance Sheet Following are the income statements and balance sheets of General Mills, Inc. Income Statement, Fiscal Years Ended ($ millions) May 29, 2011 May 30, 2010 Net Sales $ 14,880.2 $ 14,635.6 Cost of sales 8,926.7 8,835,4 Selling general and administrative expenses 3.192.0 3,162.7 Divestitures (gain), net (17.4) Restructuring, impairment, and other exit costs 4.4 31.4 Operating income 2.606.1 Interest, net 401.6 Earnings before income tax...

  • Prepare a vertical analysis of the income statement and balance sheet. Show each item on the...

    Prepare a vertical analysis of the income statement and balance sheet. Show each item on the income statement as a percentage of the net sales for each year. On the balance sheet, show each asset item as a percentage of the total assets and each liability and equity item as a percentage of the total liabilities and stockholders' equity. Round percentages to one decimal place. Miller Electronics Corporation Comparative Income Statement For Years Ended December 31, 20-2 and 20-1 20-2...

  • Complete a vertical and horizontal analysis on the tabs labeled "Balance Sheet" and "Income Statement," use total assets on the balance sheet and net sales on the income statement for...

    Complete a vertical and horizontal analysis on the tabs labeled "Balance Sheet" and "Income Statement," use total assets on the balance sheet and net sales on the income statement for your vertical analysis. Consolidated Balance Sheets (USD $) In Millions, unless o Feb. 01,2015 Vertical AnalysisFeb. 01,2014Vertical AnalysisHorizontal Analysis therwises fied Current Assets: Cash and Cash Equivalents Receivables, net Merchandise Inventories Other Current Assets Total Current Assets $1.723 1484 11079 1016 15302 38.513 $1929 1.398 11,057 895 15,279 39,064 at...

  • Dauber Corporation's comparative balance sheet and income statement for last year appear below: Comparative Balance Sheet...

    Dauber Corporation's comparative balance sheet and income statement for last year appear below: Comparative Balance Sheet Ending Balance Beginning Balance Cash and cash equivalents $ 64,000 $ 39,000 Accounts receivable 57,000 44,000 Inventory 58,000 70,000 Prepaid expenses 18,000 10,000 Long-term investments 290,000 230,000 Property, plant, and equipment 520,000 520,000 Less accumulated depreciation 390,000 358,000 Total assets $ 617,000 $ 555,000 Accounts payable $ 14,000 $ 38,000 Accrued liabilities 35,000 17,000 Income taxes payable 69,000 40,000 Bonds payable 160,000 180,000 Common...

  • Prepare a horizontal analysis of both the balance sheet and income statement. Complete this question by...

    Prepare a horizontal analysis of both the balance sheet and income statement. Complete this question by entering your answers in the tabs below. Analysis Bal Sheet Analysis Inc Stmt Prepare a horizontal analysis of the balance sheet. (Negative answers should be indicated by a minus sign. Round your answers to 1 decimal place. (i.e., .234 sho be entered as 23.4).). FANNING COMPANY Horizontal Analysis of Balance Sheets 2019 2018 Percentage Change $ Assets Current assets Cash Marketable securities Accounts receivable...

  • Problem 23.1A Horizontal and vertical analysis of income statement and balance sheet. LO 23-1, 23...

    Problem 23.1A Horizontal and vertical analysis of income statement and balance sheet. LO 23-1, 23-2 The EastTN Company sells computer parts through a retail store that it operates. The firm’s comparative income statement and balance sheet for the years 2016 and 2015 are shown below.    1-a. Complete both a horizontal and a vertical analysis of comparative income statement for the years 2016 and 2015. (Round your percentage answers to 1 decimal place. i.e., 0.123 should be entered as 12.3.) 1-b....

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT