Explore BrainMass
Share

Capital Budgeting : NPW and IRR methods

This content was STOLEN from BrainMass.com - View the original, and get the solution, here!

University Athletic Wear (UAW) is evaluating several new product proposals. Resources are available for any or all of the products . UAW uses a MARR of 15% and a time span of 5 years for project evaluations. Determine which new product(s) should be chosen using Internal rate of return criteria.

MARR=15%
Investment Cash Flows
Project 1 2 3 4 5
Shorts ($450,000) $80,000 $120,000 $150,000 $150,000 $150,000
Shirts ($200,000) $50,000 $70,000 $80,000 $80,000 $80,000
Jackets ($500,000) $150,000 $150,000 $150,000 $150,000 $150,000

a. Determine which new product(s) should be chosen using the Internal rate of return criteria.

b. Determine which new product(s) should be chosen using the present worth criteria.

© BrainMass Inc. brainmass.com September 24, 2018, 1:27 pm ad1c9bdddf - https://brainmass.com/economics/personal-finance-savings/capital-budgeting-npw-and-irr-methods-461474

Attachments

Solution Preview

Please refer attached file for better clarity of tables and formulas.

a Determine which new product(s) should be chosen using the Internal rate of return criteria.

Year Shorts Shirts Jackets
Initial ($450,000) ($200,000) ($500,000)
1 $80,000 $50,000 $150,000
2 $120,000 $70,000 $150,000
3 $150,000 $80,000 $150,000
4 $150,000 $80,000 $150,000
5 $150,000 $80,000 $150,000

We can use IRR function in MS Excel to IRR for the projects
IRR for "Shorts"=12.35% =IRR(B5:B10)
IRR for "Shirts"=21.52% =IRR(C5:C10)
IRR for "Jackets"=15.24% =IRR(D5:D10)
IRR is above 15% for ...

Solution Summary

Solution chooses the appropriate investment proposal/s.

$2.19