C D G Only enter accounts that have a balance Credit Balance Debil $9.380.0 $7.370.00 34.400.00 $1.082.00 $10,800.00 $120.00 $8.182.00 500 Adjusted Trial Balance March 31 Account Account Number Title 111 Cash 115 Accounts Receivable 117 Prepaid Insurance 119 Repair Supplies 144 Repor Equipment 145 Accum Dep-Repar Equipment 212 Accounts Payable 213 Income Tax Payable 214 Interest Payable 220 Dividends Payable 300 Common Stock 301 Additional Pd in Capital 312 Retoined Eminas 313 Treasury Stock 411 Bicycle Repair Revenue 511 Store Rent Expense 512 Telephone Expense 513 insurance ponse 514 Repair Supplies Expense $15Dep Expense - Repair Equipment 516 Income tax expense 517 Bectric Expense 518 France Interest Expense $9.600.00 $30,000.00 $1,100.00 $10.100,00 $2.400.00 $500.00 $400.00 $120.00 $65.00 31.250.00 48.467 3 - Trial Balance 485 Adjusting Entries 6 - Adjusted TB 7. Financial Statements 889- Closing Entries dtv Aw 0 ? MacBook Pro ed $ 4. % 5. & 7 6 Home Insert Draw Layout Formulas Data Heview View Table Tell me % V LIMI Hill Hill Cells Editir Century Gothic (B... v 10 - A A Conditional Formatting 2 Format as Table Paste BIU Av Number Cell Styles H20 XV fx Interest Payable A D G H Requirement #7: Prepare the financial statements for Bethany's Bicycle Corporation as of March 31 in the space below. You will only be preparing the income Statement, Statement of Retained Eaming, and the Balance Sheet The Statement of Cash Rows is a required Financial Statement, but is not required for this project Bethany's Bicycle Corporation Income Statement For the Month Ending March 31 fotony's Bicycle Corporation Statement of Reghed foming For the Month Ending March 31 Retained Coming, March 1 Add: Not income Bethany's cycle Corporation Balance Sheet March 31 Revenues Total Revenue 10 11 Expenses 12 13 14 Les : Dividends Relained Coming, March 31 Cash Accounts Recivable Prepaid arance Repair Supplies Repair Equipment Less: Accum Depr Total Asses + Liables and Stockholders Equity Liebe Accounts Payable nore Pavable Income les Payon Total Liabile Total Deportes Nel income YOU MUST USE THE DICE FUNCIONESUMN ORDER TO DOCUMENT YOUR TOTALS & SUBTOTALS Stockhoon Euty Common Stock Additional Poidin Capital Detained comings Trectory Stock Totol Stockholders' Equity Total lobes Stockholder tuly 3 - Trial Balance 486 Adjusting Entries 6 - Adjusted TB 7 - Financial Statements 369- Closing Entries 10- Post Clos dtv Aw O ? MacBook Pro . EF? ily ) $ 4. % 5 & 7 6 8. 8 9 0