[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
Checking/Savings
Cash & Cash Equivalents
Cash at Bank | 2,459,200.50 | 1,674,126.50 | 1,674,126.50 | 1,208,819.50 | 700,354.50 | 356,889.50 | 4,250,635.50 | 3,621,955.50 | 2,930,584.50 | 2,615,909.50 | 1,733,925.50 | 1,129,323.50 | 4,654,865.50
Cash in Hand | 5,533.00 | 5,533.00 | 5,533.00 | 3,233.00 | 3,233.00 | 3,233.00 | 3,233.00 | 3,233.00 | 3,233.00 | 3,233.00 | 3,233.00 | 3,233.00 | 3,233.00
Total Cash & Cash Equivalents | 2,464,733.50 | 1,679,659.50 | 1,679,659.50 | 1,212,052.50 | 703,587.50 | 360,122.50 | 4,253,868.50 | 3,625,188.50 | 2,933,817.50 | 2,619,142.50 | 1,737,158.50 | 1,132,556.50 | 4,658,098.50
Total Checking/Savings | 2,464,733.50 | 1,679,659.50 | 1,679,659.50 | 1,212,052.50 | 703,587.50 | 360,122.50 | 4,253,868.50 | 3,625,188.50 | 2,933,817.50 | 2,619,142.50 | 1,737,158.50 | 1,132,556.50 | 4,658,098.50
Other Current Assets
Advance, Deposits & Prepayments
Advance against Consulting Fees | 161,000.00 | 64,400.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00
Advances to Employee | 125,000.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00
Total Advance, Deposits & Prepayments | 286,000.00 | 64,400.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00
Total Other Current Assets | 286,000.00 | 64,400.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00
Total Current Assets | 2,750,733.50 | 1,744,059.50 | 1,679,659.50 | 1,212,052.50 | 703,587.50 | 360,122.50 | 4,253,868.50 | 3,625,188.50 | 2,933,817.50 | 2,619,142.50 | 1,737,158.50 | 1,132,556.50 | 4,658,098.50
Fixed Assets
Computer Equipments
Acc. Dep. - Computer Equipments | -252,937.24 | -274,155.06 | -291,504.31 | -308,419.82 | -324,912.45 | -340,992.76 | -356,671.06 | -371,957.40 | -386,861.59 | -401,393.17 | -415,561.46 | -429,375.54 | -442,844.27
Computer Equipments - Other | 843,125.00 | 968,125.00 | 968,125.00 | 968,125.00 | 968,125.00 | 968,125.00 | 968,125.00 | 968,125.00 | 968,125.00 | 968,125.00 | 968,125.00 | 968,125.00 | 968,125.00
Total Computer Equipments | 590,187.76 | 693,969.94 | 676,620.69 | 659,705.18 | 643,212.55 | 627,132.24 | 611,453.94 | 596,167.60 | 581,263.41 | 566,731.83 | 552,563.54 | 538,749.46 | 525,280.73
Furniture & Fixtures
Acc. Dep.- Furniture & Fixtures | -2,459.56 | -2,652.90 | -2,835.79 | -3,017.16 | -3,197.02 | -3,375.38 | -3,552.25 | -3,727.65 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00
Furniture & Fixtures - Other | 24,600.00 | 24,600.00 | 24,600.00 | 24,600.00 | 24,600.00 | 24,600.00 | 24,600.00 | 24,600.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00
Total Furniture & Fixtures | 22,140.44 | 21,947.10 | 21,764.21 | 21,582.84 | 21,402.98 | 21,224.62 | 21,047.75 | 20,872.35 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00
Office Equipments
Acc. Dep. - Office Equipments | -2,735.59 | -2,951.51 | -3,154.85 | -3,356.50 | -3,556.47 | -3,754.77 | -3,951.42 | -4,146.43 | -4,339.81 | -4,531.58 | -4,721.75 | -4,910.34 | -5,097.36
Office Equipments - Other | 27,353.00 | 27,353.00 | 27,353.00 | 27,353.00 | 27,353.00 | 27,353.00 | 27,353.00 | 27,353.00 | 27,353.00 | 27,353.00 | 27,353.00 | 27,353.00 | 27,353.00
Total Office Equipments | 24,617.41 | 24,401.49 | 24,198.15 | 23,996.50 | 23,796.53 | 23,598.23 | 23,401.58 | 23,206.57 | 23,013.19 | 22,821.42 | 22,631.25 | 22,442.66 | 22,255.64
Total Fixed Assets | 636,945.61 | 740,318.53 | 722,583.05 | 705,284.52 | 688,412.06 | 671,955.09 | 655,903.27 | 640,246.52 | 604,276.60 | 589,553.25 | 575,194.79 | 561,192.12 | 547,536.37
TOTAL ASSETS | 3,387,679.11 | 2,484,378.03 | 2,402,242.55 | 1,917,337.02 | 1,391,999.56 | 1,032,077.59 | 4,909,771.77 | 4,265,435.02 | 3,538,094.10 | 3,208,695.75 | 2,312,353.29 | 1,693,748.62 | 5,205,634.87
LIABILITIES & EQUITY
Liabilities
Current Liabilities
Other Current Liabilities
Liabilities for Expenses
Audit Fee Payable | 92,920.00 | 92,920.00 | 92,920.00 | 92,920.00 | 92,920.00 | 92,920.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 185,840.00
Consultancy Fees Payable | 164,450.00 | 164,450.00 | 181,700.00 | 228,850.00 | 315,100.00 | 379,500.00 | 483,541.00 | 547,769.00 | 494,155.00 | 580,405.00 | 97,750.00 | 64,400.00 | 282,900.00
Office Rent Payable | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 5,000.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00
Salary Payable | 512,324.00 | 165,000.00 | 508,465.00 | 508,465.00 | 343,465.00 | 343,465.00 | 343,465.00 | 309,675.00 | 309,675.00 | 309,675.00 | 497,475.00 | 346,275.00 | 433,899.00
Total Liabilities for Expenses | 769,694.00 | 422,370.00 | 783,085.00 | 830,235.00 | 751,485.00 | 820,885.00 | 827,006.00 | 857,444.00 | 803,830.00 | 890,080.00 | 595,225.00 | 410,675.00 | 902,639.00
Liabilities to Govt.
TDS Payable
TDS Payable on Office Rent | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 263.00 | 526.00 | 263.00 | 263.00 | 526.00 | 263.00 | 263.00 | 263.00
TDS Payable on Salary | 0.00 | 0.00 | 6,535.00 | 6,535.00 | 13,070.00 | 19,605.00 | 13,070.00 | 3,325.00 | 3,325.00 | 6,650.00 | 3,325.00 | 3,325.00 | 2,901.00
TDS Payable on Supplies | 2,496.00 | 5,047.00 | 5,047.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00
Total TDS Payable | 2,496.00 | 5,047.00 | 11,582.00 | 6,535.00 | 13,070.00 | 19,868.00 | 13,596.00 | 3,588.00 | 3,588.00 | 7,176.00 | 3,588.00 | 3,588.00 | 3,164.00
VDS Payable
VDS Payable on Office Rent | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 789.00 | 1,578.00 | 789.00 | 789.00 | 1,578.00 | 789.00 | 789.00 | 789.00
VDS Payable on Supplies | 9,362.00 | 18,928.00 | 18,928.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00
Total VDS Payable | 9,362.00 | 18,928.00 | 18,928.00 | 0.00 | 0.00 | 789.00 | 1,578.00 | 789.00 | 789.00 | 1,578.00 | 789.00 | 789.00 | 789.00
Total Liabilities to Govt. | 11,858.00 | 23,975.00 | 30,510.00 | 6,535.00 | 13,070.00 | 20,657.00 | 15,174.00 | 4,377.00 | 4,377.00 | 8,754.00 | 4,377.00 | 4,377.00 | 3,953.00
Loan from Parent Company | 2,904,510.00 | 2,904,510.00 | 2,904,510.00 | 2,904,510.00 | 2,904,510.00 | 2,904,510.00 | 7,416,630.00 | 7,416,630.00 | 7,416,630.00 | 7,416,630.00 | 7,416,630.00 | 7,416,630.00 | 7,416,630.00
Payable to TCF (Adv. Payment) | 74,082.00 | 74,082.00 | 74,082.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00
Total Other Current Liabilities | 3,760,144.00 | 3,424,937.00 | 3,792,187.00 | 3,741,280.00 | 3,669,065.00 | 3,746,052.00 | 8,258,810.00 | 8,278,451.00 | 8,224,837.00 | 8,315,464.00 | 8,016,232.00 | 7,831,682.00 | 8,323,222.00
Total Current Liabilities | 3,760,144.00 | 3,424,937.00 | 3,792,187.00 | 3,741,280.00 | 3,669,065.00 | 3,746,052.00 | 8,258,810.00 | 8,278,451.00 | 8,224,837.00 | 8,315,464.00 | 8,016,232.00 | 7,831,682.00 | 8,323,222.00
Total Liabilities | 3,760,144.00 | 3,424,937.00 | 3,792,187.00 | 3,741,280.00 | 3,669,065.00 | 3,746,052.00 | 8,258,810.00 | 8,278,451.00 | 8,224,837.00 | 8,315,464.00 | 8,016,232.00 | 7,831,682.00 | 8,323,222.00
Equity
Retained Earnings | -406,578.00 | -406,578.00 | -406,578.00 | -406,578.00 | -406,578.00 | -406,578.00 | -406,578.00 | -6,787,513.73 | -6,787,513.73 | -6,787,513.73 | -6,787,513.73 | -6,787,513.73 | -6,787,513.73
Share Capiital | 3,300,000.00 | 3,300,000.00 | 3,300,000.00 | 3,300,000.00 | 3,300,000.00 | 3,300,000.00 | 3,300,000.00 | 3,300,000.00 | 3,300,000.00 | 3,300,000.00 | 3,300,000.00 | 3,300,000.00 | 3,300,000.00
Share Money Deposit | 138,475.50 | 138,475.50 | 138,475.50 | 138,475.50 | 138,475.50 | 138,475.50 | 138,475.50 | 138,475.50 | 138,475.50 | 138,475.50 | 138,475.50 | 138,475.50 | 138,475.50
Net Income | -3,404,362.39 | -3,972,456.47 | -4,421,841.95 | -4,855,840.48 | -5,308,962.94 | -5,745,871.91 | -6,380,935.73 | -663,977.75 | -1,337,704.67 | -1,757,730.02 | -2,354,840.48 | -2,788,895.15 | 231,451.10
Total Equity | -372,464.89 | -940,558.97 | -1,389,944.45 | -1,823,942.98 | -2,277,065.44 | -2,713,974.41 | -3,349,038.23 | -4,013,015.98 | -4,686,742.90 | -5,106,768.25 | -5,703,878.71 | -6,137,933.38 | -3,117,587.13
TOTAL LIABILITIES & EQUITY | 3,387,679.11 | 2,484,378.03 | 2,402,242.55 | 1,917,337.02 | 1,391,999.56 | 1,032,077.59 | 4,909,771.77 | 4,265,435.02 | 3,538,094.10 | 3,208,695.75 | 2,312,353.29 | 1,693,748.62 | 5,205,634.87