1 Name: 2 Your score: 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 The trial balance of the Lucas Casel Company as of December 31, 2022 is presented below. Prepare an income statement, statement of retained earnings and a balance sheet for the year ended (date of), December 31, 2022. Every yellow cell requires either an account title or a formula. ALL FORMULAS FOR TOTALS MUST INCLUDE THE =SUM FUNCTION. Use the dropdown list to select the proper account titles. Cash Accounts receivable Inventory Prepaid rent Equipment Accounts payable Unearned consulting revenue Common stock Dividends Consulting revenue Rental revenue Salaries expense Rent expense Insurance expense Totals Revenues Total revenues Expenses Lucas Casel 0% Lucas Casel Company Trial Balance December 31, 2022 Debit Total expenses $5,400 1,300 10,800 3,500 27,100 Instructions 1,300 2,500 2,100 1,400 1) Prepare the income statement for Lucas Casel Company for the year ended December 31, 2022. Lucas Casel Company Income Statement For Year Ended December 31, 2022 Credit $7,300 4,100 35,700 6,900 1,400 2) The Lucas Casel Company began operations on January 1, 2022. Prepare its statement of retained earnings for the year ended December 31, 2022. Lucas Casel Company Prepare Fin Sts +
1 Name: 2 Your score: 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 The trial balance of the Lucas Casel Company as of December 31, 2022 is presented below. Prepare an income statement, statement of retained earnings and a balance sheet for the year ended (date of), December 31, 2022. Every yellow cell requires either an account title or a formula. ALL FORMULAS FOR TOTALS MUST INCLUDE THE =SUM FUNCTION. Use the dropdown list to select the proper account titles. Cash Accounts receivable Inventory Prepaid rent Equipment Accounts payable Unearned consulting revenue Common stock Dividends Consulting revenue Rental revenue Salaries expense Rent expense Insurance expense Totals Revenues Total revenues Expenses Lucas Casel 0% Lucas Casel Company Trial Balance December 31, 2022 Debit Total expenses $5,400 1,300 10,800 3,500 27,100 Instructions 1,300 2,500 2,100 1,400 1) Prepare the income statement for Lucas Casel Company for the year ended December 31, 2022. Lucas Casel Company Income Statement For Year Ended December 31, 2022 Credit $7,300 4,100 35,700 6,900 1,400 2) The Lucas Casel Company began operations on January 1, 2022. Prepare its statement of retained earnings for the year ended December 31, 2022. Lucas Casel Company Prepare Fin Sts +
Fundamentals Of Financial Management, Concise Edition (mindtap Course List)
10th Edition
ISBN:9781337902571
Author:Eugene F. Brigham, Joel F. Houston
Publisher:Eugene F. Brigham, Joel F. Houston
Chapter10: The Cost Of Capital
Section: Chapter Questions
Problem 1TCL: CALCULATING 3MS COST OF CAPITAL Use online resources to work on this chapters questions. Please note...
Related questions
Question
Click on the "Prepare Fin Sts" tab and enter your name in Cell C1. If Cell C1 is left blank, you will not be able to see your score. | ||||||||||
Each graded cell is highlighted in yellow. Select all account titles/labels using dropdowns. Enter formulas for all dollar amounts. | ||||||||||
The formula must only contain cell addresses. | ||||||||||
Each correct formula will begin with =, +, or -. | ||||||||||
The basic mathematical operators are +, -, * and / | ||||||||||
Addition: To add the values in cells A1 and B4, the formula is =A1+B4 | ||||||||||
Subtraction: To subtract the value in cell B4 from the value in cell A1, the formula is =A1-B4 | ||||||||||
Multiplication: To multiply the values in cells A1 and B4, the formula is =A1*B4 | ||||||||||
Division: To divide the value in cell A1 by the value in cell B4, the formula is =A1/B4 | ||||||||||
THIS FILE REQUIRES THE USE OF =SUM FOR ALL TOTALS AND SUBTOTALS | ||||||||||
The =SUM function adds all values within a range of cells. | ||||||||||
For example, the formula to calculate total attendees in cell B19 is =SUM(B16:B18). | ||||||||||
Men | 850 | |||||||||
Women | 930 | |||||||||
Children | 1,145 | |||||||||
Total | 2,925 |
![A
1 Name:
2 Your score:
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
Cash
Accounts receivable
Inventory
Prepaid rent
B
Equipment
Accounts payable
Unearned consulting revenue
Common stock
Dividends
Consulting revenue
Rental revenue
Salaries expense
Rent expense
The trial balance of the Lucas Casel Company as of December 31, 2022 is presented below. Prepare an
income statement, statement of retained earnings and a balance sheet for the year ended (date of), December
31, 2022. Every yellow cell requires either an account title or a formula. ALL FORMULAS FOR TOTALS MUST
INCLUDE THE =SUM FUNCTION. Use the dropdown list to select the proper account titles.
Insurance expense
Totals
Revenues
Total revenues
Expenses
Total expenses
C
Lucas Casel
0%
Lucas Casel Company
Trial Balance
December 31, 2022
Debit
$5,400
1,300
10,800
3,500
27,100
1,300
Instructions
2,500
2,100
1,400
1) Prepare the income statement for Lucas Casel Company for the year
ended December 31, 2022.
Lucas Casel Company
Income Statement
For Year Ended December 31, 2022
D
Credit
Prepare Fin Sts
$7,300
4,100
35,700
6,900
1,400
2) The Lucas Casel Company began operations on January 1, 2022.
Prepare its statement of retained earnings for the year ended December
31, 2022.
Lucas Casel Company
E
+
F](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fb65b897e-c25a-4cf2-8353-f55699c5f000%2F2f1b4475-58e3-4ddd-b1f4-736cbac3533f%2Fson6v7k_processed.png&w=3840&q=75)
Transcribed Image Text:A
1 Name:
2 Your score:
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
Cash
Accounts receivable
Inventory
Prepaid rent
B
Equipment
Accounts payable
Unearned consulting revenue
Common stock
Dividends
Consulting revenue
Rental revenue
Salaries expense
Rent expense
The trial balance of the Lucas Casel Company as of December 31, 2022 is presented below. Prepare an
income statement, statement of retained earnings and a balance sheet for the year ended (date of), December
31, 2022. Every yellow cell requires either an account title or a formula. ALL FORMULAS FOR TOTALS MUST
INCLUDE THE =SUM FUNCTION. Use the dropdown list to select the proper account titles.
Insurance expense
Totals
Revenues
Total revenues
Expenses
Total expenses
C
Lucas Casel
0%
Lucas Casel Company
Trial Balance
December 31, 2022
Debit
$5,400
1,300
10,800
3,500
27,100
1,300
Instructions
2,500
2,100
1,400
1) Prepare the income statement for Lucas Casel Company for the year
ended December 31, 2022.
Lucas Casel Company
Income Statement
For Year Ended December 31, 2022
D
Credit
Prepare Fin Sts
$7,300
4,100
35,700
6,900
1,400
2) The Lucas Casel Company began operations on January 1, 2022.
Prepare its statement of retained earnings for the year ended December
31, 2022.
Lucas Casel Company
E
+
F
![1 Name:
2 Your score:
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
2
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
Lucas Casel
0%
2) The Lucas Caser Company pegan operations on January 1, ZUZZ.
Prepare its statement of retained earnings for the year ended December
31, 2022.
Retained earnings, January 1, 2022
Subtotal
Retained earnings, December 31, 2022
Lucas Casel Company
Statement of Retained Earnings
For Year Ended December 31, 2022
Total assets
3) Prepare a balance sheet for Lucas Casel Company at December 31, 2022.
Lucas Casel Company
Balance Sheet
December 31, 2022
Assets
Liabilities
Total liabilities
Equity
Total liabilities and equity
$0
Liabilities and Equity](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fb65b897e-c25a-4cf2-8353-f55699c5f000%2F2f1b4475-58e3-4ddd-b1f4-736cbac3533f%2F8orcw3_processed.png&w=3840&q=75)
Transcribed Image Text:1 Name:
2 Your score:
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
2
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
Lucas Casel
0%
2) The Lucas Caser Company pegan operations on January 1, ZUZZ.
Prepare its statement of retained earnings for the year ended December
31, 2022.
Retained earnings, January 1, 2022
Subtotal
Retained earnings, December 31, 2022
Lucas Casel Company
Statement of Retained Earnings
For Year Ended December 31, 2022
Total assets
3) Prepare a balance sheet for Lucas Casel Company at December 31, 2022.
Lucas Casel Company
Balance Sheet
December 31, 2022
Assets
Liabilities
Total liabilities
Equity
Total liabilities and equity
$0
Liabilities and Equity
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 4 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Recommended textbooks for you
![Fundamentals Of Financial Management, Concise Edi…](https://www.bartleby.com/isbn_cover_images/9781337902571/9781337902571_smallCoverImage.jpg)
Fundamentals Of Financial Management, Concise Edi…
Finance
ISBN:
9781337902571
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Principles of Accounting Volume 1
Accounting
ISBN:
9781947172685
Author:
OpenStax
Publisher:
OpenStax College
![Financial & Managerial Accounting](https://www.bartleby.com/isbn_cover_images/9781285866307/9781285866307_smallCoverImage.gif)
Financial & Managerial Accounting
Accounting
ISBN:
9781285866307
Author:
Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:
Cengage Learning
![Fundamentals Of Financial Management, Concise Edi…](https://www.bartleby.com/isbn_cover_images/9781337902571/9781337902571_smallCoverImage.jpg)
Fundamentals Of Financial Management, Concise Edi…
Finance
ISBN:
9781337902571
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Principles of Accounting Volume 1
Accounting
ISBN:
9781947172685
Author:
OpenStax
Publisher:
OpenStax College
![Financial & Managerial Accounting](https://www.bartleby.com/isbn_cover_images/9781285866307/9781285866307_smallCoverImage.gif)
Financial & Managerial Accounting
Accounting
ISBN:
9781285866307
Author:
Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:
Cengage Learning
![Intermediate Accounting: Reporting And Analysis](https://www.bartleby.com/isbn_cover_images/9781337788281/9781337788281_smallCoverImage.jpg)
Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:
9781337788281
Author:
James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:
Cengage Learning
![Auditing: A Risk Based-Approach (MindTap Course L…](https://www.bartleby.com/isbn_cover_images/9781337619455/9781337619455_smallCoverImage.gif)
Auditing: A Risk Based-Approach (MindTap Course L…
Accounting
ISBN:
9781337619455
Author:
Karla M Johnstone, Audrey A. Gramling, Larry E. Rittenberg
Publisher:
Cengage Learning