Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
A previous poster explained what I also need; there were no responses,
so I thought I would try again. Does anyone know of an Excel template--or a small stand-alone program--that will calculate the interest/principal breakdown when payments are varied in amount and frequency? Free or low-cost, please. I need one that will work on my Mac/Office 2004. I will need to print out periodic reports. Here is the way the previous poster described it: "Excel template: Loan Amortization for random/irregular payments, figures days between payment dates. I have a loan with a variable beginning balance and irregular payments with annual large payment. (based on collections) Would like to enter payment and date. then Excel would figure days since last payment, interest amount, principal amount, Ending Principal balance. And total interest paid, total pricipal paid If I change the starting principal, excel would recalculate all entries." Thanks very much. |
#2
![]() |
|||
|
|||
![]()
Microsoft offers this template
http://office.microsoft.com/en-us/te...xIn stalled=1 ....which you could alter to do the things you need. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Where is the Template Wizard with Data Tracking Excel 2003? | Excel Discussion (Misc queries) | |||
Merging data from an excel worksheet into an excel template | Excel Worksheet Functions | |||
Where is the template wizard add-in download for excel 2003 stude. | Excel Discussion (Misc queries) | |||
Does the add in Template Wizard exist for Excel 2003 | Excel Discussion (Misc queries) | |||
How do I save a record from an excel template to a database in a . | Excel Discussion (Misc queries) |