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

Q

30 Which protein modification occurs on intermediate filaments to regulate their state i e being...

Biology
Q

Given TU XW Prove XW 8 X 14 XW 4 7 XW 56 XW 8...

Geometry
Q

Curtis Corporations balance sheet included the following: Common Stock, $5 par value, 5,000 shares issued...

Accounting
Q

Required information Problem 13-77 (LO 13-4) (Algo) [The following information applies to the questions displayed...

Accounting
Q

Which of the following is consider as user of financial accounting information? .a. Employees b....

Accounting
Q

Windsor Company is considering the purchase of a new machine. The invoice price of the...

Accounting
Q

Discuss some of the important features of audit documentation and what are the risks of...

Accounting
Q

Emerald Corporation is required to change its method of accounting for Federal income tax purposes....

Accounting
Q

Name: Questions 1 and 2 refer to the following information ant it made in 2019....

Accounting
Q

efferson Companys demand for its only product exceeds its manufacturing capacity. The company provided the...

Accounting
Q

At the end of the most current year, B&B reported the following key performance indicators:...

Accounting
Q

Required information Benchmark Assignment - Coca-Cola Co. \& Pepsico inc. You will need to use...

Accounting