Cash flow scenarios NPV and IRR
Not what you're looking for?
Initial investment outlay of $20 million for equipment only
Project and equipment life: 5 years
Sales projected to be $12 million per for 5 years
Assume gross margin of 50% (exclusive of depreciation)
Depreciation: straight-line for tax purposes
Selling, general and administrative expenses: 10% of sales
Tax rate: 35%
Solve for NPV and IRR.
Purchase this Solution
Solution Summary
The tutorial with instructional notes is attached in excel. Click in cells to see computation. You do not specify a required rate of return or cost of capital. I assumed 8% but the model will update if you change this rate (see yellow cell).
Education
- BSc, University of Virginia
- MSc, University of Virginia
- PhD, Georgia State University
Recent Feedback
- "hey just wanted to know if you used 0% for the risk free rate and if you didn't if you could adjust it please and thank you "
- "Thank, this is more clear to me now."
- "Awesome job! "
- "ty"
- "Great Analysis, thank you so much"
Purchase this Solution
Free BrainMass Quizzes
Basics of corporate finance
These questions will test you on your knowledge of finance.
Academic Reading and Writing: Critical Thinking
Importance of Critical Thinking
Social Media: Pinterest
This quiz introduces basic concepts of Pinterest social media
Marketing Research and Forecasting
The following quiz will assess your ability to identify steps in the marketing research process. Understanding this information will provide fundamental knowledge related to marketing research.
Understanding Management
This quiz will help you understand the dimensions of employee diversity as well as how to manage a culturally diverse workforce.