calculate this problem using excel
Not what you're looking for?
I need to know how to calculate this problem using excel. A model is also on the sheet that can be used as a guide. The numbers in the model have nothing to do with the problem.
---
The Seattle Corporation has been presented with an investment opportunity which will yield end-of-year cash flows of $30,000 per year in Years 1 through 4, $35,000 per year in Years 5 through 9, and $40,000 in Year 10.
The investment will cost the firm $150,000 today, and the firm's cost of capital is 10 percent.
a. What is the payback period, discounted payback period, npv, IRR, and MIRR for this investment?
b. Should the project be accepted or rejected?
---
Purchase this Solution
Solution Summary
This job calculates this problem using excel.
Purchase this Solution
Free BrainMass Quizzes
Organizational Behavior (OB)
The organizational behavior (OB) quiz will help you better understand organizational behavior through the lens of managers including workforce diversity.
Situational Leadership
This quiz will help you better understand Situational Leadership and its theories.
SWOT
This quiz will test your understanding of the SWOT analysis, including terms, concepts, uses, advantages, and process.
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.
Balance Sheet
The Fundamental Classified Balance Sheet. What to know to make it easy.