Question

Please I want clear workings and formula used to arrive at the answer and detailed explanation...

Please I want clear workings and formula used to arrive at the answer and detailed explanation for better understanding

A recent project nominated for consideration at your company has a four-year cash flow of $20,000; $25,000; $30,000; and $50,000. The cost of the project is $75,000.

a. If the required rate of return is 20%, conduct a discounted cash flow calculation to determine the NPV.

b. What is the benefit-cost ratio for the project?

c. What would the NPV of the above project be if the inflation rate was expected to be 4% in each of the next four years?

0 0
Add a comment Improve this question Transcribed image text
Answer #1

Part A

Investment

Year 1

Year 2

Year 3

Year 4

Cash flow

(75000)

20000

25000

30000

50000

PV@ 20%

1.00000

0.83333

0.69444

0.57870

0.48225

Present value

-75000

16667

17361

17361

24113

NPV

$502

Part B

Benefit-cost ratio = PV of benefit expected from the project / PV of the cost of the project = 75502/75000 = 1.01

Part C

Real discount rate = ((1.20/1.04)-1) = 15.38%

Investment

Year 1

Year 2

Year 3

Year 4

Cash flow

(75000)

20000

25000

30000

50000

PV@ 15.38%

1.00000

0.86670

0.75117

0.65104

0.56426

Present value

-75000

17334

18779

19531

28213

NPV

$8857

Add a comment
Know the answer?
Add Answer to:
Please I want clear workings and formula used to arrive at the answer and detailed explanation...
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 five-year project has a projected net cash flow of $17,000 in year 1, $25,000 in...

    A five-year project has a projected net cash flow of $17,000 in year 1, $25,000 in year 2, $27,000 in year 3, $20,000 in year 4, and $15,000 in year 5. It will cost $60,000 to implement the project. If the required rate of return is 23 percent, conduct a discounted cash flow calculation to determine the NPV. 1) the NPV for the project is ____

  • Help and verified and be clear. The net present value (NPV) and internal rate of return...

    Help and verified and be clear. The net present value (NPV) and internal rate of return (IRR) methods of investment analysis are interrelated and are sometimes used together to make capital budgeting decisions. Consider the case of Blue Hamster Manufacturing Inc.: Last Tuesday, Blue Hamster Manufacturing Inc. lost a portion of its planning and financial data when both its main and its backup servers crashed. The company's CFO remembers that the internal rate of return (IRR) of Project Lambda is...

  • PLEASE BE DETAILED WITH ANSWER Read Book Company is the manufacturer of exercise machines and is...

    PLEASE BE DETAILED WITH ANSWER Read Book Company is the manufacturer of exercise machines and is considering producing a new line of equipment in an effort to increase its market share. The new production line will cost $850,000 for manufacturing the parts and an additional $280,000 is needed for installation. The equipment falls into the MACRS 3-yr class, and would be sold after four years for $350,000. The equipment line will generate additional annual revenues of $600,000, and will have...

  • please answer question number 2 Note: Show all of your work to arrive at a final...

    please answer question number 2 Note: Show all of your work to arrive at a final result. Use periodic interest factors in the calculation of NPV and IRR 1. At the end of a tax year, a company has the following data: Gross receipts (sales) Cost of goods sold $300,000 $50,000 $15,000 Tax depreciation Book depreciation $8,000 Interest on debt $10,000 What is the company's tax liability (tax) and effective tax rate? 2. For the net cash flows given below,...

  • Please answer all three parts thank you 3. Understanding the IRR and NPV Aa Aa The...

    Please answer all three parts thank you 3. Understanding the IRR and NPV Aa Aa The net present value (NPV) and internal rate of return (IRR) methods of investment analysis are interrelated and are sometimes used together to make capital budgeting decisions. Consider the case of Green Caterpillar Garden Supplies Inc. Last Tuesday, Green Caterpillar Garden Supplies Inc. lost a portion of its planning and financial data when both its main and its backup servers crashed. The company's CFO remembers...

  • uul liaie h the exam paper and each of your answer sheets. Epiphany Industries is considering a new capital budgeting project that will last for three I. (10 pts.) years. Epiphany plans on using a...

    uul liaie h the exam paper and each of your answer sheets. Epiphany Industries is considering a new capital budgeting project that will last for three I. (10 pts.) years. Epiphany plans on using a cost of capital of 12% to evaluate this project. Based on extensive research, it has prepared the following incremental cash flow projections: Year Sales (Revenues) 100,000 100,000 100,000 50,000 50,000 50,000 30,000 30,000 30,000 20,000 20,000 20,000 Cost of Goods Sold (50% of Sales) -Depreciation...

  • Can I please receive assistance with the sections highlighted in Yellow. Please provide an explanation as...

    Can I please receive assistance with the sections highlighted in Yellow. Please provide an explanation as to how to calculate these figures, I am not familiar with how to calculate the Break-even, and I want to learn. Thank you! . Year 0 Year 1 Year 2 Year 3 Totals $0 Net Economic Benefit Discount Rate (5%) PV of Benefits NPV of Benefits $40,000 0.9524 $38,096 $38,096 $45,000 $45,000 0.907 0.8638 $40,815 $38,871 $78,911 $117,782 $117,782 $0 $0 One-time Costs ($30,000)...

  • udicates problems in Excel Study Problems All Study Problems are available in MyLab Finance. The X...

    udicates problems in Excel Study Problems All Study Problems are available in MyLab Finance. The X icon indicates problems Mylab format available in MyLab Finance. LO2 10-1. (Payback Period) What is the payback period for the following set of cash flowe YEAR CASH FLOWS --- $11,300 3,400 4,300 3,600 4,500 3,500 x 10-2. (IRR calculation) Determine the IRR on the following projects: a. An initial outlay of $10,000 resulting in a single free cash flow of $17,182 after 8 years...

  • Discounted payback period. Becker, Inc. uses the discounted payback period for projects costing less than $25,000 and h...

    Discounted payback period. Becker, Inc. uses the discounted payback period for projects costing less than $25,000 and has a cutoff period of four years for these small-value projects. Two projects, R and S, in the following table, PE, are under consideration. Their anticipated cash flows are listed in the following table. If Becker uses a discount rate of 4% on these projects, are they accepted or rejected? If it uses a discount rate of 8%? A discount rate of 18%?...

  • 4. Analysis of a replacement project At times firms will need to decide if they want...

    4. Analysis of a replacement project At times firms will need to decide if they want to continue to use their current equipment or replace the equipment with newer equipment. The company will need to do replacement analysis to determine which option is the best financial decision for the company. Price Co. is considering replacing an existing piece of equipment. The project involves the following: The new equipment will have a cost of $9,000,000, and it is eligible for 100...

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