PAST PAPER ANSWERS - 2017 (B)

QUESTION NO -04
Business Name:- NM Company Ltd
Go to Account Trial Balance
In st / B.she Debit Credit
IN Sales 1,450,000.00
IN Purchase 1,035,000.00
BS Trade Debtors 49,000.00
BS Provision for doubtful debt 01.04.2016 3,500.00
IN Advertising expenses 71,000.00
IN Repair to buildings 249,000.00
IN Salaries & Wages 781,000.00
IN Other Administrative expenses 420,000.00
IN Rent income 35,000.00
IN Discount Received 41,000.00
IN Losses frome stock damages 10,500.00
IN Stock @ 01.04.2016 38,000.00
BS Trade Creditor 42,000.00
BS Buildings (cost) 1,300,000.00
BS Land (cost) 2,000,000.00
Provision for depreciation as @ 01.04.2016
BS Buildings 390,000.00
BS cash 108,000.00
BS capital 4,100,000.00

ADJUSTMENTS
BS Closing stock
IN Closing stock
IN Building depreciation
BS Accruid advertising expences
BS prepaid rent incom
IN under provsion doubtful debt
Total 6,061,500.00 6,061,500.00
Net loss for the year
Total 6,061,500.00 6,061,500.00

QUESTION NO -02
Value of the assets 25000
 Life time 5 Years
Salvage value 5000

Year

1
2
3
4
5
 Computer Application For Accounting- R.Nitharshan
Assignment-01 BAT/AC/2017/F/143
ny Ltd Accounting Period:- 31/03/2017
Adjusting Entries Adjusted Trial Balance Income Statement
Debit Credit Debit Credit Debit Credit
1,450,000.00 1,450,000.00
1,035,000.00 1,035,000.00
49,000.00
1,400.00 4,900.00
22,000.00 93,000.00 93,000.00
100,000.00 149,000.00 149,000.00
781,000.00 781,000.00
420,000.00 420,000.00
35,000.00
41,000.00 41,000.00
10,500.00 10,500.00
38,000.00 38,000.00
42,000.00
100,000.00 1,400,000.00
2,000,000.00

135,000.00 525,000.00
108,000.00
4,100,000.00

68,000.00 68,000.00
68,000.00 68,000.00 68,000.00
135,000.00 135,000.00 135,000.00
22,000.00 22,000.00
35,000.00 35,000.00
1,400.00 1,400.00 1,400.00
361,400.00 361,400.00 6,287,900.00 6,287,900.00 2,662,900.00 1,559,000.00
1,103,900.00
361,400.00 361,400.00 6,287,900.00 6,287,900.00 2,662,900.00 2,662,900.00
Starting book
Accumulated Ending book
value for Rate Depreciation depreciation value
period
25,000.00 20% $10,000.00 10,000.00 15,000.00
15,000.00 20% 6,000.00 16,000.00 9,000.00
9,000.00 20% 3,600.00 19,600.00 5,400.00
5,400.00 20% 400.00 20,000.00 5,000.00
5,000.00 20% - 20,000.00 5,000.00
R.Nitharshan
/AC/2017/F/143

Balance Sheet
Debit Credit

49,000.00
4,900.00

42,000.00
1,400,000.00
2,000,000.00

525,000.00
108,000.00
- 4,100,000.00

68,000.00

22,000.00
35,000.00

3,625,000.00 4,728,900.00
1,103,900.00
4,728,900.00 4,728,900.00
 PAST PAPER ANSWERS - 2016 (A) Computer Appli
Assi
QUESTION NO -03

Business Name:- Brora trading

Go to Account Trial Balance Adjusting Entries
In st / B.she Debit Credit Debit
BS Capital 425,000.00
BS Drawing 20,500.00
BS Trade Debtors 45,800.00
BS Trade Creditors 38,600.00
BS Buildings 257,000.00
IN Purchase 275,800.00
IN Salaries 97,500.00
IN Opening Stock 37,500.00
BS Bank 36,450.00
BS Equipment 61,500.00
IN Electricity 22,500.00
IN Telephone 5,500.00
IN Salaries payable 4,600.00
IN rent And Taxes 10,350.00 650.00
IN Sales 411,400.00

