Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. accounting
  3. i need to know what the results would look like in

I need to know what the results would look like in excel. The...

50.1K

Verified Solution

Question

Accounting

I need to know what the results would look like in excel.

The management of ABC company is considering buying a new machine which would produce parts for a client.

They have 2 options:

Machine A costs $165,000 (useful life: 7 years, salvage value: $15,000) and would have cash sales of

$124,000 and cash costs of $80,000 each year during its useful life. It would require $20,000 of working capital which

is released at the end of the period.

Machine B costs $140,000 (useful life: 7 years, salvage value: $16,000) and would have cash sales of

$111,000 and cash costs of $74,000 each year during its useful life. It would require $16,000 working capital which is

released at the end of the period.

The discount rate of ABC is 12% and the tax rate is 20%. Normally ABC gets their investment back in 4.5

years.

Required:

a) Compute the NPV for each machine. Which investment is better according to this method?

b) Compute the IRR for each machine. Which investment is better according to this method?

c) Compute the PBP for each machine. Which investment is better according to this method?

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Statistics
1.2K views

Question5. Please answer the following questions as either \"TRUE\" or \"FALSE\" (Write out either “True” or...

Electrical Engineering
1.2K views

In the class, we had formulated the rules for the r’s compliment subtraction (also see section...

Biology
1.2K views

estion Listen Which part of the neuron contains the nucleus 1 point a the axon...

Physics
1.2K views

2 A closed organ pipe and an open organ pipe of same length produce four...

Basic Math
1.2K views

Assume there is a certain population of fish in a pond whose growth is described...

Calculus
1.2K views

er 7 Group Worki The following account balances come from t Accounts receivable Allowance for...

Accounting
1.2K views

On December 31, 2015, Net Co. is in financial difficulty and cannot pay a...

Accounting
1.2K views

How do I get this answer [The following information applies to the questions displayed...

Accounting
1.2K views

Suomit test A company reports net accounts receivable of $253,000 on its December 31,2026,...

Accounting
1.2K views

Crane Company must decide whether to make or buy some of its components. The costs...

Accounting
1.2K views

please help Donna Forrester's gross pay is $ 64,669 a...

Accounting
1.2K views

Granfield Company has a piece of manufacturing equipment with a book value of $38,000 and...