Looking for help with an assignment? Connect with an assignment Expert Now!

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

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

you are supposed to be a financial manager to apply the knowledge obtained from the Financial Management 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.

(1) Executive Summary (10 points)

– Summarize the major findings, results, and the analysis of the report.

(2) Financial Ratio Analysis (40 points)

You are expected to apply the knowledge obtained in Financial Management and Financial Statement Analysis 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 (25 points)

– 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) (35 points)

– 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 (40 points)

– We assume that the company of your choice is considering a new project. The project has 11 years’ life. This project requires initial investment of $680 million to purchase equipment, and $25 million for shipping & installation fee. The fixed assets fall in the 10-year MACRS class. The number of units of the new product expected to be sold in the first year is 2,560,000 and the expected annual growth rate is 5.5%. The sales price is $255 per unit and the variable cost is $200 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 12% 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. (Please refer to Table 11A-2 MACRS Depreciation Percentages on P.496 of the textbook)

– Estimate annual cash flows for the 11 years.

– Draw a time line of the cash flows.

(6) Capital Budgeting Analysis (40 points)

– 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 document Sensitivity Analysis in Excel is provided in this learning module. It 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.

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

Get a Quick Quote

Approximately 250 words
Total price (USD) $: 10.99

Spend Hours doing a Paper or spend just $33 for a 3 page essay?

Tired writing homework

Reviews from Clients who Ordered this Paper

Our Benefits

Take a look at the characteristics of our custom essay writing service. We ensure that not only will your essay be delivered on schedule, but that it will also be of the finest possible quality.

Guaranteed Customer Satisfaction

We are always available to help with any revisions and deliver flawless results

Quick Results

Any deadline can be met. 400+ dedicated writers are waiting to finish your essay in as little as three hours.

Support is available

We’re here for you at all times and can answer in as little as one minute.

All papers reviewed

We examine our own database of completed orders to ensure that you always get original work.
b

Provide Detailed Instructions

  • Fill in instruction details on the order page such as length, title, slides, subject etc. and upload neccesary attachments
  • Provide additional parameters which you would like for your order such as writer category, formatting requirement, sources etc.

Login & Complete Payment

  • Once logged & completed payment, your order will be put to bid and assigned to suitable writer who matches your requirements.
  • The order is moved to ‘in progress’ on this stage.

Writing, Editing & Proofreading

  • Once the writer completes your order, he or she forwads it to the editing team for review.
  • The order is scrutinized for syntax or grammar error and checked for plagiarism with softwares such as turnitin.
h

Download Your Final Document

  • Upon satsfaction by the editing team, your order is moved to ‘completed’ tab where you can download final copy.
  • You can tip writer if you are satisfied with the order.
  • Approve the order or ask for revision if unsatisfied

Having a rough time with your urgent homework?

Place your order today and get it delivered before your deadline