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