The following are the balances extracted from the ledger of the Big & Co. LLC, Salalah...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The following are the balances extracted from the ledger of the Big & Co. LLC, Salalah as on December 31, 2019. Amounts in OMR 600 4,100 7,850 67,350 8,550 40,250 17,600 19,350 7,150 1,200 15,600 Account Title Interest Payable Bad debts Loan from Bank Cash and Bank Furniture Plan and Machinery Accounts Payables Accounts Receivables Advertising Printing & Stationery Reserves (D) (E) Account Title Share capital General Expenses Rent Salaries Insurance Discount Received Discount allowed Wages Purchases Sales Stock Amounts in OMR 125,000 4,475 3,600 9,250 3,360 1,585 2,100 35,000 150,000 212,500 25,000 Additional Information (A) Stock on hand 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. Charge 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 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 Trial Balance, Income statement and Balance Sheet columns. Number Jamary February March April May June July (E) (F) (G) .00 ➜.0 (1) N N Cell Formatting Table Styles- Styles 0 Wages 96,800 89,000 P 89,000 89,000 90,500 Y Rent Operating Expenses 30,100 93,100 30,100 33,100 67,200 30,100 83,100 79,500 35,500 23,500 63,500 93,500 120,100 Q 35,500 35,500 40,100 R S Insert Delete Format Purchases 624,000 825,000 528,000 731,000 825,000 829,000 860,000 Cells Sales 898,000 6ZZ,000 800,000 952,000 758,000 850,000 900,000 U V W Additional Information: (A) 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. (B) (C) 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 Rent is 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. Sort & Find & Filter Select Editing X 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. Y Question No 6: (A) (B) 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) 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) Larruoss X # 4 ENG The following are the balances extracted from the ledger of the Big & Co. LLC, Salalah as on December 31, 2019. Amounts in OMR 600 4,100 7,850 67,350 8,550 40,250 17,600 19,350 7,150 1,200 15,600 Account Title Interest Payable Bad debts Loan from Bank Cash and Bank Furniture Plan and Machinery Accounts Payables Accounts Receivables Advertising Printing & Stationery Reserves (D) (E) Account Title Share capital General Expenses Rent Salaries Insurance Discount Received Discount allowed Wages Purchases Sales Stock Amounts in OMR 125,000 4,475 3,600 9,250 3,360 1,585 2,100 35,000 150,000 212,500 25,000 Additional Information (A) Stock on hand 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. Charge 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 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 Trial Balance, Income statement and Balance Sheet columns. Number Jamary February March April May June July (E) (F) (G) .00 ➜.0 (1) N N Cell Formatting Table Styles- Styles 0 Wages 96,800 89,000 P 89,000 89,000 90,500 Y Rent Operating Expenses 30,100 93,100 30,100 33,100 67,200 30,100 83,100 79,500 35,500 23,500 63,500 93,500 120,100 Q 35,500 35,500 40,100 R S Insert Delete Format Purchases 624,000 825,000 528,000 731,000 825,000 829,000 860,000 Cells Sales 898,000 6ZZ,000 800,000 952,000 758,000 850,000 900,000 U V W Additional Information: (A) 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. (B) (C) 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 Rent is 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. Sort & Find & Filter Select Editing X 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. Y Question No 6: (A) (B) 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) 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) Larruoss X # 4 ENG
Expert Answer:
Answer rating: 100% (QA)
Soln 6a FVPV1r 8000002000001r 2 41121r r1225 pa Calcul... View the full answer
Related Book For
Posted Date:
Students also viewed these finance questions
-
1. Downriver Excursions LLC buys a new boat on credit for $10,000. How does this affect the income statement, balance sheet, and statement of cash flows for that calendar year? What if anything will...
-
The following data is available for three different alternatives. MARR =12% Alt. A Alt. B Alt. C $6,000 $900 $1,500 $525 $450 20 10 Data Initial Cost Uniform Annual Benefit Useful Life $300 5...
-
Suppose you want to have $300,000 for retirement in 20 years. Your account earns 10% interest. a) How much would you need to deposit in the account each month? $ b) How much interest will you earn?...
-
Label each transition in this flowchart Label each transition in this flowchart as a chemical change or a physical change. 8 chemical physical 00
-
What makes this apparently simple process challenging to write down?
-
Based on Exhibit 1, the rolling yield of Aschel over a one-year investment horizon is closest to: A. 2.56%. B. 0.54%. C. 5.66%. Ccile is a junior analyst for an international wealth management firm....
-
DVR Equipment, Inc., reported these data for 2007: Compute DVR's net cash provided by operating activities indirect method. Income Statement Net income. Depreciation....... Balance sheet Increase in...
-
Tyra has a zero basis in her partnership interest and a share in partnership liabilities, which are quite large. Explain how these facts will affect the taxation of her departure from the partnership...
-
One of Hotel Paradise housekeeping department biggest challenges was how to work as a team to accomplish departmental functions, and build a department brand on a trusting relationship among the...
-
The following table summarizes the operating results for Bene Petits first year of operations: Bene Petit First year operating data: Single (1 serving) Dual (2 servings) Family (4 servings) Total...
-
Fiske identified different approaches to communication. Discuss the differences in seeing communication as "transmission of messages" as opposed to "production and exchange of meaning." Explain which...
-
What effect did each of these cases have on auditors' ordinary negligence liability to third parties? a. C.I.T. Financial Corporation. b. Rusch Factors, Inc. v. Levin. c. Rosenblum v. Adler.
-
Describe the three-part test established in the Credit Alliance v. Arthur Andersen \& Co. case.
-
What was the significance of the Barchris case?
-
Describe the ways in which the scope of many audits in the early 1900 s was significantly different from what it is today.
-
Describe two litigation guidelines.
-
This excerpt provides insights into the perceptions of NO-SEEK respondents from accounting units at public and private universities, as well as those from units with different missions (teaching,...
-
What did Lennox gain by integrating their WMS, TMS, and labor management systems?
-
Huffman Systems has forecasted the following sales for home alarm systems to be 63,000 units per year at $38.50 per unit. The cost to produce each unit is expected to be about 42% of the sales price....
-
The Profitability Index produces a ratio between the present value of the benefits and present value of the costs of a project. Is there a time when PI and NPV do not agree on the ranking of...
-
While traveling in various countries, you occasionally resort to U.S. food. You pay the following prices for a Big Mac: India 210 rupee Kuwait 1.39 dinar Sweden 34.90 krona Ukraine 133 rubles If...
-
What is the relation between accounting and recordkeeping?
-
Who are the internal and external users of accounting information?
-
What are internal controls and why are they important?
Study smarter with the SolutionInn App