DCF, sensitivity analysis, no income taxes
Not what you're looking for?
Landom Corporation is an international manufacturer of fragrances for women. Management at Landom is considering expanding the product line to men's fragrances. From the best estimates of the marketing and production managers, annual sales (all for cash) for this new line is 1,000,000 units at $25 per unit; cash variable cost is $10 per unit; cash fixed costs is $5,000,000 per year. The investment project requires $30,000,000 of cash outflow and has a project life of 5 years.
At the end of the five-year useful life, there will be no terminal disposal value. Asssume all cash flows occur at year-end expect for initial investment amounts. Men's fragrance is a new market for Landom, and management is concerned about the reliability of the estimates. The controller has proposed applying sensitivity analysis to selected factors. Ignore income taxes in your computations. Landom's required rate of return on this project is 14%.
1. Calculate the net present value of this investment proposal.
2. Calculate the effect on the net present value of the following two changes in assumptions. (Treat each item independently on the other)
a. 5% reduction in the selling price
b. 5% increase in the variable cost / unit
3. Discuss how management would use the data developed in requirements 1 and 2 in its consideration of the proposed capital investment.
* Complete in Excel
Purchase this Solution
Solution Summary
This solution provides a complete computation of the given capital budgeting problem formatted in Excel.
Solution Preview
** Please see the attached file for the complete solution response **
Year 0 1 2 3 4 5
Initial outlay -$30,000,000
Selling price $25 $25 $25 $25 $25
Selling units 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000
Sales revenue $25,000,000 $25,000,000 $25,000,000 $25,000,000 $25,000,000
EXPENSES:
Fixed costs $5,000,000 $5,000,000 $5,000,000 $5,000,000 $5,000,000
Variable costs $10,000,000 $10,000,000 $10,000,000 $10,000,000 $10,000,000
Net cash flow -$30,000,000 $10,000,000 $10,000,000 $10,000,000 $10,000,000 $10,000,000
Year Cash flow Discount rate Discount factor Discounted cash ...
Education
- B. Sc., University of Nigeria
- M. Sc., London South Bank University
Recent Feedback
- "Thank you."
- "thank you Chidi Ngene.. if you have any APA references would be great"
- "Thank you so much for your help, your explanations were easy to understand and apply!"
- "are you able to highlight the equations used either on the xlsx or a word doc as to how each graph was formed- overall looks fine i just need help understanding this myself"
- "Chidi Ngene, M. Sc. Was extremely helpful as without the help and guidance I would have failed, but with the help I passed. I still have a lot to learn and in need of the guidance to understand and learn more on the subject. I would recommend Chidi Ngene and BrainMass to anyone that are in need of help. Thank you!!"
Purchase this Solution
Free BrainMass Quizzes
Learning Lean
This quiz will help you understand the basic concepts of Lean.
Managing the Older Worker
This quiz will let you know some of the basics of dealing with older workers. This is increasingly important for managers and human resource workers as many countries are facing an increase in older people in the workforce
Lean your Process
This quiz will help you understand the basic concepts of Lean.
Business Ethics Awareness Strategy
This quiz is designed to assess your current ability for determining the characteristics of ethical behavior. It is essential that leaders, managers, and employees are able to distinguish between positive and negative ethical behavior. The quicker you assess a person's ethical tendency, the awareness empowers you to develop a strategy on how to interact with them.
Organizational Behavior (OB)
The organizational behavior (OB) quiz will help you better understand organizational behavior through the lens of managers including workforce diversity.