Hey all,

I've searched this site and can't find the answer I'm looking for so I need help. I'm building a spreadsheet that shows loan balances. I need a formula(s) that will return what I'm looking for.

Ex.

C4 Loan Amount ($30,000)
D4 Interest (3%)
E4 Total # of Payments (60)
F4 January (amount of payment)
G4 February
Etc. ... (thru December)
R4 Balance This cell always reflects the current balance!

I'm thinking I might need to have formulas somewhere else on the sheet and then have the cells reflect the results