I need help with this using excel

question 4

3. Assume the homeowner has made the minimum required monthly payments on the mortgage and 5 years have passed. If the homeowner's income has increased and he/she decides to increase the monthly payments to $1500, how many months and years will t take to retire the mortgage? Months Years 4. The rights to Frederico Fellini's cinematic masterpiece "La Strada" are to be auctioned. You forecast that you can collect annual cash flows in the form of royalties, net of taxes, as shown in the table below. At the end of the forecast horizon, you plan to sell the rights in a future auction. You forecast you can get $1,750,000 for the rights, after taxes, at the end of year 5. If your target rate of return is 12%, what is the maximum price you should offer for the rights? Year 2 3 4 5 Annual Cash Flow $350,000 $380,000 $400,000 $450,000 $480,000 Auction Proceeds $1.750.000