to compute for I.E( interet Expense)= (Principal*Rate*TIme)/360
to compute for AIP for the next month( sept., oct., Nov.)= Prev. AIP+ nxt month's I.E
to compute for I.E( interet Expense)= (Principal*Rate*TIme)/360
to compute for AIP for the next month( sept., oct., Nov.)= Prev. AIP+ nxt month's I.E
It is unclear where you need help. Are you so new to Excel that you don't know how to write the formulae you have pretty much described in your text above? What do you mean by 'consistent' in your title?
What do you consider to be 'Time'? Is it just 30, since you seem to be assuming a 30 day, 12 month year by your divisor of 360?
Seems like your IE would be something like this in cell I3, =D3*F3/12. Then drag it down for the other payments. The same equation would go into L3, O3, and R3.
AIP would be in cell M3, =J3+L3. Drag it down. Use similar formula for P3 and S3.
Pauley
Pauley
--------
If I helped with your issue, I'd appreciate a rep bump (hit the '*' icon to the bottom left of this post).
in I4, =D4*F4*(G4-A4)/360 copied down
in J4 =J3+I5 copied down
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
basically, i just need a formula for the time. you will use the actual days in the month. Consistent in the way that you can just drag it down
I believe this is what you are looking for...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks