N
name
I'm trying to calculate *annual* principal portion of a *monthly* loa
payments using only one cell. For example, the cell for year one woul
be the sum of ppmt(monthly_interest_rate,i,60,loan_amount) where i i
1-12.
Any thoughts on how this can be done? Is there some sort of loo
function in excel
payments using only one cell. For example, the cell for year one woul
be the sum of ppmt(monthly_interest_rate,i,60,loan_amount) where i i
1-12.
Any thoughts on how this can be done? Is there some sort of loo
function in excel