In this assignment you will use the Income Statement and Balance Sheet information of Triple B...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
In this assignment you will use the Income Statement and Balance Sheet information of Triple B Company to meet the following requirements: Part 1: Use the worksheet titled Horizontal Analysis to create a horizontal analysis of the Assets section of the Balance Sheet using 2020 as the analysis year. You must use formulas with cell references for all calculations in the yellow cells. Part 2: Use the worksheet titled Vertical Analysis to create a vertical analysis of the Income Statement for 2020. You must use formulas with cell references for all calculations in the yellow cells. Part 3: Use the data provided in the "Income statement" and "Balance Sheet" worksheets for 2020 to complete the required ratios in the worksheet titled "Ratio Analysis". You must use formulas with cell references for all calculations in yellow cells. All final answers should be rounded to three decimal places. Part 4: Use the data provided in the "Income Statement" and "Balance Sheet" worksheets to prepare the Operating Activities Section of the Statement of Cash Flows in the worksheet titled "Op. Act Stmt of Cash Flows". There is no additional information. For the blue shaded cells please select the appropriate line item from the drop-down list. You must use formulas and/or cell references for yellow cells. A 1 2 3 4 5 6 7 8 Revenue: 9 Sales Revenue (net) 10 less: Cost of Goods Sold 11 Gross Profit 12 less Operating expenses (excluding depreciation): 13 less: Depreciation 14 less: General and administrative 15 Add: Gain on sale of equipment 16 less: Income tax expense 17 Net Income F18 19 20 21 22 23 24 B Years Ended December 31, 2020 CONSOLIDATED INCOME STATEMENT Triple B Company $1,085,000 605,000 480,000 252,000 90,000 109,620 12,000 31,250 $9,130 C G6 6000 SAWNH x ✓ fx 6 7 8 Assets 7 9 Current assets: 10 Cash and cash equivalents. 11 Accounts receivable 12 Inventory 13 Prepaid expenses 14 Total current assets 15 Property and equipment, net 16 Total assets 17 Liabilities and Stockholders' Equity 18 Current liabilities: 19 Accounts payable 20 Accrued liabilities 21 Total current liabilities 22 Long-term Notes Payable 23 Total liabilities 24 Stockholders' equity: 25 Common stock, par value 26 Additional paid-in capital 27 Retained Earnings 28 Total stockholders' equity 29 Total liabilities and stockholders' equity 30 31 32 33 34 35 35 36 36 37 38 38 39 40 41 42 43 A CONSOLIDATED BALANCE SHEETS Triple B $ $ $ $ B 31-Dec-20 123,450 77,100 240,600 15,100 456,250 151,500 607,750 17,750 6,500 24,250 115,000 139,250 220,000 30,000 218,500 468,500 607,750 с D 31-Dec-19 $ 87,550 80,750 250,700 17,000 436,000 105,000 541,000 102,000 8,000 110,000 67500 177,500 154,130 0 209,370 363,500 $ 541,000 $ $ E F G H I р 1. L23456 ot 9 F 1 7 8 Assets 9 Current assets: 10 Cash and cash equivalents 11 Accounts receivable 12 Inventory 13 Prepaid expenses and other current assets 14 Total current assets 15 Property and equipment, net 16 Total assets 17 18 19 20 21 22 23 S 24 21 25 26 A $ $ B C Partial BALANCE SHEETS Horizontal Analysis 31-Dec-20 123,450 77,100 240,600 15,100 456,250 151,500 607,750 D 31-Dec-19 $ 87,550 80,750 250,700 17,000 436,000 105,000 $ 541,000 E F Dollar change G Percent change H | 1 2 3 4 5 6 Revenue: 7 Sales Revenue 8 less: Cost of Goods Sold 9 Gross Profit 10 less Operating expenses (excluding depreciation): 11 less: Depreciation 12 less: General and administrative expenses 13 Add: Gain on sale of equipment 14 less: Income tax expense 15 Net Income 16 17 18 19 20 21 22 23 S 24 р 1. ot 9 F A NE CONSOLIDATED INCOME STATEMENT Vertical Analysis Years Ended December 31, 2020 B C D up n. ot 29 F A 1 Ratio Analysis 2 3 Current Ratio 4 A/R Turnover 5 Days' sales in inventory 6 7 8 9 10 11 12 13 14 15 B C Profit Margin Return on Total Assets Asset Turnover D E F A 1 STATEMENT OF CASH FLOWS OPERATING ACTIVITIES: 2 3 Net Income 4 Adjustments to reconcile net income to net cash provided by operating activities 5 Income statement items not affecting cash 6 Depreciation 7 Gain on sale of equipment 8 Changes in current assets and liabilities hip 9 Decrease in Accounts Receivable on. 10 Decrease in Inventory 11 Decrease in Prepaid Expenses 12 Decrease in Accounts Payable - 13 Decrease in Other Payable 14 Net cash provided by operating activities 15 hot 16 29 F 17 18 19 20 21 22 23 S$ 30 B In this assignment you will use the Income Statement and Balance Sheet information of Triple B Company to meet the following requirements: Part 1: Use the worksheet titled Horizontal Analysis to create a horizontal analysis of the Assets section of the Balance Sheet using 2020 as the analysis year. You must use formulas with cell references for all calculations in the yellow cells. Part 2: Use the worksheet titled Vertical Analysis to create a vertical analysis of the Income Statement for 2020. You must use formulas with cell references for all calculations in the yellow cells. Part 3: Use the data provided in the "Income statement" and "Balance Sheet" worksheets for 2020 to complete the required ratios in the worksheet titled "Ratio Analysis". You must use formulas with cell references for all calculations in yellow cells. All final answers should be rounded to three decimal places. Part 4: Use the data provided in the "Income Statement" and "Balance Sheet" worksheets to prepare the Operating Activities Section of the Statement of Cash Flows in the worksheet titled "Op. Act Stmt of Cash Flows". There is no additional information. For the blue shaded cells please select the appropriate line item from the drop-down list. You must use formulas and/or cell references for yellow cells. A 1 2 3 4 5 6 7 8 Revenue: 9 Sales Revenue (net) 10 less: Cost of Goods Sold 11 Gross Profit 12 less Operating expenses (excluding depreciation): 13 less: Depreciation 14 less: General and administrative 15 Add: Gain on sale of equipment 16 less: Income tax expense 17 Net Income F18 19 20 21 22 23 24 B Years Ended December 31, 2020 CONSOLIDATED INCOME STATEMENT Triple B Company $1,085,000 605,000 480,000 252,000 90,000 109,620 12,000 31,250 $9,130 C G6 6000 SAWNH x ✓ fx 6 7 8 Assets 7 9 Current assets: 10 Cash and cash equivalents. 11 Accounts receivable 12 Inventory 13 Prepaid expenses 14 Total current assets 15 Property and equipment, net 16 Total assets 17 Liabilities and Stockholders' Equity 18 Current liabilities: 19 Accounts payable 20 Accrued liabilities 21 Total current liabilities 22 Long-term Notes Payable 23 Total liabilities 24 Stockholders' equity: 25 Common stock, par value 26 Additional paid-in capital 27 Retained Earnings 28 Total stockholders' equity 29 Total liabilities and stockholders' equity 30 31 32 33 34 35 35 36 36 37 38 38 39 40 41 42 43 A CONSOLIDATED BALANCE SHEETS Triple B $ $ $ $ B 31-Dec-20 123,450 77,100 240,600 15,100 456,250 151,500 607,750 17,750 6,500 24,250 115,000 139,250 220,000 30,000 218,500 468,500 607,750 с D 31-Dec-19 $ 87,550 80,750 250,700 17,000 436,000 105,000 541,000 102,000 8,000 110,000 67500 177,500 154,130 0 209,370 363,500 $ 541,000 $ $ E F G H I р 1. L23456 ot 9 F 1 7 8 Assets 9 Current assets: 10 Cash and cash equivalents 11 Accounts receivable 12 Inventory 13 Prepaid expenses and other current assets 14 Total current assets 15 Property and equipment, net 16 Total assets 17 18 19 20 21 22 23 S 24 21 25 26 A $ $ B C Partial BALANCE SHEETS Horizontal Analysis 31-Dec-20 123,450 77,100 240,600 15,100 456,250 151,500 607,750 D 31-Dec-19 $ 87,550 80,750 250,700 17,000 436,000 105,000 $ 541,000 E F Dollar change G Percent change H | 1 2 3 4 5 6 Revenue: 7 Sales Revenue 8 less: Cost of Goods Sold 9 Gross Profit 10 less Operating expenses (excluding depreciation): 11 less: Depreciation 12 less: General and administrative expenses 13 Add: Gain on sale of equipment 14 less: Income tax expense 15 Net Income 16 17 18 19 20 21 22 23 S 24 р 1. ot 9 F A NE CONSOLIDATED INCOME STATEMENT Vertical Analysis Years Ended December 31, 2020 B C D up n. ot 29 F A 1 Ratio Analysis 2 3 Current Ratio 4 A/R Turnover 5 Days' sales in inventory 6 7 8 9 10 11 12 13 14 15 B C Profit Margin Return on Total Assets Asset Turnover D E F A 1 STATEMENT OF CASH FLOWS OPERATING ACTIVITIES: 2 3 Net Income 4 Adjustments to reconcile net income to net cash provided by operating activities 5 Income statement items not affecting cash 6 Depreciation 7 Gain on sale of equipment 8 Changes in current assets and liabilities hip 9 Decrease in Accounts Receivable on. 10 Decrease in Inventory 11 Decrease in Prepaid Expenses 12 Decrease in Accounts Payable - 13 Decrease in Other Payable 14 Net cash provided by operating activities 15 hot 16 29 F 17 18 19 20 21 22 23 S$ 30 B
Expert Answer:
Related Book For
Understanding financial statements
ISBN: 978-0136086246
9th Edition
Authors: Lyn M. Fraser, Aileen Ormiston
Posted Date:
Students also viewed these general management questions
-
The following income statement and balance sheet information are available for two firms, Firm A and Firm B. (a) Calculate the amount of dividends Firm A and Firm B paid using the information given....
-
Use the income statement and balance sheet for Wal-Mart (see Appendix A) to gather the necessary information to calculate Wal-Marts Economic Value Added (EVA) for 2009 and 2008. Wal-Marts weighted...
-
Use the following income statement and balance sheet information to put together a statement of cash flows. 2013 Assets 2012 S25,000 $21,990 2013 Sales S1,230,000 Cash Accounts receivable Cost of...
-
Researchers investigated the relationship between the number of involuntary admissions (detentions) for mental disorders a year under the Mental Health Act 1983 and the number of NHS psychiatric beds...
-
Study Appendix 16A. Hamlin Toy Company prepared financial statements using U.S. GAAP. It uses cost or market, whichever is lower, for its inventories. There were no sales or purchases during the...
-
While working on your homework for this course and surfing the Internet to check out all the fascinating links, you realize the person who manages the branch of the new durable medical equipment...
-
The use of chlorofluoro carbon refrigerants is banned because these react with (a) water vapours and cause acid rain (b) plants and cause green house effect (c) oxygen and cause its depletion (d)...
-
The balance sheet debit column of the worksheet for Mrotet Company includes the following accounts: Accounts Receivable $12,500, Prepaid Insurance $3,600, Cash $4,100, Supplies $5,200, and Debt...
-
Do you think that it would be more difficult to lead a non-profit group of employees versus a traditional organization? Why and why not? What type of leadership styles, skills, and qualities are...
-
A compound has a molecular formula of C8H14O4, and its infrared spectrum contains an intense peak at 1730 cm -1. The 1H NMR spectrum of the compound is shown in Figure 20.11. What is its structure?...
-
Assess different perspectives, theories, and models in operations and supply chain management.
-
Covered interest rate arbitrage. As a trader for the London-based money market Commonwealth Fund, you see the following quotes: a. From Barclays Bank, one-year sterling deposits/loans at 6. 0 percent...
-
Covered interest rate arbitrage with withholding tax. On September 1, 2013, the treasurer of Volvo, the Swedish automotive manufacturer, is faced with the following investment dilemma: he could...
-
BSI has sold to Cambodias Angkor Wat Entertainment Inc.(CAWE) INR 10 million licensing rights to 10 of its recent films. Payment is due in six months. BSI can simply finance its exports by drawing on...
-
Carry trade at a macro hedge fund. Ms. Ivanhoe is the chief strategist of Caran dAchethe Fribourg-based (Switzerland) macro hedge fund. Newly issued oneyear Greek government zero-coupon (Z) bonds...
-
On November 28, 2012, MegaFonthe Russian telecom companyraised 1 billion on the London Stock Exchange. The controversial Uzbeck oligarch Alisher Usmanov owns 55. 8 percent of MegaFon, which is the...
-
. Assume the following function definition exists, where even returns true if an integer is even otherwise returns false nmap f [] [] nmap f (x:xs ) = (f x ): (nmap f xs ) What is the output of the...
-
Calculate I, , and a for a 0.0175 m solution of Na 3 PO 4 at 298 K. Assume complete dissociation. How confident are you that your calculated results will agree with experimental results?
-
What do liquidity ratios measure? Activity ratios? Leverage ratios? Profitability ratios? Market ratios?
-
The 2007 Intel Annual Report can be found at the following Web site: www .prenhall.com/fraser. Using the annual report, answer the following questions: (a) Prepare a common-size balance sheet for...
-
Using the information below for Dean Corporation, calculate the amount of dividends Dean most likely paid to common stockholders in 2008, 2009, and 2010. Retained earnings Net Year balances income...
-
How the duration of a sprint can be decided?
-
Variants and exception handlers are alternate flows for a use case. In which situations should one or the other be used?
-
Why estimating software development effort is so difficult? What are the obstacles?
Study smarter with the SolutionInn App