ADJUSTMENTS
BS Prepaid electricity 2,500.00
BS Rent& Tax Payable
BS Closing Stock 28,000.00
IN Closing Stock
IN depreciation Equipment 6,150.00

Total 875,000.00 875,000.00 37,300.00

Net lost for the year
Total 875,000.00 875,000.00 37,300.00

QUESTION NO -02
Loan borrowing 1500000
Period 4 years
Rate 15%

Monthly
Loan starting Mmonthly
Period / Months balance instalment capital
payment
1 1,500,000 (41,746) (22,996)
2 1,477,004 (41,746) (23,284)
3 1,453,720 (41,746) (23,575)
4 1,430,146 (41,746) (23,869)
5 1,406,276 (41,746) (24,168)
6 1,382,109 (41,746) (24,470)
7 1,357,639 (41,746) (24,776)
8 1,332,863 (41,746) (25,085)
9 1,307,778 (41,746) (25,399)
10 1,282,379 (41,746) (25,716)
11 1,256,663 (41,746) (26,038)
12 1,230,625 (41,746) (26,363)
13 1,204,262 (41,746) (26,693)
14 1,177,569 (41,746) (27,027)
15 1,150,542 (41,746) (27,364)
16 1,123,178 (41,746) (27,706)
17 1,095,471 (41,746) (28,053)
18 1,067,419 (41,746) (28,403)
19 1,039,015 (41,746) (28,758)
20 1,010,257 (41,746) (29,118)
21 981,139 (41,746) (29,482)
22 951,657 (41,746) (29,850)
23 921,807 (41,746) (30,224)
24 891,583 (41,746) (30,601)
25 860,982 (41,746) (30,984)
26 829,998 (41,746) (31,371)
27 798,627 (41,746) (31,763)
28 766,864 (41,746) (32,160)
29 734,703 (41,746) (32,562)
30 702,141 (41,746) (32,969)
31 669,172 (41,746) (33,381)
32 635,790 (41,746) (33,799)
33 601,991 (41,746) (34,221)
34 567,770 (41,746) (34,649)
35 533,121 (41,746) (35,082)
36 498,039 (41,746) (35,521)
37 462,518 (41,746) (35,965)
38 426,554 (41,746) (36,414)
 39 390,139 (41,746) (36,869)
40 353,270 (41,746) (37,330)
41 315,940 (41,746) (37,797)
42 278,143 (41,746) (38,269)
43 239,874 (41,746) (38,748)
44 201,126 (41,746) (39,232)
45 161,894 (41,746) (39,722)
46 122,171 (41,746) (40,219)
47 81,952 (41,746) (40,722)
48 41,231 (41,746) (41,231)

QUESTION NO -02
value of the assets 675000
Life time 4 years
salvage value 25000

depreciation
beginning
year rate value straigt line ending value
method

1 25% 675,000.00 162,500.00 512,500.00

2 25% 512,500.00 162,500.00 350,000.00
3 25% 350,000.00 162,500.00 187,500.00
4 25% 187,500.00 162,500.00 25,000.00
Computer Application For Accounting- R.Nitharshan
Assignment-01 BAT/AC/2017/F/143

Accounting Period:- 31/03/2016

Adjusting Entries Adjusted Trial Balance Income Statement Balance Sheet
Credit Debit Credit Debit Credit Debit
425,000.00
20,500.00 20,500.00
45,800.00 45,800.00
38,600.00
257,000.00 257,000.00
275,800.00 275,800.00
97,500.00 97,500.00
37,500.00 37,500.00
36,450.00 36,450.00
6,150.00 55,350.00 55,350.00
2,500.00 20,000.00 20,000.00
5,500.00 5,500.00
4,600.00 4,600.00
11,000.00 11,000.00
411,400.00 411,400.00

2,500.00 2,500.00
650.00 650.00
28,000.00 28,000.00
28,000.00 28,000.00 28,000.00
6,150.00 6,150.00

37,300.00 903,650.00 903,650.00 458,050.00 439,400.00 445,600.00

