MoneySavingExpert Chair, Martin Lewis · Editor, Marcus Herbert

# Online Loan calculator/ printable schedule

in Loans
6 replies 71 views
Forumite
1 Post
Newbie
Hi I was wondering if anyone has come across or used any smart resources online for printing out payments/dates/amounts on a sheet. My partner and I have bought a car and we have a bank loan to pay back but he wants to pay weekly as that's how he's paid. I get paid monthly and that's straightforward but I want us both to be paid off on the same end date in 48 months. And I don't really excel with Excel. I did find something, seemed perfect (financial-calculators.com) but a bit worryingly, didn't seem to do anything when I tried to save or print. Not sure if it's a bogus site or not but doesn't have www in the address?

## Replies

• Forumite
12K Posts
Forumite
What about a simple note book to write down all the payments due and made?
• 0 Posts
Newbie
www or not is not an issue, if you're using Chrome it's because they hide the https://www bit - provided it has the padlock it's ok

I hate excel with a passion but it's not difficult to do a really simple balance calculator (I don't know if you were planning on putting payments into a joint bank account perhaps)

If you are going 50/50, split the balance into A1 and C1

B1 would be your partner's contributions
D1 would be your contributions

=sum(A1-B1) in cell A2
=sum(C1-D1) in cell C2

Then just copy the formula down, so A3 should be A2-B1 C3 should be C2-D1 etc
• Forumite
1.3K Posts
Forumite

Then just copy the formula down, so A3 should be A2-B1 C3 should be C2-D1 etc
You will need dollar signs on B1 and D1 if you want the reference to remain static as above (\$B\$1 and \$D\$1).

Otherwise the above would move as
A1-B1   C1-D1
Then when dragged/copied down
A2-B2   C2-D2 etc for each line dragged/copied down.
A3....
A4....
Life isn't about the number of breaths we take, but the moments that take our breath away. Like choking....
• 0 Posts
Newbie
I did say I hated excel

It normally works for me I guess if I do A2-B1, then A3-B1 and then drag it but \$ is useful to know thanks
• Forumite
1.3K Posts
Forumite
No worries, I hate Excel,but get the pleasure of using it every day......

A dollar in front of the letter (\$A1) will "lock" the column as you move formula, in front of the numeric reference (A\$1) will lock the row, both locks the cell the formula reads from (\$A\$1).
Life isn't about the number of breaths we take, but the moments that take our breath away. Like choking....
• 0 Posts
Newbie
Think my most advanced things are getting conditional formatting to work to remind me of certain dates I need doing and the spreadsheet I have for all my BT deals to allow me to tweak the payments to cover them before the 0% runs out but only pay the minimum possible so it is timed well and even then I kept breaking it somehow when I was trying to do running totals of 5 deals over 2 cards and when the cards would be cleared.

The latter would actually work well for the OP scenario of 2x people paying in and working to a fixed date