Information technology, Study Guides, Projects, Research of Internet and Information Access

Download Information technology and more Study Guides, Projects, Research Internet and Information Access in PDF only on Docsity!

2. RATE () FUNCTION =RATE(NPER,PMT,PV, [FV], [TYPE], [GUESS]) NPER 60 Pmt -2027.64 wv 100000 = per D4 ‘RATE 8% Pmt [0s Pv D6 Fy [0 Tyre ol = 0,006666677 Returns the interest rate per period of a loan or an investment. For example, use 6%/4 for quarterly payments at 6% APR. ‘Type isa logical value: payment at the beginning of the period = 1; payment at the end of the period = 0 or omitted. 3. PV () FUNCTION =PV(RATE,NPER,PMT,|[FV],[TYPE]) RATE 8% NPER 60 PMT 2027.64 py 100000 per 04 Pmt 5 Fv 0 Type 0} = 100000.0282 Returns the present value of an investment: the total amount that a series of future payments is worth now. ‘Types a logkal valve: payment at the beginning of the = 1; payment. ‘end of the period = 0 or omitted, Lira] ate | B:Renom Ln isesive ina |ipeanere | CREATE THE INVENTORY SOLUTION 1 :- SOLUTION 2 :-