18,650.00 18,650.00
37,300.00 903,650.00 903,650.00 458,050.00 458,050.00 464,250.00
Monthly
Loan ending
intrest balance
payment
(18,750) 1,477,004
(18,463) 1,453,720
(18,172) 1,430,146
(17,877) 1,406,276
(17,578) 1,382,109
(17,276) 1,357,639
(16,970) 1,332,863
(16,661) 1,307,778
(16,347) 1,282,379
(16,030) 1,256,663
(15,708) 1,230,625
(15,383) 1,204,262
(15,053) 1,177,569
(14,720) 1,150,542
(14,382) 1,123,178
(14,040) 1,095,471
(13,693) 1,067,419
(13,343) 1,039,015
(12,988) 1,010,257
(12,628) 981,139
(12,264) 951,657
(11,896) 921,807
(11,523) 891,583
(11,145) 860,982
(10,762) 829,998
(10,375) 798,627
(9,983) 766,864
(9,586) 734,703
(9,184) 702,141
(8,777) 669,172
(8,365) 635,790
(7,947) 601,991
(7,525) 567,770
(7,097) 533,121
(6,664) 498,039
(6,225) 462,518
(5,781) 426,554
(5,332) 390,139
 (4,877) 353,270
(4,416) 315,940
(3,949) 278,143
(3,477) 239,874
(2,998) 201,126
(2,514) 161,894
(2,024) 122,171
(1,527) 81,952
(1,024) 41,231
(515) 0

depreciation depreciation
beginning beginning
value sum of year ending value value double decli ending value
digit method method

675,000.00 260,000.00 415,000.00 675,000.00 337,500.00 337,500.00

415,000.00 195,000.00 220,000.00 337,500.00 168,750.00 168,750.00
220,000.00 130,000.00 90,000.00 168,750.00 84,375.00 84,375.00
90,000.00 65,000.00 25,000.00 84,375.00 59,375.00 25,000.00
shan
7/F/143

Balance Sheet
Credit
425,000.00

38,600.00

650.00

464,250.00
-
464,250.00
 PAST PAPER ANSWERS - 2015 (B)
QUESTION NO -04

Business Name:- Sumathra

Go to Account Trial Balance
In st / B.she Debit
IN Sales
IN opening Stock 330,000.00
BS Account Receivable 470,000.00
BS Account Payable
BS Cash & Bank 90,000.00
IN Return Inwards 30,000.00
IN Return Outwards
IN Finance Cost 26,000.00
BS Building at Cost 500,000.00
BS Motor Vehicle at Cost 1,500,000.00
BS Bank Loan
IN Administrative Expences 50,000.00
IN Purchase 400,000.00
IN Carriage Inward 8,000.00
IN Carriage Outward 7,000.00
BS Drawing 12,000.00
IN Distribution Cost 16,000.00
BS Investment At cost 100,000.00
IN Other Income
BS Capital
BS Accumulated depreciation building at 01.04.2015
BS Accumulated depreciation MV at 01.04.2015

ADJUSTMENTS
BS Closing Stock
IN Closing Stock
IN Building depreciation
IN MV depreciation
BS Accruid Admin Expences
BS other income Receivable
IN doubtful debt
BS provision for doubtful debt

Total 3,539,000.00
Net profit for the year
Total 3,539,000.00
QUESTION NO -03 (ii)
Loan borrowing 1000000
Period 5 years
Rate 15%

Loan starting
Period / Months
balance

1 1,000,000
2 988,710
3 977,279
4 965,705
5 953,986
6 942,121
7 930,108
8 917,944
9 905,629
10 893,159
11 880,534
12 867,750
13 854,807
14 841,703
15 828,434
16 814,999
17 801,397
18 787,625
19 773,680
20 759,561
21 745,266
22 730,791
23 716,136
24 701,298
25 686,274
26 671,063
27 655,661
28 640,067
29 624,278
30 608,292
31 592,105
32 575,717
33 559,123
34 542,322
35 525,311
36 508,088
37 490,649
38 472,992
39 455,115
40 437,014
41 418,687
42 400,130
43 381,342
44 362,319
45 343,058
46 323,556
47 303,811
48 283,818
49 263,576
50 243,081
51 222,329
52 201,319
53 180,045
54 158,506
55 136,697
56 114,616
57 92,259
58 69,622
59 46,702
60 23,496
 Computer Application For Accounting- R.Nitharshan
Assignment-01 BAT/AC/2017/F/143

mathra Accounting Period:- 31/03/2015

