Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Barnacle Bill
 
Posts: n/a
Default How do I calculate loan balances when payments are missed?

I would like to have a template for a Loan Amortization Schedule that would
allow manual entry of the payment date and amount (if any). The program would
recalculate the balance accordingly.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Miguel Zapico
 
Posts: n/a
Default How do I calculate loan balances when payments are missed?

You can search office online. This is one set of results with the term "loan"
http://office.microsoft.com/en-us/re...=TC&Query=loan

"Barnacle Bill" wrote:

I would like to have a template for a Loan Amortization Schedule that would
allow manual entry of the payment date and amount (if any). The program would
recalculate the balance accordingly.

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Barnacle Bill
 
Posts: n/a
Default How do I calculate loan balances when payments are missed?

I need to restate my request. I need a template for a loan amortization
schedule that will allow manual entry of the payment date and amount (if any)
when the actual date of payment or payment amount is DIFFERENT than the
schedule provides. If a payment is made three months late, for example, the
program would recalculate the additional interest and add it to the loan
balance. Sorry for the inconvenience!
"Barnacle Bill" wrote:

I would like to have a template for a Loan Amortization Schedule that would
allow manual entry of the payment date and amount (if any). The program would
recalculate the balance accordingly.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Add insurance to loan payments VRhodes Excel Worksheet Functions 2 December 29th 05 09:42 PM
WANTED: Excel template for loan payment record with random/irregular payments cassidy Excel Discussion (Misc queries) 1 July 24th 05 01:09 AM
How do you set up a loan using the loan calculator w/odd payments. rad Excel Discussion (Misc queries) 0 February 3rd 05 06:05 PM
How to calculate total interest on 12 month loan with early payments Fred Smith Excel Worksheet Functions 0 January 6th 05 02:33 AM
Loan amortization schedule with bi-monthly payments McCarthy_MF Excel Worksheet Functions 0 December 9th 04 09:45 PM


All times are GMT +1. The time now is 04:02 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"