Need help with 3-20

3-4 After years of working in the oil patch you have managed to scrape together $1 million you are willing to invest in a drilling venture. Using all your knowledge gained from years of experience you have made the following estimates of operating income and investment amounts and timing. What is the maximum amount of money you expect to have to invest in this deal and when will that happen? When do you anticipate payout will occur? Plot the cumulative net cash flow curve Oper Year Income Invest MS MS 0 20 0 80 0 500 140 100 2 4 126 5 113 6 7 92 83 75 9 10 3-20.) Calculate the modified IRR for problem 4 assuming your average investment opportunity rate is 3%/annum. Use mid period discounting