I need the statement of retained earnings and balance sheet completed based on the worksheet and income statement provided.
AutoSave Off A 2 0 Milestone One - Ex... Search Paul Hudson-Bourdeau - X Comments File Home Insert Page Layout Formulas Data Review View Developer PH Share E 27 J Or Arial 12 A A == = Our ab Help Conditional Formatting v Format as Table Cell Styles Accounting $ % ) Paste LE BIUDA ES 3 Insert Ex Delete - Format v Cells Ideas Clipboard Font Alignment Ey Number Styles Editing Ideas D26 X fix 335675 Hi Credit K M N O P Q R S T U V W X Y Z AA AB AC AD Debit Credit Debit Credit Debit 64,713.72 27.850.00 25.750.00 165.250.00 25,750.00 137,400.00 2,000.00 400.00 17,000.00 2.400.00 17.000.00 1 10,000.00 3.285.72 2,642.86 5,928.58 10,000.00 2.000.00 2.000.00 4,000.00 2,300.00 1.600.00 30.401.00 1,350.00 2.300.00 250.00 30,401.00 10,000.00 1,468.75 27,325.00 Account Cash Baking Supplies Merchandise Inventory (FIFO) Prepaid Rent Prepaid Insurance Baking Equipment Accumulated Depreciation Leasehold Improvements Accumulated Amortization Trademark Office Supplies Account Receivable Notes Payable Interest Payable Accounts Payable Waqon Povable Loans Payable Common Stock Dividends Bakery Sales Merchandise Sales Baking Coat of Goods Sold Rent Expense Interest Expense Insurance Expense Depreciation Expense Amortization Expense Misc. Expense Office Supplies Expense Business License Expense Advertising Expense Wage Expense Telephong Expense Merchandise COGS (FIFO 10,000.00 1,468.75 27,325.00 22,800.00 21,000.00 30,000.00 22,800.00 21,000.00 30,000.00 20,000.00 1335.675.00! 35,200.00 20,000.00 335.675.00 35,200.00 137,400.00 90.000.00 137,400.00 90,000.00 1,468.75 2,000.00 2.642.86 2,000.00 2.780.00 2,000.00 2,642.86 2.000.00 2,780.00 1.350.00 375.00 5.200.00 1,350.00 375.00 5.200.00 22,800.00 3.456.00 15.760.00 3.456.00 15,760.00 Total 464.485.72464.485.72 169.661.61 169.661. 61 493,397.33 493,397.33 . Worksheet Adjusting Entries Income Statement Closing Entries | State ... | 9 0 - + 40% AutoSave Off A 2 0 Milestone One - Ex... Search Paul Hudson-Bourdeau - X Comments File Home Insert Page Layout Formulas Data Review View Developer PH Share E 27 J- Ov -12 A = = 0 ab Arial B I U Help Conditional Formatting Format as Table Cell Styles Insert $X Delete - Format Paste A Accounting $ % ) 40.00 Number Ideas E S Alignment Clipboard Font to Styles Cells Editing Ideas E6 X far C | D E F G H I J K L M LA Peyton Approved Statement of Retained Earnings For Year Ending 12/31/2017 Beginning Balance: plus Net Income less Dividends: Ending Balance: ... Income Statement Closing Entries Statement of Retained Earnings Balar ... + . - - + 100% AutoSave Off A 2 0 Milestone One - Ex... Search Paul Hudson-Bourdeau - X Comments File Home Insert Page Layout Formulas Data Review View Developer PH Share E 27 J Or == = Our ab 35= 9. Help Conditional Formatting Format as Table Cell Styles Calibri 11 A A BI U v Prav A- General $ % ) Insert Ex Delete - Format Paste LE Shop Ideas Clipboard Font Alignment Ey Number Styles Cells Editing Ideas C17 x fx A B C D H I J K L M N O P Q R S T U L A E F G Balance Sheet As of December 31, 2017 Assets Current Assets: Cash Baking Supplies Merchandise Inventory (FIFO) Prepaid Rent Prepaid Insurance Office Supplies Accounts Receivable Total Current Assets Liabilities and Owners' Equity Current Liabilities: Accounts Payable Wages Payable Interest Payable Total Current Liabilities Long Term Liabilities: Notes Payable Loans Payable Total Long Term Liabilities: Total Liabilities: Long Term Fixed Assets: Baking Equipment Accumulated Depreciation Common Stock Retained Earnings Total Equity Leasehold Improvements Accumulated Amortization Trademark Total Assets: Total Liabilities & Equity Closing Entries Statement of Retained Earnings Balance Sheet Financial ... | 5 0 - + 55% AutoSave Off A 2 0 Milestone One - Ex... Search Paul Hudson-Bourdeau - X Comments File Home Insert Page Layout Formulas Data Review View Developer PH Share E 27 J Or 11 == = Our ab Calibri B I U IT A A A v Help Conditional Formatting Format as Table Cell Styles General $ % ) Insert Ex Delete - Format v Paste LE Ideas 2 = = = 6s = a, Clipboard Font Alignment E Number E Styles Cells Editing Ideas F29 X fx E F G H I J K L M N O P Q R S T U V W X 5 D Income Statement For Year Ending 12/312017 $ $ Bakery Sales Merchandise Sales Total Revenues Merchandise Cost of Goods Sold (FIFO) Baking Cost of Goods Sold Gross Profit 335,675.00 35,200.00 370,875.00 (15,760.00) (137,400.00) 217,715.00 Operating Expenses: Rent Expense Interest Expense Insurance Expense Depreciation Expense Amortization Expense Misc. Expense Office Supplies Expense Business License Expense Advertising Expense Wages Expense Telephone Expense Total Operating Expenses: 90,000.00 1,468.75 2,000.00 2,642.86 2,000.00 2,780.00 1,350.00 375.00 5,200.00 22,800.00 3,456.00 134,072.61 Net Income 83,642.39 ... Worksheet Adjusting Entries Income Statement Closing Entries State ... | 0 - + 55%
