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...

80.2K

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

In a test of a new medication, 65 out of 98 males and 45 out...

Biology
1.2K views

Summarize this: Biological, Chemical, & Other Non-Nuclear Threats Biological, chemical and other non-nuclear threats, such as cyber and...

Mechanical Engineering
1.2K views

A man is pulling a 120 lb wooden box by a rope with a force...

Biology
1.2K views

Source www britannica com O Abnormal condition of red blood cells Presence of bacteria in...

Basic Math
1.2K views

Real GDP per capita in the United States grew from about 6 000 in 1900...

Basic Math
1.2K views

Solve the following problem Be sure to make a diagram of the situation with all...

Algebra
1.2K views

Refer to functions s and f Find the indicated function and write the domain in...

Accounting
1.2K views

Rockett Company is considering a business decision to invest in new equipment. The new equipment...

Accounting
1.2K views

9. Management is the art and science of decision making and leadership A. O Harold...

Accounting
1.2K views

How can companies support whistleblowers? What are the risks to a whistleblower? (Professional & Ethical...

Accounting
1.2K views

LMO Company incurred expenditures for leasehold improvements during the year. The relevant lease is on...

Accounting
1.2K views

You are an auditor studying the internal controls of a client receiving department where inventory...