Hey guys, I'm trying to make an amortization table. But how I'm doing it right now is going to take me forever. Basically, what I'm trying to do is take the Beginning Balance in each row and multiply it by the set monthly interest rate at the top to come up with the monthly interest payment. However, I'm entering the formula for each row in the interest payment rows. The formula is for example: =PRODUCT(B54,D47). Is there a way that I can take this formula and apply it to every row in the interest payment column without having to change the B value (Beginning balance) each time manually? Thank you very much for any help and here's a picture so you get a visual:
