4. John is selling his house and there are currently 2 offers on the table. Nick is offering upfront and Php500,000 semi-annually for the next 10 years, and together with the final Php500,000 payment will be a lumpsum of Joe is offering upfront and Php600,000 semi-annually for the next 10 years, and together with the final Php600,000 payment will be a lumpsum of Assuming funds he receives can be invested at 7% per annum compounded semi-annually, who should John sell his house to? (15 points)