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