| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Loan Table templates allowing for payments in advance
Is there a loan amortitization template to allow for payments in advance? The
templates I have come across seem to calculate in arrears. I use Microsoft Office Excel 2003 Thank you |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Loan Table templates allowing for payments in advance
You can easily adjust for payments in advance. If you borrow $100,000 with
payments (in advance) of $2500/month, you've really borrowed only $97,500. So simply deduct your first payment from the principal, then use the template. Regards, Fred. "emc" wrote in message ... Is there a loan amortitization template to allow for payments in advance? The templates I have come across seem to calculate in arrears. I use Microsoft Office Excel 2003 Thank you |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Loan Payments P/Yr. | Excel Worksheet Functions | |||
| loan payments | Excel Worksheet Functions | |||
| 30-yr Amortization allowing 26 payments per year/780 lines vs 360 | Excel Worksheet Functions | |||
| how do I include advance payments in the PMT function | Excel Worksheet Functions | |||
| How do you set up a loan using the loan calculator w/odd payments. | Excel Discussion (Misc queries) | |||
Hybrid Mode
