Perform trend analysis of the key financial ratios

Assignment Help Financial Management

Reference no: EM131307410

Cost of Capital, Capital Structure, and Capital Budgeting Analysis
1. The purpose of the project:
In this project, you are supposed to be a financial manager to apply the knowledge obtained from the Financial Management (FINC6352) course to estimate the cost of debt, cost of preferred stock, cost of common equity, capital structure, and the weighted average cost of capital (WACC) for a publicly-traded corporation of your choice. You will use the estimated WACC as the discount rate to perform capital budgeting analysis for a hypothetical project (the information is given below) that is under consideration by the selected company, and decide whether the project should be accepted.

2. Outline for the project:
(1) Executive Summary
• Summarize the major findings, results, and the analysis of the report.

(2) Financial Ratio Analysis
You are expected to apply the knowledge obtained in Financial Management and Financial Statement Analysis (ACCT6351) to the key financial ratios of the selected company.

• Perform trend analysis of the key financial ratios (i.e., liquidity ratios, asset management ratios, debt management ratios, profitability ratios, market value ratios) of the company.

• Perform industry (or benchmark companies) comparison analysis of the key financial ratios of the company.

• Based on the financial ratio analysis results, discuss/evaluate the financial performance of the company.

(3) Estimate Capital Structure

• Estimate the firm's weights of debt, preferred stock, and common stock using the firm's balance sheet (book value).

• Estimate the firm's weights of debt, preferred stock, and common stock using the market value of each capital component.

(4) Compute Weighted Average Cost of Capital (WACC)
• Estimate the firm's before-tax and after-tax component cost of debt; (Note: If the information about the current corporate tax rate is not available, you need to estimate the tax rate based on the historical tax payments).

• Estimate the firm's component cost of preferred stock;

• Use three approaches (CAPM, DCF, bond-yield-plus-risk-premium) to estimate the component cost of common equity for the firm.

• Calculate the firm's weighted average cost of capital (WACC) using the market-based capital weights.

(5) Cash Flow Estimation
• We assume that the company that you selected is considering a new project. We assume that the company you selected is considering a new project. The project has 8 years' life. This project requires initial investment of $500 million to construct building and purchase equipment, and $30 million for shipping & installation fee. The fixed assets fall in the 7-year MACRS class. The salvage value of the fixed assets is $32 million. The number of units of the new product expected to be sold in the first year is 1,500,000 and the expected annual growth rate is 7.8%. The sales price is $285 per unit and the variable cost is $235 per unit in the first year, but they should be adjusted accordingly based on the estimated annualized inflation rate of 1.8 %. The required net operating working capital (NOWC) is 13.6% of sales. Use the corporate tax rate obtained in Step (4) for this project. The project is assumed to have the same risk as the corporation, so you should use the WACC you obtained from prior steps as the discount rate. Note: you may revise the partial model in the file Ch11 P18 Build a Model.xls provided by the textbook (Posted in this final project learning module in Blackboard) for capital budgeting analysis, but you are NOT required to strictly follow this partial model. Actually, you are encouraged to build a model by yourself.

• Compute the depreciation basis and annual depreciation of the new project. (Please refer to Table 11A-2 MACRS allowances in the textbook)

• Estimate annual cash flows for the 8 years.

• Draw a time line of the cash flows.

(6) Capital Budgeting Analysis
• Using the WACC obtained from in Step (4) as the discount rate for this project, apply capital budgeting analysis techniques (NPV, IRR, MIRR, PI, Payback, Discounted Payback) to analyze the new project.

• Perform asensitivity analysis for the effects of key variables (e.g., sales growth rate, cost of capital, unit costs, sales price) on the estimated NPV or IRR in order to demonstrate the sensitivity of the model. The Scenario analysis of several variables simultaneously is encouraged (but not required). A PDF document named Sensitivity Analysis in Excel is provided in this learning module. The article introduces the Data Table method that you can use for performing sensitivity analysis in Excel.

• Discuss whether the project should be taken and summarize your report.

Reference no: EM131307410

Questions Cloud

Sketch a horizontal line for the efficient price : Explain in clear language the economic inefficiency associated with adverse selection - What does the theory of moral hazard tell is likely to happen to doctor visits among these people?

What is the duration of path a-b-e-h-j : Refer to the above. What is the duration of path A-B-E-H-J? The inputs required for material requirements planning are defined by the ____.

What are the characteristics of a good lit review : What are the Characteristics of a Good Lit Review. Synthesize other research on the topic, explaining what is known about it. Conclude by stating what is missing, what is controversial, what is not yet known, or what needs to be resolved in the dis..

What are the requirements for the customer interface : Also, what are the requirements for the customer interface for each phase? That is, what will the web-based site look like and what will it do?

Perform trend analysis of the key financial ratios : Summarize the major findings, results, and the analysis of the report.- Perform trend analysis of the key financial ratios.

How globalization in past fifty years affected organizations : Provide an analysis of how globalization in the past 50 years affected nonprofits and non-governmental organizations in the United States (or your country of residence) and throughout the world.

What is the throughput of the connection : In a TCP connection, the window size fluctuates between 60,000 bytes and 30,000 bytes. If the average RTT is 30 ms, what is the throughput of the connection?

Identify franchise brands that might make a good partnership : Identify two franchise brands that might make a good "partnership" as co-brands (i.e. Dunkin Donuts / Baskin & Robbins). Explain your rationale.

Determine how much one months interest expense : Determine the maximum loan for which Charmin Paper Company could qualify. - Determine how much one month's interest expense would be on the loan balance determined in part a.

User Account

All Pages