Trial Balance Adjusting Entries Adjusted Trial Balance Income Statement
Credit Debit Credit Debit Credit Debit Credit
1,630,000.00 1,630,000.00 1,630,000.00
330,000.00 330,000.00
470,000.00
400,000.00 400,000.00
90,000.00
30,000.00 30,000.00
18,000.00 18,000.00 18,000.00
26,000.00 26,000.00
500,000.00
1,500,000.00
200,000.00 200,000.00
20,000.00 70,000.00 70,000.00
400,000.00 400,000.00
8,000.00 8,000.00
7,000.00 7,000.00
12,000.00
16,000.00 16,000.00
100,000.00
100,000.00 12,000.00 112,000.00 112,000.00
1,100,000.00 1,100,000.00
47,000.00 125,000.00 172,000.00
44,000.00 300,000.00 344,000.00

60,000.00 60,000.00
60,000.00 60,000.00 60,000.00
125,000.00 125,000.00 125,000.00
300,000.00 300,000.00 300,000.00
20,000.00 20,000.00
12,000.00 12,000.00
47,000.00 47,000.00 47,000.00
47,000.00 47,000.00

3,539,000.00 564,000.00 564,000.00 4,103,000.00 4,103,000.00 1,359,000.00 1,820,000.00

461,000.00
3,539,000.00 564,000.00 564,000.00 4,103,000.00 4,103,000.00 1,820,000.00 1,820,000.00
 Monthly Monthly Monthly Loan ending
capital intrest
instalment payment payment balance

(23,790) (11,290) (12,500) 988,710

(23,790) (11,431) (12,359) 977,279
(23,790) (11,574) (12,216) 965,705
(23,790) (11,719) (12,071) 953,986
(23,790) (11,865) (11,925) 942,121
(23,790) (12,013) (11,777) 930,108
(23,790) (12,164) (11,626) 917,944
(23,790) (12,316) (11,474) 905,629
(23,790) (12,470) (11,320) 893,159
(23,790) (12,625) (11,164) 880,534
(23,790) (12,783) (11,007) 867,750
(23,790) (12,943) (10,847) 854,807
(23,790) (13,105) (10,685) 841,703
(23,790) (13,269) (10,521) 828,434
(23,790) (13,435) (10,355) 814,999
(23,790) (13,602) (10,187) 801,397
(23,790) (13,772) (10,017) 787,625
(23,790) (13,945) (9,845) 773,680
(23,790) (14,119) (9,671) 759,561
(23,790) (14,295) (9,495) 745,266
(23,790) (14,474) (9,316) 730,791
(23,790) (14,655) (9,135) 716,136
(23,790) (14,838) (8,952) 701,298
(23,790) (15,024) (8,766) 686,274
(23,790) (15,211) (8,578) 671,063
(23,790) (15,402) (8,388) 655,661
(23,790) (15,594) (8,196) 640,067
(23,790) (15,789) (8,001) 624,278
(23,790) (15,986) (7,803) 608,292
(23,790) (16,186) (7,604) 592,105
(23,790) (16,389) (7,401) 575,717
(23,790) (16,593) (7,196) 559,123
(23,790) (16,801) (6,989) 542,322
(23,790) (17,011) (6,779) 525,311
(23,790) (17,224) (6,566) 508,088
(23,790) (17,439) (6,351) 490,649
(23,790) (17,657) (6,133) 472,992
(23,790) (17,878) (5,912) 455,115
(23,790) (18,101) (5,689) 437,014
(23,790) (18,327) (5,463) 418,687
(23,790) (18,556) (5,234) 400,130
(23,790) (18,788) (5,002) 381,342
(23,790) (19,023) (4,767) 362,319
(23,790) (19,261) (4,529) 343,058
(23,790) (19,502) (4,288) 323,556
(23,790) (19,745) (4,044) 303,811
(23,790) (19,992) (3,798) 283,818
(23,790) (20,242) (3,548) 263,576
(23,790) (20,495) (3,295) 243,081
(23,790) (20,751) (3,039) 222,329
(23,790) (21,011) (2,779) 201,319
(23,790) (21,273) (2,516) 180,045
(23,790) (21,539) (2,251) 158,506
(23,790) (21,809) (1,981) 136,697
(23,790) (22,081) (1,709) 114,616
(23,790) (22,357) (1,433) 92,259
(23,790) (22,637) (1,153) 69,622
(23,790) (22,920) (870) 46,702
(23,790) (23,206) (584) 23,496
(23,790) (23,496) (294) 0
 Balance Sheet
