1. In cell G7, write a PMT function that returns the weekly payment on a $8,000 ioan at an annual rate of 685 . The loan is paid off in 4 vears. All payments are made at the end of the period. Each vear is 52 werks. 2. In cell G14, write a PMT function that returns the annual payment on a $6,5000 loan at an annual rate of 5%. The loan is pald off in 10 years. All payments are made at the end of the period. 3. In cell 620, write a PMT tunction that returns the monthly payment on a $5,000 loan at an annual rate of 7%. The loan is paid off in 2 vears. All payments are made at the beginning of the period