Question
Hello I need help with the completion of the following spreadsheet, directions are as followed: 1. Record the transactions in the general journal for December
Hello I need help with the completion of the following spreadsheet, directions are as followed:
1. Record the transactions in the general journal for December 1 through December 31. The transactions are in the EXCEL file.
2. Post entries to T-accounts.
3. Prepare a trial balance.
4. Record the adjusting entries in the general journal. The information related to the adjusting entries are in EXCEL.
5. Post adjusting entries to T-accounts.
6. Prepare an adjusted trial balance.
7. Record the closing entries in the general journal.
8. Post entries to T-accounts.
9. Prepare a post closing trial balance.
10. Prepare an income statement.
11. Prepare a statement of retained earnings.
12. Prepare a balance sheet.
* SHOW WORK AND CALCULATIONS IN THE EMPTY AREA PROVIDED
You must enable macros in order fo Please visit the Microsoft Office Support sit Contact the World Campus Helpdesk s in order for this assignment to function. e Support site for documentation and instructions. us Helpdesk if you continue to have trouble. . Comprehensive Problem Number 1 Charles Sepia is a photographer who has started his own photography business. Charles has decided Sepia Photography. Charles has hired you to provide accounting services for his company. The transa business along with the information needed to prepare the adjusting entries on December 31, 2018 are The following transaction occurred in December 1. On December 1 our company issued 10,000 shares of common stock to C. Sepia in exchange for c 2. On December 1, we purchased photography equipment for cash. The photography equipment cost: 3. On December 1, we prepaid 2 month's rent for our studio. The amount prepaid is: 4. On December 4, we received a deposit from Kim Jong and Vince Molinaro for their June wedding: 5. On December 9 we received a deposit from Edward Taylor for a late December photo shoot: 6. On December 12 we purchased photgraphy supplies (paper etc.) on account for: 7. On December 15, we performed photography services for a local church and billed the client: 8. On December 18, we received our electric bill (utilities). Payment is due on January 18: 9. On December 28, we paid part of the amount due on account from the December 12 transacation: 10. On December 30, we paid our staff assistant's salary for December. The amount paid is: 11. On December 30, we paid a cash dividend. The amount paid is: Prepare the following adjusting entires 1. The photography equipment was purchased December 1 has an expected useful life is 3 years, the Calculate the depreciation for the month of December. Round amount to two decimal places. 2. Rent expired during December 3. Revenue earned from photo shoot for Edward Taylor. Service was completed late in December 7. Photography Supplies on hand on December 31 totaled: Required: 1. Record the transactions for December 1 through December 31 in the General Jounral using the account name 2. Post the entries to the t-accounts. (please read the note on t-account balances in the instructions) 3. Prepare an unadjusted trial balance on December 31, 2018 4. Record the adjusting entries in the General Journal 5. Post the adjusting entries to the t-accounts (please read the note on t-account balances in the instructions) 6. Prepare an adjusted trial balance on December 31, 2018 7. Record the closing entries on December 31, 2018 in the General journal 8. Post the closing entries to the t-accounts (please read the note on t-account balances in the instructions) 9. Prepare a post closing trial balance on December 31, 2018 10. Prepare an income statement for the month ending December 31, 2018 11. Prepare a statement of retained earnings for the month ending December 31, 2018 12. Preapre a balance sheet as of December 31, 2018 Use the area (*Note: Your instructor Gener blem Number 1 business. Charles has decided to incorporate under the name es for his company. The transactions for the first month in ries on December 31, 2018 are shown below: Date Dec 1 E-1 Accou Dec 1 E-2 ed in December k to C. Sepia in exchange for cash : e photography equipment cost: nt prepaid is: linaro for their June wedding: December photo shoot: account for: rch and billed the client: ue on January 18: e December 12 transacation: The amount paid is: Amount 22,331.00 14,223.00 2,237.00 1,111.00 2,121.00 186.00 3,189.00 264.00 101.00 724.00 852.00 ng entires Dec 1 E-3 Dec 4 E-4 Dec 9 E-5 Dec 12 E-6 Amount Dec 15 E-7 ected useful life is 3 years, the residual value is $0. Student Calc o two decimal places. Student Calc Student Calc mpleted late in December 94.00 Dec 18 E-8 Dec 28 E-9 Dec 30 E-10 al Jounral using the account names listed in the chart of account: ces in the instructions) Dec 30 E-11 unt balances in the instructions) Adjusting Dec 31 AJE1 balances in the instructions) Dec 31 AJE2 31, 2018 Dec 31 AJE3 Dec 31 AJE4 Closing e Dec 31 CE1 Dec 31 CE2 Dec 31 CE3 Dec 31 CE4 Use the area below to show your work and calculations. (*Note: Your instructor may use this area to help review and resolve any incorrect answers) General Journal (journal) Accounts Adjusting entries Debit Credit calculations. ny incorrect answers) Closing entires Ledger accounts (T-accounts) Date Cash Debit Credit Date Accounts Payable Debit Balance Date Utilities Payable Debit Balance Date Accounts Receivable Debit Balance Credit Unearned Revenue Date Debit Balance Bal Before AE Date Prepaid Rent Debit Credit Balance Date Date Photography Supplies Debit Credit Balance Date Balance Balance Date Photography Equipment Debit Credit Common Stock Debit Dividends Debit Balance Retained Earnings Date Debit Balance Balance Accumulated Depreciation, Photography Equipment Date Debit Credit Date Balance Photography Revenue Debit 0.00 Balance Date Salaries Expense Debit Balance Date Income Summary Debit Credit Date Utilities Expense Debit Balance Balance Date Rent Expense Debit Balance Depreciation Expense, Photography Equipment Date Debit Balance Photography Supplies Expense Date Debit Balance Sepia Photography Unadjusted Trial Balance unts Payable For Month ended, December 31, 2017 Credit Accounts Debit ties Payable Credit ned Revenue Total Credit Sepia Photography Adjusted Trial Balance For Month ended, December 31, 2017 Accounts mmon Stock Credit ividends ned Earnings Credit Debit Credit Total Sepia Photography Post-Closing Trial Balance For Month ended, December 31, 2017 raphy Revenue Credit Accounts ies Expense Credit Total ties Expense Credit nt Expense Credit se, Photography Equipment Credit Debit y Supplies Expense Credit 17 Sepia Photography Income Statement For Month ended, December 31, 2017 Credit Revenue: Expenses: Total Expenses Net Income Sepia Photography Statement of Retained Earnings For Month ended, December 31, 2017 17 Credit 17 Credit Sepia Photography Balance Sheet December 31, 2017 Assets Current Assets Total Current Assets Property, Plant and Equipment Total Property, Plant and Equipment Total assets Liabilities Current Liabilities Stockholders' Equity Total Stockholders' Equity Total liabilties and stockholders' equity You must enable macros in order fo Please visit the Microsoft Office Support sit Contact the World Campus Helpdesk s in order for this assignment to function. e Support site for documentation and instructions. us Helpdesk if you continue to have trouble. s. Comprehensive Problem Number 1 Charles Sepia is a photographer who has started his own photography business. Charles has decided Sepia Photography. Charles has hired you to provide accounting services for his company. The transa business along with the information needed to prepare the adjusting entries on December 31, 2018 are The following transaction occurred in December 1. On December 1 our company issued 10,000 shares of common stock to C. Sepia in exchange for c 2. On December 1, we purchased photography equipment for cash. The photography equipment cost: 3. On December 1, we prepaid 2 month's rent for our studio. The amount prepaid is: 4. On December 4, we received a deposit from Kim Jong and Vince Molinaro for their June wedding: 5. On December 9 we received a deposit from Edward Taylor for a late December photo shoot: 6. On December 12 we purchased photgraphy supplies (paper etc.) on account for: 7. On December 15, we performed photography services for a local church and billed the client: 8. On December 18, we received our electric bill (utilities). Payment is due on January 18: 9. On December 28, we paid part of the amount due on account from the December 12 transacation: 10. On December 30, we paid our staff assistant's salary for December. The amount paid is: 11. On December 30, we paid a cash dividend. The amount paid is: Prepare the following adjusting entires 1. The photography equipment was purchased December 1 has an expected useful life is 3 years, the Calculate the depreciation for the month of December. Round amount to two decimal places. 2. Rent expired during December 3. Revenue earned from photo shoot for Edward Taylor. Service was completed late in December 7. Photography Supplies on hand on December 31 totaled: Required: 1. Record the transactions for December 1 through December 31 in the General Jounral using the account name 2. Post the entries to the t-accounts. (please read the note on t-account balances in the instructions) 3. Prepare an unadjusted trial balance on December 31, 2018 4. Record the adjusting entries in the General Journal 5. Post the adjusting entries to the t-accounts (please read the note on t-account balances in the instructions) 6. Prepare an adjusted trial balance on December 31, 2018 7. Record the closing entries on December 31, 2018 in the General journal 8. Post the closing entries to the t-accounts (please read the note on t-account balances in the instructions) 9. Prepare a post closing trial balance on December 31, 2018 10. Prepare an income statement for the month ending December 31, 2018 11. Prepare a statement of retained earnings for the month ending December 31, 2018 12. Preapre a balance sheet as of December 31, 2018 Use the area (*Note: Your instructor 1) 2) Calculation for Deprecyation Cost of Equipment Residual Value Useful Life 14,223.00 0.00 3 Years Dep for the Year Dep for the Year Dep for the Year Dep for 1 Month Dep for 1 Month (Cost - Residual Value) / Useful Life (14,223 - 0)/3 4741 4741 x 1/12 395.08333333 Prepaid Rent Amount Rent Prepaid for 1 Month Rent 1 Month Rent 2237 2 Month (2237 / 2) 1118.5 Rent Expenses 3) Gener blem Number 1 business. Charles has decided to incorporate under the name es for his company. The transactions for the first month in ries on December 31, 2018 are shown below: ed in December k to C. Sepia in exchange for cash : e photography equipment cost: nt prepaid is: linaro for their June wedding: December photo shoot: account for: rch and billed the client: ue on January 18: e December 12 transacation: The amount paid is: ng entires Amount 22,331.00 14,223.00 2,237.00 1,111.00 2,121.00 186.00 3,189.00 264.00 101.00 724.00 852.00 Date Dec 1 E-1 Accou Cash Dec 1 E-2 Photography Equipment Dec 1 E-3 Prepaid Rent Dec 4 E-4 Cash Dec 9 E-5 Cash Dec 12 E-6 Photography Supplies Dec 15 E-7 Accounts Receivable Dec 18 E-8 Utitlities Expenses Dec 28 E-9 Accounts Payable Amount ected useful life is 3 years, the residual value is $0. Student Calc o two decimal places. Student Calc Student Calc mpleted late in December 94.00 Dec 30 E-10 Salaries Expenses al Jounral using the account names listed in the chart of account: ces in the instructions) unt balances in the instructions) Dec 30 E-11 Dividends Adjusting Dec 31 AJE1 Depreciation Expenses - Photograph balances in the instructions) 31, 2018 Dec 31 AJE2 Rent Expenses Dec 31 AJE3 Unearned Revenue Dec 31 AJE4 Photography Supplies Expenses Closing e Dec 31 CE1 Photography Revenue Dec 31 CE2 Income Summary Dec 31 CE3 Income Summary Dec 31 CE4 Retained Earnings Use the area below to show your work and calculations. (*Note: Your instructor may use this area to help review and resolve any incorrect answers) lue) / Useful Life General Journal (journal) Accounts Cash Debit 22,331.00 Common Share Photography Equipment Cash 22,331.00 14,223.00 14,223.00 Prepaid Rent Cash 2,237.00 Cash 1,111.00 2,237.00 Unearned Revenue Cash Credit 1,111.00 2,121.00 Unearned Revenue Photography Supplies Accounts Payable Accounts Receivable Photography Revenue 2,121.00 186.00 186.00 3,189.00 3,189.00 Utitlities Expenses Utility Payable 264.00 Accounts Payable Cash 101.00 Salaries Expenses Cash 724.00 Dividends Cash 852.00 Adjusting entries Depreciation Expenses - Photography Equipment Accumulated Depreciation - Photography Equipment Rent Expenses Prepaid Rent 264.00 101.00 724.00 852.00 395.08 395.08 1,118.50 1,118.50 Unearned Revenue Photography Revenue 2,121.00 Photography Supplies Expenses Photography Supplies 92.00 Closing entires Photography Revenue Income Summary 2,121.00 92.00 5,310.00 5,310.00 Income Summary Salaries Expenses Utilities Expenses Rent Expenses Depreciation Expenses - Phothgraphy Equipment Photography Supplies Expenses 2,593.58 Income Summary Retained Earnings 2,716.42 Retained Earnings Dividends calculations. ny incorrect answers) 724.00 264.00 1,118.50 395.08 92.00 2,716.42 852.00 852.00 Ledger accounts (T-accounts) Date Dec 1 E-1 Dec 1 E-2 Dec 1 E-3 Dec 4 E-4 Dec 9 E-5 Dec 28 E-9 Dec 30 E-10 Dec 30 E-11 Balance Date Dec 15 E-7 Balance Date Dec 1 E-3 Bal Before AE Dec 31 AJE2 Balance Date Dec 12 E-6 Bal Before AE Dec 31 AJE4 Balance Date Dec 1 E-2 Cash Debit 22,331.00 Credit 14,223.00 2,237.00 1,111.00 2,121.00 7,426.00 Date Dec 18 E-8 Credit Date Dec 4 E-4 Dec 9 E-5 Bal Before AE Dec 31 AJE3 Balance Credit 1,118.50 1,118.50 Photography Supplies Debit 186.00 186.00 Date Dec 1 E-1 Credit 94.00 Credit Unearned Revenue Debit 2,121.00 Common Stock Debit Balance 92.00 Photography Equipment Debit 14,223.00 Utilities Payable Debit Balance 3,189.00 Prepaid Rent Debit 2,237.00 2,237.00 101.00 Balance 101.00 724.00 852.00 Accounts Receivable Debit 3,189.00 Date Dec 12 E-6 Dec 28 E-9 Accounts Payable Debit Date Dec 30 E-11 Bal Before CE Dec 31 CE4 Balance Date Dividends Debit 852.00 852.00 0.00 Retained Earnings Debit Balance 14,223.00 Dec 31 CE3 Dec 31 CE4 Balance Accumulated Depreciation, Photography Equipment Date Debit Credit Dec 31 AJE1 395.08 Balance 395.08 Date Dec 15 E-7 Bal Before AE Dec 31 AJE3 Bal Before CE Dec 31 CE1 Balance Date Dec 30 E-10 Bal Before CE Dec 31 CE2 Balance Date Dec 31 CE1 Dec 31 CE2 Dec 31 CE3 Balance Income Summary Debit Credit 5,310.00 2,593.58 2,716.42 0.00 Date Dec 18 E-8 Bal Before CE Dec 31 CE2 Balance Date Dec 31 AJE2 Bal Before CE Dec 31 CE2 Balance 852.00 Photography Revenue Debit 5,310.00 Salaries Expense Debit 724.00 724.00 0.00 Utilities Expense Debit 264.00 264.00 0.00 Rent Expense Debit 1,118.50 1,118.50 0.00 Depreciation Expense, Photography Equipment Date Debit Dec 31 AJE1 395.08 Bal Before CE 395.08 Dec 31 CE2 Balance 0.00 Photography Supplies Expense Date Debit Dec 31 AJE4 92.00 Bal Before CE 92.00 Dec 31 CE2 Balance 0.00 Sepia Photography Unadjusted Trial Balance For Month ended, December 31, 2017 unts Payable Credit 186.00 Accounts Cash Accounts Receivable 85.00 ties Payable Credit 264.00 264.00 ned Revenue Credit 1,111.00 2,121.00 3,232.00 Prepaid Rent Photography Supplies Photography Equipment Accounts Payable Utilities Payable Unearned Revenue Common Stock Dividends Photography Revenue Salaries Expenses Utilities Expenses Total Debit 7,426.00 3,189.00 2,237.00 186.00 14,223.00 852.00 724.00 264.00 29,101.00 Sepia Photography Adjusted Trial Balance For Month ended, December 31, 2017 1,111.00 Accounts mmon Stock Credit 22,331.00 22,331.00 ividends Credit 852.00 ned Earnings Credit Cash Accounts Receivable Prepaid Rent Photography Supplies Photography Equipment Accumulated Depreciation - Photography Equipment Accounts Payable Utilities Payable Unearned Revenue Common Stock Dividends Photography Revenue Salaries Expenses Utilities Expenses Rent Expenses Depreciation Expenses - Photography Equipment Photographt Supplies Expenses Total Debit 7,426.00 3,189.00 1,118.50 94.00 14,223.00 852.00 724.00 264.00 1,118.50 395.08 92.00 29,496.08 2,716.42 1,864.42 Sepia Photography Post-Closing Trial Balance For Month ended, December 31, 2017 raphy Revenue Credit 3,189.00 3,189.00 2,121.00 5,310.00 Accounts 0.00 ies Expense Credit Total 724.00 ties Expense Credit 264.00 nt Expense Credit 1,118.50 se, Photography Equipment Credit 395.08 Debit y Supplies Expense Credit 92.00 17 Sepia Photography Income Statement For Month ended, December 31, 2017 Credit Revenue: 85.00 264.00 3,232.00 22,331.00 3,189.00 Photography Revenue Expenses: Salaries Expenses Utilities Expenses Rent Expenses Depreciation Expenses - Photography Equipment Photographt Supplies Expenses Total Expenses Net Income 5,310.00 724.00 264.00 1,118.50 395.08 92.00 2,593.58 2,716.42 29,101.00 Sepia Photography Statement of Retained Earnings For Month ended, December 31, 2017 17 Credit Retained Earning, December 1, 2017 Add: Net Income for the Month Less: Dividends Retained Earning, December 31, 2017 395.08 85.00 264.00 1,111.00 22,331.00 5,310.00 29,496.08 0.00 2,716.42 -852.00 1,864.42 1,864.42 17 Credit Sepia Photography Balance Sheet December 31, 2017 Assets Current Assets Cash Accounts Receivable Prepaid Rent Photography Supplies Total Current Assets Property, Plant and Equipment Photography Equipment Less: Accumulated Depreciation - Photography Equipme Total Property, Plant and Equipment Total assets 7,426.00 3,189.00 1,118.50 94.00 11,827.50 14,223.00 -395.08 13,827.92 25,655.42 Liabilities Current Liabilities Accounts Payable Utilities Payable Unearned Revenue Total Current Liabilities 85.00 264.00 1,111.00 1,460.00 Stockholders' Equity Common Stock Retained Earnings Total Stockholders' Equity 22,331.00 1,864.42 24,195.42 Total liabilties and stockholders' equity 25,655.42 You must enable macros in order fo Please visit the Microsoft Office Support sit Contact the World Campus Helpdesk s in order for this assignment to function. e Support site for documentation and instructions. us Helpdesk if you continue to have trouble. s. Comprehensive Problem Number 1 Charles Sepia is a photographer who has started his own photography business. Charles has decided Sepia Photography. Charles has hired you to provide accounting services for his company. The transa business along with the information needed to prepare the adjusting entries on December 31, 2018 are The following transaction occurred in December 1. On December 1 our company issued 10,000 shares of common stock to C. Sepia in exchange for c 2. On December 1, we purchased photography equipment for cash. The photography equipment cost: 3. On December 1, we prepaid 2 month's rent for our studio. The amount prepaid is: 4. On December 4, we received a deposit from Kim Jong and Vince Molinaro for their June wedding: 5. On December 9 we received a deposit from Edward Taylor for a late December photo shoot: 6. On December 12 we purchased photgraphy supplies (paper etc.) on account for: 7. On December 15, we performed photography services for a local church and billed the client: 8. On December 18, we received our electric bill (utilities). Payment is due on January 18: 9. On December 28, we paid part of the amount due on account from the December 12 transacation: 10. On December 30, we paid our staff assistant's salary for December. The amount paid is: 11. On December 30, we paid a cash dividend. The amount paid is: Prepare the following adjusting entires 1. The photography equipment was purchased December 1 has an expected useful life is 3 years, the Calculate the depreciation for the month of December. Round amount to two decimal places. 2. Rent expired during December 3. Revenue earned from photo shoot for Edward Taylor. Service was completed late in December 7. Photography Supplies on hand on December 31 totaled: Required: 1. Record the transactions for December 1 through December 31 in the General Jounral using the account name 2. Post the entries to the t-accounts. (please read the note on t-account balances in the instructions) 3. Prepare an unadjusted trial balance on December 31, 2018 4. Record the adjusting entries in the General Journal 5. Post the adjusting entries to the t-accounts (please read the note on t-account balances in the instructions) 6. Prepare an adjusted trial balance on December 31, 2018 7. Record the closing entries on December 31, 2018 in the General journal 8. Post the closing entries to the t-accounts (please read the note on t-account balances in the instructions) 9. Prepare a post closing trial balance on December 31, 2018 10. Prepare an income statement for the month ending December 31, 2018 11. Prepare a statement of retained earnings for the month ending December 31, 2018 12. Preapre a balance sheet as of December 31, 2018 Use the area (*Note: Your instructor 1) 2) Calculation for Deprecyation Cost of Equipment Residual Value Useful Life 14,223.00 0.00 3 Years Dep for the Year Dep for the Year Dep for the Year Dep for 1 Month Dep for 1 Month (Cost - Residual Value) / Useful Life (14,223 - 0)/3 4741 4741 x 1/12 395.08333333 Prepaid Rent Amount Rent Prepaid for 1 Month Rent 1 Month Rent 2237 2 Month (2237 / 2) 1118.5 Rent Expenses 3) Gener blem Number 1 business. Charles has decided to incorporate under the name es for his company. The transactions for the first month in ries on December 31, 2018 are shown below: ed in December k to C. Sepia in exchange for cash : e photography equipment cost: nt prepaid is: linaro for their June wedding: December photo shoot: account for: rch and billed the client: ue on January 18: e December 12 transacation: The amount paid is: ng entires Amount 22,331.00 14,223.00 2,237.00 1,111.00 2,121.00 186.00 3,189.00 264.00 101.00 724.00 852.00 Date Dec 1 E-1 Accou Cash Dec 1 E-2 Photography Equipment Dec 1 E-3 Prepaid Rent Dec 4 E-4 Cash Dec 9 E-5 Cash Dec 12 E-6 Photography Supplies Dec 15 E-7 Accounts Receivable Dec 18 E-8 Utitlities Expenses Dec 28 E-9 Accounts Payable Amount ected useful life is 3 years, the residual value is $0. Student Calc o two decimal places. Student Calc Student Calc mpleted late in December 94.00 Dec 30 E-10 Salaries Expenses al Jounral using the account names listed in the chart of account: ces in the instructions) unt balances in the instructions) Dec 30 E-11 Dividends Adjusting Dec 31 AJE1 Depreciation Expenses - Photograph balances in the instructions) 31, 2018 Dec 31 AJE2 Rent Expenses Dec 31 AJE3 Unearned Revenue Dec 31 AJE4 Photography Supplies Expenses Closing e Dec 31 CE1 Photography Revenue Dec 31 CE2 Income Summary Dec 31 CE3 Income Summary Dec 31 CE4 Retained Earnings Use the area below to show your work and calculations. (*Note: Your instructor may use this area to help review and resolve any incorrect answers) lue) / Useful Life General Journal (journal) Accounts Cash Debit 22,331.00 Common Share Photography Equipment Cash 22,331.00 14,223.00 14,223.00 Prepaid Rent Cash 2,237.00 Cash 1,111.00 2,237.00 Unearned Revenue Cash Credit 1,111.00 2,121.00 Unearned Revenue Photography Supplies Accounts Payable Accounts Receivable Photography Revenue 2,121.00 186.00 186.00 3,189.00 3,189.00 Utitlities Expenses Utility Payable 264.00 Accounts Payable Cash 101.00 Salaries Expenses Cash 724.00 Dividends Cash 852.00 Adjusting entries Depreciation Expenses - Photography Equipment Accumulated Depreciation - Photography Equipment Rent Expenses Prepaid Rent 264.00 101.00 724.00 852.00 395.08 395.08 1,118.50 1,118.50 Unearned Revenue Photography Revenue 2,121.00 Photography Supplies Expenses Photography Supplies 92.00 Closing entires Photography Revenue Income Summary 2,121.00 92.00 5,310.00 5,310.00 Income Summary Salaries Expenses Utilities Expenses Rent Expenses Depreciation Expenses - Phothgraphy Equipment Photography Supplies Expenses 2,593.58 Income Summary Retained Earnings 2,716.42 Retained Earnings Dividends calculations. ny incorrect answers) 724.00 264.00 1,118.50 395.08 92.00 2,716.42 852.00 852.00 Ledger accounts (T-accounts) Date Dec 1 E-1 Dec 1 E-2 Dec 1 E-3 Dec 4 E-4 Dec 9 E-5 Dec 28 E-9 Dec 30 E-10 Dec 30 E-11 Balance Date Dec 15 E-7 Balance Date Dec 1 E-3 Bal Before AE Dec 31 AJE2 Balance Date Dec 12 E-6 Bal Before AE Dec 31 AJE4 Balance Date Dec 1 E-2 Cash Debit 22,331.00 Credit 14,223.00 2,237.00 1,111.00 2,121.00 7,426.00 Date Dec 18 E-8 Credit Date Dec 4 E-4 Dec 9 E-5 Bal Before AE Dec 31 AJE3 Balance Credit 1,118.50 1,118.50 Photography Supplies Debit 186.00 186.00 Date Dec 1 E-1 Credit 94.00 Credit Unearned Revenue Debit 2,121.00 Common Stock Debit Balance 92.00 Photography Equipment Debit 14,223.00 Utilities Payable Debit Balance 3,189.00 Prepaid Rent Debit 2,237.00 2,237.00 101.00 Balance 101.00 724.00 852.00 Accounts Receivable Debit 3,189.00 Date Dec 12 E-6 Dec 28 E-9 Accounts Payable Debit Date Dec 30 E-11 Bal Before CE Dec 31 CE4 Balance Date Dividends Debit 852.00 852.00 0.00 Retained Earnings Debit Balance 14,223.00 Dec 31 CE3 Dec 31 CE4 Balance Accumulated Depreciation, Photography Equipment Date Debit Credit Dec 31 AJE1 395.08 Balance 395.08 Date Dec 15 E-7 Bal Before AE Dec 31 AJE3 Bal Before CE Dec 31 CE1 Balance Date Dec 30 E-10 Bal Before CE Dec 31 CE2 Balance Date Dec 31 CE1 Dec 31 CE2 Dec 31 CE3 Balance Income Summary Debit Credit 5,310.00 2,593.58 2,716.42 0.00 Date Dec 18 E-8 Bal Before CE Dec 31 CE2 Balance Date Dec 31 AJE2 Bal Before CE Dec 31 CE2 Balance 852.00 Photography Revenue Debit 5,310.00 Salaries Expense Debit 724.00 724.00 0.00 Utilities Expense Debit 264.00 264.00 0.00 Rent Expense Debit 1,118.50 1,118.50 0.00 Depreciation Expense, Photography Equipment Date Debit Dec 31 AJE1 395.08 Bal Before CE 395.08 Dec 31 CE2 Balance 0.00 Photography Supplies Expense Date Debit Dec 31 AJE4 92.00 Bal Before CE 92.00 Dec 31 CE2 Balance 0.00 Sepia Photography Unadjusted Trial Balance For Month ended, December 31, 2017 unts Payable Credit 186.00 Accounts Cash Accounts Receivable 85.00 ties Payable Credit 264.00 264.00 ned Revenue Credit 1,111.00 2,121.00 3,232.00 Prepaid Rent Photography Supplies Photography Equipment Accounts Payable Utilities Payable Unearned Revenue Common Stock Dividends Photography Revenue Salaries Expenses Utilities Expenses Total Debit 7,426.00 3,189.00 2,237.00 186.00 14,223.00 852.00 724.00 264.00 29,101.00 Sepia Photography Adjusted Trial Balance For Month ended, December 31, 2017 1,111.00 Accounts mmon Stock Credit 22,331.00 22,331.00 ividends Credit 852.00 ned Earnings Credit Cash Accounts Receivable Prepaid Rent Photography Supplies Photography Equipment Accumulated Depreciation - Photography Equipment Accounts Payable Utilities Payable Unearned Revenue Common Stock Dividends Photography Revenue Salaries Expenses Utilities Expenses Rent Expenses Depreciation Expenses - Photography Equipment Photographt Supplies Expenses Total Debit 7,426.00 3,189.00 1,118.50 94.00 14,223.00 852.00 724.00 264.00 1,118.50 395.08 92.00 29,496.08 2,716.42 1,864.42 Sepia Photography Post-Closing Trial Balance For Month ended, December 31, 2017 raphy Revenue Credit 3,189.00 3,189.00 2,121.00 5,310.00 Accounts 0.00 ies Expense Credit Total 724.00 ties Expense Credit 264.00 nt Expense Credit 1,118.50 se, Photography Equipment Credit 395.08 Debit y Supplies Expense Credit 92.00 17 Sepia Photography Income Statement For Month ended, December 31, 2017 Credit Revenue: 85.00 264.00 3,232.00 22,331.00 3,189.00 Photography Revenue Expenses: Salaries Expenses Utilities Expenses Rent Expenses Depreciation Expenses - Photography Equipment Photographt Supplies Expenses Total Expenses Net Income 5,310.00 724.00 264.00 1,118.50 395.08 92.00 2,593.58 2,716.42 29,101.00 Sepia Photography Statement of Retained Earnings For Month ended, December 31, 2017 17 Credit Retained Earning, December 1, 2017 Add: Net Income for the Month Less: Dividends Retained Earning, December 31, 2017 395.08 85.00 264.00 1,111.00 22,331.00 5,310.00 29,496.08 0.00 2,716.42 -852.00 1,864.42 1,864.42 17 Credit Sepia Photography Balance Sheet December 31, 2017 Assets Current Assets Cash Accounts Receivable Prepaid Rent Photography Supplies Total Current Assets Property, Plant and Equipment Photography Equipment Less: Accumulated Depreciation - Photography Equipme Total Property, Plant and Equipment Total assets 7,426.00 3,189.00 1,118.50 94.00 11,827.50 14,223.00 -395.08 13,827.92 25,655.42 Liabilities Current Liabilities Accounts Payable Utilities Payable Unearned Revenue Total Current Liabilities 85.00 264.00 1,111.00 1,460.00 Stockholders' Equity Common Stock Retained Earnings Total Stockholders' Equity 22,331.00 1,864.42 24,195.42 Total liabilties and stockholders' equity 25,655.42
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started