Online Loan calculator/ printable schedule 2 August 2021 at 10:52AM in Loans 6 replies 71 views

Sissychops

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?

Grumpy_chap

What about a simple note book to write down all the payments due and made?

[Deleted User]

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

mcpitman

Deleted_User said:

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....

[Deleted User]

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

mcpitman

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).

[Deleted User]

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