1 in Excel--use this page to practice, and then move to the IS-OE-BS-CF worksheet. 2 3 ata in a trial balance, and you wish to construct an income statement 4 following data to demonstrate the procedure. 5 ... TO CONSTRUCT AN INCOME STATEMENT... ...AND RETAINED EARNINGS STATEMENT 6 7 Comments 8 Example Corporation Income Statement FYE 12/31/2015 Comments 0 CR Example Corporation Retained Earnings Statement EYE 12/31/2015 Beginning Retained Earnings +Net Income Subtotal -Dividends Ending Retained Earnings Service Revenue 9 10 DR 11 95,500 12 1,500 13 3,000 14 12,000 15 --Equipmei 16 17 18 0 1,000 2,000 100,000 0 22,000 Advertising Expense Rent Expense Salaries Expense Utilities Expense Depreciation Expense Supplies Expense Net Income Johnson Corporation Cash Flow Statement EYE 12/31/2015 Comments 3 19 20 Note: put your copied cells and formulas in the gray areas. 3,000 2,000 4,000 1,000 1,000 2,000 125,000 CF from OPERATIONS Net Income + Depreciation Expense -Increase in Accounts Receivable 21 22 23 24 25 26 27 28 29 30 -- 125,000 for boldface, Italic, and Underline. BIU If you click the down-arrow, you will see how to underline, double underline, or create boxes around your cells. To erase a border use the "blank" border symbol. 31 32 33 34 35 Just like Word...select a cell and click the left, right or center button. 19 22,000 Net Income FYE 12/11/2015 Comments Note: put your copied cells and formulas in the gray areas. 20 21 22 23 24 25 26 27 28 3,000 2,000 4,000 1,000 1,000 2,000 125,000 CF from OPERATIONS Net Income + Depreciation Expense -Increase in Accounts Receivable 125,000 BIU for boldface, Italic, and Underline. 29 30 31 32 If you click the down-arrow, you will see how to underline, double underline, or create boxes around your cells. To erase a border use the "blank" border symbol. Just like Word...select a cell and click the left, right or center button. Comments Adding numbers: 100 200 300 Subtracting numbers 700 600 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 Division--use / 400 20 Multiplication--use * 12 3 1 in Excel--use this page to practice, and then move to the IS-OE-BS-CF worksheet. 2 3 ata in a trial balance, and you wish to construct an income statement 4 following data to demonstrate the procedure. 5 ... TO CONSTRUCT AN INCOME STATEMENT... ...AND RETAINED EARNINGS STATEMENT 6 7 Comments 8 Example Corporation Income Statement FYE 12/31/2015 Comments 0 CR Example Corporation Retained Earnings Statement EYE 12/31/2015 Beginning Retained Earnings +Net Income Subtotal -Dividends Ending Retained Earnings Service Revenue 9 10 DR 11 95,500 12 1,500 13 3,000 14 12,000 15 --Equipmei 16 17 18 0 1,000 2,000 100,000 0 22,000 Advertising Expense Rent Expense Salaries Expense Utilities Expense Depreciation Expense Supplies Expense Net Income Johnson Corporation Cash Flow Statement EYE 12/31/2015 Comments 3 19 20 Note: put your copied cells and formulas in the gray areas. 3,000 2,000 4,000 1,000 1,000 2,000 125,000 CF from OPERATIONS Net Income + Depreciation Expense -Increase in Accounts Receivable 21 22 23 24 25 26 27 28 29 30 -- 125,000 for boldface, Italic, and Underline. BIU If you click the down-arrow, you will see how to underline, double underline, or create boxes around your cells. To erase a border use the "blank" border symbol. 31 32 33 34 35 Just like Word...select a cell and click the left, right or center button. 19 22,000 Net Income FYE 12/11/2015 Comments Note: put your copied cells and formulas in the gray areas. 20 21 22 23 24 25 26 27 28 3,000 2,000 4,000 1,000 1,000 2,000 125,000 CF from OPERATIONS Net Income + Depreciation Expense -Increase in Accounts Receivable 125,000 BIU for boldface, Italic, and Underline. 29 30 31 32 If you click the down-arrow, you will see how to underline, double underline, or create boxes around your cells. To erase a border use the "blank" border symbol. Just like Word...select a cell and click the left, right or center button. Comments Adding numbers: 100 200 300 Subtracting numbers 700 600 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 Division--use / 400 20 Multiplication--use * 12 3