Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The Pioneer Company is evaluating the replacement of one of its machines. The machine was originally purchased ten years ago at a cost of $45,000

The Pioneer Company is evaluating the replacement of one of its machines. The machine was originally purchased ten years ago at a cost of $45,000 and has been depreciated to a book value of zero. If Pioneer replaces the machine, it will be able to bid on larger projects that require the capabilities of the new machine. The new machine will cost the firm $50,000, which will be fully depreciated to a book value of 0 over 5 years according to the following MACRS-type depreciation rates: 30% in each of years 1 and 2, and 15% in each of years 3 and 4, and 10% in year 5. The new machine qualifies for an immediate 3% investment tax credit. Pioneer anticipates that at the end of the machines eight year economic life it will be sold for $10,000. Pioneer estimates that its existing machine can be sold today for $6,000. If Pioneer does not replace the machine, it anticipates being able to use the existing machine for eight more years at which time its salvage value would be zero. Without the purchase of the new machine, Pioneer expects to generate revenue of $200,000 per year.

The firms use of its existing machine is expected to generate operating expenses of $120,000 per year. If the new machine is purchased, Pioneer expects the firms annual revenues and operating costs to increase to $260,000 and $160,000 respectively. Pioneers marginal tax rate is 25%. To finance this project, Pioneer will raise 30% of the capital from debt and 70% of the capital from equity; its after-tax cost of debt is 8% and the cost of equity is 18%, which results in a cost of capital of 15%.

(18) a. Calculate the NPV for this project.

(2) b. Calculate the IRR to 2 decimals; for example, 25.63%.

can you explain using the NPV and IRR functions in excel

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Continuous Time Finance

Authors: Robert C. Merton

1st Edition

0631185089, 978-0631185086

More Books

Students also viewed these Finance questions