Question
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.
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.21Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started