Calculating Payback Period, IRR and NPV fo Investments
Not what you're looking for?
Problems:
1). You are a real estate agent thinking of placing a sign advertising your services at a local bus stop. The sign will cost $ 5000 and will be posted for one year. You expect that it will generate additional revenue of $ 500 per month. What is the payback period?
2). Innovation Company is thinking about marketing a new software product. Upfront costs to market and develop the product are $5 million. The product is expected to generate profits of $ 1 million per year for ten years. The company will have to provide product support expected to cost $ 100,000 per year in perpetuity for 10 years. Assume all profits and expenses occur at the end of the year. What is the NPV of this investment if the cost of capital is 6 %? Should the firm under-take the project? Repeat the analysis for discount rates of 2 % and 11 %.
3). You own a coal mining company and are considering opening a new mine. The mine itself will cost $ 120 million to open. If this money is spent immediately, the mine will generate $ 20 million for the next ten years. After that, the coal will run out and the site must be cleaned and maintained at environmental standards. The cleaning and maintenance are expected to cost $ 2 million per year in perpetuity for 10 years. What does the IRR rule say about whether you should accept this opportunity? If the cost of capital is 8 %, what does the NPV rule say?
Purchase this Solution
Solution Summary
There are three problems. Solution to these problems demonstrate the steps to calculate Payback period, Internal rate of retrun and net present value for given investment proposals.
Solution Preview
Please refer attached Excel file for better clarity of tables and formulas.
Solutions:
1). You are a real estate agent thinking of placing a sign advertising your services at a
local bus stop. The sign will cost $ 5000 and will be posted for one year. You expect that
it will generate additional revenue of $ 500 per month. What is the payback period?
Solution:
Since additional revenue generation is same throughout the teure
Pay back period = Initial cost/ periodic net cash inflow=5000/50=10 months
2). Innovation Company is thinking about marketing a new software product. Upfront
costs to market and develop the product are $5 million. The product is expected to
generate profits of $ 1 million per year for ten years. The company will have to provide
product support expected to cost $ 100,000 per year in perpetuity for 10 years. Assume
all profits and expenses occur at the end of the year.
What is the NPV of this investment if the cost of capital is 6 %? Should the firm
under-take the project? Repeat the analysis for discount rates of 2 % and 11 %.
Initial outlay=-5 million
Net annual cash inflow=1,000,000-100,000= 0.9million
PV factor of ordinary annuity for period = 10 year and discout rate=6%
PV factor =7.3601
PV of inflows = PV factor*net cash inflow=6.62 million
Net Present Value=Initial outlay+PV of net cash flows
NPV=-5+6.62=1.62 ...
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
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.
Academic Reading and Writing: Critical Thinking
Importance of Critical Thinking
SWOT
This quiz will test your understanding of the SWOT analysis, including terms, concepts, uses, advantages, and process.
Business Processes
This quiz is intended to help business students better understand business processes, including those related to manufacturing and marketing. The questions focus on terms used to describe business processes and marketing activities.