FormatFS_AU23

xlsx

School

Ohio State University *

*We aren’t endorsed by this school

Course

12344

Subject

Accounting

Date

Apr 3, 2024

Type

xlsx

Pages

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)