Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
anonymous
 
Posts: n/a
Default Loan Amoritization Spreadsheet Issue

Hello,

I have found the Loan Amoritization Excel SS template from Microsoft but it
does not work the way I want it.

I bought a new car and the loan came on my account on 02/02/06 and the next
payment date is 03/15/06. When I use the template...I put in 02/02/06 and
the first payment date is 03/02/06. I want to put in 02/02/06 as when the
loan came on the account then use the first payment date as 03/15/06 and
calculate the interest based on the period of 02/02/06 to 03/15/06 then have
the next payment date as 04/15/06.

If you have this type of spreadsheet available for me...please let me know.
I would love to get a copy of it. I would like to have this for my records.

Chris
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
Loan Schedule with Balloon Payment R0bert Neville Excel Worksheet Functions 7 April 22nd 23 12:08 PM
Excel 2K3: Opening a spreadsheet, also opens book1.xls? Newtek Excel Discussion (Misc queries) 3 July 6th 05 07:56 PM
Excel 2K3: Opening spreadsheet, also opens book1.xls? Newtek Setting up and Configuration of Excel 1 July 6th 05 07:56 PM
paste contents from other spreadsheet JohnT Excel Worksheet Functions 3 February 8th 05 03:30 PM
Applying Existing Password to New Spreadsheet Vic Excel Discussion (Misc queries) 1 January 27th 05 12:37 AM


All times are GMT +1. The time now is 12:19 PM.

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

About Us

"It's about Microsoft Excel"