Revenue Cost of Revenue, Total Gross Profit Selling/General/Admin. Expenses, Total Depreciation/Amortization Unusual Expense (Income) Operating Income...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Revenue Cost of Revenue, Total Gross Profit Selling/General/Admin. Expenses, Total Depreciation/Amortization Unusual Expense (Income) Operating Income Gain (Loss) on Sale of Assets Income Before Tax Income After Tax Cash & Equivalents Short Term Investments Total Receivables, Net Other Current Assets, Total Total Current Assets Long Term Investments Other Long Term Assets, Total Total Assets The Assignment 2 Company Income Statement For the Years 2016 to 2019 Property/Plant/Equipment, Total - Gross Accumulated Depreciation, Total Long-Term Note Receivable Goodwill, Net Intangibles, Net Accounts Payable Accrued Expenses Notes Payable/Short Term Debt Other Current liabilities, Total Total Current Liabilities Total Debt Deferred Income Tax Other Liabilities, Total Total Liabilities 30-Jun-19 11667.8 6628.7 5039.1 2637 Total Equity Total Liabilities & Shareholders' Equity Total Common Shares Outstanding 211.6 -29.1 2219.6 13.9 2233.5 1493.4 The Assignment 2 Company Balance Sheet For the Years Ending June 30 2016 to 2019 30-Jun-19 30-Jun-18 3191.1 23.5 1742.8 34543 39500.4 1840.8 -1155.8 27.1 1682 534.2 7.8 1233.5 43670 152.3 1863.5 0 33831.6 35847.4 2007.7 251.1 1082.2 39188.4 4481.6 43670 455.7 30-Jun-18 10938.5 6220.7 4717.8 2496.9 206.9 -1.4 2015.4 0 2015.4 1376.5 Task Copy the Income Statement and paste it into a new worksheet. Reformat the data so that it is more readable, add any titles required, and insert formulas in place of the numbers where possible (ignoring any Income tax formulas--- leave any tax amounts as numbers). Copy the Balance Sheet and paste it into an area below the Income Statement. Reformat the data so that it is more readable, add any titles required, and insert formulas in place of the numbers where possible (leave any Retained Earnings (or Deficit) amounts in the Equity section as numbers). On a new worksheet, using the years of information you have, create a common-size income statement. Link all the formulas to the income statement worksheet, and ensure formatting and titles are appropriate. On the original income statement and balance sheet worksheet, choose any three financial ratios from our textbook's chapter 3. Using cell referencing, calculate these three ratios for the three most recent years of information you have. Place these ratio's names and calculations in a space to the right of the Income Statement, with applicable titles, formatting and column headers. Again to the right of these ratio calculations, for each ratio, add a brief summary of the performance over the years and what it may indicate about the company (if anything). 1639.3 26.6 1546.9 25596.4 28809.2 1776.4 -1103.7 32.2 1793.5 503.2 28.9 1270.8 33110.5 194.5 1786.5 0 25132.7 27113.7 9.2 172.1 1007 28302 4808.5 33110.5 466.4 30-Jun-17 10226.4 5842 4384.4 2370.3 199 0 1815.1 0 1815.1 1242.6 30-Jun-17 1584 2032.2 1498.8 22378 27493 1718.7 -1051.6 155.4 1883.5 491 54.1 1315.7 32059.8 152.1 1793.9 2173 20048.6 24167.6 2184.5 215.9 994.6 25389.6 6670.2 32059.8 480.2 What I'm looking for Use of Excel formatting, cell referencing anywhere there'd be a calculation within the statement. 30-Jun-16 9442 5380.2 4061.8 2200.4 193.9 42.7 1624.8 2.9 1627.7 1122.2 Use of Excel formatting, cell referencing anywhere there'd be a calculation within the statement. Using "time-effective" cell referencing to have created all the formulas. Appropriate titles/formatting. Am I going to know what ratio is calculated? Am I going to know for what years? Was it calculated correctly? 30-Jun-16 1699.1 I will manually change a ratio value...your "result" should change accordingly... 28 1595.3 22892.1 26214.5 2040.7 -1312.1 138.7 3039.2 643.2 314 1189.9 32268.1 156.5 1809.6 0 22766.7 24732.8 14.7 234.4 1096.3 26078.2 6189.9 32268.1 482.6 Revenue Cost of Revenue, Total Gross Profit Selling/General/Admin. Expenses, Total Depreciation/Amortization Unusual Expense (Income) Operating Income Gain (Loss) on Sale of Assets Income Before Tax Income After Tax Cash & Equivalents Short Term Investments Total Receivables, Net Other Current Assets, Total Total Current Assets Long Term Investments Other Long Term Assets, Total Total Assets The Assignment 2 Company Income Statement For the Years 2016 to 2019 Property/Plant/Equipment, Total - Gross Accumulated Depreciation, Total Long-Term Note Receivable Goodwill, Net Intangibles, Net Accounts Payable Accrued Expenses Notes Payable/Short Term Debt Other Current liabilities, Total Total Current Liabilities Total Debt Deferred Income Tax Other Liabilities, Total Total Liabilities 30-Jun-19 11667.8 6628.7 5039.1 2637 Total Equity Total Liabilities & Shareholders' Equity Total Common Shares Outstanding 211.6 -29.1 2219.6 13.9 2233.5 1493.4 The Assignment 2 Company Balance Sheet For the Years Ending June 30 2016 to 2019 30-Jun-19 30-Jun-18 3191.1 23.5 1742.8 34543 39500.4 1840.8 -1155.8 27.1 1682 534.2 7.8 1233.5 43670 152.3 1863.5 0 33831.6 35847.4 2007.7 251.1 1082.2 39188.4 4481.6 43670 455.7 30-Jun-18 10938.5 6220.7 4717.8 2496.9 206.9 -1.4 2015.4 0 2015.4 1376.5 Task Copy the Income Statement and paste it into a new worksheet. Reformat the data so that it is more readable, add any titles required, and insert formulas in place of the numbers where possible (ignoring any Income tax formulas--- leave any tax amounts as numbers). Copy the Balance Sheet and paste it into an area below the Income Statement. Reformat the data so that it is more readable, add any titles required, and insert formulas in place of the numbers where possible (leave any Retained Earnings (or Deficit) amounts in the Equity section as numbers). On a new worksheet, using the years of information you have, create a common-size income statement. Link all the formulas to the income statement worksheet, and ensure formatting and titles are appropriate. On the original income statement and balance sheet worksheet, choose any three financial ratios from our textbook's chapter 3. Using cell referencing, calculate these three ratios for the three most recent years of information you have. Place these ratio's names and calculations in a space to the right of the Income Statement, with applicable titles, formatting and column headers. Again to the right of these ratio calculations, for each ratio, add a brief summary of the performance over the years and what it may indicate about the company (if anything). 1639.3 26.6 1546.9 25596.4 28809.2 1776.4 -1103.7 32.2 1793.5 503.2 28.9 1270.8 33110.5 194.5 1786.5 0 25132.7 27113.7 9.2 172.1 1007 28302 4808.5 33110.5 466.4 30-Jun-17 10226.4 5842 4384.4 2370.3 199 0 1815.1 0 1815.1 1242.6 30-Jun-17 1584 2032.2 1498.8 22378 27493 1718.7 -1051.6 155.4 1883.5 491 54.1 1315.7 32059.8 152.1 1793.9 2173 20048.6 24167.6 2184.5 215.9 994.6 25389.6 6670.2 32059.8 480.2 What I'm looking for Use of Excel formatting, cell referencing anywhere there'd be a calculation within the statement. 30-Jun-16 9442 5380.2 4061.8 2200.4 193.9 42.7 1624.8 2.9 1627.7 1122.2 Use of Excel formatting, cell referencing anywhere there'd be a calculation within the statement. Using "time-effective" cell referencing to have created all the formulas. Appropriate titles/formatting. Am I going to know what ratio is calculated? Am I going to know for what years? Was it calculated correctly? 30-Jun-16 1699.1 I will manually change a ratio value...your "result" should change accordingly... 28 1595.3 22892.1 26214.5 2040.7 -1312.1 138.7 3039.2 643.2 314 1189.9 32268.1 156.5 1809.6 0 22766.7 24732.8 14.7 234.4 1096.3 26078.2 6189.9 32268.1 482.6
Expert Answer:
Answer rating: 100% (QA)
Income Statement Year Revenue Cost of Revenue Gross Profit Selling General Admin Expenses Depreciati... View the full answer
Related Book For
Horngrens Accounting
ISBN: 978-0133855371
10th Canadian edition Volume 1
Authors: Tracie L. Miller-Nobles, Brenda L. Mattison, Ella Mae Matsumura, Carol A. Meissner, Jo-Ann L. Johnston, Peter R. Norwood
Posted Date:
Students also viewed these accounting questions
-
Suppose Quik Trip Stores' comparative income statement for two years included these items (dollars in thousands): _________________ ____ ____________________2017 2016 Net...
-
Identify the errors in the following income statement: Curbstone Company Income Statement For the Year Ended August 31, 2019 $8,595,000 6,110,000 $2,485,000 Inc xnlk: 0111 psations Expenses 1xlivery...
-
Refer to the information in Problem 12-7A. Problem 12-7 LANSING COMPANY Income Statement For Year Ended December 31, 2013 Sales revenue . . . . . . . . . . . . . . . . . . $97,200 Expenses Cost of...
-
For the data in Problem 1, what is the differential return if beta is the appropriate measure of risk? In Problem 1 Fund Return Standard Deviation 14 12 16 10 20 Beta 1.5 0.5 1.0 0.5 4 LE 10
-
In a volumetric determination of an analyte A, the data obtained and their standard deviations are as follows: From the data, find the coefficient of variation of the final result for the % A that is...
-
Consider a randomized pair design with $n$ units where two treatments are randomly assigned to each unit, resulting in a pair of observations $\left(X_{i}, Y_{i} ight)$, for $i=1, \ldots, n$ on each...
-
Allowance Method of Accounting for Bad DebtsComparison of the Two Approaches Kandel Company had the following data available for 2010 (before making any adjustments): Accounts receivable, 12/31/10...
-
(a) Use the method of integrating factor to solve the equation below for y: dy dx +ycotx cos x given that when x,y=2 (b) In the circuit below, switch S is closed at 7=0, and the current at that time...
-
Eric Brown is responsible for upgrading the wireless network for his employer. He has identified seven possible locations to install new nodes for the network. Each node can provide service to...
-
Calculate gross pay for the weekly pay period, then determine taxable income used to calculate federal income tax withholding, Social Security, and Medicare tax. An employee works 48 hours (48 - 40...
-
How might the COVID-19 pandemic serve as a catalyst for reconfiguring the parameters of globalization, including shifts in global trade patterns, the reevaluation of supply chain vulnerabilities, and...
-
ABC Inc. ( " ' ABC " ) has the following capital structure with the following weights: Common Shares 6 0 % Preferred Shares 3 0 % Bond 1 0 % * Total 1 0 0 % The Total Book Value of the capital...
-
UPS, a delivery services company, has a Beta of 1.10, and Wal-Mart has a Beta of 0.70. The Risk-Free Rate of return is 4.50% and the expected return of the market portfolio is 11.50%. What is the...
-
A high proportion of young male cattle bones at an archaeological site would indicate that the cultural group was transitioning to herding cattle rather than hunting them. Explain
-
One of the typical applications of the CPM and CPP analysis is to plan budgets to buy media. The exposure needed for a campaign is estimated at 225 rating points weekly and recommended CPP is set at...
-
Which car has the larger acceleration? A) The green car B) The red car C) They are the same D) Cannot tell the difference
-
$10,000 was borrowed at 3.5% on July 17. The borrower repaid $5000 on August 12, and $2000 on September 18. What final payment is required on November 12 to fully repay the loan?
-
Suppose you are ready to invest in a small resort property. Two locations look promising: Nootka Resort in Victoria, British Columbia, and Critter Cove Resort in Nova Scotia. Each place has its...
-
Vista Distributors purchases inventory in crates of merchandise. Assume the company began July with an inventory of 30 units that cost $300 each. During the month, the company purchased and sold...
-
Define amortization. What are common misconceptions about amortization?
-
Consider an experiment that selects a cell phone camera and records the recycle time of a flash (the time taken to ready the camera for another flash). The possible values for this time depend on the...
-
Suppose that the recycle times of two cameras are recorded. The extension of the positive real line \(R\) is to take the sample space to be the positive quadrant of the plane \[ S=R^{+} \times R^{+}...
-
As in Example 2.1, camera recycle times might use the sample space \(S=R^{+}\), the set of positive real numbers. Let \[ E_{1}=\{x \mid 10 \leq x <12\} \quad \text { and } \quad E_{2}=\{x \mid 11 0\}...
Study smarter with the SolutionInn App