Question
Prepare the following analysis using Fords interactive financial statements (http://www.sec.gov/cgi-bin/viewer?action=view&cik=37996&accession_number=0000037996-14-000010&xbrl_type=v#) for end of the Fiscal year 2013, 2012, and 2011. Submit an Excel worksheet that
Prepare the following analysis using Fords interactive financial statements (http://www.sec.gov/cgi-bin/viewer?action=view&cik=37996&accession_number=0000037996-14-000010&xbrl_type=v#) for end of the Fiscal year 2013, 2012, and 2011. Submit an Excel worksheet that develops the following: (((PLEASE SUBMIT THE EXCEL SHEET)))
Prepare horizontal analysis by developing a comparative balance sheet for the current and previous year of the balance sheet included in the 10-K.
Prepare vertical analysis by developing a comparative income statement for the current and previous year of the income statement included in the 10-K.
Please calculate the following ratios based on the current and previous years financial statements in the 10-K report, showing your calculations on your Excel worksheet. Explain what each of these ratios mean:
Working capital
Current ratio
Quick ratio
Accounts receivable turnover
Total Asset Turnover
Inventory turnover
Total Debt to Equity Ratio
Long term Debt to Equity ratio
Profitability Ratio
Return on Assets
Return on Equity
Return on Revenue
Earnings per share on common stock
Price-earnings ratio
Dividend yield
Step 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