Sheet1
| WENDY REINA | ||||||||||||
| BUDGET | ||||||||||||
| as for 4/april /2022 | ||||||||||||
| particulars | budget | |||||||||||
| Income | ||||||||||||
| income from salary | 50,000.00 | average income/earnings | car | |||||||||
| income from rent | 15,000.00 | 14800 | cost | 15000 | ||||||||
| income from stocke | 3,000.00 | average expense | years | 5 | ||||||||
| incentives | 4,000.00 | 21250 | apr | 5.50% | ||||||||
| other sources | 2,000.00 | minumum expense | ||||||||||
| total income | 74,000.00 | 74,000.00 | 1500 | date | monthly installment | interest | principle | balance | ||||
| Expenditure | maximum expense | 1 | 250 | 0 | 250 | 14750 | ||||||
| fixed expences | 11000 | 2 | 250 | 13.75 | 236.25 | 14513.75 | ||||||
| house rent | 11,000.00 | 3 | 250 | 12.99375 | 223.25625 | 14290.49375 | ||||||
| groceries | 7,500 | 4 | 250 | 12.27909375 | 210.97715625 | 14079.51659375 | ||||||
| gas | 2,500.00 | 5 | 250 | 11.6037435937 | 199.3734126562 | 13880.1431810937 | ||||||
| water and sewage | 1,000.00 | 6 | 250 | 10.9655376961 | 188.4078749602 | 13691.7353061336 | ||||||
| SATELITE TV | 2,000.00 | 7 | 250 | 10.3624331228 | 178.0454418373 | 13513.6898642962 | ||||||
| INTERNET | 2,000.00 | 8 | 250 | 9.7924993011 | 168.2529425363 | 13345.43692176 | ||||||
| medical and insurance | 2,500.00 | 9 | 250 | 9.2539118395 | 158.9990306968 | 13186.4378910632 | ||||||
| charity | 2,500.00 | 10 | 250 | 8.7449466883 | 150.2540840085 | 13036.1838070547 | ||||||
| 31,000.00 | 31,000.00 | 11 | 250 | 8.2639746205 | 141.990109388 | 12894.1936976667 | ||||||
| 12 | 250 | 7.8094560163 | 134.1806533717 | 12760.013044295 | ||||||||
| variable expences | 13 | 250 | 7.3799359354 | 126.8007174362 | 12633.2123268588 | |||||||
| transport | 3,000.00 | 14 | 250 | 6.974039459 | 119.8266779772 | 12513.3856488815 | ||||||
| entertaiment | 2,500.00 | 15 | 250 | 6.5904672887 | 113.2362106885 | 12400.1494381931 | ||||||
| repairs | 2,500.00 | 16 | 250 | 6.2279915879 | 107.0082191006 | 12293.1412190924 | ||||||
| phone | 2,000.00 | 17 | 250 | 5.8854520505 | 101.1227670501 | 12192.0184520424 | ||||||
| electrictity | 1,500.00 | 18 | 250 | 5.5617521878 | 95.5610148623 | 12096.45743718 | ||||||
| 11,500.00 | 11,500.00 | 19 | 250 | 5.2558558174 | 90.3051590449 | 12006.1522781351 | ||||||
| saving | 20 | 250 | 4.9667837475 | 85.3383752974 | 11920.8139028377 | |||||||
| emergency fund | 5,000.00 | 21 | 250 | 4.6936106414 | 80.6447646561 | 11840.1691381816 | ||||||
| car replacement | 10,500.00 | 22 | 250 | 4.4354620561 | 76.2093026 | 11763.9598355816 | ||||||
| investment | 10,000.00 | 23 | 250 | 4.191511643 | 72.017790957 | 11691.9420446246 | ||||||
| educataion fund | 6,000.00 | 24 | 250 | 3.9609785026 | 68.0568124544 | 11623.8852321703 | ||||||
| 31,500.00 | 31,500.00 | 25 | 250 | 3.743124685 | 64.3136877694 | 11559.5715444009 | ||||||
| 0 | 26 | 250 | 3.5372528273 | 60.7764349421 | 11498.7951094589 | |||||||
| 27 | 250 | 3.3427039218 | 57.4337310202 | 11441.3613784386 | ||||||||
| 28 | 250 | 3.1588552061 | 54.2748758141 | 11387.0865026245 | ||||||||
| 29 | 250 | 2.9851181698 | 51.2897576443 | 11335.7967449802 | ||||||||
| 30 | 250 | 2.8209366704 | 48.4688209739 | 11287.3279240063 | ||||||||
| 31 | 250 | 2.6657851536 | 45.8030358203 | 11241.5248881859 | ||||||||
| 32 | 250 | 2.5191669701 | 43.2838688502 | 11198.2410193357 | ||||||||
| 33 | 250 | 2.3806127868 | 40.9032560635 | 11157.3377632722 | ||||||||
| 34 | 250 | 2.2496790835 | 38.65357698 | 11118.6841862923 | ||||||||
| 35 | 250 | 2.1259467339 | 36.5276302461 | 11082.1565560462 | ||||||||
| 36 | 250 | 2.0090196635 | 34.5186105825 | 11047.6379454636 | ||||||||
| 37 | 250 | 1.898523582 | 32.6200870005 | 11015.0178584631 | ||||||||
| 38 | 250 | 1.794104785 | 30.8259822155 | 10984.1918762477 | ||||||||
| 39 | 250 | 1.6954290219 | 29.1305531936 | 10955.061323054 | ||||||||
| 40 | 250 | 1.6021804256 | 27.528372768 | 10927.5329502861 | ||||||||
| 41 | 250 | 1.5140605022 | 26.0143122657 | 10901.5186380203 | ||||||||
| 42 | 250 | 1.4307871746 | 24.5835250911 | 10876.9351129292 | ||||||||
| 43 | 250 | 1.35209388 | 23.2314312111 | 10853.7036817181 | ||||||||
| 44 | 250 | 1.2777287166 | 21.9537024945 | 10831.7499792236 | ||||||||
| 45 | 250 | 1.0976851247 | 20.8560173698 | 10810.8939618538 | ||||||||
| 46 | 250 | 1.1470809553 | 19.7089364144 | 10791.1850254394 | ||||||||
| 47 | 250 | 1.0839915028 | 18.6249449116 | 10772.5600805278 | ||||||||
| 48 | 250 | 1.0243719701 | 17.6005729415 | 10754.9595075863 | ||||||||
| 49 | 250 | 0.9680315118 | 16.6325414297 | 10738.3269661566 | ||||||||
| 50 | 250 | 0.9147897786 | 15.7177516511 | 10722.6092145055 | ||||||||
| 51 | 250 | 0.8644763408 | 14.8532753103 | 10707.7559391952 | ||||||||
| 52 | 250 | 0.8169301421 | 14.0363451682 | 10693.719594027 | ||||||||
| 53 | 250 | 0.7719989843 | 13.264346184 | 10680.455247843 | ||||||||
| 54 | 250 | 0.7295390401 | 12.5348071438 | 10667.9204406992 | ||||||||
| 55 | 250 | 0.6894143929 | 11.8453927509 | 10656.0750479483 | ||||||||
| 56 | 250 | 0.6514966013 | 11.1938961496 | 10644.8811517986 | ||||||||
| 57 | 250 | 0.6156642882 | 10.5782318614 | 10634.3029199372 | ||||||||
| 58 | 250 | 0.5818027524 | 9.996429109 | 10624.3064908282 | ||||||||
| 59 | 250 | 0.549803601 | 9.446625508 | 10614.8598653202 | ||||||||
| 60 | 250 | 0.5195644029 | 8.9270611051 | 10605.9328042151 |
Budget-2.xlsx


