Financial Statements from a company are shown below. INCOME STATEMENT Sales Cost of Good Sold GROSS...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Financial Statements from a company are shown below. INCOME STATEMENT Sales Cost of Good Sold GROSS PROFIT Operating Expenses EBITDA Depreciation Expenses EBIT Interest Expense EBT Tax EAT/NI 2016 2017 716.000 145.000 571.000 121.000 450.000 20.000 25.000 420.000 425.000 55.000 60.000 365.000 365.000 36.000 36.000 329.000 329.000 700.000 140.000 560.000 120.000 440.000 ASSET Current Asset Cash Account Receivable Inventory TOTALASSET Net Income Depreciation Expenses BALANCE SHEET 2016 420.000 530.000 200.000 Fix Asset 950.000 Accumulation Depreciation (100.000) (125.000) Inventory Account Payable Accrued Wages Net Cash Flow From Operation 2017 LIABILITY & EQUITY LIABILITIES CASH FLOW FROM OPERATING ACTIVITIES Account Receivable 299.000 Current Liabilities 645.000 Account Payable 450.000 Accrued Wages 2.000.000 2.244.000 STATEMENT OF CASH FLOW 975.000 Long Term Liabilities 329.000 25.000 EQUITY Owner's Equity Retaid Earnings TOTAL LIABILITY & EQUITY (115.000) (250.000) (65.000) 2017 354.000 (430.000) 2016 245.000 65.000 300.000 2017 180.000 65.000 280.000 450.000 450.000 940.000 1.269.000 2.000.000 2.244.000 CASH FLOW FROM INVESTING ACTIVITIES Fix Asset Net Cash Flow From Investing Activities CASH FLOW FROM FINANCING ACTIVITIES Long Term Liabilities Net Cash Flow From Financing Activities Net change excluding cash account Beginning cash Ending cash (25.000) (20.000) (25.000) (20.000) (121.000) 420.000 299.000 1. Using data shown above, calculate: liquidity, leverage, profitability, and efficiency ratios from that company. 2. Analyse that company financial condition. 3. Organize your answers using available excel functions. Financial Statements from a company are shown below. INCOME STATEMENT Sales Cost of Good Sold GROSS PROFIT Operating Expenses EBITDA Depreciation Expenses EBIT Interest Expense EBT Tax EAT/NI 2016 2017 716.000 145.000 571.000 121.000 450.000 20.000 25.000 420.000 425.000 55.000 60.000 365.000 365.000 36.000 36.000 329.000 329.000 700.000 140.000 560.000 120.000 440.000 ASSET Current Asset Cash Account Receivable Inventory TOTALASSET Net Income Depreciation Expenses BALANCE SHEET 2016 420.000 530.000 200.000 Fix Asset 950.000 Accumulation Depreciation (100.000) (125.000) Inventory Account Payable Accrued Wages Net Cash Flow From Operation 2017 LIABILITY & EQUITY LIABILITIES CASH FLOW FROM OPERATING ACTIVITIES Account Receivable 299.000 Current Liabilities 645.000 Account Payable 450.000 Accrued Wages 2.000.000 2.244.000 STATEMENT OF CASH FLOW 975.000 Long Term Liabilities 329.000 25.000 EQUITY Owner's Equity Retaid Earnings TOTAL LIABILITY & EQUITY (115.000) (250.000) (65.000) 2017 354.000 (430.000) 2016 245.000 65.000 300.000 2017 180.000 65.000 280.000 450.000 450.000 940.000 1.269.000 2.000.000 2.244.000 CASH FLOW FROM INVESTING ACTIVITIES Fix Asset Net Cash Flow From Investing Activities CASH FLOW FROM FINANCING ACTIVITIES Long Term Liabilities Net Cash Flow From Financing Activities Net change excluding cash account Beginning cash Ending cash (25.000) (20.000) (25.000) (20.000) (121.000) 420.000 299.000 1. Using data shown above, calculate: liquidity, leverage, profitability, and efficiency ratios from that company. 2. Analyse that company financial condition. 3. Organize your answers using available excel functions.
Expert Answer:
Answer rating: 100% (QA)
Okay here are the calculations with workings shown Income Statement for 2020 in USD Sales 100000 Cos... View the full answer
Related Book For
College Accounting Chapters 1-30
ISBN: 978-1259631115
15th edition
Authors: John Price, M. David Haddock, Michael Farina
Posted Date:
Students also viewed these accounting questions
-
Below you will find the condensed financial statements for Best Inc. and Good Inc. for 2019. INSTRUCTIONS 1. Compute the following ratios for each company: a. Rate of return on net sales b. Rate of...
-
Many areas have attempted to increase the amount of recycled waste lubricating oil by requiring service stations to serve as collection centers or by instituting deposit-refund systems. On what...
-
Determine the following for a q-curve with parameters = 6 and = 13. a. The q-value having area 0.05 to its right b. q0.01
-
Solve for y in terms of t or x, as appropriate. ln (y - b) = 5t
-
Design Data sold a piece of machinery to HHB Drafting Company. However, after HHB had taken possession of the machine, it discovered damage and revoked the contract. The court found that the...
-
Trophy Fish Company supplies flies and fishing gear to sporting goods stores and outfitters throughout the western United States. The accounts receivable clerk for Trophy Fish prepared the following...
-
Explain the effect of inflation on UK, Canada, US, Switzerland, China, South Africa, Australia Comparison should be based on house prices, food price, gasoline, energy and so on. I need proper...
-
Complete Form 941 for the 4th quarter for TCLH Industries (which is located at 202 Whitmore Avenue, Durham, NC 27701; Employer Identification #44-4444444). Assume that all necessary deposits were...
-
State two specific functions or jobs that should be segregated in the sales order processing system. 2. What specific internal control procedure would prevent the sale of goods on account to a...
-
The American Association of Individual Investors (AAII) has identified several qualitative factors that should also be considered when evaluating a companys likely future financial performance....
-
Questions: Which strategy has your company followed? Apply the concepts on strategy development to analyze and explain the rationale for your decision. This includes whether or not it has been...
-
Commissioner Roisman has highlighted many issues that are relevant when mandating ESG related disclosures by companies. Why are the issues highlighted by Commissioner Roisman important to you as an...
-
what is the benefits and drawbacks of the different reporting lines of the Compliance Officer, as described in Eagaen's "Designating a Compliance Officer and Committee."
-
The store had sales of $1,450,000.00 for the Spring Season? The markdowns for the Spring Season totaled $230,000.00. What is the markdown percent for the Spring Season? The store bought 400 skirts...
-
The coefficients of friction between the load and the flatbed trailer shown are s = 0.40 and k = 0.30. Knowing that the speed of the rig is 72 km/h, determine the shortest distance in which the rig...
-
Suppose the market is semistrong form efficient. Can you expect to earn excess returns if you make trades based on? a. Your brokers information about record earnings for a stock? b. Rumors about a...
-
Wilson Leather Products sells leather clothing at both wholesale and retail. The company has found that there is a higher rate of uncollectible accounts from retail credit sales than from wholesale...
-
Will the amount shown as a departments ending inventory of work in process on the cost of production report agree with the work in process for the department in the general ledger after adjusting and...
-
What is the purpose of the minute book?
-
The business staff of the law firm Frampton, Davis & Smythe has constructed the following report that breaks down the firms overall results for last month into two business segmentsfamily law and...
-
The Excel worksheet form that appears below is to be used to recreate portions of Review Problem 1 relating to Dexter Corporation. Download the workbook containing this form from Connect, where you...
-
Millard Corporation is a wholesale distributor of office products. It purchases office products from manufacturers and distributes them in the West, Central, and East regions. Each of these regions...
Study smarter with the SolutionInn App