Advance Excel
Excel-2013
Format
Loan Amount | Interest | Duration | Method
5,0000 | 10% | 12 | Monthly
Sr.no | Installment | Interest | Total pay | Balance
Formula
01
Installment = Loan Amount / Duration
Interest = Loan Amount x Interest / Duration
Total Pay = Installment + Interest
Balance = Loan Amount – Installment
02
Interest = Balance x Interest / Duration
Balance = Balance – Installment
No comments:
Post a Comment
Please do not enter ant spam link in the comment box.