80.2K

Verified Solution

Link Copied!

Interactive Dashboard / Strategic Competitive Position / Share Forecast

Download the 10-year comparative financial data (see Financials folder) for the two (2) companies (LIC and CLW).

Using prepare a single interactive dashboard of the key ratios that you feel would help an analyst to evaluate the strategic competitive position of the two companies.

Please select any four ratios from the following categories: Liquidity, Asset Management, Leverage / Debt Management, Profitability, Cash Flow and Market Based Ratios.

In addition, to the four ratios selected, students are also required to calculate the Altman Z score for the two companies allocated.

The single Dashboard should contain, at a minimum: 1) two different chart types; 2) images of company brand and other graphical images related to each companys business; 3) filters for data in your charts to engage user interaction with your Dashboard; and 4) Title and text boxes to explain the charts and diagrams in your Dashboard.

Prepare a single interactive dashboard of the key ratio (for Twocompanies):

10-year comparative ratio analysis

should include 4 financial ratio analysis

calculated the Altman Z score for two companies

two different chart types

images of company brand and other graphical images related to each companys business

filters for data in your charts to engage user interaction with your Dashboard

Answer & Explanation Solved by verified expert

See Answer