Qalab bilaash ah

Xisaabiyaha amaahda: lacag-bixinta bisha iyo jadwalka

Xisaabi lacag-bixinta bisha ee amaah bangi, amaah guri, amaah baabuur ama amaah ganacsi, wadarta dulsaarka iyo jadwalka lacag-bixinta oo dhan oo leh taariikhaha Gregorian iyo Itoobiya. U soo deji CSV Excel ahaan.

Sida loo xisaabiyo

• Lacag-bixinta bisha = P × r ÷ (1 − (1 + r)^−n), r waa heerka bisha, n waa tirada bilaha
• Bil kasta dulsaarku waa hadhaaga × r; inta kale ee lacag-bixintu waxay bixisaa amaahda
• Lacag-bixinta ugu dambeysa waa la hagaajiyaa si hadhaagu si sax ah eber u noqdo

Isbarbar dhig dalabyada

Beddel heerka ama muddada si aad u aragto inta dulsaar ee amaah gaaban badbaadiso. Jadwalku wuxuu ku furmaa Excel ama ERP-ga ELIF.

Waa immisa lacag-bixinta bisha ee ETB 1,000,000 heerka 15% 5 sano?

Qiyaastii ETB 23,790 bishii, iyo qiyaastii ETB 427,396 dulsaar 60-ka lacag-bixin.

Ma ku jiraan khidmadaha bangiga?

Maya. Wuxuu muujiyaa asalka iyo dulsaarka oo keliya; weydii bangigaaga khidmadaha adeegga, caymiska iyo shuruudaha kale.

Ma ku arki karaa taariikhaha kalandarka Itoobiya?

Haa. Lacag-bixin kastaa waxay sidoo kale muujisaa taariikhdeeda Itoobiya, CSV-guna labadaba wuu leeyahay.

Amaahda iyo lacag-bixinta xisaabaadkaaga