Naeem Maqsood, Aca
$15/hr
Chartered Accountant
- Reply rate:
- 100.0%
- Availability:
- Hourly ($/hour)
- Location:
- Lahore, Punjab, Pakistan
- Experience:
- 10 years
SEPHIROT CONSTRUCTORS CORP
PROJECTED BALANCE SHEETS
As at Mar 31, 2019
Mar 2019
US$
ASSETS
Current Assets:
Cash and cash equivalents
40,830
Trade receivables
520,300
Inventories
589,116
Other current assets
50,000
1,200,246
Non-Current Assets:
Property and equipment
127,500
127,500
Apr 2019
US$
May 2019
US$
Jun 2019
US$
Jul 2019
US$
Aug 2019
US$
Sep 2019
US$
Oct 2019
US$
Nov 2019
US$
Dec 2019
US$
Jan 2020
US$
Feb 2020
US$
Mar 2020
US$
42,872
534,400
597,951
50,000
1,225,223
38,120
566,786
603,931
50,000
1,258,837
61,348
569,620
606,950
50,250
1,288,168
85,815
572,468
609,985
50,501
1,318,770
111,528
575,330
613,035
50,754
1,350,647
138,495
578,207
616,100
51,008
1,383,810
166,725
581,098
619,181
51,263
1,418,266
196,221
584,004
622,276
51,519
1,454,020
226,994
586,924
625,388
51,776
1,491,082
259,054
589,858
628,515
52,035
1,529,463
292,411
592,807
631,657
52,296
1,569,171
327,074
595,772
634,816
52,557
1,610,218
126,969
126,969
126,440
126,440
125,913
125,913
125,388
125,388
124,866
124,866
124,345
124,345
123,827
123,827
123,311
123,311
122,797
122,797
122,286
122,286
121,776
121,776
121,269
121,269
1,327,746
1,352,192
1,385,276
1,414,080
1,444,158
1,475,513
1,508,155
1,542,093
1,577,331
1,613,879
1,651,748
1,690,947
1,731,486
115,500
120,000
85,000
320,500
110,300
110,000
80,750
301,050
111,403
100,000
76,713
288,116
111,960
90,000
72,877
274,837
112,520
80,000
69,233
261,753
113,082
70,000
65,771
248,853
113,648
60,000
62,482
236,130
114,216
50,000
59,358
223,574
114,787
40,000
56,390
211,177
115,361
30,000
53,571
198,932
115,938
20,000
50,892
186,830
116,518
10,000
48,347
174,865
117,100
45,930
163,030
LIABILITIES AND EQUITY
Current liabilities:
Accounts payable
Current maturities of debt
Income taxes payable
Long-term liabilities
-
-
-
-
-
-
-
-
-
-
-
-
-
Equity:
Owners' Equity
Un-appropriated profit
Total equity
Signature:
Name:
Title:
Date:
250,000
757,246
1,007,246
250,000
801,142
1,051,142
250,000
847,161
1,097,161
245,000
894,244
1,139,244
240,000
942,405
1,182,405
235,000
991,660
1,226,660
230,000
1,042,026
1,272,026
225,000
1,093,519
1,318,519
220,000
1,146,154
1,366,154
215,000
1,199,948
1,414,948
210,000
1,254,919
1,464,919
205,000
1,311,083
1,516,083
200,000
1,368,457
1,568,457
1,327,746
1,352,192
1,385,277
1,414,081
1,444,157
1,475,513
1,508,155
1,542,093
1,577,331
1,613,880
1,651,748
1,690,947
1,731,487
SEPHIROT CONSTRUCTORS CORP
Projected Profit and loss account
For the period ended Mar 31, 2019
Mar 2019
US$
Revenues
Cost of revenues
Gross profit
Apr 2019
US$
May 2019
US$
Jun 2019
US$
Jul 2019
US$
Aug 2019
US$
Sep 2019
US$
Oct 2019
US$
Nov 2019
US$
Dec 2019
US$
Jan 2020
US$
Feb 2020
US$
Mar 2020
US$
4,123,604
(3,388,217)
735,387
350,850
(288,958)
61,892
354,854
(290,403)
64,451
358,403
(292,726)
65,677
361,987
(295,068)
66,919
365,607
(297,429)
68,178
369,263
(299,808)
69,455
372,956
(302,206)
70,750
376,686
(304,624)
72,062
380,453
(307,061)
73,392
384,258
(309,517)
74,741
388,101
(311,993)
76,108
391,982
(314,489)
77,493
(119,993)
(10,156)
(10,512)
(10,596)
(10,681)
(10,766)
(10,852)
(10,939)
(11,027)
(11,115)
(11,204)
(11,294)
(11,384)
Operating income
615,394
51,736
53,939
55,081
56,238
57,412
58,603
59,811
61,035
62,277
63,537
64,814
66,109
Finance cost
Taxes
(8,148)
(85,000)
(687)
(7,154)
(695)
(7,225)
(701)
(7,297)
(707)
(7,370)
(713)
(7,444)
(719)
(7,518)
(725)
(7,593)
(731)
(7,669)
(737)
(7,746)
(743)
(7,823)
(749)
(7,901)
(755)
(7,980)
Net income
522,246
43,896
46,019
47,083
48,161
49,255
50,366
51,493
52,635
53,794
54,971
56,164
57,374
General and administrative expenses
Signature:
Name:
Title:
Date:
