Amortization Schedule Regza What Should The Excel 2007 Formula Be To Calculate Interest In A Amortization Schedule I Am Preparing?

What should the Excel 2007 formula be to calculate interest in a amortization schedule I am preparing? - amortization schedule regza

My interest for the month seems too low. I do not think my formula is correct. My first record is in cell B15 and the interest rate is in cell D4. The formula I used to be my interest for the month = B15 * ($ D $ 4/12/100 calculation).

With this formula for my interest calulates $ 5.83 for the month up to $ 100,000 at an interest rate of 7% with monthly payments of 5 years. HELP.