Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

A firm is considering purchasing a new machine for $450,000. This machine will allow the firm to sell an additional 16,000 units of its product

A firm is considering purchasing a new machine for $450,000. This machine will allow the firm to sell an additional 16,000 units of its product per year at $30 per unit for five years, after which the machine will be sold for $40,000. Production costs will be $10 per unit. Maintenance of the machine will be covered under the terms of an existing maintenance contract the firm entered into and paid for four years ago. This contract provides for maintenance for all the firms machines for the next six years for no cost beyond the original price of the contract. The cost of that contract was $10,000.

The firm plans to depreciate the machine over FOUR years using straight-line depreciation. The new machine will require net working capital of $70,000 per year in years zero, one and two and $50,000 per year in years three and four. At the end of year five, the firm will recover its working capital. The tax rate is 35 percent. The cost of capital is 15 percent.

Build a spreadsheet to show the following output variables:

  1. The projects EBIT each year,
  2. The project's net income each year,
  3. The projects operating cash flows each year,
  4. The projects cash flows from working capital each year,
  5. The net cash flows associated with the project each year,
  6. The projects NPV, and
  7. The projects IRR.

Use the following input variables in the spreadsheet:

  1. Unit sales price,
  2. Units sold,
  3. Unit production costs,
  4. Salvage value,
  5. Tax rate,
  6. Cost of capital, and
  7. Cost of new machine.

Put the input variables at the top of the spreadsheet. When I grade your spreadsheet, I will want to be able to change any of the input variables at the top of the spreadsheet and have the spreadsheet automatically recalculate the output variables.

Use the values of the input variables given above to answer the four quiz questions.

What is the projects NPV? (Enter your answer without the $ symbol, e.g., for 500 dollars, enter 500, not $500.)

What is the projects IRR? (Enter your answer without the % symbol, e.g. for 50.25 percent, enter 50.25 or 0.5025, but not 50.25%.)

What is the project's payback period?

What is the project's discounted payback period?

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

Emerging Markets And The Global Economy A Handbook

Authors: Mohammed El Hedi Arouri, Sabri Boubaker, Duc Khuong Nguyen

1st Edition

0124115497, 978-0124115491

More Books

Students also viewed these Finance questions

Question

What attracts you about this role?

Answered: 1 week ago

Question

How many states in India?

Answered: 1 week ago

Question

HOW IS MARKETING CHANGING WITH ARTIFITIAL INTELIGENCE

Answered: 1 week ago

Question

Different types of Grading?

Answered: 1 week ago

Question

1. Are my sources credible?

Answered: 1 week ago

Question

3. Are my sources accurate?

Answered: 1 week ago

Question

1. Is it a topic you are interested in and know something about?

Answered: 1 week ago