I'm trying to calculate *annual* principal portion of a *monthly* loan
payments using only one cell. For example, the cell for year one would
be the sum of ppmt(monthly_interest_rate,i,60,loan_amount) where i is
1-12.

Any thoughts on how this can be done? Is there some sort of loop
function in excel?


--
name
------------------------------------------------------------------------
name's Profile: http://www.excelforum.com/member.php...o&userid=34115
View this thread: http://www.excelforum.com/showthread...hreadid=557300