ACCT 212 INDIVIDUAL LEARNING PROJECT 1 (KELLEY ENTERPRISES)
Assignment instructions are as follows:
1. Use the information in the provided trial balance to create the following financial statements:
a. 2016 Income Statement
b. 2016 Balance Sheet
c. 2016 Cash Flow Statement
2. Create ONE Excel Workbook with the following tabs:
a. Tab 1: Trial Balance for 2015 and 2016 provided
b. Tab 2: Closing Entries for 2015 Income Statement
c. Tab 3: 2016 Income Statement
d. Tab 4: Closing entries for 2016
e. Tab 5: 2016 Balance Sheet post-closing entries (Use the 2015 Retained Earnings balance as your beginning 2016 balance)
f. Tab 6: Cash Flow Statement
a. Use Excel to setup the financial statements by linking the values from the trial balance.
b. Use Excel formulas to calculate all totals and sub-totals.
4. Save your Excel workbook as last name _ Project1. (For example: Koss_Project1.xls).
5. Upload the completed assignment to BlackBoard using the link provided.