Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default MORTGAGES and ACTUAL/360

I am trying to calculate (commercial) mortgages where the interest it
calculated on actual/360 basis. This keeps the monthly payments the same as
the regular PMT function, but with actual/360 it 'charges' 5 extra days
interest, meaning you pay the same but within your mortgage payments you are
paying 5 extra days interest and therefore less principal.

The monthly payments are the same as regular, but the balance at the end of
the term (on baloon mortgages, for example 10-year term on a 30-eyar
amortization) is higher with actual/360.

Question is, I need an elegant way to calculate that balance at the end of
the actual/360 term.
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
xnpv with actual/360 Anand Excel Worksheet Functions 1 January 19th 06 04:18 AM


All times are GMT +1. The time now is 12:18 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"