Debit Credit

470,000.00
400,000.00
90,000.00

500,000.00
1,500,000.00
200,000.00

12,000.00

100,000.00

1,100,000.00
172,000.00
344,000.00

60,000.00

20,000.00
12,000.00

47,000.00

2,744,000.00 2,283,000.00
461,000.00
2,744,000.00 2,744,000.00
 PAST PAPER ANSWERS - 2014 (B)
QUESTION NO -04
Business Name:- Araliya Ltd
Go to Account Trial Balance Adjusting Entries
In st / B.she Debit Credit Debit
IN Advertising 44,000.00
BS Bank Loan 400,000.00
IN Sales 1,900,000.00
IN Salaries 192,000.00
IN Telephone 72,000.00
IN Electricity 36,000.00
IN Bad debt 20,000.00
IN Stock @01.04.2013 76,000.00
IN Rent & Rates 96,000.00 4,000.00
BS Land & Buildings 800,000.00
BS Office Equipment 200,000.00
BS Motor vehicle 500,000.00
BS Debtors 100,000.00
BS Cash at bank 50,000.00
BS Creditors 50,000.00
BS Drawing 30,000.00
BS Capital 666,000.00
IN Purchase 800,000.00

ADJUSTMENTS
BS Closing Stock 100,000.00
IN Closing Stock
BS Rent & Rates Payable
BS Prepaid Electricity 6,000.00
IN Office Equipment depreciation 20,000.00
IN MV depreciation 75,000.00

Total 3,016,000.00 3,016,000.00 205,000.00

Net profit for the year
 Total 3,016,000.00 3,016,000.00 205,000.00

QUESTION NO -03 (A)

Loan borrowing 725000
Period 5 years
Rate 7%

Period / Loan starting Monthly

Months balance instalment

1 725,000 (14,356)
2 714,873 (14,356)
3 704,688 (14,356)
4 694,442 (14,356)
5 684,137 (14,356)
6 673,772 (14,356)
7 663,347 (14,356)
8 652,860 (14,356)
9 642,313 (14,356)
10 631,704 (14,356)
11 621,033 (14,356)
12 610,300 (14,356)
13 599,504 (14,356)
14 588,645 (14,356)
15 577,723 (14,356)
16 566,737 (14,356)
17 555,687 (14,356)
18 544,573 (14,356)
19 533,394 (14,356)
20 522,149 (14,356)
21 510,839 (14,356)
22 499,463 (14,356)
23 488,021 (14,356)
24 476,512 (14,356)
25 464,936 (14,356)
26 453,292 (14,356)
27 441,580 (14,356)
28 429,800 (14,356)
 29 417,952 (14,356)
30 406,034 (14,356)
31 394,047 (14,356)
32 381,989 (14,356)
33 369,862 (14,356)
34 357,663 (14,356)
35 345,394 (14,356)
36 333,053 (14,356)
37 320,640 (14,356)
38 308,154 (14,356)
39 295,596 (14,356)
40 282,964 (14,356)
41 270,259 (14,356)
42 257,480 (14,356)
43 244,626 (14,356)
44 231,697 (14,356)
45 218,693 (14,356)
46 205,613 (14,356)
47 192,456 (14,356)
48 179,223 (14,356)
49 165,913 (14,356)
50 152,524 (14,356)
51 139,058 (14,356)
52 125,514 (14,356)
53 111,890 (14,356)
54 98,187 (14,356)
55 84,404 (14,356)
56 70,540 (14,356)
57 56,596 (14,356)
58 42,570 (14,356)
59 28,462 (14,356)
60 14,273 (14,356)

QUESTION NO -02
value of the assets 625000
Life time 5 years
salvage value 25000
 depreciation
year rate beginning value straigt line ending value
method
1 20% 625,000 120,000 505,000
2 20% 505,000 120,000 385,000
3 20% 385,000 120,000 265,000
4 20% 265,000 120,000 145,000
5 20% 145,000 120,000 25,000

Chart Title
700000

600000

500000

400000

300000

