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,...
-
Suppose an experimenter intends to do a regression analysis by taking a total of 2n data points, where the xis are restricted to the interval [0, 5]. If the xy-relationship is assumed to be linear...
-
Determine whether the given map is a homomorphism. Let : Z 9 Z 2 be given by (x) = the remainder of x when divided by 2, as in the division algorithm.
-
3. State the major decision-making functions of Financial Management.
-
A company's cost of goods sold for the year was $97,500. Ending inventory was $12,000 and $13,500 in the current and prior years, respectively. Required Calculate the company's inventory turnover...
-
Refer to the bond listing table below to determine the coupon rate and maturity of a bond issued by Citigroup. Click the icon to view the bond listing from the table below. The coupon rate is % . (...
-
Problem 9 (50 Points) An air-cooled aluminum heat sink is used to keep electronics cool (see image and diagram). The cooling requirements are being significantly increased. To increase the rate of...
-
Listed below are several terms and phrases associated with the FASB's conceptual framework. Pair each item from List A with the item from List B that is most appropriately associated with it. List A...
-
(25 Points) University Painting is considering investing in a new paint sprayer to allow them to paint more classrooms in less time. The sprayer would have the following cash flow and cost of capital...
-
Use the following information for questions 1 and 2. Caterpillar Financial Services Corp. (a subsidiary of Caterpillar) and Sterling Construction sign a lease agreement dated January 1, 2020, that...
-
Summit Regional Medical Center operates as a private not-for-profit hospital, providing services to a community of 20,000 and the surrounding rural areas. Summit has maintained a banking relationship...
-
Woodland Wearables produces two models of a smart watch, the Basic and the Flash. The watches have the following characteristics: Basic Flash Selling price per watch $ 3 3 0 $ 4 9 0 Variable cost per...
-
Introduction This practice case has been designed to give introductory-level business students practical experience in the application of accounting concepts. This practice case will provide students...
-
Check my work [The following information applies to the questions displayed below.) California Orchards reports the following sales data for the year ended December 31, Crade of Walnuts Sales $...
-
Consider the function f and its graph. a. Estimate the zeros of the area function b. Estimate the points (if any) at which A has a local maximum or minimum. c. Sketch a graph of A, for 0 x 10,...
-
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...
-
22.14. The National Basketball Association (NBA) has hired you as a consultant to figure out what the proper mix of Eastern and Western teams should be. An Eastern team has a return variance of .04,...
-
22.13. Ford is considering building a factory to produce its new Taurus. The factory will cost $100 million and will produce 10,000 automobiles one year from now, but its cost and production can be...
-
22.8. Suppose you wish to hedge your exposure to oil prices by means of forwards and futures over the next year. You have the following information: the current price of oil is $20 per barrel and the...
![Mobile App Logo](https://dsd5zvtm8ll6.cloudfront.net/includes/images/mobile/finalLogo.png)
Study smarter with the SolutionInn App