Problem 8. Consider two projects with the following cash flows. Find the interest rate that brings both projects to the same NPV. (Hint: Use Excel Goal Seek). Solve in excel using solver. Year1 Year 2 Year 3 Year4 Project 1 -$1000 $500 $320 $400 Project 2 -$400 $490 $130 $1200
Added by Ashlee F.
Your feedback will help us improve your experience
Sri K and 71 other Intro Stats / AP Statistics educators are ready to help you.
Ask a new question
Labs
Want to see this concept in action?
Explore this concept interactively to see how it behaves as you change inputs.
Key Concepts
Recommended Videos
'Problem #4: For the following cash flows, calculate the Present Worth at an interest rate of 10%_ 12,000 10,000 8,000 000 4,000 Hint; 12,000 10,000 8 000 6,000 12,000 12,000 12,000 12,000 12,000 8, 000 6 000 4,000 000 2,000'
Arun B.
Crenshaw Enterprises has gathered projected cash flows for two projects. Year Project I Project J 0 −$ 197,000 −$ 197,000 1 95,500 72,600 2 87,600 77,800 3 65,200 81,400 4 59,800 87,000 At what interest rate would the company be indifferent between the two projects? Note: Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16. Which project is better if the required return is above this interest rate?
Akash M.
Based on the following cash flow diagram, calculate the equivalent future value at t-8. The interest rate is 5% compounded annually: F8=? $1500 $1300 $1100 $900 $700 Year 0 1 2 3 4 5 6 7 8
Babita K.
Recommended Textbooks
Elementary Statistics a Step by Step Approach
The Practice of Statistics for AP
Introductory Statistics
Transcript
Watch the video solution with this free unlock.
EMAIL
PASSWORD