200000

100000

0
0 2 4 6 8 10 12 14 16

Row 129 Row 130 Row 131 Row 132 Row 133
 Computer Application For Accounting- R.Nitharshan
Assignment-01
BAT/AC/2017/F/143
Accounting Period:- 31/03/2014
Adjusting Entries Adjusted Trial Balance Income Statement Balance Sheet
Credit Debit Credit Debit Credit Debit Credit
44,000.00 44,000.00
400,000.00 400,000.00
1,900,000.00 1,900,000.00
192,000.00 192,000.00
72,000.00 72,000.00
6,000.00 30,000.00 30,000.00
20,000.00 20,000.00
76,000.00 76,000.00
100,000.00 100,000.00
800,000.00 800,000.00
20,000.00 180,000.00 180,000.00
75,000.00 425,000.00 425,000.00
100,000.00 100,000.00
50,000.00 50,000.00
50,000.00 50,000.00
30,000.00 30,000.00
666,000.00 666,000.00
800,000.00 800,000.00

100,000.00 100,000.00
100,000.00 100,000.00 100,000.00
4,000.00 4,000.00 4,000.00
6,000.00 6,000.00
20,000.00 20,000.00
75,000.00 75,000.00

205,000.00 3,120,000.00 3,120,000.00 1,429,000.00 2,000,000.00 1,691,000.00 1,120,000.00

571,000.00 571,000.00
205,000.00 3,120,000.00 3,120,000.00 2,000,000.00 2,000,000.00 1,691,000.00 1,691,000.00

Monthly Monthly Loan ending

capital intrest
payment payment balance

(10,127) (4,229) 714,873

(10,186) (4,170) 704,688
(10,245) (4,111) 694,442
(10,305) (4,051) 684,137
(10,365) (3,991) 673,772
(10,426) (3,930) 663,347
(10,486) (3,870) 652,860
(10,548) (3,808) 642,313
(10,609) (3,747) 631,704
(10,671) (3,685) 621,033
(10,733) (3,623) 610,300
(10,796) (3,560) 599,504
(10,859) (3,497) 588,645
(10,922) (3,434) 577,723
(10,986) (3,370) 566,737
(11,050) (3,306) 555,687
(11,114) (3,242) 544,573
(11,179) (3,177) 533,394
(11,244) (3,111) 522,149
(11,310) (3,046) 510,839
(11,376) (2,980) 499,463
(11,442) (2,914) 488,021
(11,509) (2,847) 476,512
(11,576) (2,780) 464,936
(11,644) (2,712) 453,292
(11,712) (2,644) 441,580
(11,780) (2,576) 429,800
(11,849) (2,507) 417,952
(11,918) (2,438) 406,034
(11,987) (2,369) 394,047
(12,057) (2,299) 381,989
(12,128) (2,228) 369,862
(12,198) (2,158) 357,663
(12,269) (2,086) 345,394
(12,341) (2,015) 333,053
(12,413) (1,943) 320,640
(12,485) (1,870) 308,154
(12,558) (1,798) 295,596
(12,632) (1,724) 282,964
(12,705) (1,651) 270,259
(12,779) (1,577) 257,480
(12,854) (1,502) 244,626
(12,929) (1,427) 231,697
(13,004) (1,352) 218,693
(13,080) (1,276) 205,613
(13,156) (1,199) 192,456
(13,233) (1,123) 179,223
(13,310) (1,045) 165,913
(13,388) (968) 152,524
(13,466) (890) 139,058
(13,545) (811) 125,514
(13,624) (732) 111,890
(13,703) (653) 98,187
(13,783) (573) 84,404
(13,864) (492) 70,540
(13,944) (411) 56,596
(14,026) (330) 42,570
(14,108) (248) 28,462
(14,190) (166) 14,273
(14,273) (83) (0)
 depreciation depreciation
beginning
sum of year ending value beginning value double decli ending value beginning value
value digit method method
625,000 200,000 425,000 625,000 250,000 375,000 625,000
425,000 160,000 265,000 375,000 150,000 225,000 328,125
265,000 120,000 145,000 225,000 90,000 135,000 172,266
145,000 80,000 65,000 135,000 54,000 81,000 90,439
65,000 40,000 25,000 81,000 56,000 25,000 47,481
depreciation
declining ending value
method
296,875 328,125
155,859 172,266
81,826 90,439
42,959 47,481
22,481 25,000
 PAST PAPER ANSWERS - 2015 (B) Computer Applic
