What will be the tax depreciation each year

Assignment Help Managerial Accounting
Reference no: EM132188376

Assignment - Answer the questions on each worksheet.

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).

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.

Attachment:- Assignment File - Workbook.rar

Reference no: EM132188376

Questions Cloud

Describe the different organizational structures : Describe the different organizational structures as it relates to project management (i.e., functional, project-based, matrix).
Explain the management plan for conducting it audits : This assignment consists of four (4) sections: an internal IT audit policy, a management plan, a project plan, and a disaster recovery plan.
Demonstrate knowledge gained from the course readings : Writing assignment is to answer any two of the three questions below, in about 500-800 words for each essay, or approximately 2-4 pages each.
Describe your strategic position in the market : Describe your strategic position in the market and what differentiates the products or services you sell.
What will be the tax depreciation each year : To supplement the production process, the company will need to purchase $1 million worth of inventory. What will be the tax depreciation each year
Identifying particular process of agile : Statement is all about identifying particular process of agile and its factors need to be taken into consideration of expecting valid outcome results.
Explain a cloud-based office productivity suite : Create a 6- to 10-slide presentation about a cloud-based office productivity suite, identifying how each of the above needs can be met and the collaborative.
Create matrix comparing features of presentation software : Create a matrix comparing five features of presentation software. Using these five features, compare two presentation programs.
How the literature further informed your research agenda : Literature Review, presented as the primary topics you separated your review into, the reason they are important and frame your study successfully.

Reviews

len2188376

12/8/2018 1:24:37 AM

Both tabs need to be complete with complete sentences to questions and calculation work needs to be shown. Instructions - To complete this workbook, answer the questions on each worksheet in the space provided. Use the given area to show your work using Excel.

Write a Review

Managerial Accounting Questions & Answers

  Calculate monthly purchases august to november

Calculate Monthly Purchases August to November - Calculate Payments Made for Inventory (purchases Paid in)August to October and after October

  Compute the total cost of the two ending inventories

Deschamps Company's ending Goods in Process Inventory account consists of 5,000 units of partially completed product, and its Finished Goods Inventory account consists of 12,000 units of product.

  Compare the two prices you just calculated

Compare the two prices you just calculated; why are the prices different? What is likely to happen to the quantity demanded if the company is forced to raise its price to the price calculated in part b?

  Direct labor and manufacturing overhead

Allocate Mr. DeJay's earnings for the week between direct labor and manufacturing overhead.

  Net present value

Net present value

  Marions production cost report

Marion Chemicals produces a chemical used as a base in paints. In the manufacturing process, all materials are added at the start of the process, whereas labor and overhead are added evenly throughout production.

  Reconstruct the reconciliation of net income to cash flows

Reconstruct the reconciliation of net income to cash flows from operating activities (operating cash flows using the indirect method).

  Possible customer returns or account adjustments

On July 15, Mann Company sold $600,000 in accounts receivable for cash of $500,000. The factor withheld 10% of the cash proceeds to allow for possible customer returns or account adjustments. An Allowance for Bad Debts of $80,000 had previously been ..

  What does a business contribution margin represent

What does a business's Contribution Margin represent? What does the Contribution Margin have to do with Operating Leverage?

  Which of the following does not represent a cash flow

Which of the following would not be a component of cash flows from investing activities? a. Sale of land. b. Purchase of securities. c. Purchase of equipment. d. Dividends paid.

  Preparing an operating budget-sales budget

There are several examples in the book I am unsure what one to follow. Here is the question. Any assistance would be great.

  What are the expected dividend growth rates for each firm

What are the dividend payout ratios for each firm? What are the expected dividend growth rates for each firm?

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