.00 >0 Cell Insert Delete Format Formatting Number Table Styles Styles Sort & Find & Filter - Select Editing Cells N P @ R S U V W Y Wages Rent Purchases Sales 898,000 6ZZ,000 Jammary February March April May Jume July 96,800 89,000 67,200 79,500 89,000 89,000 30,100 30,100 30,100 35,500 35,500 Operating Expenses 93,100 33, 100 83,100 23,500 63,500 93,500 120,100 624,000 825,000 528,000 731,000 825,000 829,000 860,000 800,000 952,000 758,000 850,000 900,000 35,500 40,100 90,500 Additional Information: (A) (B) (C) (E) (F) (G) 100,000 Equity shares of OMR 1 each were issued on 1% July at 50% Premium Due amount of Income is to be paid in the month of April OMR 2,500. 20% of sales are in cash terms. Remaining credit sales are collected in the following month. 10% of purchases are in cash terms. Remaining credit purchases are paid in the second month. Lag in the payment of wages - two month. 75% of the Rentis paid in the subsequent month and balance Rent is paid in the month it concern Lag in the payment of operating expenses is one month. During April the company purchased an item of old furniture costing OMR 4,000 for OMR 2,000. However, in May the company paid cash against the purchase of old furniture. Formatting Styles Table Styles er UN Sort & Find & Filter - Select Editing Cells F w S U W N Y 3 AA AB HO Question No 5 (10 Marks) The Ellowing are the balances extracted from the ledger or the Big & Co. LLC, Sablah on December 31, 2019. Account Tide Amounts in OMR 600 Account Tide Interest Payable Bad debts Amounts in OMR 125,000 Share capital General Expenses 4,100 7,475 Loan from Bank Cash and Bank 7,850 Rent 3,600 67,350 Salaries Furniture 9.200 8,550 Lissurance 3 360 10,250 Discount Received 1585 17,600 Discount allowed Plan and Machinery Accounts Payables Accounts Receivables Advertising Printing & Stationery 2,100 19,350 Wages Purchase 35.000 7150 150,000 1,200 Sales Reserves 212,500 15,600 Stock 25,000 Additional Information (B) Stock on sind on 31 December 2019 is OMR 35.000 Insurance is prepaid to the extent of OMR 1,060. Advertisem expenses include an amount of OMR 1,590 paid in advance for Une year 2020. Clerge depreciation on Furniture and plant and Machinery at 10% and 16% respectively Outstanding liabilities - Rent OMR 11 200.Salary OMR2 200 and Wages OMR6,000 [D) (E) You are required to create a spreadsheet for Extended Trul B.ance for the year ending December 31, 2019, showing separate columns for each of Trul Balance Adjusunents, Adjustu Trial Balance, come statement and Bilance Sheet columns so (1ENG 11:41 12/26 hp Question No 6: (A) At what quoted annual interest rate must OR200,000 be invested so that it will grow to be OR800,000 in 12 years if interest is compounded weekly? (2 Marks) (B) You are offered an annuity that will pay OMR 1,700 per month for 10 years; the first payment will be made at the end of month. If you feel that the appropriate interest rate is 3% per month, what is the annuity worth to you today, if interest is compounded monthly? (2 Marks) CE ^ (1) ENG