Ukubalwa kokwehla kwenani ku-Excel

I-Excel inikeza imisebenzi emihlanu ehlukene yokubala ukwehla kwenani. Cabangela impahla enezindleko $ 10000, inani lokuqedwa (elisele). $ 1000 nempilo ewusizo 10 izikhathi (iminyaka). Imiphumela yayo yonke imisebenzi emihlanu ikhonjisiwe ngezansi. Sizochaza ngamunye wale misebenzi ngokuningiliziwe ngezansi.

Izimpahla eziningi zilahlekelwa iningi lenani lazo ekuqaleni kokusebenziseka kwazo. Imisebenzi Vula (EMZANSI), I-FUO (DB), I-DDOB (DDB) kanye I-PUO (VDB) cabangela lesi sici.

Ukubalwa kokwehla kwenani ku-Excel

Premier League

Umsebenzi Premier League (SLN) ilula njengomugqa oqondile. Unyaka ngamunye, izindleko zokwehla kwenani zibhekwa zilingana.

Ukubalwa kokwehla kwenani ku-Excel

Umsebenzi Premier League yenza izibalo ezilandelayo:

  • Izindleko zokwehla kwenani = ($10000–$1000)/10 = $900.
  • Uma sidonsa inani elitholwe ezindlekweni zangempela zempahla izikhathi ezingu-10, khona-ke inani layo lokwehla lizoshintsha lisuka ku-$10000 liye ku-$1000 eminyakeni engu-10 (lokhu kuboniswa phansi kwesibalo sokuqala ekuqaleni kwesihloko).

Vula

Umsebenzi Vula (I-SYD) nayo ilula - ibala ukwehla kusetshenziswa isamba sendlela yezinombolo zonyaka. Njengoba kuboniswe ngezansi, lo msebenzi nawo udinga inani lezikhathi okufanele licaciswe.

Ukubalwa kokwehla kwenani ku-Excel

Umsebenzi Vula yenza izibalo ezilandelayo:

  • Impilo ewusizo yeminyaka eyi-10 inikeza isamba sezinombolo 10+9+8+7+6+5+4+3+2+1 = 55
  • Impahla ilahlekelwa inani elingu-$10 phakathi nenkathi ecatshangelwayo (iminyaka engu-9000).
  • Inani lokwehla kwenani 1 = 10/55*$9000 = $1636.36;

    Inani lokwehla kwenani 2 = 9/55*$9000 = $1472.73 njalonjalo.

  • Uma sisusa konke ukwehla okuwumphumela wezindleko zoqobo zempahla engu-$10000, sithola inani eliyinsalela lika-$1000 ngemva kokuphila okusebenzisekayo kweminyaka eyi-10 (bheka phansi kwesibalo sokuqala ekuqaleni kwesihloko).

I-FUO

Umsebenzi I-FUO (DB) iyinkimbinkimbi kakhulu. Indlela egxilile yokwehla kwenani isetshenziselwa ukubala ukwehla.

Ukubalwa kokwehla kwenani ku-Excel

Umsebenzi I-FUO yenza izibalo ezilandelayo:

  • Isilinganiso = 1–((residual_cost/initial_cost)^(1/lifetime)) = 1–($1000/$10000)^(1/10)) = 0.206. Umphumela ufinyelelwe endaweni eyinkulungwane.
  • Isikhathi senani lokwehla 1 = $10000*0.206 = $2060.00;

    Isikhathi senani lokwehla 2 = ($10000-$2060.00)*0.206 = $1635.64 nokunye.

  • Uma sisusa konke ukwehla okuwumphumela wezindleko zoqobo zempahla engu-$10000, sithola inani eliyinsalela lika-$995.88 ngemva kokuphila okusebenzisekayo kweminyaka eyi-10 (bheka phansi kwesibalo sokuqala ekuqaleni kwesihloko).

Qaphela: Umsebenzi I-FUO ine-agumenti yesihlanu yokuzikhethela. Le mpikiswano ingasetshenziswa uma ufuna ukucacisa inani lezinyanga zokusebenza onyakeni wokuqala wokukhokha (uma le mpikiswano ishiywe, inani lezinyanga zokusebenza onyakeni wokuqala lithathwa njengeziyi-12). Isibonelo, uma impahla yatholwa ekuqaleni kwekota yesibili yonyaka, okungukuthi ngonyaka wokuqala, impilo yempahla yayiyizinyanga ezingu-9, bese kuba yi-agumenti yesihlanu yomsebenzi udinga ukucacisa inani elingu-9. Kulokhu, kunomehluko othile kumafomula asetshenziswa i-Excel ukubala ukwehla kwenani lenkathi yokuqala neyokugcina (inkathi yokugcina kuzoba unyaka we-11, ehlanganisa kuphela izinyanga ezi-3 zokusebenza).

