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?