.nl T-Mobile LTE 2:27 PM @ 42%. Done Accounting Cycle Case Study - Pr... l T-Mobile LTE 2:27 PM @ 42%. Done Accounting Cycle Case Study - Pr.. General Journal Adjustments Gen reston H Bed &Breakfest l T-Mobile LTE 2:27 PM @ 42%. Done Accounting Cycle Case Study - Pr.. General Journal Adjustments Gen Apri pri 15 April 30 l T-Mobile LTE 2:33 PM @ 38% Done Accounting Cycle Case Study - Pr.. General Journal Adjustments Gen Apri pri 15 April 30 Instructions Account Preston Hill Bed & Breakfast Chart of Accounts count mber Account Assets 1 Cash 5 Accounts Receivable Office Supplies Prepaid Rent 5 Prepaid Insurance 0 Furniture 5 Accumulated Depreciation Van Liabilities Accounts Payable 3 8 Deferred Room Rental Revenue Notes Payable Stockholders' Equity Common Stock 0 Retained Eamings Revenue 1 Room Rental Revenue Administrative Fee Revenue Expenses 5 Advertising 5 Dues 0 Interest Expense Depreciation Expense Food Expense 5 nsurance Expense Office Supplies Printing expense 5 Postage Licenses and fees 0 Telephone 5 Rent Expense Utilities 0 Wage Expense Uniforms 5 0 Dividends Income Summary ll T-Mobile LTE 2:34 PM Done Accounting Cycle Case Study - Pr This case study must be completed in Excel or other spreadsheet program using the formats provided in this workbook Objectives Practice the steps involved in the Accounting Practice electronic spreadsheet skills b. Linking worksheets a. Formulas ctice using data visualization to share results Instructions 1. Using the Chart of Accounts record ho transactions i the Generai Sounal Do not add new accounts Post the General Journal entries to the General Ledger 3. Prepare the Unadjusted Trial Balance in the Trial Balance tab e any adjusting entries in the General Journal and post in the General Ledger Show your calcuations for the adustments in the Adustments tab the Adjusted Trial Balance in the Trial Balances tab. Also include the Income Joumalize and Balance Sheet on the Trial Balance Worksheet Prepare the Income Statement, Statement of Shareholders' Equity, and Sheet for the month of April 2018 in the appropriate tabs. ignore the effects of income tax Prepare an appropriate data visualization of financial results (either income statement or balance sheet) 8.Close the temporary accounts and record the closing entries in the General Journal. Post the closing entries in the General Ledger 9. Note the following additional information: iness began on April 1.2018 2. The penod under consideration is the month 2018 3. For the purposes of this assignment, ignare the efects of income tax, propenty tax. sales tax, and payroll tax. 4.Straightine depreciation method s use 5. The supplies on hand Apri 30, 2018 were $325. 6. The telephone bill for April 2018 for $305 was receive May 2018 7. The utlity bill for 8. For 10 was received the purposes of this assignment, consider the note payable to be a current assignment ..il T-Mobile LTE 2:34 PM Done Accounting Cycle Ca Instructions AccountsTransactions General Journal Adjustments Preston HIll Bed and Breakfast General Journal -Month of April 2018 Date Description PR Debit Credit structions Accounts Transactions General Journal Adjustments General Ledger Trial Balance Income St Preston Hil Bed& Breakfast the Month Ended April 30, Unadjusted Trial Balance Sheet Closing Adjustments Trial Bala Credt Credit C Debit Credt Debit Ce Receivable Suppies Prepaid Rent Prepaid Insurance Secunity Deposts Accounts Payable Deterred Room Rental Revenue Notes Payable Retained Eamings oom Rental Revenue Depreciation Expense Dues Expense interest E, pense Insurance Expense Pinting Expense Office Supples Rent Expense taties Wage Expense Income Summary income (Los) Totals Instructions Accounts Transactions Preston Hill Bed & Breakfast Balance Sheet Assets Liabilities and Stockholders' Equity l T-Mobile LTE 2:33 PM @ 38% Done Accounting Cycle Case Study - Pr.. General Journal Adjustments Gen Apri pri 15 April 30 .nl T-Mobile LTE 2:27 PM @ 42%. Done Accounting Cycle Case Study - Pr... l T-Mobile LTE 2:27 PM @ 42%. Done Accounting Cycle Case Study - Pr.. General Journal Adjustments Gen reston H Bed &Breakfest l T-Mobile LTE 2:27 PM @ 42%. Done Accounting Cycle Case Study - Pr.. General Journal Adjustments Gen Apri pri 15 April 30 l T-Mobile LTE 2:33 PM @ 38% Done Accounting Cycle Case Study - Pr.. General Journal Adjustments Gen Apri pri 15 April 30 Instructions Account Preston Hill Bed & Breakfast Chart of Accounts count mber Account Assets 1 Cash 5 Accounts Receivable Office Supplies Prepaid Rent 5 Prepaid Insurance 0 Furniture 5 Accumulated Depreciation Van Liabilities Accounts Payable 3 8 Deferred Room Rental Revenue Notes Payable Stockholders' Equity Common Stock 0 Retained Eamings Revenue 1 Room Rental Revenue Administrative Fee Revenue Expenses 5 Advertising 5 Dues 0 Interest Expense Depreciation Expense Food Expense 5 nsurance Expense Office Supplies Printing expense 5 Postage Licenses and fees 0 Telephone 5 Rent Expense Utilities 0 Wage Expense Uniforms 5 0 Dividends Income Summary ll T-Mobile LTE 2:34 PM Done Accounting Cycle Case Study - Pr This case study must be completed in Excel or other spreadsheet program using the formats provided in this workbook Objectives Practice the steps involved in the Accounting Practice electronic spreadsheet skills b. Linking worksheets a. Formulas ctice using data visualization to share results Instructions 1. Using the Chart of Accounts record ho transactions i the Generai Sounal Do not add new accounts Post the General Journal entries to the General Ledger 3. Prepare the Unadjusted Trial Balance in the Trial Balance tab e any adjusting entries in the General Journal and post in the General Ledger Show your calcuations for the adustments in the Adustments tab the Adjusted Trial Balance in the Trial Balances tab. Also include the Income Joumalize and Balance Sheet on the Trial Balance Worksheet Prepare the Income Statement, Statement of Shareholders' Equity, and Sheet for the month of April 2018 in the appropriate tabs. ignore the effects of income tax Prepare an appropriate data visualization of financial results (either income statement or balance sheet) 8.Close the temporary accounts and record the closing entries in the General Journal. Post the closing entries in the General Ledger 9. Note the following additional information: iness began on April 1.2018 2. The penod under consideration is the month 2018 3. For the purposes of this assignment, ignare the efects of income tax, propenty tax. sales tax, and payroll tax. 4.Straightine depreciation method s use 5. The supplies on hand Apri 30, 2018 were $325. 6. The telephone bill for April 2018 for $305 was receive May 2018 7. The utlity bill for 8. For 10 was received the purposes of this assignment, consider the note payable to be a current assignment ..il T-Mobile LTE 2:34 PM Done Accounting Cycle Ca Instructions AccountsTransactions General Journal Adjustments Preston HIll Bed and Breakfast General Journal -Month of April 2018 Date Description PR Debit Credit structions Accounts Transactions General Journal Adjustments General Ledger Trial Balance Income St Preston Hil Bed& Breakfast the Month Ended April 30, Unadjusted Trial Balance Sheet Closing Adjustments Trial Bala Credt Credit C Debit Credt Debit Ce Receivable Suppies Prepaid Rent Prepaid Insurance Secunity Deposts Accounts Payable Deterred Room Rental Revenue Notes Payable Retained Eamings oom Rental Revenue Depreciation Expense Dues Expense interest E, pense Insurance Expense Pinting Expense Office Supples Rent Expense taties Wage Expense Income Summary income (Los) Totals Instructions Accounts Transactions Preston Hill Bed & Breakfast Balance Sheet Assets Liabilities and Stockholders' Equity l T-Mobile LTE 2:33 PM @ 38% Done Accounting Cycle Case Study - Pr.. General Journal Adjustments Gen Apri pri 15 April 30