Leo needs to consolidate data in multiple worksheets by performing a calculation across all worksheets on the same cells. Which feature should he use to perform this task? data consolidation 3-D reference grouped cells linked cells

Balance sheet baggett company's balance sheet accounts and amounts as of december 31, 2016, are shown in random order as follows: account debit (credit) account debit (credit) income taxes payable $(3,800) additional paid-in capital on preferred prepaid items 1,800 stock $(7,900) additional paid-in capital on common stock (9,300) allowance for doubtful accounts (1,600) land 12,200 bonds payable (due 2020) (23,000) notes payable (due 2019) (6,000) buildings 57,400 notes receivable (due 2018) 16,400 sinking fund to retire bonds payable 5,000 accounts receivable 12,600 advances from customers (long-term) (2,600) premium on bonds payable (1,400) cash 4,300 accounts payable (13,100) accumulated depreciation: equipment (9,700) inventory 7,400 retained earnings (18,300) accumulated depreciation: buildings (21,000) preferred stock, $100 par (18,600) patents (net) 4,600 wages payable (1,400) equipment 28,700 common stock, $10 par (12,700) required: 1. prepare a december 31, 2016 balance sheet for the baggett. baggett company balance sheet december 31, 2016 assets current assets: $ $ $ long-term investments: $ property, plant, and equipment: $ $ $ intangible assets: liabilities current liabilities: $ $ long-term liabilities: $ $ other liabilities: shareholders' equity contributed capital: $ $ $ $ 2. compute the debt-to-assets ratio. round to one decimal place. do not enter a percent sign (%) as part of your answer. %

Why do you think the compensation plans differ at the two firms? in particular, why do you think kaufmann’s pays commissions to salespeople, while parkleigh does not? why does parkleigh offer employees discounts on purchases, while kaufmann’s does not?

Fred smithers, a recent college graduate decided to open his own portable juice bar, smithers smoothies, to wheel around newport beach. you, a trusted friend of fred, are a business major that has also recently graduated and agreed to handle the books for a while to get some practical experience and have a favor that you can ask of fred in the future. given the following five transactions concerning the new venture, prepare the necessary journal entries for the transactions, post the journal entries to appropriate t accounts and prepare a trial balance as of the end of the month in order to answer to the necessary may 2: fred invests $12,000 of his own money to start the new company. this money was obtained from a part-time job working at a legal firm while he was in school. may 3: fred spent $5,100 cash to purchase a refrigerated trailer that he can pull behind his car and set up at the beach. under your advice, fred agrees to place the new asset under an account called "equipment." may 6: fred bought $640 of supplies on account from the flav-o-rite confectioners company. because they will last longer than a single accounting period fred agrees to record them as, "supplies" as per your suggestion. may 13: fred sat on the beach for six hours without a single sale and was feeling very down. right before he left, however, a plumber escorting his family reunion along the beach stopped by his stand and bought $800 worth of smoothies for the entire family. under your advice, fred agrees to call this cash revenue, "sales." may 15: excited about his new venture, fred withdraws $350 from the company to take his girlfriend out to dinner. what would be the balance in the cash account at the end of the period following the posting of all the transactions?