Question

Next Activity A Company has been offered a five years contract to provide components to a car manufacturer. If they accept th
0 0
Add a comment Improve this question Transcribed image text
Answer #1

NPV = sum of present values of all cash flows

NPV is calculated using NPV function in Excel

The cash flows and NPV are calculated as below :

NPV = -133,611 EUR

A 1 Year 3 0 1 2 3 B CashFlow (300,000) 75,000 75,000 25,000 (133,611) 6 NPV

1 Year 20 31 CashFlow =-300000 =75000 =75000 =75000-50000 =NPV(3%,B3:B5)+B2 5 3 6 NPV

Add a comment
Know the answer?
Add Answer to:
Next Activity A Company has been offered a five years contract to provide components to a...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • A Company has been offered a five years contract to provide components to a car manufacturer....

    A Company has been offered a five years contract to provide components to a car manufacturer. If they accept that project, there will be an initial investment of 100,000 EUR, an extra expense of 100,000 EUR in year 3, and yearly revenues of 50,000 EUR. The company wishes to gain a 18% at least (use this as a discount rate). What is the NPV of this operation? (Write the answer with no decimals) Please upload an excel file with the...

  • Financial Management MGMT8500 Case study on NPV Tech Help Inc. has been offered a new contract....

    Financial Management MGMT8500 Case study on NPV Tech Help Inc. has been offered a new contract. The firm needs to determine whether the contract will be profitable. The new contract will generate 800 billing hours at $125 per year for 5 years. The variable costs, labour will be $32 an hour (including fringe benefits). The fixed costs include 3 vehicle for the employees to service customers at their locations will be $500 per month per car. Other fixed costs will...

  • Ramona Company has been offered a eight-year contract to supply a part for the government. After...

    Ramona Company has been offered a eight-year contract to supply a part for the government. After careful study, the company has estimated the following data relating to the contract: Cost of Equipment Needed Working Capital Needed Annual Cash Receipts from the Delivery of Parts Annual Cash Operating Costs Salvage Value of Equipment at Termination of the Contract $200,000 50,000 100,000 30,000 5,000 It is not expected that the contract would be extended beyond the initial contract period. The company's discount...

  • PLEASE SHOW YOUR WORK Lnupier 13 Exercise 13-2. Lynde Company has been offered a contract to...

    PLEASE SHOW YOUR WORK Lnupier 13 Exercise 13-2. Lynde Company has been offered a contract to provide a key replacement part for the Army's main attack helicopter. The contract would expire in eight years. The projected cash flows that result from the contract are given below: Cost of new equipment.............................. $300,000 Working capital needed............ $100,000 Annual net cash inflows...... $ 85,000 Salvage value of equipment in eight years. $ 50,000 The company's discount rate is 16%. The working capital would...

  • Harman deep Ltd. is a private company in the pharmaceutical industry. It has been preparing its...

    Harman deep Ltd. is a private company in the pharmaceutical industry. It has been preparing its financial statements in accordance with ASPE. Since it has plans to go public in the next 3 to 5 years, it is considering changing to IFRSs for the current year. It wishes to adopt policies that will maximize the return on shareholders’ equity. Based on the draft financial statements prepared in accordance with ASPE, its net income for Year 5 is $400,000, and its...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT