Finance Company Projections On Market Value
-Calculated financial ratios using the right formula in the Excel sheet with the downloaded financial statements info (under balance sheet and income statement )
-Confirm your financial ratio calculation is correct using D&B calculated numbers (under Annual ratios)
The financial ratios you are going to calculate are:
Category 1: current ratio, market debt-to-equity ratio, times interest earned ratio, cash coverage ratio. Analyze the change in ratios over time for the same firm and between the two at the same time.
Category 2: operating profit margin, net profit margin, return on equity (ROE). Analyze the change in ratios over time for the same firm and between the two at the same time.
Category 3: price-to-earnings ratio, market-to-book ratio, enterprise value-to-EBITDA ratio. Analyze the change in ratios over time for the same firm and between the two at the same time.
Category 4: DuPont Analysis on ROE
– Identify the driver for change in ROE for the company you select to do research on
– Compare the drivers based on DuPont Analysis between the two firms at the same time and assess the financial health of the two.








Jermaine Byrant
Nicole Johnson



