show excel formulas.

ix) You have won a prize which promises to pay you both $200,000 five years from now and $200,000 seven years from now. How much is the prize worth today if the interest rate is 9% ? v) You are looking to purchase a house. The house costs $400,000. Your mortgage broker says that you can borrow 100% of the purchase price ( 0% down payment) and make monthly payments of $3,000 for the next 360 months to pay back the loan. What is the monthly interest rate that the mortgage broker is offering in percent? (Please show three decimal places) You have $100,000 to deposit today. You would like to withdraw $70,000 four years from now and then the rest of the money ten years from today. How much can you withdraw in Your broker has offered you an investment vehicle which will pay you (or your descendants) $90,000 per year forever with the first payment coming one year from today. If the interest rate is 6%, how much is the investment vehicle worth to you today