Question: please read the whole question first. needs to be done in excel so please provide pictures by doing in excel sheet, or tables. You can
Financial Statement Analysis In this assignment is to perform financial analysis for your favourite public company. Choose your favourite company and create the four financial statements on a separate excel file. Perform the following analysis on your company. Record the company's four financial statements. Provide a recommendation to buy or not buy your company based on your analysis. Liquidity Ratios Current Ratio Quick Ratio Inventory Turnover Inventory Turnover Period (days) Accounts Receivable Turnover Accounts Receivable Turnover Period (days) Operating Cycle (days) Cash Flow to Current Debt Borrowing Capacity Ratios Debt Ratio Equity Ratio Times Interest Earned Profitability Ratios Return on Net Sales Return on Equity Return on Assets Horizontal Analysis Total Assets Total Equity
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
