FormatFS_AU23
xlsx
keyboard_arrow_up
School
Ohio State University *
*We aren’t endorsed by this school
Course
12344
Subject
Accounting
Date
Apr 3, 2024
Type
xlsx
Pages
7
Uploaded by ColonelRain4790
Eric Ash
Instructions
1) Open the financial statements downloaded from FIND2 assignment (sec.gov) 2) Select the Consolidated Balance Sheet, Consolidated Statement of Operations and Consolidated Statement
3)
COPY or MOVE each of the worksheets from step 2) to this template 4)
Begin transferring data by copying and pasting data from the copied tabs into the template sheets
5) 6)
Some accounts may not transfer 1 for 1 and must be aggregated.
7) Remove the yellow formatting after you've input the information -or-format after you've input the data
8)
The check rows will provide a 'check' as to whether the data copied is accurate. 9)
Save the file as FORMAT1_registrarname.xlsx
10)
Make sure you've input YOUR NAME in cell A1 ABOVE!
11)
Upload the excel file to CARMEN
Legend
Cell data
Color
Student input
Hard code Black
Formula
Red
Mapping / checks
Balance sheet
Income statement
Cash flow statement
To reduce the risk of mis-keying data, I recommend you copy the data
from the FIND2 tabs into the highlig
The non-current assets is essentially a plug figure, meaning that once you have input cash, current assets, n
and equipment you can "back into" non-current assets by subtracting total assets from current assets + ne
equipment
The check cells next to the balance sheet should
show a 0 balance. If the check cells do not equal -0-, chec
have input the correct data. The cost of sales cell check ensures that the cost of sales sign is positive since the formula to calculate gros
sales from cost of sales. If cost of sales is negative change the sign to positive
The operating profit check makes sure that the correct amounts are entered into sales, cost of sales and op
the check value does not equal -0-, check your inputs.
The pre-tax income check makes sure that the correct amounts are entered into operating profit, interest e
expense. If the check value does not equal -0-, check your inputs.
Keying in the operating, investing and financing cash flows allows you to back into change in working capita
cash flows and other financing cash flows. Account names may vary between the financial statemetn and t
require aggregation (netting).
t of Cash
ghted yellow boxes
net plant property et plant property and ck to make sure you ss profit is subtracting perating expense. If expense, other al, other investing template. Some
Income Statement (in $M)
Current year
Prior year
2yr prior
Total revenue
402996
372510
336613
COGS
187307
187330
169265
Gross profit
$215,689 $185,180 $167,348 Operating expenses
109711
97,866
83,257
Operating income
105,978
87,314
84,091
Interest expense (income)
11721
6,777
13,618
Other expense (income)
-212
-2,214
-6,505
Pre-tax income
94,469
82,751
76,978
Tax expense
25,183
22,524
21,008
Net income
69,286
60,227
55,970
Operating profit check
Pre-tax income check
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
105,872 87,227 84,013 94,375 82,668 76,901
Balance Sheet (in $M)
Current year
Prior year
Assets
Cash
$ 6,353 $ 3,167 Current assets
381,177 336,354 Net plant property & equiptment
323,530 269,659 Non current assets
636,622 642,333 Total assets check
Total assets
1,341,329 1,248,346 Liabilities
Current liabilities
74,460 60,002 LT debt
223,619 213,748 Non-current liabilities
107,195 110,602 Total liabilities
405,274 384,352 Equity
Equity
942,408 867,161 Liability + Equity
1,347,682 1,251,513 Total liabilities + equity check
1,339,981 1,247,094 1,346,334 1,250,261
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Cash Flow Statement (in $M)
Current year
Prior year
2yr prior
Cash flow from operations
Net income
$ 69,286 $ 60,227 $ 55,970 Depreciaiton
27,768 23,427 21,343 Change in working capital
(26,962) (14,822) (13,041)
Cash flow from operations
70,092 68,832 64,272 Cash flow from investing
Capital expenditures
(72,843)
(44,644)
(13,689)
Other cash flows from investing
271 910 122 Cash flow from investing
(72,572)
(43,734)
(13,567)
Cash flow from financing
Net debt issuance (repayment)
(2,671)
- (260)
Net share repurchases
350 287 -
Dividend
- - (100,000)
Other cash flows from financing
5,507 (1,364) 98,252 Cash flow from financing
3,186 (1,077) (2,008)
Related Documents
Related Questions
Select the letter of the item below that best matches the definitions that follow.
a. Balance Sheet Standard report.
b. To date
c. Summary Balance Sheet report
d. QuickZoom
e. Transactions by Account report
f. % of Column
g. Memorizing a report
h. Divided by 1000
1. ________ When selected in the Modify Report window, this check box requires QuickBooks Accountant to add a column representing the percentage of each item compared to total assets.
2. ________ When selected in the Modify Report window, this check box requires QuickBooks Accountant to round amounts to the nearest whole dollar.
3. ________ The start of the reporting period.
4. ________ A financial statement reporting in detail the assets, liabilities, and equities of a business as of a certain date.
5. ________ A process by which modified reports are saved for later use.
6. ________ When selected in the Modify Report window, this check box requires QuickBooks Accountant to report amounts in thousands.
7. ________ The end…
arrow_forward
The Maintain; Chart of Accounts window can be used to revise accounts in the chart of accounts.
Question 15 options:
True
False
arrow_forward
help please answer in text form with proper workings and explanation for each and every part and steps with concept and introduction no AI no copy paste remember answer must be in proper format with all working
arrow_forward
This is the excel spreadsheet to complete problem E6-23 all shaded cells in column D,H and J.
Attached is the page from the book for E6-23 and the spreadsheet is attached to where the account titles goes and amounts
arrow_forward
QC 07.
arrow_forward
urnalizing entries, information can be entered into T-Accounts and/or the four-column ledger. Enter the information from the T-Account and calculate the running balance in the appropriate place in the four-column ledger to review the similarities between the two formats.
arrow_forward
16) When creating a new QuickBooks data file for an existing company, QuickBooks automatically offsets accounts receivable balances with an entry to the:A) Uncategorized Expenses accountB) Uncategorized Income accountC) Opening Balance Equity accountD) Capital Stock account
Group of answer choices
A
B
C
D
arrow_forward
Enter the amount of each transaction on individual items of the accounting equation. (Enter decreases to account balances with a minus sign. Enter as per the transaction order provided in the question data.)
arrow_forward
Errors can occur in posting debits and credits from the journal to the ledger. One way to detect errors is by transferring the balances in each account to summary report called the _____________________ and by adding the debit column and the credit column to see if the totals equal (or balance).
Group of answer choices
ledger
journal
balance sheet
trial balance
arrow_forward
Please provide the formulas used to find these missing amounts in the T-Accounts. Please do not use an Excel sheet. If you could type out the formula that would make it easier for me to understand.
1) Find Missing CR amount
Left Side of T-Account
Beginning Balance 4800
Transaction A
Transaction B 6000
Transaction E 8700
Right Side of T-Account
Transaction C-amount unknown
Transaction D 1200
Transaction F 4200
2) Find Beginning Balance on DR Side
Debit Side of T-Account
Beginning Balance-Unknown
Transaction B 5000
Ending Balance 65000
Right Side of T-Account
Transaction A 2000
Transaction C 25000
3) Find Missing CR Amount
Debit Side of Account
Beginning Balance 0
Transaction A 1500
Transaction B 6000
Transaction C 8700
Ending Balance 14700
Credit Side of Account
Transaction D-Unknown
4) Find Missing Ending Balance Amount on DR side
Left Side of T-Account
Beginning Balance 0
Transaction A 1500
Transaction B 2000
Ending Balance-Unknown
Rigth Side of T-Account-No Transactions
arrow_forward
ssignments x
signment/assignmentOverview.do?filterMode=all&studentCourseSelector=199635
9 Cookie
Graces
Sady Teels
Final
Which of the following has the steps of the accounting cycle in the proper sequence? (Some
Score
steps may be missing.)
Attempt
a. analyze and record transactions, post transaction to the ledger prepare a trial balance, prepare
financial statements, journalize closing entries, analyze adjustment data and prepare adjusting
Score
entries
b. prepare financial statements, journalize closing entries and post to the ledger, analyze and record
transactions, post transactions to the ledger, prepare a trial balance, analyze adjustment data,
prepare adjusting entries
C. prepare a trial balance, analyze adjustment data, prepare adjusting entries, prepare financial
statements, journalize closing entries and post to the ledger analyze and record transactions, post
transactions to the ledger
Commen
d. analyze and record transactions, post transactions to the ledger, prepare a…
arrow_forward
INSTRUCTIONS:
• Use MS Excel
• Before you start journalizing, enter the appropriate columnar headings: Date, Description, P/R, Debit, Credit.
• Journalize the transactions, including the appropriate description and source documents for each transaction.
• Use compound entry for entries with multiple debit and credit accounts.
• In the posting reference (P/R) column encode the account numbers.
• Leave a space after every journal entry.
Required:
- JOURNAL ENTRIES
arrow_forward
Which accountant tool in QuickBooks Online helps identify transactions that may have been removed accidentally from the company file?
A. Reclassify Transactions
B. Voided/deleted transactions
C. Close Books
D. Prep for Taxes
arrow_forward
Which of the following statements regarding the balance ledger form is inaccurate?
It displays multiple accounts within a single form.
It shows the balance of the account after each entry is posted
It is one of a number of types of general ledger accounts forms
Or
It includes a posting reference column and a description column
arrow_forward
The financial data on the financial reports is built or generated on the base of
A.Single entry accounting system
B.Manual dual data system
C.Double entry system
D.Excel spread sheet data entry system
arrow_forward
Pls do the one that says
“Enter the opening balances in the ledger accounts as at October 1, Write balance..” too with the send one using the templates
Thank you!
arrow_forward
WP NWP Assessment Player UI Applic
Question 17 of 42
View Policies
Current Attempt in Progress
Credits
decrease both assets and liabilities.
increase both assets and liabilities.
decrease assets and increase liabilities.
O increase assets and decrease liabilities.
Save for Later
arrow_forward
Hi,
Can you please help me with problem 5.6? Thank you.
arrow_forward
Please prepare the general format of the balance sheet (without numbers).
Please make sure you list out the major categories and the common accounts
under each category.
Bonus
(ISOS
42038
banl pribli
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you

Pkg Acc Infor Systems MS VISIO CD
Finance
ISBN:9781133935940
Author:Ulric J. Gelinas
Publisher:CENGAGE L
Principles of Accounting Volume 1
Accounting
ISBN:9781947172685
Author:OpenStax
Publisher:OpenStax College
Related Questions
- Select the letter of the item below that best matches the definitions that follow. a. Balance Sheet Standard report. b. To date c. Summary Balance Sheet report d. QuickZoom e. Transactions by Account report f. % of Column g. Memorizing a report h. Divided by 1000 1. ________ When selected in the Modify Report window, this check box requires QuickBooks Accountant to add a column representing the percentage of each item compared to total assets. 2. ________ When selected in the Modify Report window, this check box requires QuickBooks Accountant to round amounts to the nearest whole dollar. 3. ________ The start of the reporting period. 4. ________ A financial statement reporting in detail the assets, liabilities, and equities of a business as of a certain date. 5. ________ A process by which modified reports are saved for later use. 6. ________ When selected in the Modify Report window, this check box requires QuickBooks Accountant to report amounts in thousands. 7. ________ The end…arrow_forwardThe Maintain; Chart of Accounts window can be used to revise accounts in the chart of accounts. Question 15 options: True Falsearrow_forwardhelp please answer in text form with proper workings and explanation for each and every part and steps with concept and introduction no AI no copy paste remember answer must be in proper format with all workingarrow_forward
- This is the excel spreadsheet to complete problem E6-23 all shaded cells in column D,H and J. Attached is the page from the book for E6-23 and the spreadsheet is attached to where the account titles goes and amountsarrow_forwardQC 07.arrow_forwardurnalizing entries, information can be entered into T-Accounts and/or the four-column ledger. Enter the information from the T-Account and calculate the running balance in the appropriate place in the four-column ledger to review the similarities between the two formats.arrow_forward
- 16) When creating a new QuickBooks data file for an existing company, QuickBooks automatically offsets accounts receivable balances with an entry to the:A) Uncategorized Expenses accountB) Uncategorized Income accountC) Opening Balance Equity accountD) Capital Stock account Group of answer choices A B C Darrow_forwardEnter the amount of each transaction on individual items of the accounting equation. (Enter decreases to account balances with a minus sign. Enter as per the transaction order provided in the question data.)arrow_forwardErrors can occur in posting debits and credits from the journal to the ledger. One way to detect errors is by transferring the balances in each account to summary report called the _____________________ and by adding the debit column and the credit column to see if the totals equal (or balance). Group of answer choices ledger journal balance sheet trial balancearrow_forward
- Please provide the formulas used to find these missing amounts in the T-Accounts. Please do not use an Excel sheet. If you could type out the formula that would make it easier for me to understand. 1) Find Missing CR amount Left Side of T-Account Beginning Balance 4800 Transaction A Transaction B 6000 Transaction E 8700 Right Side of T-Account Transaction C-amount unknown Transaction D 1200 Transaction F 4200 2) Find Beginning Balance on DR Side Debit Side of T-Account Beginning Balance-Unknown Transaction B 5000 Ending Balance 65000 Right Side of T-Account Transaction A 2000 Transaction C 25000 3) Find Missing CR Amount Debit Side of Account Beginning Balance 0 Transaction A 1500 Transaction B 6000 Transaction C 8700 Ending Balance 14700 Credit Side of Account Transaction D-Unknown 4) Find Missing Ending Balance Amount on DR side Left Side of T-Account Beginning Balance 0 Transaction A 1500 Transaction B 2000 Ending Balance-Unknown Rigth Side of T-Account-No Transactionsarrow_forwardssignments x signment/assignmentOverview.do?filterMode=all&studentCourseSelector=199635 9 Cookie Graces Sady Teels Final Which of the following has the steps of the accounting cycle in the proper sequence? (Some Score steps may be missing.) Attempt a. analyze and record transactions, post transaction to the ledger prepare a trial balance, prepare financial statements, journalize closing entries, analyze adjustment data and prepare adjusting Score entries b. prepare financial statements, journalize closing entries and post to the ledger, analyze and record transactions, post transactions to the ledger, prepare a trial balance, analyze adjustment data, prepare adjusting entries C. prepare a trial balance, analyze adjustment data, prepare adjusting entries, prepare financial statements, journalize closing entries and post to the ledger analyze and record transactions, post transactions to the ledger Commen d. analyze and record transactions, post transactions to the ledger, prepare a…arrow_forwardINSTRUCTIONS: • Use MS Excel • Before you start journalizing, enter the appropriate columnar headings: Date, Description, P/R, Debit, Credit. • Journalize the transactions, including the appropriate description and source documents for each transaction. • Use compound entry for entries with multiple debit and credit accounts. • In the posting reference (P/R) column encode the account numbers. • Leave a space after every journal entry. Required: - JOURNAL ENTRIESarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Pkg Acc Infor Systems MS VISIO CDFinanceISBN:9781133935940Author:Ulric J. GelinasPublisher:CENGAGE LPrinciples of Accounting Volume 1AccountingISBN:9781947172685Author:OpenStaxPublisher:OpenStax College

Pkg Acc Infor Systems MS VISIO CD
Finance
ISBN:9781133935940
Author:Ulric J. Gelinas
Publisher:CENGAGE L
Principles of Accounting Volume 1
Accounting
ISBN:9781947172685
Author:OpenStax
Publisher:OpenStax College