Purchase Solution

Capital Budgeting : NPW and IRR methods

Not what you're looking for?

Ask Custom Question

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.

Attachments
Purchase this Solution

Solution Summary

Solution chooses the appropriate investment proposal/s.

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 provided by:
Education
  • BEng (Hons) , Birla Institute of Technology and Science, India
  • MSc (Hons) , Birla Institute of Technology and Science, India
Recent Feedback
  • "Thank you"
  • "Really great step by step solution"
  • "I had tried another service before Brain Mass and they pale in comparison. This was perfect."
  • "Thanks Again! This is totally a great service!"
  • "Thank you so much for your help!"
Purchase this Solution


Free BrainMass Quizzes
Basics of Economics

Quiz will help you to review some basics of microeconomics and macroeconomics which are often not understood.

Economics, Basic Concepts, Demand-Supply-Equilibrium

The quiz tests the basic concepts of demand, supply, and equilibrium in a free market.

Economic Issues and Concepts

This quiz provides a review of the basic microeconomic concepts. Students can test their understanding of major economic issues.

Pricing Strategies

Discussion about various pricing techniques of profit-seeking firms.

Elementary Microeconomics

This quiz reviews the basic concept of supply and demand analysis.