Lantana Company has provided you with the transactions that occurred during its first month of operations....
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Lantana Company has provided you with the transactions that occurred during its first month of operations. The Controller has already recorded the transactions to the T-Accounts and has asked you to prepare the classified balance sheet based on the T-Account balances. Use the information included in the Excel Simulation and the Excel functions described below to complete the task. XS- FILE • Cell Reference: Allows you to refer to data from another cell in the worksheet. From the Excel Simulation below, if in a blank cell, "=B11" was entered, the formula would output the result from cell B11, or $50,000 in this example. • Basic Math functions: Allows you to use the basic math symbols to perform mathematical functions. You can use the following keys: +(plus sign to add), - (minus sign to subtract), * (asterisk sign to multiply), and / (forward slash to divide). From the Excel Simulation below, if in a blank cell "=C11+C12" was entered, the formula would add the values from those cells and output the result, or 15,000 in this example. If using the other math symbols the result would output an appropriate answer for its function. • SUM function: Allows you to refer to multiple cells and adds all the values. You can add individual cell references or ranges to utilize this function. From the Excel Simulation below, if in a blank cell "-SUM(C11, C12, C13)" was entered, the formula would output the result of adding those three separate cells, or 15,500 in this example. Similarly, if in a blank cell "=SUM(C11:C13)" was entered, the formula would output the same result of adding those cells, except they are expressed as a range in the formula, and the result would be 15,500 in this example. Paste Clipboard B42 10 11 a. 12 13 14 bal. 15 16 B 17 b. 18 19 bal. 20 21 22 e. 23 21 24 25 26 26 27 28 • HOME Calibri BIU B V B INSERT 50,000 READY Attempt(s) 2/3 Cash 34,500 T 20.000 Land 20,000 A C DE F G 1 The following transactions occurred for Lantana Company during its first month of operations 2 and have been recorded in the T-accounts below. M 3 Font X 4 a. Received $50,000 cash from owners in exchange for common stock. 5 b. Purchased land for $20,000, paid $5,000 in cash and signed a 2-year note for the remainder. Bought $900 of supplies on account. 6 7 d. Purchased $10,000 of equipment, paying cash. 8 e. Paid $500 on account for supplies purchased in transaction (c). 9 -11 Accounts Payable 500 Common Stock PAGE LAYOUT Y gy A A fx Cell Conditional Format as. A. Formatting Table Styles Styles Preparing a classified balance sheet - Excel FORMULAS DATA REVIEW 900 C. % Alignment Number ▾ 5,000 b. C. 10,000 d. 500 e. 400 bal. 50,000 a. 50.000 bal. bal. d. 29 30 31 Required: 32 Using the T-account BALANCES and the information in the transactions. 4 ▸ Sheet1 (+) bal. Supplies 900 900 Equipment 10,000 10.000 Note Payable H I 15,000 b. 15.000 bal.. 4 VIEW B A Cells Editing J ? F K [J 2 X Sign In A 10% Hint Required: Using the T-account BALANCES and the information in the transactions, prepare a classified balance sheet for Lantana Company. Note: Use cell references to the T-account titles to complete columns B and G. Use cell references to the T-account balances and formulas to complete columns C and H. List long-term assets in alphabetical order. Current Assets Total Current Assets Long-term Assets Assets Total Long-term Assets Total Assets LANTANA COMPANY Balance Sheet At December 31, 2016 Liabilities and Stockholders' Equity Current Liabilities Total Current Liabilities Long-term Liabilities Total Long-term Liabilities Total Liabilities Stockholders' Equity Retained Earnings Total Stockholders' Equity Total Liabilities and Stockholders' Equity 0 Lantana Company has provided you with the transactions that occurred during its first month of operations. The Controller has already recorded the transactions to the T-Accounts and has asked you to prepare the classified balance sheet based on the T-Account balances. Use the information included in the Excel Simulation and the Excel functions described below to complete the task. XS- FILE • Cell Reference: Allows you to refer to data from another cell in the worksheet. From the Excel Simulation below, if in a blank cell, "=B11" was entered, the formula would output the result from cell B11, or $50,000 in this example. • Basic Math functions: Allows you to use the basic math symbols to perform mathematical functions. You can use the following keys: +(plus sign to add), - (minus sign to subtract), * (asterisk sign to multiply), and / (forward slash to divide). From the Excel Simulation below, if in a blank cell "=C11+C12" was entered, the formula would add the values from those cells and output the result, or 15,000 in this example. If using the other math symbols the result would output an appropriate answer for its function. • SUM function: Allows you to refer to multiple cells and adds all the values. You can add individual cell references or ranges to utilize this function. From the Excel Simulation below, if in a blank cell "-SUM(C11, C12, C13)" was entered, the formula would output the result of adding those three separate cells, or 15,500 in this example. Similarly, if in a blank cell "=SUM(C11:C13)" was entered, the formula would output the same result of adding those cells, except they are expressed as a range in the formula, and the result would be 15,500 in this example. Paste Clipboard B42 10 11 a. 12 13 14 bal. 15 16 B 17 b. 18 19 bal. 20 21 22 e. 23 21 24 25 26 26 27 28 • HOME Calibri BIU B V B INSERT 50,000 READY Attempt(s) 2/3 Cash 34,500 T 20.000 Land 20,000 A C DE F G 1 The following transactions occurred for Lantana Company during its first month of operations 2 and have been recorded in the T-accounts below. M 3 Font X 4 a. Received $50,000 cash from owners in exchange for common stock. 5 b. Purchased land for $20,000, paid $5,000 in cash and signed a 2-year note for the remainder. Bought $900 of supplies on account. 6 7 d. Purchased $10,000 of equipment, paying cash. 8 e. Paid $500 on account for supplies purchased in transaction (c). 9 -11 Accounts Payable 500 Common Stock PAGE LAYOUT Y gy A A fx Cell Conditional Format as. A. Formatting Table Styles Styles Preparing a classified balance sheet - Excel FORMULAS DATA REVIEW 900 C. % Alignment Number ▾ 5,000 b. C. 10,000 d. 500 e. 400 bal. 50,000 a. 50.000 bal. bal. d. 29 30 31 Required: 32 Using the T-account BALANCES and the information in the transactions. 4 ▸ Sheet1 (+) bal. Supplies 900 900 Equipment 10,000 10.000 Note Payable H I 15,000 b. 15.000 bal.. 4 VIEW B A Cells Editing J ? F K [J 2 X Sign In A 10% Hint Required: Using the T-account BALANCES and the information in the transactions, prepare a classified balance sheet for Lantana Company. Note: Use cell references to the T-account titles to complete columns B and G. Use cell references to the T-account balances and formulas to complete columns C and H. List long-term assets in alphabetical order. Current Assets Total Current Assets Long-term Assets Assets Total Long-term Assets Total Assets LANTANA COMPANY Balance Sheet At December 31, 2016 Liabilities and Stockholders' Equity Current Liabilities Total Current Liabilities Long-term Liabilities Total Long-term Liabilities Total Liabilities Stockholders' Equity Retained Earnings Total Stockholders' Equity Total Liabilities and Stockholders' Equity 0
Expert Answer:
Answer rating: 100% (QA)
This is a document that is used by a companys accountant to record all of the financ... View the full answer
Related Book For
Posted Date:
Students also viewed these accounting questions
-
Gerald Grass started the Grass Company, a new business that began operations on May 1. The Grass Company completed the following transactions during its first month of operations: May 1 May 1 . May 3...
-
Stanford Enterprises has provided its manufacturing estimated and actual data for the year end. The Controller has asked you to compute the predetermined overhead rate, the schedule of cost of goods...
-
FloorCo, Inc. has provided data from its previous year of operations. The Controller has asked you to prepare the Operating Activities Section of the Statement of Cash Flows. Use the information...
-
The PredatoryCreditCard class provides a processMonth( ) method that models the completion of a monthly cycle. Modify the class so that once a customer has made ten calls to charge during a month,...
-
Waco Tire Corporation redesigned its production facilities around a team-based system. However, the company president believes that employees will not be motivated unless they receive incentives...
-
Physiologists use a machine called a pneumotachograph to produce a graph of the rate of flow R on air into the lungs (inspiration) and out (expiration). The figure gives the graph of the inspiration...
-
Pinnacle Foods imports a variety of items for resale to U.S. retailers. Following is a description of purchases and foreign-currency-denominated payments made in the last accounting period, plus the...
-
Larussa Inc. is preparing its annual budgets for the year ending December 31, 2011. Accounting assistants furnish the data shown below. An accounting assistant has prepared the detailed manufacturing...
-
Finance 430 Derivatives Markets. Q1 below is based on the following information and assumptions: BBB takes a Short position in 1 futures contract on Gold. The Gold futures contract has contract size...
-
The December 31, 2024, adjusted trial balance for the Blueboy Cheese Corporation is presented below. Required: 1. Prepare an income statement for the year ended December 31, 2024, and a classified...
-
In addition to units not being standard everywhere, symbols for different variables are often different. Explain why it is difficult to obtain uniform agreement on symbols.
-
What is meant by defeasance? Can debt that is subject to a defeasance arrangement be derecognized? Contrast this with an in-substance defeasance.
-
"Bad debts" are the same as a. Uncollectible accounts c. Neither of the above b. Doubeful accounts d. Both \(a\) and \(b\)
-
Your company uses the allowance method to account for uncollectible receivables. At the beginning of the year, Allowance for Uncollectibles had a credit balance of \(\$ 1,100\). During the year you...
-
Your ending balance of Accounts Receivable is \(\$ 20,000\). Use the data in the preceding question to compute the net realizable value of Accounts Receivable at year-end. a. \(\$ 18,000\) b. \(\$...
-
Please don't pick from the internet Explain clearly please Acme Water Pumps The Acme Water Pump Company has a problem. The pumps are fairly expensive to make and store, so the company tends to keep...
-
Find the center of mass of a thin triangular plate bounded by the y-axis and the lines y = x and y = 2 - x if (x, y) = 6x + 3y + 3.
-
Daintree and Hong own 55% and 45%, respectively, of the common shares that carry voting rights at a general meeting of shareholders of Moor. Hong also holds debt instruments that are convertible into...
-
Len Innsbruck is the accountant for Wallex Trucks. This entity has an 80% holding in the entity Tires R-Us. Len is concerned that the consolidated nancial statements prepared under IFRS 10 may be...
-
Metrosport is a city located in the most populous census district in Canada. Its mayor and council are ambitious and want to attract an NHL team to their community. Although Metrosport's population...
-
Docile LLC is an audit firm based in Tarrytown, NY. Docile has accepted a new engagement to perform audit services for Danger T, Inc. The auditor professional responsibilities is to: (a) The client...
-
The following are types of assurance services with the exception of: (a) Legal counsel engagement (b) Facilitation engagement (c) Advice engagement (d) System security engagement
-
An accountants objective of a review of the financial statements of a non-issuer (nonpublic company) is to provide what type of assurance? (a) Absolute assurance (b) Limited assurance (c) No...
Study smarter with the SolutionInn App