1. For Total current assets (on the Balance Sheet), use an Excel function to calculate the value. 2. For Total fixed assets (on the Balance Sheet), use operation signs to calculate the value. 3. As the CFA for Filler Construction, you notice the given Balance Sheet is suspiciously missing accounts that have an opposite normal balance of otheraccounts in their same category. a. What are these types of accounts called? b. add the following accounts where they should be listed: Allowance forDoubtful Accounts of $50, Accumulated Depreciation of $3450, and Treasury Stock of $450. Note: ensure these values are properly visually denoted ashaving the opposite normal balance. 4. Now you see that it is mising required formatting for a U.S. public company's external financial statement! Add in the required underlines where neededand change the number formatting to meet requirement.5. What is a first "check" to determine if this Balance Sheet is balanced? 6. What are two financial ratios that can be determined from the information given on a Balance Sheet. Filler Construction Balance Sheet 31-Dec-23 Cash 2500 Accounts Receivable 4200 Total current assets 6700 Equipment 21000 Land 12100 Total fixed assets 33100 Patents 2500 Total Assets 42300 Accounts Payable 3750 Salaries Payable 1200 Total current liabilities 4950 Notes Payable, long-term 8100 Total long-term liabilities 8100 Total Liabilities 13050 Common Stock 14000 Retained Earnings 11300 Total Stockholders' Equity 25300 Total Liabilities & Stockholders' Equity 38350
1. For Total current assets (on the Balance Sheet), use an Excel function to calculate the value. 2. For Total fixed assets (on the Balance Sheet), use operation signs to calculate the value. 3. As the CFA for Filler Construction, you notice the given Balance Sheet is suspiciously missing accounts that have an opposite normal balance of otheraccounts in their same category. a. What are these types of accounts called? b. add the following accounts where they should be listed: Allowance forDoubtful Accounts of $50, Accumulated Depreciation of $3450, and Treasury Stock of $450. Note: ensure these values are properly visually denoted ashaving the opposite normal balance. 4. Now you see that it is mising required formatting for a U.S. public company's external financial statement! Add in the required underlines where neededand change the number formatting to meet requirement.5. What is a first "check" to determine if this Balance Sheet is balanced? 6. What are two financial ratios that can be determined from the information given on a Balance Sheet. Filler Construction Balance Sheet 31-Dec-23 Cash 2500 Accounts Receivable 4200 Total current assets 6700 Equipment 21000 Land 12100 Total fixed assets 33100 Patents 2500 Total Assets 42300 Accounts Payable 3750 Salaries Payable 1200 Total current liabilities 4950 Notes Payable, long-term 8100 Total long-term liabilities 8100 Total Liabilities 13050 Common Stock 14000 Retained Earnings 11300 Total Stockholders' Equity 25300 Total Liabilities & Stockholders' Equity 38350
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Question
1. For Total current assets (on the Balance Sheet ), use an Excel function to calculate the value.
2. For Total fixed assets (on the Balance Sheet), use operation signs to calculate the value.
3. As the CFA for Filler Construction, you notice the given Balance Sheet is suspiciously missing accounts that have an opposite normal balance of other
accounts in their same category. a. What are these types of accounts called? b. add the following accounts where they should be listed: Allowance for
Doubtful Accounts of $50,Accumulated Depreciation of $3450, and Treasury Stock of $450. Note: ensure these values are properly visually denoted as
having the opposite normal balance.
4. Now you see that it is mising required formatting for a U.S. public company's external financial statement! Add in the required underlines where needed
and change the number formatting to meet requirement.
5. What is a first "check" to determine if this Balance Sheet is balanced?
6. What are two financial ratios that can be determined from the information given on a Balance Sheet.
2. For Total fixed assets (on the Balance Sheet), use operation signs to calculate the value.
3. As the CFA for Filler Construction, you notice the given Balance Sheet is suspiciously missing accounts that have an opposite normal balance of other
accounts in their same category. a. What are these types of accounts called? b. add the following accounts where they should be listed: Allowance for
Doubtful Accounts of $50,
having the opposite normal balance.
4. Now you see that it is mising required formatting for a U.S. public company's external financial statement! Add in the required underlines where needed
and change the number formatting to meet requirement.
5. What is a first "check" to determine if this Balance Sheet is balanced?
6. What are two financial ratios that can be determined from the information given on a Balance Sheet.
Filler Construction | ||
Balance Sheet | ||
31-Dec-23 | ||
Cash | 2500 | |
|
4200 | |
Total current assets | 6700 | |
Equipment | 21000 | |
Land | 12100 | |
Total fixed assets | 33100 | |
Patents | 2500 | |
Total Assets | 42300 | |
Accounts Payable | 3750 | |
Salaries Payable | 1200 | |
Total current liabilities | 4950 | |
Notes Payable, long-term | 8100 | |
Total long-term liabilities | 8100 | |
Total Liabilities | 13050 | |
Common Stock | 14000 | |
|
11300 | |
Total |
25300 | |
Total Liabilities & Stockholders' Equity | 38350 |
AI-Generated Solution
AI-generated content may present inaccurate or offensive content that does not represent bartleby’s views.
Unlock instant AI solutions
Tap the button
to generate a solution
Recommended textbooks for you
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education