Question

In: Accounting

Please show your work. Liquidity Performance Analysis 1. Do a Cahs Flow Liquidity Analysis. Analyze Trends...

Please show your work.

Liquidity Performance Analysis

1. Do a Cahs Flow Liquidity Analysis.

Analyze Trends in cash flow from operations from the indirect cash flow statement, Changes in the cash balance, Changes in the days cash conversion cycle, Changes in inventory days, Accounts receivables days, & Accounts payable days - to - analyze the reasons for any changes in the cash conversion cycle.

2. Calculate the growth rate for revenues over the 2 years and the sustainable growth rate, and compare them.

3. Discuss what these trends reveal about the firm's liquidity from a cash flow perspective.

Income Statement (in thousands) 2017 2016
Total Revenue         543,660         282,354
Cost of Revenue         448,467         246,109
Gross Profit            95,193            36,245
Selling & Administrative Exp.            41,515            37,652
Depreciaiton Expense            66,221            64,343
Total Operating Expense         107,736         101,995
Operating Income or Loss         (12,543)         (65,750)
Interest & other expenses            60,126            31,447
Earnings before Tax         (72,669)         (97,197)
Tax            (4,987)          (26,286)
Net Income         (67,682)         (70,911)
Dividends Paid                     -                 2,438
Addition to Ret. Earnings          (67,682)          (73,349)
Balance Sheet 2017 2016
Cash & Equivalents            17,513              4,074
Net Accounts Receivables            99,573            62,005
Inventory            22,230            15,169
Other Current Assets              7,921              9,466
Total Current Assets         147,237            90,714
Net Property, Plant & Equip.         259,039         273,210
Goodwill & Intangible Assets         157,301         201,430
Other Assets            15,282            10,740
Total Assets         578,859         576,094
Current Liabilities
Accounts Payable            29,643            18,823
Short-term Debt         241,509         244,534
Other Current Liabilities            15,268            12,417
Total Current Liabilities         286,420         275,774
Long-term Debt              5,081            12,134
Total Liabilities         291,501         287,908
Equity
Retained Earnings          (94,081)          (26,399)
Common Stock         381,439         314,585
Total Equity         287,358         288,186
Total Liabs. & Equity         578,859         576,094

Solutions

Expert Solution

Cash flow
Net profit/Loss during the year          -72,669
(+) Depreciation            66,221
(+) Interest exp            60,126
           53,678
Changes in Current assets
Increase in Net accounts receivables          -37,568
Increase in Inventory             -7,061
Decrease in Other current asset              1,545
Changes in Current Liabilities
Increase in Net accounts Payable            10,820
Decrease in Short term debt             -3,025
Increase in Other current liabilities              2,851
Cash generated from operations            21,240
(-) Taxes paid             -4,987
Net Cash generated from operations            16,253
Investing Activity
Purchase of net property & plant & equipments          -52,050
(2,59,039+66,221(Depreci)-2,73,210)
Sale of Intangible assets            44,129
(2,01,430-1,57,301)
Purchase of Other assets             -4,542
(15,282-10,740)          -12,463
             3,790
Finance activty
Decrease in Long term debt             -7,053
Increase in shares            66,854
interest exp          -60,126
               -325
             3,465

Related Solutions

Please show the work 1. What is the total flow for a 35% venture mask set...
Please show the work 1. What is the total flow for a 35% venture mask set at 10 liters per minute at the flow meter? 2. How long will an E cylinder last if the flow rate is set at 5, and there is 1500 PSIG on the pressure gauge? 3. What is the total flow for a 50% venture mask set at 15 liters per minute at the flow meter?
Please show the detail work 1. How long will an E cylinder last if the flow...
Please show the detail work 1. How long will an E cylinder last if the flow rate is set at 2, and there is 2000 PSIG on the pressure gauge? 2. What is the total flow for a 24% venture mask set at 5 liters per minute at the flow meter? 3. How long will an H cylinder last if the flow rate is set at 15, and there is 2000 PSIG on the pressure gauge? 4. What is the...
Please show your work and do not use calculators. You need to accumulate $114,480 for your...
Please show your work and do not use calculators. You need to accumulate $114,480 for your son's education. You have decided to place equal year-end deposits in a savings account for the next 14 years. The savings account pays 6.88 percent per year, compounded annually. How much will each annual payment be? Please show your work and do not use calculators.
please don't do it by excel, do it manually and show work! 1. A manufacturing company...
please don't do it by excel, do it manually and show work! 1. A manufacturing company decides to buy solar cells in anticipation of rising electricity costs. The company is modeling its purchase to save it $20,000 for the first year, and this saving increases 5% each year for the next 20 years as the solar cells generate enough electricity to compensate for the rising power bills. If the expected rate of return for the company equals 8%, what is...
please answer to Part 1 b please show your work how to get that number and...
please answer to Part 1 b please show your work how to get that number and no hand writing plz thanks Waterways Corporation is considering various business opportunities. It wants to make the best use of its production facilities to maximize income. This problem asks you to help Waterways do incremental analysis on these various opportunities. Part 1 Waterways mass-produces a special connector unit that it normally sells for $3.90. It sells approximately 35,000 of these units each year. The...
please answer to Part 1 c please show your work how to get that number and...
please answer to Part 1 c please show your work how to get that number and no hand writing plz thanks Waterways Corporation is considering various business opportunities. It wants to make the best use of its production facilities to maximize income. This problem asks you to help Waterways do incremental analysis on these various opportunities. Part 1 Waterways mass-produces a special connector unit that it normally sells for $3.90. It sells approximately 35,000 of these units each year. The...
PLEASE SHOW YOUR WORK WITH FORMULAS. 1.At the end of the year 2017 the assets of...
PLEASE SHOW YOUR WORK WITH FORMULAS. 1.At the end of the year 2017 the assets of the company X were 400 mill EUR and equity was 300 mill EUR. At the end of the year 2018 assets in the same company   were 500 mill EUR and equity was 400 mill. The net profit in 2018 was 100 mill EUR. a)Calculate ROA and ROE for the year 2018. b)What was indebtedness in the years 2017 and 2018? c)What is the change...
Please Use Excel To Show All Work, I will like your asnwer if you do this...
Please Use Excel To Show All Work, I will like your asnwer if you do this :) 15.35 Refer to the Johnson Filtration problem introduced in this section. Suppose that in addition to information on the number of months since the machine was serviced and whether a mechanical or an electrical repair was necessary, the managers obtained a list showing which repairperson performed the service. The revised data follow. Repair Time in Hours Months Since Last Service Type of Repair...
Analyze the firm's liquidity, leverage, turnover, and profitability using ratio analysis.
Analyze the firm's liquidity, leverage, turnover, and profitability using ratio analysis.
You work for a brokerage firm. Your boss asked you to analyze Eagle Manufacturing's performance for...
You work for a brokerage firm. Your boss asked you to analyze Eagle Manufacturing's performance for the past five years and to write a report that includes the benchmarking of the company’s performance. (a.) What components would be best for you to include in tour financial statement analysis? Explain your answer. (b.) Identify and explain several weaknesses or limitations of ratio analysis. (c.) Define and explain how the following four ratios are used to examine the different aspects of a...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT