Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

3. Use the balance sheet and income statement of Dalek Plumbing Supplies below to answer the questions on the following pages. Be sure to calculate

3. Use the balance sheet and income statement of Dalek Plumbing Supplies below to answer the questions on the following pages. Be sure to calculate ratios and percentages to 2 decimal places. Dalek Plumbing Supplies, Inc. Balance Sheet December 31, 2020 Dalek Plumbing Supplies, Inc. Income Statement For year ending Dec. 31, 2020 Assets: Revenue Current Assets Net Sales $452,000 Bank $ 42,000 Accounts Receivable 67,000 Cost of Goods Sold Merchandise Inventory 123,000 $232,000 Beginning Inventory $ 87,000 Plant and Equipment Purchases 242,000 Land $87,000 Merch. Available for Sale 329,000 Building, net 124,000 Ending Inventory 123,000 206,000 Long-Term Liability Equipment, net Total Assets Liabilities and Equity Current Liabilities Bank Loan Accounts Payable Mortgage Payable Shareholders' Equity Share Capital Total Liabilities and Equity 26,000 237,000 $469.000 Gross Profit 246,000 Operating Expenses Bank Charges 7,000 $83,000 Depreciation Expense 25,000 45,000 $128,000 Management Salaries 67,000 Miscellaneous Expense 8,000 142,000 Telephone Expense 13,000 Utilities Expense 42,000 Retained Earnings $70,000 129,000 199,000 $469.000 Wages Expense 106,000 268,000 Net Loss ($ 22,000) Ratio Formulae 1) Total C.A. Total C.L. 2) Total L. x 100% 3)=N.L. x 100% a) Calculate the following ratios, showing all your work to two decimal places. Under each result, write a brief comment that explains and evaluates the result. (1 A, 1 C each - 6 total) 1. Current Ratio= Total A. N.S. 2. Debt Ratio== C 3. Return on Net Sales b) Answer the following questions, showing all work where needed. 1. Calculate the Horizontal Analysis on the LS. Sales and Net Income. Assume 2019 Sales was $475,000 and 2019 Net Income was $15,000. (2A) 2. Briefly explain if Dalek Plumbing Supplies is doing better or worse in 2020 in terms of Sales and Net Income. Refer to the answers above, and be sure to explain your reasoning. (3 C) c) Calculate the Vertical Analysis for Equipment. Explain what the result suggests about the "criticality" or importance of Equipment to the company. (1 A, 1C)

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

Step: 3

blur-text-image

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 Managerial Accounting

Authors: Belverd E. Needles

7th Edition

0618867465, 978-0618867462

More Books

Students also viewed these Accounting questions

Question

=+j Describe the various support services delivered by IHR.

Answered: 1 week ago

Question

=+j Explain IHRMs role in global HR research.

Answered: 1 week ago