We'd like to remind Forumites to please avoid political debate on the Forum... Read More »
📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!
Online Loan calculator/ printable schedule
Options

Sissychops
Posts: 1 Newbie
in Loans
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?
0
Comments
-
What about a simple note book to write down all the payments due and made?0
-
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 etc0 -
Deleted_User said:
Then just copy the formula down, so A3 should be A2-B1 C3 should be C2-D1 etc
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....1 -
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 thanks1 -
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 -
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 date0
Confirm your email address to Create Threads and Reply

Categories
- All Categories
- 351.2K Banking & Borrowing
- 253.2K Reduce Debt & Boost Income
- 453.7K Spending & Discounts
- 244.1K Work, Benefits & Business
- 599.2K Mortgages, Homes & Bills
- 177K Life & Family
- 257.5K Travel & Transport
- 1.5M Hobbies & Leisure
- 16.1K Discuss & Feedback
- 37.6K Read-Only Boards