Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please show the math formula and work with the Excel answers( show it al) Consider a project that involves the purchase of a $100,000 machine.

Please show the math formula and work with the Excel answers( show it al)

Consider a project that involves the purchase of a $100,000 machine. The machine will last for three years. It is expected to produce 20,000 units per year. The sales price for each unit will be $32, and variable costs will be $25 per unit. The project will also incur fixed labor costs of $45,000 per year. It will require no additional investment in net working capital and is expected to have a salvage value of $5,000 in three years. The machine will be depreciated using the MACRS schedule below (note that this schedule has 4 years of depreciation, but the machine will be sold after 3 years). The tax rate is 40%, and the discount rate is 10%. You may want do this problem in Excel, and then copy the numbers into your Word document.

Year

MACRS %

1

33

2

44

3

15

4

8

Construct a table of the relevant cash flows for this project, and compute the NPV and IRR of the project. (14 points)

What is the minimum unit price (to the nearest cent) that would justify investment? You do not need to show all your work, but explain how you arrived at your answer. (2 points)

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

Portfolio Performance Measurement And Benchmarking

Authors: Jon Christopherson, David Carino, Wayne Ferson

1st Edition

0071496653, 978-0071496650

More Books

Students also viewed these Finance questions

Question

=+1. Why were participants randomly assigned to groups?

Answered: 1 week ago