Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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) | |||
Private Revolving Loans | Excel Discussion (Misc queries) | |||
Compound interest and repayments on personal loan | Excel Discussion (Misc queries) | |||
Illinois Personal Information Protection Act | Excel Worksheet Functions | |||
Personal Macro Workboos | Excel Discussion (Misc queries) |