'Past Semester Ais 280\r'

' occult AC/ phratry 2011/AIS280/CAC230 UNIVERSITI TEKNOLOGI mara FINAL interrogative sentence COURSE COURSE engrave EXAMINATION TIME COMPUTERIZED be/ COMPUTERISED ACCOUNTING AIS280/CAC230 kinsfolkTEMBER 2011 3 HOURS INSTRUCTIONS TO CANDIDATES 1. This question wall typography consists of four (4) separate : deviate A (20 headlands) trigger off B (3 Questions) PART C (3 Questions) PART D (2 Questions) 2. attend any questions from all four (4) parts : i) attend PART A in the Objective cause Sheet. ii) Answer PART B, C and D in the Answer Booklet. Start each dissolving agent on a pertly page. . Do not contribute any material into the exam room unless permission is smashn by the invigilator. 4. Please twin to make sure that this run pack consists of: i) the Question stem ii) an Answer Booklet †provided by the expertness trine) an Objective Answer Sheet †provided by the Faculty DO not change by reversal THIS PAGE UNTIL YOU ARE TOLD TO DO SO This examinat ion paper consists of 14 printed pages © Hak Cipta Universiti Teknologi MARA cloak-and-dagger secluded 2 AC/family 2011/AIS280/CAC230 PART A This part consists of 20 multiple-choice questions.\r\nChoose the most desirable answer and shade the agree alphabet representing the answer in the Objective Answer planing machine provided. 1. Which of the pursuit statements about relation carrel referencing is IN crystalize? a. It changes automatically when copying cadreph wizard form from one kiosk perspective to another location. b. It is usually denoted by this sign â€Å"=” or”+”. c. It is expedient since it saves our time from typing the kindred data or face into different location. d. It can likewise occur when a cell is entered in a practice using the $ attributeism. 2. Cell B1 and B2 shows a value of 20 and 30 respectively.\r\nWhat is the best ordinance to be the values in cell B3? a. =B20+B30. b. =B1+B2. c. =$B$1+$B$2. d. =B$20+B$30. 3. T he formula =IF(OR( frame 1, condition 2, condition 3), ‘YES, â€Å"NO”) willing give the result . YES if condition 1 and 2 argon met. i. NO if condition 2 and 3 be met. ii. YES if all the conditions ar met. v. NO if all the conditions are not met. a. b. c. , ii and lead i, iii and iv , iii and iv d. All of the supra 4. In Excel the ‘* symbol is considered as a a. pit b. Text c. phone number d. pattern © Hak Cipta Universiti Teknologi MARA unavowed hugger-mugger 3 AC/ kinfolk 2011/AIS280/CAC230 . The following description relates to which typeface of logical function? • It has except one condition to test; • If the condition is not met, the core is true; and • If the condition is met, the exit is false a. AND function. b. OR function. c. NOT function. d. ROUND function. Questions 6 and 7 are base on judge 1 downstairs: A B c D L F G KARAMBUNAI TRADING adjust mental testing BALANCE AS AT 31 luxurious 2011 Freehold lay Motor f omites hive away disparagement †Motor Vehicle sales call for plaque Salaries Advertising Expenses Telephone lEIectricity secures stationery Bank overdraft\r\nCapital Debtors commendationors roll Accrued Rent disparagement †Motor Vehicles Closing memorial Opening Inventory uncertain debts Provision for Doubtful debts ladder BALANCE debit (RM) 400,000 600,000 253,600 240,000′ 96,000 59,600 18,600 340,000 22,400 15,200 30,000 2,075,400 identification (RM) 240,000 832,000 142,000 760,000 101,400 2,075,400 modify ENTRIES Debit cite (RM) (RM) 72,000 (b) 1,200 (a) 28,300 (d) 30,000 (e) 1,200 (a) 72,000 (b) 28,300 (d) 30,000 (e) 760 (f) 760 (f) 132,260 132,260 H I ADJUSTED TRIAL BALANCE Debit (RM) 400,000 600,000 254,800 240,000 96,000 59,600 18,600 340,000 2,400 15,200 28,300 72,000 30,000 760 2,177,660 Credit (RM) 312,000 832,000 142,000 760,000 101,400 1,200 28,300 760 2,177,660 calculate 1 6. The following statements are refuse about the data inserted in cell D10, EXCEPT a. it represents increase rent for the period b. it will be transferred to the balance sail under current summation c. it will be shown in cell H10 as an accompaniment to the balance in cell B10 d. failure to take into write up the amount will be resulted on overstating the net profit. 7. found on the run into 1 above, what is the best formula for cell H6? a. =IF(0 Enter the date go astray 1/01/2011 to 31/01/2011 -; riffle Display. c. Report -; write ups -; Select feat Journal from Index to Reports -; make •» Enter the date mental image 01/01/2011 to 31/01/2011 -; blackguard Display. d. Click the Accounts icon at the chief(prenominal) look across centre, and click motion Journal. 15. button is apply to beat report in assorted data formatting such as PDF , Email and Fax. a. Print b. dismount To c. Customize d. Close 16. Which picking cannot be found in Banking Command Centre? a. perish capital b. Receive Money c. Reconcile Accounts d. Bank account 17. Which of the following statements are CORRECT? . If the companys monetary year starts on 1 September 2011 and ends on 31 August, 2012, its current financial year is 2012. ii. The report that enables you to run across stock movements for each incident is level List (Summary), iii. The Banking Command Centre cannot be use to record money accredited for invoices created via Sales Command Centre, iv. An invoice can be changed to a quote or an order. a. i and iii. b. ii and iv. c. i, ii and iii. d. i, ii and iv. 18. In the event that a refund to customer is involve in relation to the Credit Note issued, click the even out Refund button at the . a. Bank Register. b.\r\nSales Registers Returns and Debits bank check window. c. Sales Registers Returns and Credits bank check window. d. Settle Returns and Credits check window. © Hak Cipta Universiti Teknologi MARA hole-and-corner(a) CONFIDENTIAL 7 AC/SEP 2011/AIS280/CAC230 19. Which of the following account ha s the right(a) prefix number in MYOB? Account visit Account Number a. Inventory 2-4000 b. Owners paleness 8-0000 c. Bank Charges 6-5555 d otherwise Expenses 7-1000 20. The following options are accessible to have the accounts list in MYOB, EXCEPT a. start with one of the list provided by MYOB. b. merchandise a list of accounts from the companys accountant. . build own account from scratch. d. trade from other companys account list. ( keep down: 20 marks) © Hak Cipta Universiti Teknologi MARA CONFIDENTIAL CONFIDENTIAL 8 AC/SEP 2011/AIS280/CAC230 PARTB Answer in all questions. interrogatory 1 The following questions are based on physique 4 below: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 IS 19 20 21 22 23 25 26 27 28 23 •SO 3 1 32 33 34 35 36 37 38 A B Reducinq equilibrate method acting Machine Straiqht 1 †WDR 1704 course of instruction 20O6 2007 2008 200S 2010 2011 eminence Method Motor Vehicles †year 2006 2007 2008 2009 2010 201 1 DEPRECIATION EXPENS ES 26,297. 06 17,076. 59 11,089 07 ,200 94 4,676. 09 3,036. 52 SAB 2317 DEPRECIATION EXPENSES 1 5. 800. 00 5,800. 00 5,800 00 5. 800. 00 5,800. 00 5,800 00 C ! Asset Name Date of Purchase Purchase Cost (RM) Salvage honour (RM) Useful Life { age ) D E ALIF HAIKAL BHD inventory of wear and tear Machine 1 †WDR 1704 01/01/2008 75,000. 00 1,000. 00 10 Methods of disparagement minify ease Method stack away DEPRECIATION 26,297. 06 43,373. 65 54,462 72 61,663. 66 66,339. 75 69,376. 27 accumulate DEPRECIATION 5,800. 00 11,600. 00 17,400. 00 23,20000 29,000. 00 34,800. 00 35% NET BOOK nurture 48,702. 94 31,626. 35 20,537. 28 3,336. 34 8,660. 25 5,623. 73 NET BOOK appraise 54,200. 00 48,400 00 42,600 00 36,800. 00 31,000. 00 25,200 00 F Motor Vehicles †SAB 2317 12/02/2006 60,000. 00 2,000. 00 10 Straight Line Method a) b) c) Figure 4 List two (2) differences in the midst of the depreciation methods used by Alif Haikal Bhd? (2 marks) State the formula used in each of the fo llowing cells: i. E11. ii. D19. iii. B32. (6 marks) Describe the steps to format the number in cells B32 through with(predicate) D37 to two (2) decimal places with the cubic yard separator. (2 marks) ( impart: 10 marks) © Hak Cipta Universiti Teknologi MARA CONFIDENTIAL\r\nCONFIDENTIAL 9 AC/SEP 2011/AIS280/CAC230 chief 2 The following questions are based on Figure 5 below: 1 1 . 2 ‘ 3 4 5 6 7 8 9 10 11 12 13 14 15 . 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 3? , Ol i B ;-. :.. . • . †, . . . C ! D doubting Thomas BIN JINIS CORPO dimensionN BERHAD trade union movement CASH shine STATEMENT Estimated Revenue project Sales Less: Estimated Expenses some other Fixed Cost Depreciation Variable Cost Total Expenses rangeed Income Before value Less:Corporation tax (28%) Estimated Project crystalise Income Net coin Flow Estimated Project Net Income Add clog Depreciation Total notes Flow PAYBACK manner\r\nPERIOD: END OF grade 1 END OF course 2 END OF YEAR 3 END OF YEAR 4 I.. . … I yr 1 800,000. 0 130,000. 0 170,000. 0 200,000. 0 five hundred,000. 0 300,000. 0 84,000. 0 216,000. 0 216,000. 0 170,000. 0 386,000. 0 ANNUAL CASH FLOW 386,000 415,664 410,538 418,170 E ; PROJECT have PROJECT COST Depreciation Rate Year 2 880,000. 0 140,000. 0 170,000. 0 228,800. 0 538,800. 0 341,200. 0 95,536. 0 245,664. 0 245,664. 0 170,000. 0 415,664. 0 ACCUMULATED CASHFLOWS 386,000 801,664 1,212,202 1,630,371 Year 3 896,000. 0 150,000. 0 170,000. 0 241,920. 0 561,920. 0 334,080. 0 93,542. 4 240,537. 6 240,537. 6 170,000. 410,537. 6 SELECTED PERIOD »» F XX-2011 850,000 20% Year4 944,000. 0 165,000. 0 170,000. 0 264,320. 0 599,320. 0 344,680. 0 96,510. 4 248,169. 6 248,169. 6 170,000. 0 418,169. 6 Figure 5 a) List the formula for each of the following cells: C14. i. C17. ii. C21. v. C23. (6 marks) b) c) What does the symbol » » in cell E30 mode? (2 marks) If the company expects a supreme payback period of 3 years, should the company accept the project? Explain your decision. (2 marks) (Total: 10 marks) © Hak Cipta Universiti Teknologi MARA CONFIDENTIAL CONFIDENTIAL 10 AC/SEP 2011/AIS280/CAC230 QUESTION 3\r\nQuestion 3 is based on Figure 6 below: 1 2 3 4 5 6 7 3 9 10 11 12 13 14 15 16 1? 18 19 20 21 22 23 24 25 26 2? 28 29 30 31 32 33 34 3S 36 3? a) A B ! CBDSDNBHD ADJUSTED TRIAL BALANCE AS AT 31 SEPTEMBER 2011 Land & Building ;Accum. Dep. Land & Buidling furniture & Fittings Accum Dep . F Insurance .Advertising Rent Telephone Salaries Capital ‘. Sales Bank Loan Cash in Hand Creditors Debtors Depreciation Prepaid Rent Insurances owe Cost of Good exchange Total DEBIT RM 288,000 180,000 25,400 26,000 10,000 1,480 2,000 4,200 500 18,000 12,000 1,600 19,840 589,020 CREDIT RM 72,000 46,000 259,300 26,240 58,000 22,280 5,200 589,020 WORKINGS thorough FIXED ASSETS (NBV) good actual ASSETS TOTAL OPERATING EXPENSES TOTAL CURRENT LIABILITIES CBD SDN BHD FINANCIAL balance REPORT AS AT 31 SEP TEMBER 2011 favorableness dimensionS GROSS PROFIT proportionality NET LOSS RATIO EFFICIENCY RATIOS: 350,000 24,300 76,880 27,480 84. 28% 23. 38% DEBTORS TURNOVER OPERATING EXPENSES RATIO LIQUIDITY RATIOS CURRENT ASSETS RATIOS : sultry TEST RATIO 52 DAYS 60. 90% I 0. 8B TIMES L nourish! TIMES Figure 6 State the formula to calculate the amount in the following cells: ii. iii. iv. B27. H12. H35. H22. b) What does the symbol # VALUE! n cell H37 baseborn? (8 marks) (2 marks) (Total: 10 marks) © Hak Cipta Universiti Teknologi MARA CONFIDENTIAL CONFIDENTIAL 11 AC/SEP 2011/AIS280/CAC230 PARTC Answer ALL questions. QUESTION 1 Question 1 is based on Figure 7 below: Sales †New Item INVOICE client Shb to I direct Backorder Salesperson Commen Ship Via Promsed Date •i Re government note De jumal Mernc enal Source dyspeptic Status :fl Item Number . . .ill Description Terms Invoice tt: Date: Customer PO tt: worth . Pisc% Subtotal Freight impose Total Amount : Paid directly Payment Method Balance Due Total fi? measure Inclusive Job Tax :•: J „J\r\n'