Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Can someone please help me with my Excel Accounting Project? I am confused as to where and how to start. Thank you in advance. Your

Can someone please help me with my Excel Accounting Project? I am confused as to where and how to start. Thank you in advance.

Your company is Amedisys Inc. Ticker AMED

Using data from the company you have been assigned for your term project prepare a horizontal analysis for the most current two years; a 10 year trend analysis (10 shorter if your company is younger) and vertical analysis for the two most current years for both the income statement and balance sheet. Graph the results. For the trend analysis you should include these major categories: Sales or earnings, COGS, gross profit, Operating expenses, sales expenses, net income. Balance sheet should include: Total current assets, total long term assets, current liabilities, total long term liabilities, total liabilities, and stockholders equity. Cash value statement for the last 3 years.

Information gathered so far: From my understanding, we take the numbers presented and create/output our own to be able to make a horizontal and vertical analysis.

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

This is what I can pull from the internet about this company. Please help.

Amedisys Inc. Current Trend Analysis Sales/Earnings Cost of goods sold Gross Profit Operating Expenses Sales Expenses Net Income 805,300,000 127,330,000 2 3 Balance Sheet Total Current Assets Total Long Term Assets 5 Current Liabilities Total Long Term Liablities 3 Total Liabilities Stockholders Equity Cash Value 174,760,000 Valuation Measures Annual Quarterly A Monthly Download Current 3/31/2020 12/31/2019 9/30/2019 6/30/2019 3/31/2019 Market Cap (intraday) 5 6.14B 5.94B 5.39B 4.22B 3.89B 3.95B Enterprise Value 6.44B 6.24B 5.69B 4.57B 4.27B 3.93B Trailing P/E 49.24 47.80 43.36 34.75 32.73 34.72 Forward P/E 1 44.64 36.90 36.10 29.07 30.67 30.67 PEG Ratio (5 yr expected) 1 2.98 2.46 2.41 1.94 2.04 2.04 Price/Sales (ttm) 3.17 3.10 2.91 2.38 2.33 2.49 Price/Book (mra) 9.04 9.28 8.94 7.52 7.50 8.20 Enterprise Value/Revenue 3 3.25 12.69 11.37 9.24 8.66 8.42 Enterprise Value/EBITDAG 26.68 105.68 99.34 73.79 67.79 68.95 Financial Highlights Trading Information Fiscal Year Fiscal Year Ends Dec 31, 2019 Stock Price History Beta (5Y Monthly) 52-Week Change 0.94 Most Recent Quarter (mra) Mar 31, 2020 62.62% S&P500 52-Week Change 3 6.87% Profitability Profit Margin 218.44 6.43% 52 Week High 115.41 Operating Margin (ttm) 9.06% 52 Week Low 3 50-Day Moving Average 3 182.64 Management Effectiveness Return on Assets (ttm) 200-Day Moving Average 3 179.24 8.55% Return on Equity (ttm) 21.37% Share Statistics Avg Vol (3 month) 3 322.56k Income Statement Revenue (ttm) Avg Vol (10 day) 499.63k 1.98B Shares Outstanding 5 32.38M Revenue Per Share (ttm) 61.44 Float 32M Quarterly Revenue Growth (yoy) 5.20% % Held by Insiders 1 1.12% Gross Profit (ttm) 805.3M % Held by Institutions 1 90.99% EBITDA 200.36M Shares Short (May 29, 2020) 4 1.2M Net Income Avi to Common (ttm) 127.33M Short Ratio (May 29, 2020) 4 4.04 Diluted EPS (ttm) 3.85 4.34% Quarterly Earnings Growth (yoy) 1.60% Short % of Float (May 29, 2020) 4 Short % of Shares Outstanding (May 29, 2020) Shares Short (prior month Apr 30, 2020) 3.72% Balance Sheet Total Cash (mra) 1.11M 174.76M Total Cash Per Share (mra) 5.4 Dividends & Splits Forward Annual Dividend Rate 4 N/A Total Debt (mra) 473.46M Forward Annual Dividend Yield 4 N/A Total Debt/Equity (mra) 69.61 Trailing Annual Dividend Rate 3 N/A Current Ratio (mra) 1.48 Trailing Annual Dividend Yield 3 N/A Book Value Per Share (mra) 20.98 5 Year Average Dividend Yield 4 N/A Cash Flow Statement Operating Cash Flow (ttm) Payout Ratio 4 0.00% 187.98M Dividend Date N/A Levered Free Cash Flow (ttm) 167.78M 4 Ex-Dividend Date N/A Last Split Factor 2 4:3 Last Split Date Dec 05, 2006 Income Statement Quarterly Annual Q1 2020 (Millions USD) BOOM Revenue 491.69 300 LLLL Net Income 31.80 0 02 2019 GS 2010 04 2019 Q1 2029 Profit Margin 6.47% Balance Sheet Quarterly Annual LEE 3426 Q1 2020 (Millions USD) Total Assets 1,440.08 800 LILL. Total Liabilities 759.94 02 2019 03 2019 04 2019 012020 Debt to Assets 32.88% Cash Flow Quarterly Annual 2019 (Millions USD) 400M 200 Operating 202.00 Investing 352.95 -400 2018 2017 2018 2019 Financing 227.21 Amedisys Inc. Current Trend Analysis Sales/Earnings Cost of goods sold Gross Profit Operating Expenses Sales Expenses Net Income 805,300,000 127,330,000 2 3 Balance Sheet Total Current Assets Total Long Term Assets 5 Current Liabilities Total Long Term Liablities 3 Total Liabilities Stockholders Equity Cash Value 174,760,000 Valuation Measures Annual Quarterly A Monthly Download Current 3/31/2020 12/31/2019 9/30/2019 6/30/2019 3/31/2019 Market Cap (intraday) 5 6.14B 5.94B 5.39B 4.22B 3.89B 3.95B Enterprise Value 6.44B 6.24B 5.69B 4.57B 4.27B 3.93B Trailing P/E 49.24 47.80 43.36 34.75 32.73 34.72 Forward P/E 1 44.64 36.90 36.10 29.07 30.67 30.67 PEG Ratio (5 yr expected) 1 2.98 2.46 2.41 1.94 2.04 2.04 Price/Sales (ttm) 3.17 3.10 2.91 2.38 2.33 2.49 Price/Book (mra) 9.04 9.28 8.94 7.52 7.50 8.20 Enterprise Value/Revenue 3 3.25 12.69 11.37 9.24 8.66 8.42 Enterprise Value/EBITDAG 26.68 105.68 99.34 73.79 67.79 68.95 Financial Highlights Trading Information Fiscal Year Fiscal Year Ends Dec 31, 2019 Stock Price History Beta (5Y Monthly) 52-Week Change 0.94 Most Recent Quarter (mra) Mar 31, 2020 62.62% S&P500 52-Week Change 3 6.87% Profitability Profit Margin 218.44 6.43% 52 Week High 115.41 Operating Margin (ttm) 9.06% 52 Week Low 3 50-Day Moving Average 3 182.64 Management Effectiveness Return on Assets (ttm) 200-Day Moving Average 3 179.24 8.55% Return on Equity (ttm) 21.37% Share Statistics Avg Vol (3 month) 3 322.56k Income Statement Revenue (ttm) Avg Vol (10 day) 499.63k 1.98B Shares Outstanding 5 32.38M Revenue Per Share (ttm) 61.44 Float 32M Quarterly Revenue Growth (yoy) 5.20% % Held by Insiders 1 1.12% Gross Profit (ttm) 805.3M % Held by Institutions 1 90.99% EBITDA 200.36M Shares Short (May 29, 2020) 4 1.2M Net Income Avi to Common (ttm) 127.33M Short Ratio (May 29, 2020) 4 4.04 Diluted EPS (ttm) 3.85 4.34% Quarterly Earnings Growth (yoy) 1.60% Short % of Float (May 29, 2020) 4 Short % of Shares Outstanding (May 29, 2020) Shares Short (prior month Apr 30, 2020) 3.72% Balance Sheet Total Cash (mra) 1.11M 174.76M Total Cash Per Share (mra) 5.4 Dividends & Splits Forward Annual Dividend Rate 4 N/A Total Debt (mra) 473.46M Forward Annual Dividend Yield 4 N/A Total Debt/Equity (mra) 69.61 Trailing Annual Dividend Rate 3 N/A Current Ratio (mra) 1.48 Trailing Annual Dividend Yield 3 N/A Book Value Per Share (mra) 20.98 5 Year Average Dividend Yield 4 N/A Cash Flow Statement Operating Cash Flow (ttm) Payout Ratio 4 0.00% 187.98M Dividend Date N/A Levered Free Cash Flow (ttm) 167.78M 4 Ex-Dividend Date N/A Last Split Factor 2 4:3 Last Split Date Dec 05, 2006 Income Statement Quarterly Annual Q1 2020 (Millions USD) BOOM Revenue 491.69 300 LLLL Net Income 31.80 0 02 2019 GS 2010 04 2019 Q1 2029 Profit Margin 6.47% Balance Sheet Quarterly Annual LEE 3426 Q1 2020 (Millions USD) Total Assets 1,440.08 800 LILL. Total Liabilities 759.94 02 2019 03 2019 04 2019 012020 Debt to Assets 32.88% Cash Flow Quarterly Annual 2019 (Millions USD) 400M 200 Operating 202.00 Investing 352.95 -400 2018 2017 2018 2019 Financing 227.21

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Auditing Corporate Surveillance Systems Research Methods For Greater Transparency

Authors: Isabel Wagner

1st Edition

1108837662, 978-1108837668

More Books

Students also viewed these Accounting questions

Question

Write a research paper with abstract for the "gun control paper"

Answered: 1 week ago

Question

What factors infl uence our perceptions?

Answered: 1 week ago