Rent statements Marzi Zemlik

  • Moving-in date: 2012-12-08

  • Weekly rate: 160.- (less for first 6 weeks as discussed)

  • Four weeks' deposit paid cash 2012-12-08: 640.-

  • Share of electricity bill 30% (40% when 3rd room vacant)

  • Final balance: 640.00 - 641.12 ≈ 0.00

    2012-12

    Carry Over 0.00
    Rent
    100.- + 110.- + 120.- + (3/7)*130.-    		 -385.71
    Share of electricity 0.00
    Cash payment 2012-12-08 360.00
    Balance -25.71


    2013-01

    Carry Over -25.71
    Rent
    (4/7)*130.- + 140.- + 150.- + 160.- + (6/7)*160.-    		 -661.43
    Share of electricity
    69808 - 69392 = 416 units @ 14p → 58.24 * 40% → 23.30
    37222 - 36836 = 386 units @ 6p → 23.16 * 40% → 9.26    		 -32.56
    Cash payment 2013-01-04 270.00
    Transfer 2013-01-17 310.00
    Transfer 2013-01-30 640.00
    Balance 500.30


    2013-02

    Carry Over 500.30
    Rent
    4*160.-    		 -640.00
    Share of electricity
    69902 - 69808 = 94 units @ 14p → 13.16 * 40% → 5.26
    37316 - 37222 = 94 units @ 6p → 5.64 * 40% → 2.25
    70232 - 69902 = 330 units @ 14p → 46.20 * 30% → 13.86
    37567 - 37316 = 251 units @ 6p → 15.06 * 30% → 4.51    		 -25.88
    Balance -165.58


    2013-03

    Carry Over -165.58
    Rent
    31*(160.-/7)    		 -708.57
    Share of electricity
    70646 - 70232 = 414 units @ 14p → 57.96 * 30% → 17.38
    37927 - 37567 = 360 units @ 6p → 21.60 * 30% → 6.48    		 -23.86
    Transfer 2013-03-01 672.56
    Transfer 2013-03-31 640.00
    Balance 414.55


    2013-04

    Carry Over 414.55
    Rent
    30*(160.-/7)    		 -685.71
    Share of electricity
    70873 - 70646 = 227 units @ 14p → 31.78 * 30% → 9.53
    38212 - 37927 = 285 units @ 6p → 17.10 * 30% → 5.13    		 -14.66
    Balance -285.82


    2013-05

    Carry Over -285.82
    Rent
    31*(160.-/7)    		 -708.57
    Share of electricity
    71077 - 70873 = 204 units @ 14p → 28.56 * 30% → 8.56
    38468 - 38212 = 256 units @ 6p → 15.36 * 30% → 4.60    		 -13.16
    Transfer 2013-05-01 671.52
    Balance -336.03


    2013-06

    Carry Over -336.03
    Rent
    30*(160.-/7)    		 -685.71
    Share of electricity
    71275 - 71077 = 198 units @ 14p → 27.72 * 30% → 8.31
    38716 - 38468 = 248 units @ 6p → 14.88 * 30% → 4.46    		 -12.77
    Transfer 2013-06-01 663.86
    Balance -370.65


    2013-07

    Carry Over -370.65
    Rent
    31*(160.-/7)    		 -708.57
    Share of electricity
    71492 - 71275 = 217 units @ 14p → 30.38 * 30% → 9.11
    38998 - 38716 = 282 units @ 6p → 16.92 * 30% → 5.07    		 -14.18
    Transfer 2013-07-01 667.82
    Transfer 2013-07-31 640.00
    Balance 214.42


    2013-08

    Carry Over 214.42
    Rent
    31*(160.-/7)    		 -708.57
    Share of electricity
    71717 - 71492 = 225 units @ 14p → 31.50 * 30% → 9.45
    39228 - 38998 = 230 units @ 6p → 13.80 * 30% → 4.14    		 -13.59
    Transfer 2013-08-31 640.00
    Balance 132.26


    2013-09

    Carry Over 132.26
    Rent
    30*(160.-/7)    		 -685.71
    Share of electricity
    71937 - 71717 = 220 units @ 14p → 30.80 * 30% → 9.24
    39450 - 39228 = 222 units @ 6p → 13.32 * 30% → 3.99    		 -13.23
    Balance -566.68


    2013-10

    Carry Over -566.68
    Rent
    31*(160.-/7)    		 -708.57
    Share of electricity
    72124 - 71937 = 187 units @ 14p → 26.18 * 30% → 7.85
    39688 - 39450 = 238 units @ 6p → 14.28 * 30% → 4.28    		 -12.13
    Transfer 2013-10-01 640.00
    Transfer 2013-10-05 200.00
    Transfer 2013-10-30 785.71
    Balance 338.33


    2013-11

    Carry Over 338.22
    Rent
    30*(160.-/7)    		 -685.71
    Share of electricity
    72344 - 72124 = 220 units @ 14p → 30.80 * 30% → 9.24
    39998 - 39688 = 310 units @ 6p → 18.60 * 30% → 5.58    		 -14.82
    Balance -362.31


    2013-12

    Carry Over -362.31
    Rent
    31*(160.-/7)    		 -708.57
    Share of electricity
    72680 - 72344 = 336 units @ 14p → 47.04 * 30% → 14.11
    40408 - 39998 = 410 units @ 6p → 24.06 * 30% → 7.38    		 -21.49
    Transfer 2013-12-01 808.57
    Balance -283.80


    2014-01

    Carry Over -283.80
    Rent
    31*(160.-/7)    		 -708.57
    Share of electricity
    73337 - 72680 = 657 units @ 14p → 91.98 * 30% → 27.59
    41175 - 40408 = 767 units @ 6p → 46.02 * 30% → 13.80    		 -41.39
    Transfer 2014-01-01 640.00
    Transfer 2014-01-10 127.12
    Balance -266.64


    2014-02

    Carry Over -266.64
    Rent
    4*160.-    		 -640.00
    Share of electricity
    73731 - 73337 = 394 units @ 14p → 55.16 * 30% → 16.54
    41704 - 41175 = 529 units @ 6p → 31.74 * 30% → 9.52    		 -26.06
    Transfer 2014-02-01 640.00
    Balance -292.70


    2014-03

    Carry Over -292.70
    Rent
    31*(160.-/7)    		 -708.57
    Share of electricity
    74174 - 73731 = 443 units @ 14p → 62.02 * 30% → 18.60
    42194 - 41704 = 490 units @ 6p → 29.40 * 30% → 8.82    		 -27.42
    Transfer 2014-03-01 810.78
    Balance -217.91


    2014-04

    Carry Over -217.91
    Rent
    30*(160.-/7)    		 -685.71
    Share of electricity
    74401 - 74174 = 227 units @ 12.75p → 28.94 * 30% → 8.68
    42479 - 42194 = 285 units @ 6.50p → 18.52 * 30% → 5.55    		 -14.23
    Transfer 2014-04-01 753.16
    Balance -164.69


    2014-05

    Carry Over -164.69
    Rent
    31*(160.-/7) - 80.- (discount)    		 -628.57
    Share of electricity
    74721 - 74401 = 320 units @ 12.75p → 40.80 * 30% → 12.24
    42683 - 42479 = 204 units @ 6.50p → 13.26 * 30% → 3.97    		 -16.21
    Transfer 2014-05-05 750.22
    Balance -59.25


    2014-06

    Carry Over -59.25
    Rent
    30*(160.-/7)    		 -685.71
    Share of electricity
    74919 - 74721 = 198 units @ 12.75p → 25.24 * 30% → 7.57
    42895 - 42683 = 212 units @ 6.50p → 13.78 * 30% → 4.13    		 -11.70
    Transfer 2014-06-02 685.71
    Balance -70.95


    2014-07

    Carry Over -70.95
    Rent
    31*(160.-/7)    		 -708.57
    Share of electricity
    75077 - 74919 = 158 units @ 12.75p → 20.14 * 30% → 6.04
    43195 - 42895 = 300 units @ 6.50p → 19.50 * 30% → 5.85    		 -11.89
    Transfer 2014-07-03 644.78
    Balance -146.63


    2014-08

    Carry Over -146.63
    Rent
    31*(160.-/7)    		 -708.57
    Share of electricity
    75203 - 75077 = 126 units @ 12.75p → 16.06 * 30% → 4.81
    43339 - 43195 = 144 units @ 6.50p → 9.36 * 30% → 2.80    		 -7.61
    Transfer 2014-08-08 500.00
    Transfer 2014-08-11 208.57
    Balance -154.24


    2014-09

    Carry Over -154.24
    Rent
    30*(160.-/7)    		 -685.71
    Share of electricity
    75416 - 75203 = 213 units @ 12.75p → 27.15 * 30% → 8.14
    43567 - 43339 = 228 units @ 6.50p → 14.82 * 30% → 4.44    		 -12.58
    Transfer 2014-09-19 716.91
    Balance -135.62


    2014-10

    Carry Over -135.62
    Rent
    31*(160.-/7)    		 -708.57
    Share of electricity
    75879 - 75416 = 463 units @ 12.75p → 59.03 * 30% → 17.70
    43918 - 43567 = 351 units @ 6.50 → 22.81 * 30% → 6.84    		 -24.54
    Transfer 2014-10-20 107.61
    Cash 2014-11-01 120.00
    Balance -641.12


    Any questions, email me at [email protected].