1.In cell G7, write a PMT function that returns the weekly payment on a $8,000 loan at an annual rate of 6%. The loan is paid off in 4 years. All payments are made at the end of the period. Each year is 52 weeks.

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 paid off in 10 years. All payments are made at the end of the period.

3. In cell G20, write a PMT function that returns the monthly payment on a $5,000 loan at an annual rate of 7%. The loan is paid off in 2 years. All payments are made at the beginning of the period.