Below are the instructions for this essay. The company we have chosen is AETNA. I have also attached an excel that will be used with this essay. Also attached a copy of an example essay. Please note that citations must be used and cited properly.

1. 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 during the most recent 5-year period.

- Perform industry (or benchmark companies) comparison analysis of the key financial ratios of the company in the most recent year.

- 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) in the most recent year.

- Estimate the firm’s weights of debt, preferred stock, and common stock using the market value of each capital component in the most recent year.

(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 you selected is considering a new project. The project has 8 years’ life. This project requires initial investment of $380 million to 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 10.5% of the purchase price (including the shipping & installation fee). 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 5.5%. The sales price is $255 per unit and the variable cost is $190 per unit in the first year, but they should be adjusted accordingly based on the estimated annualized inflation rate of 2.2%. The required net operating working capital (NOWC) is 9.5% of sales. Use the corporate tax rate obtained in Step (4) for the 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 on the website of the textbook (also posted in this final project learning module in Blackboard) for capital budgeting analysis, but you are NOT required to strictly follow the partial model. Actually, you are encouraged to build a better model by yourself.

- Compute the depreciation basis and annual depreciation of the new project.

- Estimate annual cash flows for 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 a sensitivity 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.

3. Other information regarding the project:

(1) Choose a publicly-traded company in the healthcare industry. WE HAVE CHOSEN THE COMPANY: AETNA

(2) Your project should be well-organized and typed in a Word document and attach the important tables with your report. The style and organization of the project is also important. It accounts for 10 points. Do not directly copy any contents from any other resources. List the cited references in your project.

1. 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 during the most recent 5-year period.

- Perform industry (or benchmark companies) comparison analysis of the key financial ratios of the company in the most recent year.

- 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) in the most recent year.

- Estimate the firm’s weights of debt, preferred stock, and common stock using the market value of each capital component in the most recent year.

(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 you selected is considering a new project. The project has 8 years’ life. This project requires initial investment of $380 million to 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 10.5% of the purchase price (including the shipping & installation fee). 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 5.5%. The sales price is $255 per unit and the variable cost is $190 per unit in the first year, but they should be adjusted accordingly based on the estimated annualized inflation rate of 2.2%. The required net operating working capital (NOWC) is 9.5% of sales. Use the corporate tax rate obtained in Step (4) for the 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 on the website of the textbook (also posted in this final project learning module in Blackboard) for capital budgeting analysis, but you are NOT required to strictly follow the partial model. Actually, you are encouraged to build a better model by yourself.

- Compute the depreciation basis and annual depreciation of the new project.

- Estimate annual cash flows for 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 a sensitivity 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.

3. Other information regarding the project:

(1) Choose a publicly-traded company in the healthcare industry. WE HAVE CHOSEN THE COMPANY: AETNA

(2) Your project should be well-organized and typed in a Word document and attach the important tables with your report. The style and organization of the project is also important. It accounts for 10 points. Do not directly copy any contents from any other resources. List the cited references in your project.

6. Assessment TasksAssessment Task 1:Assessment Task Design a NetworkScheduleOutcomes Assessed Performance Criteria:Addresses some elements of required skills and knowledge as shown in the Assessment MatrixDescription:This...ITECH1100 Understanding the Digital RevolutionAssignment 1 - Hat ZombieOverviewFor this individual assignment, you will use skills acquired through practical laboratory exercises to automate a business...ACCT3102 Individual Case Study AssignmentInstructionsThe case is to be undertaken individually and students should independently prepare their assignment.The financial reporting case study is a comprehensive...ITSA 2005Planning and Implementing ServerProject AssignmentSeptember 2018Due Date: Tuesday, 16th of October 2018Total Marks: 25 (15 report + 10 presentation)This assessment item requires you to work in...Weight: 40%Type of Collaboration: IndividualDue: By 11.59pm 27/10/19 (Week 14)Submission: This assignment must be submitted online via Turnitin only (i.e. no hard copies). Assignments will be marked online...Working with a client sport focussed organisation or community based in Australia (as chosen by the student) the student is required to develop a sport event research report and concept for the client...Specification:Weight 30%Type Group/IndividualLength • Exactly 8 pages for groups• Exactly 6 pages for individuals• Papers not conforming to the page limit are not marked• The page limit includes references...**Show All Questions**