Purchase Solution

# Capital Budgeting : NPW and IRR methods

Not what you're looking for?

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.

##### 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!"

##### 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.