2023 Competency 1 Understands the function of managerial finance and uses financial ratios to measure the performance of businesses and | Assignments Online

 

Competency 1 – Understands the function of managerial finance and uses financial ratios to measure the performance of businesses and projects.

Comprehensive Financial Statement Problem – Part 1

Complete first part of final demonstration of mastery related to Competency 1 content; using the financial statement for the selected company analyze the figures related to profitability, leverage, efficiency, and liquidity; determine current state of company in relation to these.

1. Select a company on which to complete the financial analysis. This is the company that you will use for the rest of the course.
   • Select a publicly-traded company from the list below or of your choosing:
     • Lyft – https://www.macrotrends.net/stocks/charts/LYFT/lyft/income-statement (Links to an external site.)

Make sure you have access to the various financial statements needed to complete a full analysis. You can use the Macrotrends (Links to an external site.) website for financial statements of publicly traded companies.

1. Calculate the various ratios as presented throughout Competency 1.
   • Profitability Ratios
     • Net Profit Margin
     • Operating Profit Margin
     • Return on Assets (ROA)
     • Return on Equity (ROE)
     • Earnings per Share (EPS)
     • Price Earnings Ratio (P/E)
     • Dividend Yield and Payout
     • Economic Value Added (EVA)
   • Liquidity Ratios
     • Current Ratio
     • Quick Ratio
     • Net Liquid Balance
   • Activity Ratios
     • Average Collection Period
     • Inventory Turnover
     • Total Asset Turnover
     • Operating Cycle
     • Free Cash Flow
   • Debt and Equity Ratios
     • Leverage
     • Debt-to-Equity Ratio
     • Times-Interest-Earned Ratio (TIE)
     • Book Value per Share of Common Stock
2. Present this data so that corporate leaders, stockholders, and the public can understand it. This should be in both numeric/table and graph (such as bar graphs, histograms, etc.) form.
   • For assistance on creating graphs and charts in Excel, please see one of the following tutorials
     • Excel – Create a chart from start to finish (Links to an external site.)
     • Excel 2016 – Charts (Links to an external site.)
3. What story does this data tell about the company? Start to formulate some ideas about the company’s financial status, as well as some suggestions for moving forward. 
4. Cite any sources used in APA format.
5. Submit this assignment (Word document)
6. 5 Pages including title and reference