Agicultural Finance Spring Semester 2018 Assignment #4 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. 1. Suppose your Aunt died and provided in her trust that you will receive $5,000.00 four times each year (January, April, July, and October) for the next 10 years Assume an 8% annual interest rate. How much is this worth to you in today's dollars? Show work: Spreadsheet Answer_ 2. Suppose you would like to buy a $40,000 SUV with $5,000 down. The auto company will finance the remaining $35,000 at 3.5% annual interest with monthly payments over the next 6 years. What will your monthly payment be? Show work: Spreadsheet Answer Suppose you owe a credit card company $18,500 and you can afford to pay $450 per month. The card charges you 14.5% annual interest. pay off the credit card? 3. How long will it take to Show work: Spreadsheet Answer A machinery dealer will allow you to pay off your $120,000 tractor loan in 5 equal yearly payments (end of the year) of $27,000 each. What interest rate they charging? 4. are No algebraic answer Spreadsheet Answer (Additional Questions Next Page)