How to Create LOAN EMI Calculator in Excel | MS Excel Tutorial
HTML-код
- Опубликовано: 22 сен 2022
- #excel #excelmap #macros #vba #exceltutorial #exceltricks #exceltricks
This video is How to do LOAN EMI Calculator in Excel by Excel Map Srinivas Reddy.
EMI - =-PMT(B5/12,B4,B3)
"Monthly Payment" =$E$4
"Beginning Balance" =B3 =C8-D8
"Principal Payment" =-PPMT($B$5/12,A8,$B$4,$B$3)
"Interest Payment" =-IPMT($B$5/12,A8,$B$4,$B$3)
"Ending Balance" =C9
Follow Us on Instagram: srinivas_excelmap