Need someone to help me figure out how to enter values with formulas for each question

Daniel and Jan agreed to pay $560,000 for a four-bedroom colonial bome in Waltham, Massachusetts, with a $60,000 down payment. They have a 30 -year mortgage at a fixed rate of 6.00%. Required: Please use the above information and the provided Amortization Chart to answer the below questions: Note: Use cells A4 to B7 from the given information to complete this question. Students. The sctatchpad area is for you to do any additional work you need to solve this question or can be used to show your work. Nothing in this atea will be graded, but it will be submitted with your assignment