What will be the tax depreciation each year

Assignment Help Finance Basics
Reference no: EM132187069

Assignment -

Part A -

Complete the attached excel workbook. And prepare a 1 page executive summary or report talking about the purpose of the report to management, what method did you use, the finding and conclusions and recommendation.

Instructions - To complete this workbook, answer the questions on each worksheet in the space provided.

Cost of Capital - Information from McCormick

1. As of today, McCormick's market capitalization (E) is $14,237,510,000. Market value of equity (E), also known as market cap, is calculated using the following equation: Market Cap = Share Price x Shares Outstanding.

2. McCormick's book value of debt is $3,237,150,000. Book value of debt (D) is calculated as follows: Book Value of Debt = Last Two-Year Average of Current Portion of Long-Term Debt + Last Two-Year Average of Long-Term Debt & Capital Lease Obligation.

3. Cost of Equity = Risk-Free Rate of Return + Beta of Asset x (Expected Return of the Market - Risk-Free Rate of Return)

Risk-free rate of return = 2.82 percent.

Beta = 0.30.

Market premium = (Expected Return of the Market - Risk-Free Rate of Return) = 6 percent

4. Cost of Debt = Last Fiscal Year End Interest Expense / Book Value of Debt (D). McCormick's last fiscal year end interest expense is $95.7 million.

5. Use the effective tax rate of 25.705 percent.

Questions -

1. Find the weight of equity = E / (E + D).

2. Find the weight of debt = D / (E + D).

3. Find the cost of equity.

4. Find the cost of debt.

5. Find the weighted average cost of capital (WACC).

Capital Budgeting - Details of McCormick Plant Proposal

McCormick & Company is considering a project that requires an initial investment of $24 million to build a new plant and purchase equipment. The investment will be depreciated as a modified accelerated cost recovery system (MACRS) seven-year class asset. The new plant will be built on some of the company's land, which has a current, after-tax market value of $4.3 million.

The company will produce bulk units at a cost of $130 each and will sell them for $420 each. There are annual fixed costs of $500 thousand. Unit sales are expected to be 150,000 each year for the next six years, at which time the project will be abandoned. At that time, the plant and equipment is expected to be worth $8 million (before tax) and the land is expected to be worth $5.4 million (after tax).

To supplement the production process, the company will need to purchase $1 million worth of inventory. That inventory will be depleted during the final year of the project. The company has $100 million of debt outstanding with a yield to maturity of 8 percent, and has $150 million of equity outstanding with a beta of 0.9. The expected market return is 13 percent, and the risk-free rate is 5 percent. The company's marginal tax rate is 40 percent.

Should the project be accepted?

Questions -

1. What will be the tax depreciation each year?

2. What will be the value of the plant and equipment for tax purposes in year six? Will it be sold for a gain or a loss, and what will the tax effect be?

3. What is the weighted average cost of capital (WACC)?

4. What is the salvage cash flow of the new equipment? Include the income tax effect.

5. What is the total operating cash flows, given the following operating cash flows:

Sales = 150,000 x $420 = $63,000,000

Costs = 150,000 x $130 + $500,000 = $20,000,000

6. Create an after-tax cash flow timeline.

7. What are the total expected cash flows at the end of year six? The $4.3 million is an opportunity cost and must be included at date 0 as a cash outflow. If the project is accepted, however, the land can be sold in six years for $5.4 million.

8. Find the NPV using the after-tax WACC as the discount rate.

9. Find the IRR.

10. Should the project be accepted? Discuss whether NPV or IRR creates the best decision rule.

Part B -

Create a 3 slides PowerPoint presentation -

First slide talk about this - Describe how understanding the cost of capital can influence financing decisions in the client's business.

Second slide - Describe how capital budgeting can be used to help the client make better financing decisions.

Third slide: Highlight three key recommendations for the client in a bulleted list.

Attachment:- Assignment File.rar

Reference no: EM132187069

Questions Cloud

