Question No. 2 (6 Marks) Construct the following table in a spreadsheet to answer the questions given below it. Details of Students SAT score, Grade Score and Study Hours per week SAT Name Student Status Country Age Grade Score Height (in) Score belt tudy hours per veek Graduate UAE 33 1716 78 68 24 bdullah une er 37 1701 65 71 26 20 25 1786 69 Graduate Graduate Undergraduate Graduate Undergraduate UAE SA Oman Bahrain 67 62 19 1813 91 14 ara ntima pheer 33 71 66 24 2041 1787 Qatar 18 82 67 14 A) What is the average SAT score of Graduate Students? (1 Mark) How many students are under the age of 262 (1 Mark) C) Who is the second youngest student? (1 Mark) D) What is the Median Grade Score of the students? (1 Mark) E) How many hours did Mr. Ali study per day? (1 Mark) F) Construct a line chart for SAT Score for each student. (1 Mark) Question No 1: (10 Marks) Construct the following Statenient with complete information for the year 2010 ending December 31 in a spreadsheet. Particulars Sales Revenue 2018 (Amount in OMR 500,000 ?? Z? ?? Z? 25.000 ?? ?? ?? Custof goods sold (55% of Sales) Gross Profit Indirect Expenses (25% of Sales) Operating Profit Oder incomes Net Income Before Tax | Incuiue Tax (15% lax rale) Net Income After Tax for the current year Equity Share Capital Share premium Current year - 2018 Total Shareholders' funds Intangible assets Tangible assets Investments in Joint ventures Total Fixed Assets (6 times of Sales Revenue) Current Liabilities Current Assets Return on Shareholders' funds Current Ratio Return on Total Assets 1,000,000 870,000 ?? ?? 283,600 2,386,000 ?? ?? 423,750 400,000 ?? ?? Z? (10 Marks) Question No 3: (10 Marks) From the following information obtained from the books of blue Dart SAUG. Prepare a cash budget for the four months ending 31* July 2020. Cash on hand on April 1 will be around OMR 160,000 (Amounts in OMK) Wages Rent Purchases Sales January February March April May June July 96.800 89,000 67,200 79.500 89,000 09,000 90,500 30,100 30,100 30,100 35,500 35,500 35,500 40,100 Operating Expenses 93.100 33,100 83,100 23.500 63,500 93,500 120,100 621,000 825,000 528,000 731,000 825,000 129,000 860,000 898.000 622,000 800,000 952.000 758,000 050,000 900,000 Additional Information: (A) 100.000 Equity shares of OMR 1 cach were issued on 1* July at 50% Premium. (U) Due amount of Income is to be paid in the month of April OMR 2,500. (C) 20% of sales are in cash terms. Remaining credit sales are collected in the following month. (L) 10% of purchases are in cash terns. Remaining credit purchases are paid in the second month. (F) Lag in the payment of wages - two month. 75% of the Rent is paid in the subsequent month and balance Rent is paid in the month it concern. (H) Lag in the payment of operating expenses is one month. 0 During April the company purchased an item of old furniture costing OMR 4,000 for OMR 2,000. Ilowever, in May the company paid cash against die purchase of old funiture. Ouestion No 4: (10 Marks) Mr. Nazeer a sole trader uses a three-columa cash book for his business. On February 1, 2020, he has cash on OMR 24,000 and a bank overdraft (HBL) OMR 4,000. During the month be completed the following transactions: Feb. 4: Paid salaries OMR 2,000 in cash for the month of January Feb. 11: Sold Government Treasury Bills for OMR 4,000 Feb. 15: Received a cheque of OMR 10,900 frou Mr. Abdul Nasser in full settlement of his account OMR 11,000 and deposited it in the Bank on the February 15. Feb. 21: Issued a cheque for OMR 7,000 to Mr. Hatem in full settlement of his account OMR 7,400. Feb. 26: Withdrew cash OMR3,000 from the bank for office use. Feb.27: Drew a cheque for OMR 800 for domestic use. Feb. 28 Cash advance of OMR 280 received as commission. Feb. 28: Gave a cheque to Muscat Media for Printing OMR 100 Feb. 29: Paid cash OMR 3,500 to Jawahir in full settlement of due amount OMR. 3,700. Feb. 29: Deposited cash into bank OMR 10,000 You are required to construct a three column cash book for the month of February 2020. Question No 5: (10 Marks) The following are the balances extracted from the ledger of the Rlg & CO. LLC, Salalah as on December 31, 2019. Account Title Account Title Amuls in OMR 600 Amounts in OMR 125,000 Interest Payable Share capital General Expenses Rad debts 4,100 4,475 Loan from Bank 7,050 Rent 3,600 Cash and Bank 67,350 Salaries 9,250 Furniture 8,550 Insurance 3,360 40,250 Discount Received 1,505 17,600 Discount allowed 2,100 Plan and Machinery Accounts Payables Accounts Receivables Advertising Printing & Stationery 19,350 Wages 35,000 7,150 Purchases 1,200 Sales 150,000 212,500 25,000 Reserves 15,600 Stock Additional Information: (A) Sluck un land on 31 December 2019 is OMR 35,000 (B) Insurance is prepaid to the extent of OMR 1,060. (C) Advertisement expenses include an amount of OMR 1,590 paid in advance for the year 2020 (D) Charge depreciation on Furniture and plant and Machinery at 10% and 16% respectively. (E) Outstanding liabilities - Kent OMR 11,200: Salary OMR 2,200 and Wages OMR 6,000 You are required to create a spreadsheet for Extended Trial Balance for the year ending December 31, 2019, showing separate columns for each of Trial Balance, Adjustments, Adjusted Trlal Balance, Income statement and Balance Sheet columns 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) Question No. 2 (6 Marks) Construct the following table in a spreadsheet to answer the questions given below it. Details of Students SAT score, Grade Score and Study Hours per week SAT Name Student Status Country Age Grade Score Height (in) Score belt tudy hours per veek Graduate UAE 33 1716 78 68 24 bdullah une er 37 1701 65 71 26 20 25 1786 69 Graduate Graduate Undergraduate Graduate Undergraduate UAE SA Oman Bahrain 67 62 19 1813 91 14 ara ntima pheer 33 71 66 24 2041 1787 Qatar 18 82 67 14 A) What is the average SAT score of Graduate Students? (1 Mark) How many students are under the age of 262 (1 Mark) C) Who is the second youngest student? (1 Mark) D) What is the Median Grade Score of the students? (1 Mark) E) How many hours did Mr. Ali study per day? (1 Mark) F) Construct a line chart for SAT Score for each student. (1 Mark) Question No 1: (10 Marks) Construct the following Statenient with complete information for the year 2010 ending December 31 in a spreadsheet. Particulars Sales Revenue 2018 (Amount in OMR 500,000 ?? Z? ?? Z? 25.000 ?? ?? ?? Custof goods sold (55% of Sales) Gross Profit Indirect Expenses (25% of Sales) Operating Profit Oder incomes Net Income Before Tax | Incuiue Tax (15% lax rale) Net Income After Tax for the current year Equity Share Capital Share premium Current year - 2018 Total Shareholders' funds Intangible assets Tangible assets Investments in Joint ventures Total Fixed Assets (6 times of Sales Revenue) Current Liabilities Current Assets Return on Shareholders' funds Current Ratio Return on Total Assets 1,000,000 870,000 ?? ?? 283,600 2,386,000 ?? ?? 423,750 400,000 ?? ?? Z? (10 Marks) Question No 3: (10 Marks) From the following information obtained from the books of blue Dart SAUG. Prepare a cash budget for the four months ending 31* July 2020. Cash on hand on April 1 will be around OMR 160,000 (Amounts in OMK) Wages Rent Purchases Sales January February March April May June July 96.800 89,000 67,200 79.500 89,000 09,000 90,500 30,100 30,100 30,100 35,500 35,500 35,500 40,100 Operating Expenses 93.100 33,100 83,100 23.500 63,500 93,500 120,100 621,000 825,000 528,000 731,000 825,000 129,000 860,000 898.000 622,000 800,000 952.000 758,000 050,000 900,000 Additional Information: (A) 100.000 Equity shares of OMR 1 cach were issued on 1* July at 50% Premium. (U) Due amount of Income is to be paid in the month of April OMR 2,500. (C) 20% of sales are in cash terms. Remaining credit sales are collected in the following month. (L) 10% of purchases are in cash terns. Remaining credit purchases are paid in the second month. (F) Lag in the payment of wages - two month. 75% of the Rent is paid in the subsequent month and balance Rent is paid in the month it concern. (H) Lag in the payment of operating expenses is one month. 0 During April the company purchased an item of old furniture costing OMR 4,000 for OMR 2,000. Ilowever, in May the company paid cash against die purchase of old funiture. Ouestion No 4: (10 Marks) Mr. Nazeer a sole trader uses a three-columa cash book for his business. On February 1, 2020, he has cash on OMR 24,000 and a bank overdraft (HBL) OMR 4,000. During the month be completed the following transactions: Feb. 4: Paid salaries OMR 2,000 in cash for the month of January Feb. 11: Sold Government Treasury Bills for OMR 4,000 Feb. 15: Received a cheque of OMR 10,900 frou Mr. Abdul Nasser in full settlement of his account OMR 11,000 and deposited it in the Bank on the February 15. Feb. 21: Issued a cheque for OMR 7,000 to Mr. Hatem in full settlement of his account OMR 7,400. Feb. 26: Withdrew cash OMR3,000 from the bank for office use. Feb.27: Drew a cheque for OMR 800 for domestic use. Feb. 28 Cash advance of OMR 280 received as commission. Feb. 28: Gave a cheque to Muscat Media for Printing OMR 100 Feb. 29: Paid cash OMR 3,500 to Jawahir in full settlement of due amount OMR. 3,700. Feb. 29: Deposited cash into bank OMR 10,000 You are required to construct a three column cash book for the month of February 2020. Question No 5: (10 Marks) The following are the balances extracted from the ledger of the Rlg & CO. LLC, Salalah as on December 31, 2019. Account Title Account Title Amuls in OMR 600 Amounts in OMR 125,000 Interest Payable Share capital General Expenses Rad debts 4,100 4,475 Loan from Bank 7,050 Rent 3,600 Cash and Bank 67,350 Salaries 9,250 Furniture 8,550 Insurance 3,360 40,250 Discount Received 1,505 17,600 Discount allowed 2,100 Plan and Machinery Accounts Payables Accounts Receivables Advertising Printing & Stationery 19,350 Wages 35,000 7,150 Purchases 1,200 Sales 150,000 212,500 25,000 Reserves 15,600 Stock Additional Information: (A) Sluck un land on 31 December 2019 is OMR 35,000 (B) Insurance is prepaid to the extent of OMR 1,060. (C) Advertisement expenses include an amount of OMR 1,590 paid in advance for the year 2020 (D) Charge depreciation on Furniture and plant and Machinery at 10% and 16% respectively. (E) Outstanding liabilities - Kent OMR 11,200: Salary OMR 2,200 and Wages OMR 6,000 You are required to create a spreadsheet for Extended Trial Balance for the year ending December 31, 2019, showing separate columns for each of Trial Balance, Adjustments, Adjusted Trlal Balance, Income statement and Balance Sheet columns 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)