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 |