How does this crime violate the social contract : Select a crime and discuss the following questions: 1. How does this crime violate the social contract? 2. Has the definition of this crime changed over time?
Disadvantages of this product-entry mode combination : What American product would be best suited for export entry mode and why? Name one key risk and/or disadvantages of this product/entry mode combination?
What are the disadvantages of different entry modes : In this assignment, you are required to write about the strategic advantages and disadvantages of different entry modes. Choose 2 modes of entry, and compare th
Conduct research on the internet about using public hotspots : Prepare a list of specific steps that customers can take to protect their data when surfing on publicly accessible networks.
What will be the tax depreciation each year : Capital Budgeting - Details of McCormick Plant Proposal - What will be the tax depreciation each year? What is the weighted average cost of capital
Quantitative data comes from counting things : Quantitative data comes from counting things, such as defective units, defects, anomalies, conditions present or not present, and so on.
Minnesota statewide racial profiling study : For this activity, select one of the reports listed on the Minnesota Statewide Racial Profiling Study (in the Reading and Resources folder for this module).
How will end users typically respond to such announcements : How might an organization notify its users that all communications are being monitored and preserved?
The source of variability within process is identified : Analysis of valiance (ANOVA) is a statistical technique by which the source of variability within a process is identified.

Reviews

len2187069

12/6/2018 1:35:40 AM

Complete the attached excel workbook. And prepare a 1 page executive summary or report talking about the purpose of the report to management, what method did you use, the finding and conclusions and recommendation. Create a 3 slide PowerPoint: first slide talk about this:[Describe how understanding the cost of capital can influence financing decisions in the client’s business.] second slide: [Describe how capital budgeting can be used to help the client make better financing decisions.] third slide: [Highlight three key recommendations for the client in a bulleted list.]

Write a Review

 

Finance Basics Questions & Answers

  Briefly describe the municipalitys demographics

Briefly describe the municipality's demographics. Evaluate the previous three-year trend of the municipality's major revenue sources and expenditures. Analyze impact of issues contributing to the municipality's budget deficiencies.

  How much of a mortgage loan will the couple need

How much of a mortgage loan will the couple need?

  What is the smallest possible size (in bytes) for the frame

Suppose you have a system with an 8 inch by 10 inch video screen that can display 100 pixels per inch. If a color lookup table with 64 positions is used with this system what is the smallest possible size (in bytes) for the frame buffer?

  Why net income is not equal to net cash flow from operation

Explain why net income is not equal to net cash flow from operations, and reconcile the two numbers.

  Determine the cost of the beverage

Have you ever wondered why a 16-ounce beverage costs only a little more than the 12- ounce serving? Chances are that the company producing the beverage conducted a financial analysis to determine the cost of the beverage versus what the market wou..

  What is pelamed net income

Pelamed Pharmaceuticals had EBIT of $299 million in 2010. In addition, Pelamed had interest expenses of $95 million and a corporate tax rate of 35%.

  An hmo requests your hospital services for its obstetrics

an hmo requests your hospital services for its obstetrics division. it offers to pay your hospital 2000 for a vaginal

  How long will it take to achieve payback on the initial

How long will it take to achieve payback on the initial $2,000,000 TQM investment, rounded to the nearest month?

  What are the two major provisions of the mcfadden act

What are the two major provisions of the McFadden Act? - What was the motivation behind its passage?

  The bonds make annual payments

1.Your firm issued 15- year bonds one year ago at a coupon rate of 7%. The bonds make annual payments. If the YTM is 7.5%, what is the current bond price?2. A firm has bonds on the markets with 9 years to maturity YTM of 7.1% and a current pri..

  If he grows 100000 bushels and each futures contract calls

farmer brown grows number 1 red corn and would like to hedge the value of the coming harvest. however the futures

  What is the main disadvantage of annuities

Annuities. What is an annuity? What is the difference between a fixed annuity and a variable annuity? What is the main disadvantage of annuities?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd