ASSETS Current Assets Cash A/R Merch. Invty. Total Current Assets Non-Current Assets PPE Total Non-Current Assets...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
ASSETS Current Assets Cash A/R Merch. Invty. Total Current Assets Non-Current Assets PPE Total Non-Current Assets TOTAL ASSETS LIABILITIES & SE Current Liabilities Accounts Payable Accrued Expenses Long-Term Liabilities Loans payable Total Long-Term Liabilities TOTAL LIABILITIES STOCKHOLDER'S EQUITY Common Stock Retained Earnings 2020 Total Current Liabilities P 100,000 Total Stockholder's Equity TOTAL LIABILITIES & SE For the Year Ended December 31, 2020-2024 2021 2022 ABC Corporation Balance Sheet P 60,000 120,000 420,000 P 50,000 150,000 520,000 P 600,000 P 720,000 1,600,000 1,700,000 1,700,000 1,600,000 P 2,200,000 P 2,420,000 P 70,000 P 30,000 60,000 20,000 80,000 150,000 200,000 150,000 200,000 P 250,000 P 280,000 P 1,800,000 P 2,000,000 150,000 1,950,000 140,000 2,140,000 P 2,200,000 P 2,420,000 80,000 160,000 580,000 P 820,000 P 1,800,000 1,800,000 P 2,620,000 P 100,000 60,000 P 160,000 300,000 300,000 P 460,000 P 2,000,000 160,000 2,160,000 P 2,620,000 2023 P 100,000 200,000 600,000 P 900,000 2,000,000 2,000,000 P 2,900,000 P 200,000 100,000 300,000 P 400,000 400,000 P 700,000 P 2,000,000 200,000 2,200,000 P 2,900,000 2024 P 200,000 400,000 800,000 P 1,400,000 2,500,000 2,500,000 P 3,900,000 P 300,000 200,000 P 500,000 600,000 600,000 P 1,100,000 P 2,000,000 800,000 2,800,000 P 3,900,000 ASSETS Current Assets Cash A/R Merch. Invty. Total Current Assets Non-Current Assets PPE Total Non-Current Assets TOTAL ASSETS LIABILITIES & SE Current Liabilities Accounts Payable Accrued Expenses Total Current Liabilities Long-Term Liabilities Loans payable Total Long-Term Liabilities TOTAL LIABILITIES STOCKHOLDER'S EQUITY Common Stock Retained Earnings Total Stockholder's Equity TOTAL LIABILITIES & SE 2020 Requirement: Trend Ratios: ABC Corporation Balance Sheet For the Year Ended December 31, 2020-2024 2021 2022 2023 2024 ASSETS Current Assets Cash A/R Merch. Invty. Total Current Assets Non-Current Assets PPE Total Non-Current Assets TOTAL ASSETS LIABILITIES & SE Current Liabilities Accounts Payable Accrued Expenses Total Current Liabilities Long-Term Liabilities Loans payable Total Long-Term Liabilities TOTAL LIABILITIES STOCKHOLDER'S EQUITY Common Stock Retained Earnings Total Stockholder's Equity TOTAL LIABILITIES & SE 2020 ABC Corporation Income Statement For the Year Ended December 31, 2020-2024 2021 2022 Requirement: Common Size Balance Sheet 2023 2024 Retained Earnings Total Stockholder's Equity TOTAL LIABILITIES & SE 150,000 1,950,000 140,000 2,140,000 P 2,200,000 P 2,420,000 160,000 2,160,000 P 2,620,000 1. Compute Measures of Profitability from 2020-2024 Additional Information: a. par Value P 200 per share b. Market Price per share P 205 Year 2020, P 210 Year 2021, P 212 Year 2022, P 215 Year 2023, P 216 Year 2024 c. Dividend Payment 1. Year 2020 30,000 2. Year 2021 50,000 60,000 3. Year 2022 4. Year 2023 70,000 5. Year 2024 80,000 2. Compute Measures of Liquidity from 2020-2024 *All sales on account ** All purchases on account 200,000 2,200,000 P 2,900,000 800,000 2,800,000 P 3,900,000 Sales SRA SD Net Sales Cost of Sales Gross Profit Operating Expenses Marketing Expenses Gen, & Adm Expenses Total Operating Expenses Net Income ASSETS Current Assets Cash A/R Merch. Invty. Total Current Assets Non-Current Assets PPE Total Non-Current Assets TOTAL ASSETS LIABILITIES & SE Current Liabilities Accounts Payable Accrued Expenses Total Current Liabilities Long-Term Liabilities Loans payable Total Long-Term Liabilities TOTAL LIABILITIES STOCKHOLDER'S EQUITY Common Stock 2020 P 200,000 2,000 3.000 P 195,000 130,000 P 65.000 5,000 20,000 25,000 P 40,000 2020 ABC Corporation Income Statement For the Year Ended December 31, 2020-2024 2021 P 400,000 4,000 3.000 1.600.000 1,600,000 P 2,200,000 P 393,000 150,000 P 243,000 P 70,000 30,000 P 100.000 60,000 40,000 100,000 P 143,000 P 60,000 120,000 420,000 P 50,000 150,000 520,000 P 600,000 P 720.000 1.700.000 1,700,000 P. 2,420,000 P ABC Corporation Balance Sheet 60,000 20,000 P 80.000 For the Year Ended December 31, 2020-2024 2021 2022 2022 P 650,000 6,000 4,000 P 640,000 280,000 P 360,000 150,000 150,000 200.000 200,000 P 250,000 P 280,000 70,000 50,000 P 1,800,000 P 2,000,000 120,000 P 240,000 1,800,000 1,800,000 P 2,620,000 P 100,000 60,000 P 160,000 2023 P 700,000 8,000 6.000 300.000 300,000 P 460.000 P 686,000 350,000 P336.000 P 80,000 160,000 580,000 P 100,000 200,000 600,000 P 820.000 P 900.000 P 2,000,000 80,000 100,000 180,000 P 156,000 2023 2,000,000 2,000,000 P 2,900,000 P 200,000 100,000 P 300.000 400,000 400,000 P 700,000 P 2,000,000 2024 P 800,000 10,000 15,000 P 775,000 420,000 P 355.000 100,000 90,000 190,000 P 165,000 2024 P 200,000 400,000 800,000 P 1.400.000 2.500.000 2,500,000 P 3,900,000 P 300,000 200,000 P 500,000 600,000 600,000 P 1,100,000 P 2,000,000 ASSETS Current Assets Cash A/R Merch. Invty. Total Current Assets Non-Current Assets PPE Total Non-Current Assets TOTAL ASSETS LIABILITIES & SE Current Liabilities Accounts Payable Accrued Expenses Long-Term Liabilities Loans payable Total Long-Term Liabilities TOTAL LIABILITIES STOCKHOLDER'S EQUITY Common Stock Retained Earnings 2020 Total Current Liabilities P 100,000 Total Stockholder's Equity TOTAL LIABILITIES & SE For the Year Ended December 31, 2020-2024 2021 2022 ABC Corporation Balance Sheet P 60,000 120,000 420,000 P 50,000 150,000 520,000 P 600,000 P 720,000 1,600,000 1,700,000 1,700,000 1,600,000 P 2,200,000 P 2,420,000 P 70,000 P 30,000 60,000 20,000 80,000 150,000 200,000 150,000 200,000 P 250,000 P 280,000 P 1,800,000 P 2,000,000 150,000 1,950,000 140,000 2,140,000 P 2,200,000 P 2,420,000 80,000 160,000 580,000 P 820,000 P 1,800,000 1,800,000 P 2,620,000 P 100,000 60,000 P 160,000 300,000 300,000 P 460,000 P 2,000,000 160,000 2,160,000 P 2,620,000 2023 P 100,000 200,000 600,000 P 900,000 2,000,000 2,000,000 P 2,900,000 P 200,000 100,000 300,000 P 400,000 400,000 P 700,000 P 2,000,000 200,000 2,200,000 P 2,900,000 2024 P 200,000 400,000 800,000 P 1,400,000 2,500,000 2,500,000 P 3,900,000 P 300,000 200,000 P 500,000 600,000 600,000 P 1,100,000 P 2,000,000 800,000 2,800,000 P 3,900,000 ASSETS Current Assets Cash A/R Merch. Invty. Total Current Assets Non-Current Assets PPE Total Non-Current Assets TOTAL ASSETS LIABILITIES & SE Current Liabilities Accounts Payable Accrued Expenses Total Current Liabilities Long-Term Liabilities Loans payable Total Long-Term Liabilities TOTAL LIABILITIES STOCKHOLDER'S EQUITY Common Stock Retained Earnings Total Stockholder's Equity TOTAL LIABILITIES & SE 2020 Requirement: Trend Ratios: ABC Corporation Balance Sheet For the Year Ended December 31, 2020-2024 2021 2022 2023 2024 ASSETS Current Assets Cash A/R Merch. Invty. Total Current Assets Non-Current Assets PPE Total Non-Current Assets TOTAL ASSETS LIABILITIES & SE Current Liabilities Accounts Payable Accrued Expenses Total Current Liabilities Long-Term Liabilities Loans payable Total Long-Term Liabilities TOTAL LIABILITIES STOCKHOLDER'S EQUITY Common Stock Retained Earnings Total Stockholder's Equity TOTAL LIABILITIES & SE 2020 ABC Corporation Income Statement For the Year Ended December 31, 2020-2024 2021 2022 Requirement: Common Size Balance Sheet 2023 2024 Retained Earnings Total Stockholder's Equity TOTAL LIABILITIES & SE 150,000 1,950,000 140,000 2,140,000 P 2,200,000 P 2,420,000 160,000 2,160,000 P 2,620,000 1. Compute Measures of Profitability from 2020-2024 Additional Information: a. par Value P 200 per share b. Market Price per share P 205 Year 2020, P 210 Year 2021, P 212 Year 2022, P 215 Year 2023, P 216 Year 2024 c. Dividend Payment 1. Year 2020 30,000 2. Year 2021 50,000 60,000 3. Year 2022 4. Year 2023 70,000 5. Year 2024 80,000 2. Compute Measures of Liquidity from 2020-2024 *All sales on account ** All purchases on account 200,000 2,200,000 P 2,900,000 800,000 2,800,000 P 3,900,000 Sales SRA SD Net Sales Cost of Sales Gross Profit Operating Expenses Marketing Expenses Gen, & Adm Expenses Total Operating Expenses Net Income ASSETS Current Assets Cash A/R Merch. Invty. Total Current Assets Non-Current Assets PPE Total Non-Current Assets TOTAL ASSETS LIABILITIES & SE Current Liabilities Accounts Payable Accrued Expenses Total Current Liabilities Long-Term Liabilities Loans payable Total Long-Term Liabilities TOTAL LIABILITIES STOCKHOLDER'S EQUITY Common Stock 2020 P 200,000 2,000 3.000 P 195,000 130,000 P 65.000 5,000 20,000 25,000 P 40,000 2020 ABC Corporation Income Statement For the Year Ended December 31, 2020-2024 2021 P 400,000 4,000 3.000 1.600.000 1,600,000 P 2,200,000 P 393,000 150,000 P 243,000 P 70,000 30,000 P 100.000 60,000 40,000 100,000 P 143,000 P 60,000 120,000 420,000 P 50,000 150,000 520,000 P 600,000 P 720.000 1.700.000 1,700,000 P. 2,420,000 P ABC Corporation Balance Sheet 60,000 20,000 P 80.000 For the Year Ended December 31, 2020-2024 2021 2022 2022 P 650,000 6,000 4,000 P 640,000 280,000 P 360,000 150,000 150,000 200.000 200,000 P 250,000 P 280,000 70,000 50,000 P 1,800,000 P 2,000,000 120,000 P 240,000 1,800,000 1,800,000 P 2,620,000 P 100,000 60,000 P 160,000 2023 P 700,000 8,000 6.000 300.000 300,000 P 460.000 P 686,000 350,000 P336.000 P 80,000 160,000 580,000 P 100,000 200,000 600,000 P 820.000 P 900.000 P 2,000,000 80,000 100,000 180,000 P 156,000 2023 2,000,000 2,000,000 P 2,900,000 P 200,000 100,000 P 300.000 400,000 400,000 P 700,000 P 2,000,000 2024 P 800,000 10,000 15,000 P 775,000 420,000 P 355.000 100,000 90,000 190,000 P 165,000 2024 P 200,000 400,000 800,000 P 1.400.000 2.500.000 2,500,000 P 3,900,000 P 300,000 200,000 P 500,000 600,000 600,000 P 1,100,000 P 2,000,000
Expert Answer:
Answer rating: 100% (QA)
Based on the provided financial statements and additional information you want to compute measures of profitability and liquidity for ABC Corporation ... View the full answer
Related Book For
Financial Statement Analysis and Security Valuation
ISBN: 978-0078025310
5th edition
Authors: Stephen Penman
Posted Date:
Students also viewed these accounting questions
-
The following cash data for the year ended December 31 were adapted from a recent annual report of Alphabet (GOOG), formerly known as Google. The cash balance as of January 1 was $18,347 (in...
-
The following cash data for the year ended December 31 were adapted from a recent annual report of Alphabet (GOOG), formerly known as Google. The cash balance as of January 1 was $12,918 (in...
-
The following data relate to inventory for the year ended December 31, 2009. A physical inventory on December 31, 2009, indicates that 600 units are on hand and that they came from the July 1...
-
Now apply one of those decision making models (Philosophical) to this scenario: Scenario: You are a CPA in the accounting department at a HealthCare System with three other accountants. You are good...
-
Explain relationships between real and intellectual property.
-
What marketing research facts led Allstate to review its advertising and marketing strategies with respect to the motorcycle market?
-
How to draft a pretrial memorandum?
-
Assume that the demand for cosmetic or plastic surgery is price inelastic. Are the following statements true or false? Explain. a. When the price of plastic surgery increases, the number of...
-
When creating a decision tree to determine which ERP software system to investing, what questions or factors would you identify in tree besides business size and budget ?
-
Assume today is t=0. A 10-year fixed rate bond with a 5% coupon rate is selling at par (annual coupons). From $200 FV of this bond, we form a floater and an inverse floater by equally splitting its...
-
If a square capacitor has side 6cm and the distance between the plates is 0.15mm, what is the charge on the capacitor when the voltage across it is 15V? What is the internal energy of this capacitor?
-
The second of the two steps in building the sequence diagram is to (a) define how the system uses the problem domain resources (b) define how the actor uses the system resources (c) define how the...
-
Suppose that you are designing a computer-based system that plays a multiplayer game online. Which UML diagrams you will choose to design the system? Why?
-
What is the notation for a composite state?
-
Which diagrams depict the static nature of a system?
-
What are the elements of activity diagrams?
-
Kiki is a manager of a small boutique gift store. She only has two employees, Tim and Sandra. Tim is a part-time student and is happy with the amount of work he has at the store. Sandra works...
-
A non-charmed baryon has strangeness S = 2 and electric charge Q = 0. What are the possible values of its isospin I and of its third component I z ? What is it usually called if I = 1/2?
-
In 2007, an employee was granted 305 options on the stock of a firm with an exercise price of $20 per option. In 2012, after the options had vested and when the stock was trading at $35 per share,...
-
The following are earnings and dividend forecasts made at the end of 2012 for a firm with $20.00 book value per common share at that time. The firm has a required equity return of 10 percent per...
-
An analyst presents you with the following pro forma (in millions of dollars) that gives her forecast of earnings and dividends for 2013-2017. She asks you to value the 1,380 million shares...
-
You are the senior partner of a large, local audit firm. In reviewing the work of a junior staff member on a compilation engagement for Greasemonkey's Delight Inc., a local autoparts store (in which...
-
You have been assigned to audit the accounts payable of Slamtastic, a small recording company specializing in alternative music. Following is a portion of their accounts payable journal for the month...
-
The chapter discussed three issues to consider when obtaining evidence using a sample-based audit procedure: a. The number of transactions or items to examine b. The actual transactions or items to...
Study smarter with the SolutionInn App