I am pretty much a novice Excel user and am trying to make a loan amortization schedule for a few Realtors. What I am looking to do is have column B display interest rates vertically, column 2 display loan amounts horizontally, and the corresponding inner columns display the resulting payments. I would like to do this with 2 different spreadsheets...a standard 360 month amortization and an interest only scenario. What do I need to do to get the boxes to display the payments automatically when I enter the rate and loan amount into the columns?
For Example:
____$100,000
5% - $536.82
Bookmarks