Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi,
I am a cabinet maker who needs to borrow 30,000 from a friend because I tweaked my back for a few weeks and now have to catch up for the next few months. I want to be able to make a worksheet that allows me to give him a known interest rate and then apply the rest to the principal. I would love it if I could do it on any day of the month and not have it tied to a monthly period. It is essentially exactly what credit cards do. Ideally, it would show in columns what was paid, what day it was paid, how much went to interest for that month, how much went to principal, and how much principal remains. Incidentally, this would be great for just capital borrowing in general. The lender gets a fixed return, but I can write checks willy nilly. As an added tweak (just like the credit cards) if I don't make the interest in a month, I would love for the unmet interest to roll to the next month. Any ideas? Wouldn't it be cool if the lender could access this info on my webpage via a password! PS If anyone could set this up I would be willing to pay something via check or paypal. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Private Revolving Loans | Excel Discussion (Misc queries) | |||
Browse File for Mac | Excel Discussion (Misc queries) | |||
More than 3 conditional formats? | Excel Discussion (Misc queries) | |||
Format cells with a formula (7 conditions). | Excel Discussion (Misc queries) | |||
more than 3 conditions in conditional formatting - possible? | Excel Discussion (Misc queries) |