Work problems 1 -4 with your calculator, using the algebra equations if possible (show work), and using the finance function available in your spreadsheet. Prove to us that you did it in the spreadsheet. Suppose your Uncle died and provided in his trust that you will receive $3,700.00 at the end of each QUARTER for the next 15 years. Assume you can earn 7.5% annual interest. How much is this worth to you in today's dollars? 1. Spreadsheet Answer Show work: 2. Suppose you would like to buy a $35,000 Pickup with $4,000 down. The truck company will finance the remaining $31,000 at 3.5 % annual interest with monthly payments over the next 5 years. What will your monthly payment be? Spreadsheet Answer Show work: Suppose you owe a credit card company $22,500 and you can afford to pay $400 per month. The card charges you 16.5 % annual interest. How long will it take to pay off the credit card? 3. Spreadsheet Answer Show work: A machinery dealer will allow you to pay off your $250,000 combine loan in 5 equal yearly payments (end of the year) of $60,000 each. What interest rate are they charging? 4. Spreadsheet Answer No algebraic