Reference no: EM132229058
Assignment -
The assignment focuses on ratio analysis: drawing insights about the company from its financial statements. Please use the data in the attached Excel spreadsheet to answer the following questions.
1. Calculate TVH's 2017 Current and Quick ratios based on the projected balance sheet and income statement data. What can you say about the company's liquidity positions in 2015, in 2016, and as projected for 2017?
2. Calculate the 2017 Inventory Turnover, Days Sales Outstanding, Fixed Assets Turnover, and Total Assets Turnover ratios. How does TVH's utilization compare to other firms in the industry?
3. Calculate the 2017 Debt-to-Assets and Times-Interest-Earned ratios. How does TVH compare with the industry with respect to financial leverage?
4. Calculate the 2017 Operating Margin, Profit Margin, Return on Assets (ROA), and Return on Equity (ROE). What do these ratios indicate about TVH's profitability?
5. Calculate the 2017 Price/Earnings and Market/Book ratios. Do these ratios indicate that investors are expected to have a high or low opinion of the company?
6. Use the DuPont equation to provide a summary of TVH's financial condition as projected for 2017. Based on the DuPont equation, what are the firm's major strengths and weaknesses?
Attachment:- Assignment Files.rar