58. Apply Your Skills Warmth Aprendendo do the start with info BA2-A1 Create Financial Statements for Titan Industries yer create a monthly mom stutt ement and Malerei und Acest the ring female - Center DEA2A1-Financial Statements Start Mother O AD AL-Financial Statement With the exception of the Wimmutate Capital .count the balance of whom 11/1/202, the company haccountances of 11/30/2020 2.500 porte Account create 17.000 Licence 112.000 11.000 11000 $19.000 5700 510.000 pere $1.000 orice cente 56.300 Wim Burt 11/11/2016 100.000 Now $5.000 waanamaam S500 Set Up the Workbook Throughout this one the appropriate approach is the one described in the chapter und sed in preceding to If you aren't en the text to enter setting to make or other detail, turn back to the chapter for a refresher Three bone named for each financial statement and arranged in the order of completo (Hint: For the statement name that won't fine the abbreviations part of the tab mame) - Range AA (on eachta Enter the appropriate three-line header for the statement company name, 2 financial statement. 3 date expressed in proper form) P02 Bold formatting and this fil color: P-2) Then Merge and center the header toes aros Columns A-D Income Statement) or columns A-Statement of Balance Sheet), PG20 Income Statement CA CA CHAMU Toal For CC, 123Alythede Albertotie pense was the larget penge for the month and 10 do low 15 Hide- Columns widely - Accountingumomat, Statement of Owner's Equity Location What to Enter cets AS andes being out there is one and on IPO-0 Cetts And Description to Wet Lohose the correct amount of time Subtotal of cond- CA and Name of the account and mounti- Can Aland Indig egy medded amount Formatting Calle 0,8 and 9Apply the appropriate bordet. Pa . Celle AS and A9. Wrap the text to play the accounts - Columns A-Cwidth25, 2. und 3. respectively + Set a height of 29 for the two rows requiring adjustment All amounts Accounting sumber format aerodecimal ocel Balance Sheet Location What to Enter COVAS Header Asst. POJA Ranges to and in column A asset account names in order of liquidity Cash, Accounts Receivable Supore, Egmont Building and in column the associated amounts 70-76) Cells A11 and Cut The description Total Assets and is associated amount (P-761 Remember to add the appropriate borders to celli C10 and 11 p-1d, and to insetta lite break where needed in the account name in cell A7.78 Location What to Enter Cell A10 Lait Ranges A18 A15 m.column the baty account names her to long term incolumn and C14.15 the associated amounts - Cells A16 and 16 me description Total Litttes and its med amour PC-80 Cell AT Header ons uity - Celis A19 and 19 Equity account name ono date and its wmounte) Cell A21 and 21 The description Total liabilities and Over quity and the associated amount iG-80 Hint: In this instance, the order of liabilities from short-to long-term is also the order from smallest to largest Formatting . Cells A19 and A21 (account names) Use Wrap Text 0-9 . Cells CIS, C19, and C21. Apply the appropriate border. (PO- Ranges A6 A10 and A14A15, indent the account names one time. Pod Columns A-Cwidth:18, 10, and 11, respectively po-90 Set a height of 29 for the three rows requiring adjustment POV) . All amount Accounting number format, zero decimal poon Save and close the file. Using Project Grader: Save the file as EA2-A1-FinancialStatements-eSubmission and attach it to the assignment you submit for grading Not using Project Grader: Submit the file per your instructor's guidelines 10 00 58. Apply Your Skills Warmth Aprendendo do the start with info BA2-A1 Create Financial Statements for Titan Industries yer create a monthly mom stutt ement and Malerei und Acest the ring female - Center DEA2A1-Financial Statements Start Mother O AD AL-Financial Statement With the exception of the Wimmutate Capital .count the balance of whom 11/1/202, the company haccountances of 11/30/2020 2.500 porte Account create 17.000 Licence 112.000 11.000 11000 $19.000 5700 510.000 pere $1.000 orice cente 56.300 Wim Burt 11/11/2016 100.000 Now $5.000 waanamaam S500 Set Up the Workbook Throughout this one the appropriate approach is the one described in the chapter und sed in preceding to If you aren't en the text to enter setting to make or other detail, turn back to the chapter for a refresher Three bone named for each financial statement and arranged in the order of completo (Hint: For the statement name that won't fine the abbreviations part of the tab mame) - Range AA (on eachta Enter the appropriate three-line header for the statement company name, 2 financial statement. 3 date expressed in proper form) P02 Bold formatting and this fil color: P-2) Then Merge and center the header toes aros Columns A-D Income Statement) or columns A-Statement of Balance Sheet), PG20 Income Statement CA CA CHAMU Toal For CC, 123Alythede Albertotie pense was the larget penge for the month and 10 do low 15 Hide- Columns widely - Accountingumomat, Statement of Owner's Equity Location What to Enter cets AS andes being out there is one and on IPO-0 Cetts And Description to Wet Lohose the correct amount of time Subtotal of cond- CA and Name of the account and mounti- Can Aland Indig egy medded amount Formatting Calle 0,8 and 9Apply the appropriate bordet. Pa . Celle AS and A9. Wrap the text to play the accounts - Columns A-Cwidth25, 2. und 3. respectively + Set a height of 29 for the two rows requiring adjustment All amounts Accounting sumber format aerodecimal ocel Balance Sheet Location What to Enter COVAS Header Asst. POJA Ranges to and in column A asset account names in order of liquidity Cash, Accounts Receivable Supore, Egmont Building and in column the associated amounts 70-76) Cells A11 and Cut The description Total Assets and is associated amount (P-761 Remember to add the appropriate borders to celli C10 and 11 p-1d, and to insetta lite break where needed in the account name in cell A7.78 Location What to Enter Cell A10 Lait Ranges A18 A15 m.column the baty account names her to long term incolumn and C14.15 the associated amounts - Cells A16 and 16 me description Total Litttes and its med amour PC-80 Cell AT Header ons uity - Celis A19 and 19 Equity account name ono date and its wmounte) Cell A21 and 21 The description Total liabilities and Over quity and the associated amount iG-80 Hint: In this instance, the order of liabilities from short-to long-term is also the order from smallest to largest Formatting . Cells A19 and A21 (account names) Use Wrap Text 0-9 . Cells CIS, C19, and C21. Apply the appropriate border. (PO- Ranges A6 A10 and A14A15, indent the account names one time. Pod Columns A-Cwidth:18, 10, and 11, respectively po-90 Set a height of 29 for the three rows requiring adjustment POV) . All amount Accounting number format, zero decimal poon Save and close the file. Using Project Grader: Save the file as EA2-A1-FinancialStatements-eSubmission and attach it to the assignment you submit for grading Not using Project Grader: Submit the file per your instructor's guidelines 10 00