Assig
QUESTION NO -04
Business Name:- ABC Ltd
Go to Account Trial Balance
In st / B.she Debit Credit
IN Sales 800,000.00
IN opening stock 70,000.00
BS Account recievable 120,000.00
BS Account Payable 65,000.00
IN Finance Cost 60,000.00
BS Cash at Bank 50,000.00
BS Building at cost 300,000.00
BS Motor vehicle at cost 500,000.00
BS Bank loan 200,000.00
IN Purchase 35,000.00
IN Administrative expences 140,000.00
IN Electricity 10,000.00
IN Distribution cost 12,000.00
BS Investment at Cost (01/01/2013) 254,000.00
IN Other income 60,000.00
BS Stated Capital 400,000.00
BS Accumulated depriciation - Buildings 1/4/2013 10,000.00
BS Accumulated depriciation - mv 1/4/2013 16,000.00

ADJUSTMENTS
IN Motor depreciation
IN Building depriciation
BS Prepaid electricity
BS Closing stock
IN Closing stock
IN Investment income
BS Investment income recievable

Total 1,551,000.00 1,551,000.00

Net profit for the year
Total 1,551,000.00 1,551,000.00

QUESTION NO -02 (ii)

Loan borrowing 800000
Period 5 years
Rate 12%

Loan starting Monthly

Period / Months balance instalment

1 800,000 (17,796)
2 790,204 (17,796)
3 780,311 (17,796)
4 770,318 (17,796)
5 760,226 (17,796)
6 750,033 (17,796)
7 739,738 (17,796)
8 729,339 (17,796)
9 718,837 (17,796)
10 708,230 (17,796)
11 697,517 (17,796)
12 686,696 (17,796)
13 675,768 (17,796)
14 664,730 (17,796)
15 653,582 (17,796)
16 642,322 (17,796)
17 630,950 (17,796)
18 619,464 (17,796)
19 607,863 (17,796)
20 596,146 (17,796)
21 584,312 (17,796)
22 572,359 (17,796)
23 560,287 (17,796)
24 548,094 (17,796)
25 535,780 (17,796)
26 523,342 (17,796)
27 510,780 (17,796)
28 498,092 (17,796)
29 485,278 (17,796)
30 472,335 (17,796)
31 459,263 (17,796)
32 446,060 (17,796)
33 432,725 (17,796)
34 419,256 (17,796)
35 405,653 (17,796)
 36 391,914 (17,796)
37 378,038 (17,796)
38 364,023 (17,796)
39 349,867 (17,796)
40 335,571 (17,796)
41 321,131 (17,796)
42 306,546 (17,796)
43 291,816 (17,796)
44 276,939 (17,796)
45 261,913 (17,796)
46 246,736 (17,796)
47 231,408 (17,796)
48 215,927 (17,796)
49 200,290 (17,796)
50 184,498 (17,796)
51 168,547 (17,796)
52 152,437 (17,796)
53 136,166 (17,796)
54 119,732 (17,796)
55 103,134 (17,796)
56 86,370 (17,796)
57 69,438 (17,796)
58 52,336 (17,796)
59 35,064 (17,796)
60 17,619 (17,796)

QUESTION NO -02
Value of the assets 750000
Life time 5 years
Salvage value 50000

Depreciation
Year Rate Beginning value straigt line
method
1 20% 750,000.00 140,000.00
2 20% 610,000.00 140,000.00
3 20% 470,000.00 140,000.00
4 20% 330,000.00 140,000.00
5 20% 190,000.00 140,000.00
Computer Application For Accounting- R.Nitharshan
Assignment-01
BAT/AC/2017/F/143
Accounting Period:- 31/03/2013
Adjusting Entries Adjusted Trial Balance Income Statement
Debit Credit Debit Credit Debit Credit
800,000.00 800,000.00
70,000.00 70,000.00
120,000.00
65,000.00
60,000.00 60,000.00
50,000.00
300,000.00
500,000.00
200,000.00
35,000.00 35,000.00
140,000.00 140,000.00
2,000.00 8,000.00 8,000.00
12,000.00 12,000.00
254,000.00
60,000.00 60,000.00
400,000.00
45,000.00 55,000.00
60,000.00 76,000.00

