Hello, I need help. I am not sure how to work out these 2 problems on excel. Can anyone help me I am not sure what formulas to use for excel. Thank you!!

7. 8. The income of a typical family in a certain city is currently $150,000 per year. Family finance experts recommend that mortgage payment not exceed 25% of a family's income. Assuming a current mortgage interest is 4.2% compounded monthly for a 30 year mortgage with monthly payments, how large a mortgage can the typical family in that city afford? If you have $750,000 in an annuity paying 4.75% interest compounded monthly, how much can you withdraw each month for 20 years