Khuphela itheyibhile yokuhlawula amatyala ukuze uzenzele ngokwakho ukusetyenziswa!
Akunyanzelekanga ukuba ube yi-Excel ispredishithi whiz ukwenza eyakho itafile yokuhlawulela. Zonke iifomyula zibalwe kwangaphambili kuwe, ke kufuneka uzikhuphele kuphela kwiiseli ezifanelekileyo. Landela nje le miyalelo ilula ngenyathelo ngenyathelo yokwakha itafile yakho kwimizuzu nje, okanye kungenjalo ungasebenzisa ikhalityhuleyitha zokuhlawula amatyala simahla.
Imiyalelo yeTheyibhile yokuHanjiswa kwamaTyala
Njengomzekelo, cinga ukuba le yimali mboleko yeminyaka emihlanu (iinyanga ezingama-60), eyi- $ 22,000, kwinqanaba lenzala le-7 yepesenti. Nje ukuba ufumane iziseko endaweni, ungayenza ngokwezifiso itafile ukubonisa nayiphi na imigaqo-mboleko onqwenela ukuyifumana.
- Vula ispredishithi esitsha se-Excel.
- Ukuqala nge-A1, dwelisa la macandelo kwikholamu A:
- Isixa semali-mboleko
- Umgangatho wenzala
- Iinyanga
- Iintlawulo
- Ukuqala nge-B1, nikezela amaxabiso kwiindidi ezintathu zokuqala kwikholamu B:
- $ 22,000
- I-7% (Qaphela: Umyinge wenzala kufuneka ubhalwe njengepesenti.)
- 60
- Kwi-B4 faka le fomyula ilandelayo kwaye ucofe u 'enter': = PMT ($ B $ 2/12, $ B $ 3, - $ B $ 1,0)
- Dwelisa la macandelo alandelayo kumqolo we-7, ukuqala ngo-A7:
- Ixesha
- Ibhalansi yokuqala
- Intlawulo
- Inzala
- Umgaqo oQokelelweyo
- Inzala eyonyukayo
- Ibhalansi yokuphela
- Kwiseli yesitshixo se-A8 kumhla ekufanele ukuba kuhlawulwe ngawo, kwaye cinezela 'Ngena.'
- Khetha i-A8 kwaye, usebenzisa isiphatho esisekunene seseli, yitsale phantsi nge-A67, ugqamisa iseli nganye.
- Qinisekisa ukuba ukhetho lokugcwalisa oluzenzekelayo lusetelwe 'kwiinyanga.'
- Ukufikelela kuseto, cofa kwimenyu yokudonsa ebonakala ezantsi ekunene kweseli yokugqibela ekhethiweyo.
- Qinisekisa ukuba ukhetho lokugcwalisa oluzenzekelayo lusetelwe 'kwiinyanga.'
- Okwangoku ispredishithi sakho kufuneka sijongeka ngoluhlobo:
- Kwiseli B8 faka ibhalansi yokuqala yemali mboleko, kulo mzekelo, $ 22,000
- Kwiseli C8 faka le fomyula ilandelayo kwaye ucinezele 'ukungena': = $ B $ 4
- Kwiseli E8 faka le fomyula ilandelayo kwaye ucinezele 'ukungena': = $ B8 * ($ B $ 2/12)
- Kwiseli D8 faka le fomyula ilandelayo kwaye ucinezele 'ukungena': = $ C8- $ E8
- Kwiseli H8 faka le fomyula ilandelayo kwaye ucinezele 'ukungena': = $ B8- $ D8
- Kwiseli B9 faka le fomyula ilandelayo kwaye ucinezele 'ukungena': = $ H8
- Khuphela iiseli C8, D8 kunye ne-E8 kwaye uzincamathisele kwi-C9, D9 kunye ne-E9
- Khuphela iseli H8 kwaye uyincamathisele kwi-H9
- Kwiseli F9 faka le fomyula ilandelayo kwaye ucofe u 'enter': = $ D9 + $ F8
- Kwiseli G9 faka le fomyula ilandelayo kwaye ucinezele 'ukungena': = $ E9 + $ G8
- Qinisekisa ukuba iiseli ze-A8 ukuya kwi-H8 kunye ne-A9 ngokusebenzisa iifomathi zemali
- Khetha iiseli ze-B9 ukuya kwi-H9 kwaye utsalele ezantsi ukuze ugcwalise intsalela yetafile yakho yokufumana imali
- Iseli yokugqibela kwikholamu H (kulo mzekelo, H67) kufuneka iphele kwi-0.00 yeedola. Ukuba ayenzi njalo, tshekisha iifomula ezingenisiweyo
- Imiqolo embalwa yokugqibela yetafile yakho kufuneka ijongeke ngolu hlobo:
- Ukukhusela ukuchaneka okuqhubekayo kwetafile yakho, tshixa zonke iiseli ezinefomula.
- Khetha zonke iiseli ofuna ukuzitshixa kwaye ucofe i-'Fomathi 'icon kwi-spreadsheet ye-Excel.
- Cofa 'Vala iseli'
- Itheyibhile yokuHlawulelwa kweeMpahla eziSimahla
- Itheyibhile yokuhlawula amatyala iminyaka engama-30
- Itshathi yokuHanjiswa kwamanani ngokuthe ngqo
Ukwenza iTable ngokwezifiso
Ngoku ukuba itafile esisiseko yokuhlawula amatyala yenziwe, ungayenza ngokwezifiso ukubala phantse imeko ezingenakubalwa zemali mboleko. Umzekelo, ukuba ufuna ukuhlawula iminyaka engama-30 (iinyanga ezingama-360) ubambiso luya kudinga imiqolo engama-360 kulwazi lokuhlawula.
- Buyela umva kwiNyathelo 8. Endaweni yokurhuqa isikhombisi sakho kwiiseli ezingama-60 (ukuma kwi-A67), kuya kufuneka uyitsale ngeeseli ezingama-360 (ukuma kwi-A367).
- Isitshixo semali yemali mboleko kwisisele B1 kwaye ucinezele 'ukungena.'
- Cofa kwinqanaba lenzala yonyaka kwiseli B2 kwaye ucinezele 'ukungena.'
- Isitshixo senani leenyanga eziza kufuneka zihlawulwe kwi-B3, kwaye ucofe u 'enter.'
Siyavuyisana nawe! Imeko yakho entsha yemali mboleko ibalwa nje ngokuzenzekelayo.
Sebenzisa iitafile zokuhlawula amatyala
Iitafile zokuhlawula amatyala zikuvumela ukuba uzame ngeendlela ezahlukeneyo zokubolekwa kwemali mboleko. Ngokucofa nje okumbalwa unokuchonga ngokulula isixa esipheleleyo somdla oza kuwuhlawula kwimali-mboleko yeminyaka eli-15, xa kuthelekiswa neminyaka engama-30, okanye iya kuba yintoni ifuthe lokutshintsha kwenzala kwipesenti enye kwintlawulo yakho yenyanga. Ezi ntlobo zokubala zihlala zivelisa ukuqonda okumangalisayo kwaye zikunike ulwazi oludingayo ukuze wenze izigqibo ezilungileyo.
