Please help solve using excel

4. You just received notice that you have won the $30 million Indiana Lottery. You will receive $1,000,000 per year for 30 years with your first payment received today. What is the present value of these payments if the appropriate discount rate is 8% ? 5. You want to buy a new F150 electric truck for $50,000, and the finance office at the dealership has quoted you a 6% loan for 60 months to buy the truck, your trade-in allowance is $10,000. What will your monthly payment be if the first payment is due at the end the month