Womaashshu assiishsha gafa mitte
Kuni fuuli LibreOffice Calcshallagote womaashshu assiishsha amadino.
ACCRINT
Yannate baatooshshuwa kaimi giddo afi'noonni qallo shallaganno.
Ganallo
ACCRINT(Haja; FirstInterest; safaro; Bikko; Par; Marro higa; Xinta)
Hajo agarooshsheho hajote barraati.
FirstInterest (required) is the first interest date of the security.
Settlement (required) is the date at which the interest accrued up until then is to be calculated.
Bikko dirunnita shiimiidi qallo bikkaati (coupon qollote bikkoti)
Gama agarooshsheho gama barraati.
Kiiro dirunni qalloote baatooshshuwa kiirooti (1, 2 woy 4).
Lawishsha
Agarooshshu hajaminohu 2001-02-28. Umi qallo 2001-08-31. Safarote barri 2001-05-01. Bikko 0.1 woy 10% nna Par is 1000 womaashshu bikkaati. Qallo dirunni lameenge baantiro(marro higa 2). Xintu US metede (0). Mageeshshi qallo afi'nanni?
=ACCRINT("2001-02-28";"2001-08-31";"2001-05-01";0.1;1000;2;0) returns 16.94444.
ACCRINTM
mitto kubbate baatooshshuwa kaimi giddo afi'noonni qallo shallaganno.
Ganallo
ACCRINTM(Hajo; Safaro; Bikka; Gama; Xinta)
Hajo agarooshsheho hajote barraati.
Settlement (required) is the date at which the interest accrued up until then is to be calculated.
Bikko dirunnita shiimiidi qallo bikkaati (coupon qollote bikkoti)
Gama agarooshsheho gama barraati.
Lawishsha
Agarooshshsu hajaminohu 2001-04-01 barrinni hajamino. Keeshshanno yanna 2001-06-15. Bikko 0.1 woy 1o% nna gamu 1000 womaashshu bikkooti. Barru/diru xintu shallago barru taashsho (3). Qallo mageeshsha ikkitanno?
=ACCRINTM("2001-04-01";"2001-06-15";0.1;1000;3) returns 20.54795.
AMORDEGRC
Gumulote yannara ajanno baatooshshi gede xeishshu geeshsha shallaganno. AMORLINC baxxanno, xeishshu hanqafaanoumo dandiitino xe'anno heeshsho kowiicho horoonsidhino.
Ganallo
AMORDEGRC(Cost; DatePurchased; FirstPeriod; Jaddotenni gatisa; Yanna; Bikka; Xinta)
Fulo uduunnu hidho fulubbati.
DatePurchased uduunnu afi'ni barraati.
FirstPeriod is the end date of the first settlement period.
Salvage is the salvage value of the capital asset at the end of the depreciable life.
Period is the settlement period to be considered.
Bikko xeishshu bikkooti.
AMORLINC
Safaru yannara shiimiidi baatooshshi gede xeishshu geeshsha shallaganno . Womaashshu uduunni safarote yanna giddo hiraminoha ikkiro, xeishshaho taalleenyu geeshshi hedote giddora eino.
Ganallo
AMORLINC(Fulo; DatePurchased; FirstPeriod; Jaddotenni gatisa; Yanna; Bikka; Xinta)
Fulo yaa uduunnu hidho fulubbati.
DatePurchased uduunnu afi'ni barraati.
FirstPeriod is the end date of the first settlement period.
Salvage is the salvage value of the capital asset at the end of the depreciable life.
Period is the settlement period to be considered.
Bikko xeishshu bikkooti.
DB
Shallagote xe'ne hayyo horoonsiratennibaxxitino yannara uduunnichu xe'ne qolanno.
Xeishshu hanafora jawiidi xeishshi hornyo afirate hasirittoha ikkiro (shiimiidi xeishshira gurchu garinni) konni gari xeishsha horoonsiri. Xeishshu hornyo xeishsha umi waaginni xeinohunni mitte mittente xeishshu yanna garinni ajanno.
Ganallo
DB(waaga; xe'ote gedensiidi waaga; Heeshsho; Yanna; Agana)
Waagu uduunnichuha hanafote waagaati.
Xeishshu hornyo goofimarchu xeishshira uduunnichu hornyooti.
Life defines the period over which an asset is depreciated.
Period is the length of each period. The length must be entered in the same date unit as the depreciation period.
Month (optional) denotes the number of months for the first year of depreciation. If an entry is not defined, 12 is used as the default.
Lawishsha
Komipiyuuterete amuraatihu hanafote waagi 25,000 womaashshi aganunni 3 dirranni xeanno. Xe'nete goofimarchi hornyo 1,000 birraati. Mitte yanna 30 barruuwaati.
=DB(25000;1000;36;1;6) = 1,075.00 currency units
Komipiyuterete amuraatihu gumulantino xeishshi 1,075.00 birraati.
DDB
Shallagote xe'ne hayyo horoonsiratennibaxxitino yannara uduunnichu xe'ne qolanno.
Jawiidi kaimu xe'ne hornyoshiimiidi xe'nera gurchote gede shiqishittoha ikkiro xe'ote konne suude horoonsiri. Xe'nete hornyo mitte mittente yannara shiima ikkitanno nnaduucha wote uduunnichu hirrihu gedensaanni harancho yanna giddo ba"annohura kaa'litanno (lawishshaho, kaameella, komipiyuuterra). Ballo wodanchi tenne shallago garinni maxaafu hornyi horontanni zeero di"iillanno.
Ganallo
DDB(waaga; xe'ote gedensiidi waaga; Heeshsho; Yanna; Ikkito)
Waagu uduunnichuha hanafote waagaati.
Xeishshu hornyo goofimarchu xeishshira uduunnichu hornyooti.
Life is the number of periods (for example, years or months) defining how long the asset is to be used.
Period states the period for which the value is to be calculated.
Factor (optional) is the factor by which depreciation decreases. If a value is not entered, the default is factor 2.
Lawishsha
Komipiyuuterete amuraatihu hanafote waagi 75,000 womaashshi aganunni 5 dirranni xeanno. Hornyo xe'nete goofimarchira 1 birraati. Ikkito 2.
=DDB(75000;1;60;12;2) = 1,721.81 currency units. Therefore, the double-declining depreciation in the twelfth month after purchase is 1,721.81 currency units.
DISC
barru hoshshuwa (xeishshu) agarooshshe perecentejete garinni shallaganno.
Ganallo
DISC("safaro"; "Keeshshanno barra"; waaga; xibbu hornyo; kaima)
Hidhote barra agarooshshe hidhini barraati.
Keeshshanno barra agarooshshu keeshshanno (ba"anno)barraati.
Waagu hornyohote agarooshshi 100 womaashshu bikki waagaati (hidhate waagaati)
Hornyo 100 womaashshi bikko hornyo waagaati.
Lawishsha
Agarooshshu hiraminohu 2001-01-25 barrinniiti; keeshshsanno barri 2001-11-15. Waagu (hirote waagi) 97, xe'nete hornyo 100. Barru taashsho shallago horoonsiratenni (xinta 3) safaro (xe'ne) mageeshshaati?
=DISC("2001-01-25";"2001-11-15";97;100;3) returns about 0.0372 or 3.72 per cent.
DURATION_ADD
dirrate giddo murantino qallote agarooshshiha soorrantino keeshsho shallaganno.
Ganallo
DURATION_ADD("Safaro"; "Keeshshanno barra"; coupon; guma; marro higa; kaima)
Hidhote barra agarooshshe hidhini barraati.
Keeshshanno barra agarooshshu keeshshanno (ba"anno)barraati.
Coupon is the annual coupon interest rate (nominal rate of interest)
Gumu agarooshsheho diru gumaati.
Kiiro dirunni qalloote baatooshshuwa kiirooti (1, 2 woy 4).
Lawishsha
Agarooshshu hiraminohu 2001-01-01; keeshshanno barri 2006-01-01. Qallote shiimiidi bikko 8%. Gumu 9.0%. Qallo bocu dirinni (dirunni 2). Barru qallote taashsho shallago horoonsiratenni (kaima 3) soorrantino keeshsho mageeshsha seeddanno?
=DURATION_ADD("2001-01-01";"2006-01-01";0.08;0.09;2;3)
EFFECTIVE
Yannate goofimrchi qallora fixxantino diru qalloote bikka qolanno.
Goofimarchu qallo yaa shallagote yanna goofimarchi qallote geeshshaati. Gumaame qallo baatooshshu kiiro garinni lexxitanno. Wolu garinni, duucha wote qallo baantannihu yannate garinniiti (lawishshaho, aganunni woy bocu boci dirinni) shallagote yanna goofate albaanni.
Ganallo
EFFECTIVE(Gof; P)
Gof goofimarchu qallooti.
NPerY diru giddo qallote baatooshshuwa kiirooti.
Lawishsha
Dirunniti goofimarchu qallo bikka 9.75% ikkituro nna shoole qalloote yannuwa tiranturo, taalo qallote bikka mageeshaati (gumaame bikko)?
=EFFECTIVE(9.75%;4) = 10.11% The annual effective rate is therefore 10.11%.
EFFECT_ADD
dirunnita shiimiidi qallo bikko gumaame bikkonna diru giddo qallote baatooshshuwa kaiminni shallaganno.
Ganallo
EFFECT_ADD(NominalRate; NPerY)
Bikko qallote diru bikkooti.
NPerY diru giddo qallote baatooshshuwa kiirooti.
Lawishsha
Goofimarchu bikkonna bocu boci baatooshshi 5.25% nkiro dirunniti gumaame qallote bikko mageeshshaati.
=NOMINAL_ADD(5.3543%;4) 0.0525 woy 5.25% qolanno.
IRR
Investimeentete giddoyidi qolo bikko shallaganno. Hornyuwa uurrinshu yanna fanfenni woxu du'namme riqibbanno ajaa ajiro mitte hornyo neegaatiive (baatooshshuwa), nna ajaa ajiro mitte hornyo neegaatiive (eo) ikka noose.
If the payments take place at irregular intervals, use the XIRR function.
Ganallo
IRR(Hornyuwa; Hedo)
Values represents an array containing the values.
Guess (optional) is the estimated value. An iterative method is used to calculate the internal rate of return. If you can provide only few values, you should provide an initial guess to enable the iteration.
Lawishsha
Hedote hundaanni bisiccote amadubba A1=-10000, A2=3500, A3=7600 nna A4=1000, afirimalu =IRR(A1:A4) guma 11,33% aanno.
Because of the iterative method used, it is possible for IRR to fail and return Error 523, with "Error: Calculation does not converge" in the status bar. In that case, try another value for Guess.
ISPMT
sorrantinokki borreesso bayisiishshubba qallubba deerra shallaganno.
Ganallo
ISPMT(Bikko; Yanna; TotalPeriods; Investe)
Bikko yannate qallote bikkaati.
Period is the number of installments for calculation of interest.
TotalPeriods is the total number of installment periods.
Investe investimeentete geeshshaati.
Lawishsha
Asalu geeshshi 120,000 birra ikke lamu-diri yannanni nna aganu bayisiishsha, diru qallo bikki 12% 1.5 diri gedensaanni qallote bikki shiqino.
=ISPMT(1%;18;24;120000) = -300 currency units. The monthly interest after 1.5 years amounts to 300 currency units.
PV
uurrinshu baatooshshuwa aantewii gumi investimeentete xaa hornyo qolanno.
Konne assiishsha techo qixxisantino bikkonni investe ikkara hasi'nanni geeshsha , baxxino geeshsha adhate, dirunniha, baxxitino kiiro yannuwa aleenni shallagate horoonsiri. Qolteno yanna goofuhu gedensaanni mageeshshi womaashshi gatinoro gumula dandaatto. Hanafote woy jeefote yanna baataminoro bada dandaatto.
Hakkuri hornyuwa kiirote, shallagote handaarra woy maqishshuwate gede ei. Ikkiro, Lawishshaho, qallo dirunni 8% baantiro, kayinni agana yannakki gede horoonsira hasirittoro, Bikko nna LibreOffice hunda Calc umi loosaanchinni shallagate 8%/12 ei.
Ganallo
PV(Bikko; NPer; Pmt; FV; Dana)
Bikko yannate giddo tirantino qallote bikkaati.
NPer is the total number of periods (payment period).
Pmt yannate garinni baatamino uurrishu baatooshsheeti.
FV (optional) defines the future value remaining after the final installment has been made.
Type (optional) denotes due date for payments. Type = 1 means due at the beginning of a period and Type = 0 (default) means due at the end of the period.
In the LibreOffice Calc functions, parameters marked as "optional" can be left out only when no parameter follows. For example, in a function with four parameters, where the last two parameters are marked as "optional", you can leave out parameter 4 or parameters 3 and 4, but you cannot leave out parameter 3 alone.
Lawishsha
Aganu aganunni 500 womaashsha baantiro nna diru qallote bikki 8% ikkiro investimeentete kaimu hornyi me'eho? Baatooshshu yanna 48 aganna nna baatooshshu yanna goofimarchira 20,000 womaashshi gatiro.
=PV(8%/12;48;500;20000) = -35,019.37 currency units. Under the named conditions, you must deposit 35,019.37 currency units today, if you want to receive 500 currency units per month for 48 months and have 20,000 currency units left over at the end. Cross-checking shows that 48 x 500 currency units + 20,000 currency units = 44,000 currency units. The difference between this amount and the 35,000 currency units deposited represents the interest paid.
Hornyuwate darga maqishshuwa afirimalu giddora eessittoro, "ikkiro-aantete" ayee kiirono shallaga dandaatto. Ballo qaagi: soorrantannokki maqishshuwa co'itte maqishuwa gede tirantino. Konni dani lawishshuwa xeishshu assiishshi hundaanni heedhanno.
RECEIVED
Uyinoonni yanna bixxille aana qixxisamme-qallo agarooshshira adhamino geeshsha shallaganno .
Ganallo
RECEIVED("Safaro"; "Keeshshanno yanna"; Investimeente; Xe'o; Xinta)
Hidhote barra agarooshshe hidhini barraati.
Keeshshanno barra agarooshshu keeshshanno (ba"anno)barraati.
Investimeent hidhote ledooti.
xeishsha agarooshshu waagi hajajo aaninni xibbunni xeisha.
Lawishsha
Safarote barr: Ammajje 15 1999, keeshshanno barri: Onkoleessa 15 1999, investimeentete ledo: 1000 womaashshu bikko, xe'o: 5.75 saantete, xintinni: barru taashsho/360 = 2.
Keeshshote barri giddo adhinoonni geeshsha aananno garinni shallagamino:
=RECEIVED("1999-02-15";"1999-05-15";1000;0.0575;2) returns 1014.420266.
SYD
Shallagote xe'ne xeishshuwa bikko qolanno.
Uduunnichunnita mitte yanna xaphooma xeishshira xe'nete geeshsha shallagate konne assiishsha horoonsiri. Shallagote xe'ne xeishshi xe'nete geeshsha qixxisammete ledonniyannatenni yanna xeisanno.
Ganallo
SYD(waaga; xe'ote gedensiidi waaga; Heeshsho; Yanna)
Waagu uduunnichuha hanafote waagaati.
Xeishshu hornyo goofimarchu xeishshira uduunnichu hornyooti.
Life is the period fixing the time span over which an asset is depreciated.
Period defines the period for which the depreciation is to be calculated.
Lawishsha
Vidiyote amuraati kaimaho 50,000 womaashshi dirunni aantanno 5 dirrara xe"a noosi. Xeote gedensiidi hornyo 10,000 birraati. Umi dirinni shallaga hasirittoro.
=SYD(50000;10000;5;1)=13,333.33 currency units. The depreciation amount for the first year is 13,333.33 currency units.
Yannate garinni xe'nete bikkuwa illachishate, xe'nete shae tira faayyate. By entering the different depreciation formulas available in LibreOffice Calc giddo shiqinoha mittu mittoho aaninobabbaxxino xe'nete afirimalubba eatenni, roore woyyaabbino xe'ne la"a dandaatto. Aananno garinni shae ei:
A |
B |
C |
A |
A |
|
1 |
Eva |
Eva |
Irene |
su'ma |
Greta |
2 |
50,000 currency units |
10,000 currency units |
5 |
1 |
13,333.33 currency units |
3 |
2 |
10,666.67 currency units |
|||
4 |
3 |
8,000.00 currency units |
|||
5 |
4 |
5,333.33 currency units |
|||
6 |
5 |
2,666.67 currency units |
|||
7 |
6 |
0.00 currency units |
|||
8 |
7 |
||||
9 |
8 |
||||
10 |
9 |
||||
11 |
10 |
||||
12 |
|||||
13 |
0 |
Eva |
40,000.00 currency units |
E2 Giddo afirimalu aananno garaati:
=SYD($A$2;$B$2;$C$2;D2)
Kuni afirimali caccafote giddo E nni worora E11 geeshsha ( E2 doori, anchite ajotenni shiimidi qiniitira worora goshooshi).
Bisicco E13 xaphoomu xe'ne geeshsha buuxate afirimala anaddino. SUMIF assiishsha E8:E11 giddo negaatiive hornyuwa hedote giddo wora dinosi. Ikkito >0 bisicco A13 giddo amadantino. E13 giddo afirimalu aananno garaati:
=SUMIF(E2:E11;A13)
Xa 10 diri beehaachi xeishsha illachishi, woyxe'nete gedensiidi waagi 1 birra, woy babbaxxino hanafote waaga ei, nna woleno.