60,000.00 60,000.00 60,000.00

45,000.00 45,000.00 45,000.00
2,000.00 2,000.00
25,000.00 25,000.00
25,000.00 25,000.00 25,000.00
8,890.00 8,890.00 8,890.00
8,890.00 8,890.00

140,890.00 140,890.00 1,689,890.00 1,689,890.00 430,000.00 893,890.00

463,890.00
140,890.00 140,890.00 1,689,890.00 1,689,890.00 893,890.00 893,890.00
Monthly Monthly
Loan ending
capital intrest balance
payment payment
(9,796) (8,000) 790,204
(9,894) (7,902) 780,311
(9,992) (7,803) 770,318
(10,092) (7,703) 760,226
(10,193) (7,602) 750,033
(10,295) (7,500) 739,738
(10,398) (7,397) 729,339
(10,502) (7,293) 718,837
(10,607) (7,188) 708,230
(10,713) (7,082) 697,517
(10,820) (6,975) 686,696
(10,929) (6,867) 675,768
(11,038) (6,758) 664,730
(11,148) (6,647) 653,582
(11,260) (6,536) 642,322
(11,372) (6,423) 630,950
(11,486) (6,309) 619,464
(11,601) (6,195) 607,863
(11,717) (6,079) 596,146
(11,834) (5,961) 584,312
(11,952) (5,843) 572,359
(12,072) (5,724) 560,287
(12,193) (5,603) 548,094
(12,315) (5,481) 535,780
(12,438) (5,358) 523,342
(12,562) (5,233) 510,780
(12,688) (5,108) 498,092
(12,815) (4,981) 485,278
(12,943) (4,853) 472,335
(13,072) (4,723) 459,263
(13,203) (4,593) 446,060
(13,335) (4,461) 432,725
(13,468) (4,327) 419,256
(13,603) (4,193) 405,653
(13,739) (4,057) 391,914
 (13,876) (3,919) 378,038
(14,015) (3,780) 364,023
(14,155) (3,640) 349,867
(14,297) (3,499) 335,571
(14,440) (3,356) 321,131
(14,584) (3,211) 306,546
(14,730) (3,065) 291,816
(14,877) (2,918) 276,939
(15,026) (2,769) 261,913
(15,176) (2,619) 246,736
(15,328) (2,467) 231,408
(15,481) (2,314) 215,927
(15,636) (2,159) 200,290
(15,793) (2,003) 184,498
(15,951) (1,845) 168,547
(16,110) (1,685) 152,437
(16,271) (1,524) 136,166
(16,434) (1,362) 119,732
(16,598) (1,197) 103,134
(16,764) (1,031) 86,370
(16,932) (864) 69,438
(17,101) (694) 52,336
(17,272) (523) 35,064
(17,445) (351) 17,619
(17,619) (176) -

Depreciation
Accumulated Accumulated
Ending value Beginning value sum of year Ending value
depreciation depreciation
digit method
140,000.00 610,000.00 750,000.00 233,333.33 233,333.33 516,666.67
280,000.00 470,000.00 516,666.67 186,666.67 420,000.00 330,000.00
420,000.00 330,000.00 330,000.00 140,000.00 560,000.00 190,000.00
560,000.00 190,000.00 190,000.00 93,333.33 653,333.33 96,666.67
700,000.00 50,000.00 96,666.67 46,666.67 700,000.00 50,000.00
 Balance Sheet
Debit Credit

120,000.00
65,000.00

50,000.00
300,000.00
500,000.00
200,000.00

254,000.00

400,000.00
55,000.00
76,000.00

2,000.00
25,000.00

8,890.00

1,259,890.00 796,000.00
463,890.00
1,259,890.00 1,259,890.00
 Depreciation
Accumulated
Beginning value double decli
depreciation Ending value
method
750,000.00 300,000.00 300,000.00 450,000.00
450,000.00 180,000.00 480,000.00 270,000.00
270,000.00 108,000.00 588,000.00 162,000.00
162,000.00 64,800.00 652,800.00 97,200.00
97,200.00 47,200.00 700,000.00 50,000.00