Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel template for daily compound interest varying monthly paymen
Has anyone come across a excell worksheet that can work out daily or monthly
compound interest on a loan with a function for missed or varying monthly payments. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel template for daily compound interest varying monthly paymen
On Dec 17, 11:15 am, Peter wrote:
Has anyone come across a excell worksheet that can work out daily or monthly compound interest on a loan with a function for missed or varying monthly payments. There wouldn't be "a function" per se. But do you really mean that you want a template for an amortization schedule that would allow for missed payments and varying payments? The latter would not be too difficult to incorporate into a properly designed amortization schedule template. The problem is: the ones that I have seen are not "properly" designed. Are you looking for a turn-key solution, or are you willing to build it yourself, with guidance if needed? Moreover, there are additional details of the loan agreement that would have to be incorporated into the amortization schedule. Or would you be satisfied with a "first approximation" that does not take late fees into account? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
suggest excel template to calculate monthly attandence and paymen | Charts and Charting in Excel | |||
How to compound interest daily | Excel Discussion (Misc queries) | |||
Monthly Compound Interest | Excel Discussion (Misc queries) | |||
How do I show monthly compound interest in Excel? | Excel Worksheet Functions | |||
compound interest daily | Excel Discussion (Misc queries) |