Help with Business Finance

Mansfield oil & Sinclair Oil. Each student is required to perform a research on a Corporate Finance project that involves writing a report (30-35 pages) on a publicly traded company based on its available current financial data. The project involves two parts, namely, 1) The Comprehensive Financial Analysis of a Company and 2) The Computation of Cost of Capital of the same company. ALL CALCULATIONS FOR THE PROJECT SHOULD BE DONE IN EXCEL AND ALL EXCEL OUTPUTS HAVE TO BE SUBMITTED ALONG WITH THE PROJECT FOR EVALUATION. 1) Comprehensive Financial Analysis of a company: The first part of the project (using the tools and techniques given in Chapter 3 of the textbook) and its subsequent report is based on the Financial Ratio Analysis (Du Pont Chart Analysis) of a company and its available current financial dataThe students are required to evaluate the company based on the trends in its financial ratios over time and evaluate them against the industry standard (a major competitor). Details, including the selection of the company (for time-series evaluation) and its competitor (for cross-section evaluation), will be discussed throughout the semester. In general, the ratio analysis is done in the following steps: ï· Evaluate the company using the following ratios: Current, Quick, Average Collection Period, Accounts Receivable Turnover, Inventory Turnover, Average Age of Inventory, Inventory to Net Working Capital, Total Asset Turnover, Fixed Asset Turnover, Fixed Charge Coverage, Basic Earning Power, Debt Ratio, Debt to Equity, Long-term Debt to Equity, Times Interest Earned, Total Profit Margin, Operating Profit Margin, Net Profit Margin, Return on Investment, Return on Asset, Return on Equity, Price-Earnings, MarketValue to Book-Value, Cash Flow per Share, Dividend Payout, and Dividend Yield ratios. ï· Use the ratio values and accounting measures to show performance trends (time-series analysis) of the company (at least for five years). ï· Find industry quartiles for each of the ratio and accounting measures and evaluate the company ratios and accounting measures against the industry norm (a major competitor company) (cross-section analysis). ï· Write the analysis of the company on each of the ratio and accounting measurement areas (both time-series and cross-sectional analyses). ï· Use the web resources available to obtain information on both time-series and crosssection ratios and accounting measures. A series of web addresses that also provide company financial and economic information are given below. ï§ [login to view URL] ï· Remote access to [login to view URL] o Username: finacct o Password: rtlibrary [login to view URL] ï§ [login to view URL] ï§ [login to view URL] ï§ [login to view URL] ï§ [login to view URL] ï· Make sure to attach all the relevant printouts such as ratios and financial statements (submit them as attachments through the Assignment facility) you have obtained from various web sources with your final write-up. 2) Computation of Cost of Capital of the Company: In the second part, the cost of capital should be computed using the tools and techniques given in Chapter 12 and utilizing the most recent data (different web-based resources should be used to find necessary financial data such as common and preferred