Subtracting a running Balance

[TW]

I am buying a car and I want to put the payments that i am making on a
worksheet that will automatically subtract my payments from the original
amount, lets say I am paying 5,500 paying 50.00 a week how can i create this
worksheet?

 

[T. Valko]

Here's one way:

A1 = header = Starting Balance
B1 = 5500

A2 = header = Total Paid to Date
B2 = formula: =SUM(B6:B300)

A3 = header = Current Balance
B3 = formula: =B1-B2

A5 = header = Date
B5 = header = Amount Paid

Select cell A6
Goto the menu Window>Freeze Panes

As you make payments and scroll down the sheet your balance will always be
visible on top.