Please explain how to use equations and not excel!!

Your dream is coming true! You are about to complete the purchase of your first home. To do so, you will borrow $100,000 from a savings and loan association that requires an interest rate of 7.00% on your loan. To simplify your workload, assume that you will repay your mortgage loan over the next four years by making annual payments at the end of each year. Complete the following loan amortization table by selecting the correct answers: Year BeginningAmount Payment Interest Repaymentof Principal EndingBalance 1 $100,000 2 3 4