amanqaku

Isakhelo se-Excel soLawulo lokuHamba kweMali: Isakhelo seNgxelo yokuHamba kweMali

Ukuhamba nokuphuma kwemali (okanye ukungena kwemali) sesinye sezixhobo eziphambili zohlalutyo olusebenzayo lweengxelo zemali. Okubalulekileyo ukuba ufuna ukwazi imeko yezemali yenkampani yakho, ukuhamba kwemali kukukhokelela kwizigqibo ezicwangcisiweyo kwicandelo lolawulo lwemali yokuhlawula amatyala, kwaye ikunika isishwankathelo esinzulu seendlela zonondyebo wenkampani yakho.

Ukungena nokuphuma kwemali ephuma kwimali yenkampani ngexesha elithile.

Ikwabizwa ngokuba yimali ephumayo, ukuhamba kwemali defiI-nition yiparameter ekuvumela ukuba uhlalutye ukusebenza kweshishini ngokunxulumene nokungabi namali. Ngoko ke sikwimeko yohlalutyo lohlahlo lwabiwo-mali. Kodwa ngokungafaniyo okwenzekayo ngezalathisi ze-liquidity - ezibonelela ngomfanekiso omileyo kunye nothe tyaba wemeko yemali yenkampani - kunye nokuhamba kwemali kunokwenzeka ukuba unzulu uhlalutyo, kwaye uphande iiyantlukwano ezenzeka ngokuhamba kwexesha.

Ukungena kwemali kusixelela ukuba yimalini na ekhoyo kwirejista yemali nokuba iintshukumo zezimali ziyakwazi na ukukhawulelana neemfuno zenkunzi yokusebenza. Yiparamitha ebaluleke kakhulu ke ngoko, kuba ubukho bemali yokuhlawula amatyala bumele isibonelelo esibalulekileyo nesibalulekileyo kwinkampani.

I-Excel spreadsheet ilandelayo ibonelela ngethemplethi yenkcazo yokuhamba kwemali eqhelekileyo, enokuba luncedo kwiiakhawunti zamashishini amancinci.

Amabala akwii-tan cells zespreadsheet ashiywe engenanto ukuze akuvumele ukuba ufake awakho amanani, kwaye unokutshintsha iilebhile zale miqolo ukubonisa iindidi zokungena kwemali yakho. Unako kwakhona ukufaka imiqolo eyongezelelweyo kwitemplate yeCash Flow, kodwa ukuba wenza njalo, uya kufuna ukujonga iifomyula (kwiiseli ezingwevu), ukuqinisekisa ukuba zibandakanya amanani avela kuyo yonke imigca oyifakile.

Ithemplethi iyahambelana ne-Excel 2010 kunye neenguqulelo zamva.

Ukukhuphela imodeli cofa apha i

Imisebenzi esetyenziswe kwimodeli yimali kunye nabaqhubi be-arithmetic:

Isishwankathelo: Isetyenziselwa ukubala iitotali zodidi ngalunye lwengeniso okanye iindleko;
Umsebenzisi wokongezwa: isetyenziselwa ukubala:
- Ukunyuka kwesambuku (ukuncipha) kwimali eziinkozo kunye nokulingana nemali = Imali eyisambuku evela kwimisebenzi yokusebenza + Imali eyisambuku evela kwimisebenzi yotyalo-mali + Imali eyisambuku evela kwimisebenzi yenkxaso-mali + Impembelelo yokuguquguquka kwezinga lotshintshiselwano kwimali eziinkozo nakwizinto ezilingana nemali
- Imali eziinkozo nezilingana nemali, ukuphela kwexesha = Ukwenyuka kwesambuku (ukwehla) kwimali eziinkozo kunye nezinto ezilingana nemali eziinkozo + Imali kunye nezinto ezilingana nemali, ukuqala kwexesha

BlogInnovazione.it