1 / 3

FUNKCIJA I PMT (Interest Payment )

FUNKCIJA I PMT (Interest Payment ) Funkcija I PMT izračunava interes (kamatu) za ratu kredita(otplata glavnice + kamata = anuitet). Sintaksa funkcije I PMT je: = IPMT ( rate ; per;nper ; pv ; fv ;type) gdje: - Rate - kamatne stopa na kredit

roman
Download Presentation

FUNKCIJA I PMT (Interest Payment )

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. FUNKCIJA IPMT • (Interest Payment ) • Funkcija IPMTizračunava interes (kamatu) za ratukredita(otplata glavnice + kamata = anuitet)

  2. Sintaksa funkcije IPMT je:= IPMT(rate;per;nper;pv;fv;type) gdje: -Rate- kamatne stopa na kredit - Per– period za koji želite da izračunate kamatu ( mora biti u rasponu od 1 - Nper

  3. Nper- ukupan broj perioda otplate kredita (ukupan broj rata kredita) • Pv- sadašnja vrijednost, odnosno ukupan iznos sadašnje vrijednosti niza budućih uplata, (Glavnica) • Fv - je buduća vrijednost ili saldo koji želite postićinakon zadnje uplate. Ako je FV izostavljen, pretpostavlja se da je 0 (nula), to jest, buduća vrijednost kredita je 0.

More Related