***solve in Excel, showing cell references

4. An investment scheme pays $10,000 one year from now, $30,000 three years from now $50,000 five years from now. You require 11% return on your money. If you are asked to pay $55,000 for this scheme, will you pay? If you pay $55,000 for the scheme, what is rate of return you will earn