Calculate the discounted payback period

Assignment Help Financial Management

Reference no: EM131566226

The Company is considering a new turkey farm to service its western region stores. Currently the stores require 900,000 turkeys per year at a cost of $10 per bird. Managers believe that their new farm will lower the cost per bird to $7.50 while maintaining the average selling price of $13 per bird. Shipping expenses will increase from $1 to $1.50 per bird. Inventory will need to increase by $150,000 live turkeys. Additionally labor cost will increase $500,000 annually. It will cost $2,000,000 to purchase land and $1,500,000 for constructing building and equipment. Building and equipment are depreciated on the straight line method. After 7 years, the company expects to sell the land for $1,500,000 and the building and equipment at their salvage value of $600,000. The companies marginal tex rate is 40%

PLEASE SHOW EXCEL WORK FLOW

1. Calculate the initial outlay (IO) annual after tax cash flow for each year (ACF) and terminal cash flows (TCF) for this project.

2. If the WACC is 12% answer the following questions:

- 3.Calculate the payback period

- 4. Calculate the discounted payback period.

- 5 Calculate the NPV

-6 Calculate the PI

-7. Calculate ethe IRR

-8 Calculate the MIRR

Reference no: EM131566226

Questions Cloud

Problem-solving negotiation : In problem-solving negotiation, the disputing parties seek _____.

Disadvantage of arbitration : Which of the following is a disadvantage of arbitration?

If two projects are mutually exclusive and acceptable : if you believe the price of a stock is going to go lower you will purchase a call. If two projects are mutually exclusive and acceptable, then

Annual payment that will fully amortize the loan : What is the annual payment that will fully amortize the loan?

Calculate the discounted payback period : The Company is considering a new turkey farm to service its western region stores. Calculate the discounted payback period.

What is the present value at a discount rate : What is the Present Value at a discount rate of 8%?

Differentiates an arbitration proceeding from trial : Which of the following differentiates an arbitration proceeding from a trial?

What will required rate of return on equity : Holland Auto Parts is considering a merger with Workman Car Parts. What will Workman's required rate of return on equity be after it is acquired?

Statements is true of private trials : Which of the following statements is true of private trials?

User Account

All Pages