I-DDOB

Umsebenzi I-DDOB (DDB) - ukuphinda kabili ibhalansi, futhi kusuka phakathi kweziqalo. Nokho, uma usebenzisa lo msebenzi, inani eliyinsalela elidingekayo alitholakali ngaso sonke isikhathi.

Ukubalwa kokwehla kwenani ku-Excel

Umsebenzi I-DDOB yenza izibalo ezilandelayo:

  • Ngokuphila okusebenzisekayo kweminyaka eyi-10, sithola isilinganiso esingu-1/10 = 0.1. Indlela esetshenziswa isici ibizwa ngokuthi indlela ephindwe kabili, ngakho-ke kufanele siphinde kabili ukubheja (isici = 2).
  • Isikhathi senani lokwehla 1 = $10000*0.2 = $2000;

    Isikhathi senani lokwehla 2 = ($10000-$2000)*0.2 = $1600 nokunye.

Njengoba sekushiwo, uma usebenzisa lo msebenzi, inani eliyinsalela elidingekayo alitholakali ngaso sonke isikhathi. Kulesi sibonelo, uma ususa konke ukwehla kwenani okutholwe ezindlekweni zokuqala zempahla engu-$10000, ngemva kweminyaka eyi-10 sithola inani lenani eliyinsalela lika-$1073.74 (bheka ngezansi kwesibalo sokuqala ekuqaleni kwesihloko) . Funda ukuze uthole ukuthi ungasilungisa kanjani lesi simo.

Qaphela: Umsebenzi we-DDOB unokungqubuzana okungakhethwa kwesihlanu. Inani lale mpikiswano licacisa isici esihlukile sokwehla kwezinga lenzalo yebhalansi.

I-PUO

Umsebenzi I-PUO (VDB) isebenzisa indlela yokwehlisa kabili ngokuzenzakalelayo. I-agumenti yesine icacisa isikhathi sokuqala, i-agumenti yesihlanu icacisa isikhathi sokuphela.

Ukubalwa kokwehla kwenani ku-Excel

Umsebenzi I-PUO yenza izibalo ezifanayo nomsebenzi I-DDOB. Kodwa-ke, uma kudingekile, ishintshela kumodi yokubala "yomugqa oqondile" uma kudingekile (okugqanyiswe ngokuphuzi) ukuze kufinyelelwe inani lenani elisele (bheka phansi kwesibalo sokuqala ekuqaleni kwesihloko). Ukushintshela kumodi yokubala "yomugqa oqondile" kwenzeka kuphela uma inani lokwehla ngokuya "umugqa oqondile» idlula inani lokwehla kwenani ngokusho «ukuncishiswa kabili kwebhalansi".

Esikhathini sesishiyagalombili, inani lokwehla kwenani ngaphansi kwendlela yebhalansi eyehla kabili = $419.43. Kulesi sigaba, sinenani lokususa ukwehla kwenani elilingana no-$2097.15-$1000 (bheka phansi kwesibalo sokuqala ekuqaleni kwesihloko). Uma sisebenzisa indlela “yomugqa oqondile” ukuze siphinde sibale, kuzothi ezikhathini ezintathu ezisele sithola inani lokwehla elingu-$1097/3=$365.72. Leli nani alidluli inani elitholwe indlela edonswa kabili, ngakho-ke akukho ukushintshela endleleni "yomugqa oqondile".

Esikhathini sesishiyagalolunye, inani lokwehla kwenani ngaphansi kwendlela yebhalansi eyehla kabili = $335.54. Kulesi sigaba, sinenani lokususa ukwehla kwenani elilingana no-$1677.72-$1000 (bheka phansi kwesibalo sokuqala ekuqaleni kwesihloko). Uma sisebenzisa indlela "yomugqa oqondile" ukuze uthole izibalo ezengeziwe, khona-ke ezikhathini ezimbili ezisele sithola inani lokwehla lika-$677.72/2 = $338.86. Leli nani liphakeme kunevelu etholwe indlela edonswa kabili, ngakho lishintshela endleleni yomugqa oqondile.

Qaphela: Umsebenzi I-PUO nezimo kakhulu kunomsebenzi I-DDOB. Ngosizo lwayo, ungakwazi ukubala inani lokwehla kwezikhathi ezimbalwa ngesikhathi esisodwa.

Umsebenzi uqukethe ama-agumenti okuzikhethela wesithupha kanye nesikhombisa. Nge-agumenti yesithupha, ungachaza enye i-coefficient yesilinganiso senzalo sebhalansi eyehlayo. Uma impikiswano yesikhombisa isethwe ukuze TRUE (TRUE), bese ushintshela kumodi yokubala “yomugqa oqondile” akwenzeki.

shiya impendulo