[Sheet1]
Jun 30, 20 | Jul 31, 20 | Aug 31, 20 | Sep 30, 20 | Oct 31, 20 | Nov 30, 20 | Dec 31, 20 | Jan 31, 21 | Feb 28, 21 | Mar 31, 21 | Apr 30, 21 | May 31, 21 | Jun 30, 21
ASSETS
Current Assets
Other Current Assets
Cash & Cash Equivalent
Cash at Bank | 952,755.68 | 983,202.68 | 1,260,903.68 | 1,028,770.68 | 710,810.68 | 671,025.68 | 913,558.68 | 328,855.68 | 379,975.68 | 476,377.68 | 610,127.68 | 570,511.68 | 1,234,185.68
Cash in Hand | 47,531.00 | 35,072.00 | 20,467.00 | 9,827.00 | -2,098.00 | 87,126.00 | 71,401.00 | 56,056.00 | 28,334.00 | 109,069.00 | 80,569.00 | 80,569.00 | 60,306.00
Total Cash & Cash Equivalent | 1,000,286.68 | 1,018,274.68 | 1,281,370.68 | 1,038,597.68 | 708,712.68 | 758,151.68 | 984,959.68 | 384,911.68 | 408,309.68 | 585,446.68 | 690,696.68 | 651,080.68 | 1,294,491.68
Security Deposit-House Rent | 150,000.00 | 150,000.00 | 150,000.00 | 150,000.00 | 150,000.00 | 150,000.00 | 150,000.00 | 150,000.00 | 150,000.00 | 150,000.00 | 150,000.00 | 150,000.00 | 150,000.00
Security Deposit-Office Rent | 1,000,000.00 | 1,000,000.00 | 1,000,000.00 | 1,000,000.00 | 1,000,000.00 | 1,000,000.00 | 1,000,000.00 | 1,000,000.00 | 1,000,000.00 | 1,000,000.00 | 1,000,000.00 | 1,000,000.00 | 1,000,000.00
Total Other Current Assets | 2,150,286.68 | 2,168,274.68 | 2,431,370.68 | 2,188,597.68 | 1,858,712.68 | 1,908,151.68 | 2,134,959.68 | 1,534,911.68 | 1,558,309.68 | 1,735,446.68 | 1,840,696.68 | 1,801,080.68 | 2,444,491.68
Total Current Assets | 2,150,286.68 | 2,168,274.68 | 2,431,370.68 | 2,188,597.68 | 1,858,712.68 | 1,908,151.68 | 2,134,959.68 | 1,534,911.68 | 1,558,309.68 | 1,735,446.68 | 1,840,696.68 | 1,801,080.68 | 2,444,491.68
Fixed Assets
Computer Equipment
Accumulated Depreciation | -92,701.00 | -98,109.00 | -103,381.00 | -108,522.00 | -113,534.00 | -118,421.00 | -123,185.66 | -130,130.71 | -136,901.71 | -143,503.71 | -149,940.71 | -156,216.71 | -162,335.71 | -69,634.71
TDS on Computer Equipment | 3,761.00 | 3,761.00 | 3,761.00 | 3,761.00 | 3,761.00 | 3,761.00 | 3,761.00 | 5,441.00 | 5,441.00 | 5,441.00 | 5,441.00 | 5,441.00 | 5,441.00 | 1680
VDS on Computer Equipment | 11,590.00 | 11,590.00 | 11,590.00 | 11,590.00 | 11,590.00 | 11,590.00 | 11,590.00 | 17,890.00 | 17,890.00 | 17,890.00 | 17,890.00 | 17,890.00 | 17,890.00 | 6,300.00
Computer Equipment - Other | 293,656.00 | 293,656.00 | 293,656.00 | 293,656.00 | 293,656.00 | 293,656.00 | 293,656.00 | 377,656.00 | 377,656.00 | 377,656.00 | 377,656.00 | 377,656.00 | 377,656.00 | 84,000.00 | 91980
Total Computer Equipment | 216,306.00 | 210,898.00 | 205,626.00 | 200,485.00 | 195,473.00 | 190,586.00 | 185,821.34 | 270,856.29 | 264,085.29 | 257,483.29 | 251,046.29 | 244,770.29 | 238,651.29
Furniture and Fittings
Accumulated Depreciation | -358,941.00 | -385,862.00 | -412,558.00 | -439,032.00 | -465,285.00 | -491,319.00 | -517,136.38 | -542,738.61 | -568,127.61 | -593,304.61 | -618,271.61 | -643,030.61 | -667,583.61 | -308642.61
TDS on Furniture & Fittings | 2,740.00 | 2,740.00 | 2,740.00 | 2,740.00 | 2,740.00 | 2,740.00 | 2,740.00 | 2,740.00 | 2,740.00 | 2,740.00 | 2,740.00 | 2,740.00 | 2,740.00 | 0
VDS on Furniture & Fittings | 10,275.00 | 10,275.00 | 10,275.00 | 10,275.00 | 10,275.00 | 10,275.00 | 10,275.00 | 10,275.00 | 10,275.00 | 10,275.00 | 10,275.00 | 10,275.00 | 10,275.00 | 0
Furniture and Fittings - Other | 3,576,389.00 | 3,576,389.00 | 3,576,389.00 | 3,576,389.00 | 3,576,389.00 | 3,576,389.00 | 3,576,389.00 | 3,576,389.00 | 3,576,389.00 | 3,576,389.00 | 3,576,389.00 | 3,576,389.00 | 3,576,389.00 | 0
Total Furniture and Fittings | 3,230,463.00 | 3,203,542.00 | 3,176,846.00 | 3,150,372.00 | 3,124,119.00 | 3,098,085.00 | 3,072,267.62 | 3,046,665.39 | 3,021,276.39 | 2,996,099.39 | 2,971,132.39 | 2,946,373.39 | 2,921,820.39
Office Equipment
Accumulated Depreciation | -111,602.00 | -119,972.00 | -128,272.00 | -136,503.00 | -144,666.00 | -153,879.00 | -163,015.66 | -172,076.18 | -181,061.18 | -189,971.18 | -198,807.18 | -207,569.18 | -216,258.18
TDS on Office Equipment | 3,341.00 | 3,341.00 | 3,341.00 | 3,341.00 | 3,341.00 | 5,953.00 | 5,953.00 | 5,953.00 | 5,953.00 | 5,953.00 | 5,953.00 | 5,953.00 | 5,953.00 | 2612 | 134258
VDS on Office Equipment | 11,854.00 | 11,854.00 | 11,854.00 | 11,854.00 | 11,854.00 | 15,500.00 | 15,500.00 | 15,500.00 | 15,500.00 | 15,500.00 | 15,500.00 | 15,500.00 | 15,500.00 | 3646
Office Equipment - Other | 1,100,825.00 | 1,100,825.00 | 1,100,825.00 | 1,100,825.00 | 1,100,825.00 | 1,228,825.00 | 1,228,825.00 | 1,228,825.00 | 1,228,825.00 | 1,228,825.00 | 1,228,825.00 | 1,228,825.00 | 1,228,825.00 | 128000
Total Office Equipment | 1,004,418.00 | 996,048.00 | 987,748.00 | 979,517.00 | 971,354.00 | 1,096,399.00 | 1,087,262.34 | 1,078,201.82 | 1,069,216.82 | 1,060,306.82 | 1,051,470.82 | 1,042,708.82 | 1,034,019.82
Total Fixed Assets | 4,451,187.00 | 4,410,488.00 | 4,370,220.00 | 4,330,374.00 | 4,290,946.00 | 4,385,070.00 | 4,345,351.30 | 4,395,723.50 | 4,354,578.50 | 4,313,889.50 | 4,273,649.50 | 4,233,852.50 | 4,194,491.50
TOTAL ASSETS | 6,601,473.68 | 6,578,762.68 | 6,801,590.68 | 6,518,971.68 | 6,149,658.68 | 6,293,221.68 | 6,480,310.98 | 5,930,635.18 | 5,912,888.18 | 6,049,336.18 | 6,114,346.18 | 6,034,933.18 | 6,638,983.18
LIABILITIES & EQUITY
Liabilities
Current Liabilities
Other Current Liabilities
Ohter Payable
Audit fees payable | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 86,250.00 | 86,250.00
Car Rent Payable | 115,000.00 | 115,000.00 | 115,000.00 | 115,000.00 | 115,000.00 | 115,000.00 | 115,000.00 | 115,000.00 | 115,000.00 | 115,000.00 | 115,000.00 | 115,000.00 | 115,000.00 | 0.00
Professional Fees Payable | 120,750.00 | 187,450.00 | 254,150.00 | 66,700.00 | 88,550.00 | 90,620.00 | 152,950.00 | 167,670.00 | 187,450.00 | 88,550.00 | 88,550.00 | 66,700.00 | 120,750.00 | 0.00
TDS Payable | 38,710.00 | 19,338.00 | 27,878.00 | 10,815.00 | 8,593.00 | 19,734.00 | 29,548.00 | 18,907.00 | 35,996.00 | 17,175.00 | 34,137.00 | 16,498.00 | 33,074.00 | -5,636.00
TDS payable-Office Rent | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 157,250.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00
TDS Payable-Salary & Allowances | 1,000.00 | 59,344.00 | 118,438.00 | 59,094.00 | 77,304.00 | 138,000.00 | 197,094.00 | 59,860.00 | 120,220.00 | 60,360.00 | 120,719.00 | 62,957.00 | 127,057.00 | 126,057.00
VDS Payable | 196,356.00 | 97,755.00 | 143,121.00 | 53,173.00 | 45,566.00 | 94,537.00 | 144,682.00 | 52,117.00 | 97,809.00 | 45,624.00 | 90,698.00 | 43,925.00 | 88,145.00 | -108,211.00
Total Ohter Payable | 471,816.00 | 478,887.00 | 658,587.00 | 304,782.00 | 335,013.00 | 457,891.00 | 796,524.00 | 413,554.00 | 556,475.00 | 326,709.00 | 449,104.00 | 305,080.00 | 570,276.00
Total Other Current Liabilities | 471,816.00 | 478,887.00 | 658,587.00 | 304,782.00 | 335,013.00 | 457,891.00 | 796,524.00 | 413,554.00 | 556,475.00 | 326,709.00 | 449,104.00 | 305,080.00 | 570,276.00
Total Current Liabilities | 471,816.00 | 478,887.00 | 658,587.00 | 304,782.00 | 335,013.00 | 457,891.00 | 796,524.00 | 413,554.00 | 556,475.00 | 326,709.00 | 449,104.00 | 305,080.00 | 570,276.00
Total Liabilities | 471,816.00 | 478,887.00 | 658,587.00 | 304,782.00 | 335,013.00 | 457,891.00 | 796,524.00 | 413,554.00 | 556,475.00 | 326,709.00 | 449,104.00 | 305,080.00 | 570,276.00
Equity
Current Account With H/O | 20,879,943.08 | 22,558,943.08 | 23,818,193.08 | 25,077,443.08 | 25,916,943.08 | 27,176,193.08 | 28,435,443.08 | 29,694,693.08 | 30,953,943.08 | 32,632,943.08 | 33,892,193.08 | 35,571,193.08 | 37,250,193.08 | 16,370,250.00
Retained Earnings | -6,811,980.40 | -6,811,980.40 | -6,811,980.40 | -6,811,980.40 | -6,811,980.40 | -6,811,980.40 | -6,811,980.40 | -22,751,656.10 | -22,751,656.10 | -22,751,656.10 | -22,751,656.10 | -22,751,656.10 | -22,751,656.10 | 15,939,675.7
Net Income | -7,938,305.00 | -9,647,087.00 | -10,863,209.00 | -12,051,273.00 | -13,290,317.00 | -14,528,882.00 | -15,939,675.70 | -1,425,955.80 | -2,845,873.80 | -4,158,659.80 | -5,475,294.80 | -7,089,683.80 | -8,429,829.80 | 491,524.8
Total Equity | 6,129,657.68 | 6,099,875.68 | 6,143,003.68 | 6,214,189.68 | 5,814,645.68 | 5,835,330.68 | 5,683,786.98 | 5,517,081.18 | 5,356,413.18 | 5,722,627.18 | 5,665,242.18 | 5,729,853.18 | 6,068,707.18
TOTAL LIABILITIES & EQUITY | 6,601,473.68 | 6,578,762.68 | 6,801,590.68 | 6,518,971.68 | 6,149,658.68 | 6,293,221.68 | 6,480,310.98 | 5,930,635.18 | 5,912,888.18 | 6,049,336.18 | 6,114,346.18 | 6,034,933.18 | 6,638,983.18