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
-
A company received cash subscriptions for 5,000 shares of 20 CU nominal (par) value at 100 CU per share. A down-payment of 50 percent of the issuance price is required. The remainder of the purchase...
-
Large maps are printed on a plotter and rolled up. The supervisor randomly selects 12 printed maps and unfolds a part of each map to verify the quality of the printing. List one condition under which...
-
An unfinished concrete rectangular channel is \(5 \mathrm{~m}\) wide and has a slope of \(0.50^{\circ}\). The water is \(0.5 \mathrm{~m}\) deep. Find the discharge rate for uniform flow.
-
At December 31, 2008, Belmont Company had a net deferred tax liability of $375,000. An explanation of the items that compose this balance is as follows. In analyzing the temporary differences, you...
-
Assume that you are the leadership team of a convenience store chain that has more than 300 outlets. The company is facing an inventory shrinkage problem, and store managers report that the main...
-
Acme Manufacturing currently employs 13 people in its receiving department. Each receiving dock clerk earns $50,000 per year. Each employee can unload up to 200 pallets of inventory per day. It...
-
There are four suits: clubs, diamonds, hearts, and spades, and the following cards appear in each suit: Ace, 2, 3, 4, 5, 6, 7, 8, 9, 10, Jack Queen, King. The Jack Queen, and King are called face...
-
Compute the "Per capita GDP", which can be obtained by dividing the GDP for each state by that state's population. This number helps economists compare the economic activity between regions?
-
What legal policy in Texas requires higher resource school districts to send more to poorer districts to increase equity in public school funding?
-
What are the recent financial stimulus of the government given to the business world and the public during the pandemic ? (by printing dollars) might have diluted the value of the dollar.
-
What is the value of zero-coupon bond with a par value of $1,000 and a yield to maturity of 5.43%? The bond has 3 years to maturity. SET YOUR CALCULATOR TO 4 DECIMAL PLACES THEN ROUND YOUR ANSWER TO...
-
In which ways do you think that climate change related risks can affect the financial system and the global economy? Please provide some examples.
-
1. Explain what the following method is doing. public boolean whatMethodDoing (String s) String reverses = new String(""); for (int i = s.length() -1; i >= 0; i--) reverses += s.charAt(i); return...
-
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 are the differences among an onsite team, a virtual team, a task force, and a committee? What are some of the potential differences in dynamics between people in these different groups?
-
Compare and contrast disciplinary, interdisciplinary, and crossfunctional teams.
-
What are some of the unique challenges associated with teamwork in health care? How do you see teamwork fitting in with the accountable care organization (ACO) mandates? Describe three benefits and...
Study smarter with the SolutionInn App