Posted to microsoft.public.excel.misc

Keeb

Posts: n/a

Payment calculation w/ back interest

I was wondering how I can use the PMT function (or similar) to take into
account unpaid/back interest. There is no interest on the interest so I
can't capitilize it. Any suggestions on how to setup a formula so that I can
figure out a monthly payment for a fixed term? Thanks in advance :)

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Calculate total interest earned on a loan and monthly payment	Matt Stanley	Excel Worksheet Functions	4	May 4th 23 03:42 AM
daily interest	payments	Excel Worksheet Functions	1	February 16th 06 06:47 PM
Formula to calculate cumulative interest	mam	Excel Worksheet Functions	2	January 26th 06 10:06 AM
Calculation Setting in Excel	Stuart Bisset	Excel Discussion (Misc queries)	0	June 17th 05 09:54 AM
calculation of interest between two dates	Arvind Khanna via OfficeKB.com	Excel Worksheet Functions	2	May 26th 05 10:19 AM

All times are GMT +1. The time now is 11:06 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us