Question: Need help making Income Summary. Using Be Prepared, Inc.s adjusted trial balance and prior periods balance sheet (see pages 5 and 6 of this document),

Need help making Income Summary.

Using Be Prepared, Inc.s adjusted trial balance and prior periods balance sheet (see pages 5 and 6 of this document), prepare the following Financial Reports in good form using Microsoft Excel or Microsoft Word:

Multi-Step Income Statement for the month of January 2016

Need help making Income Summary. Using Be Prepared, Inc.s adjusted trial balanceand prior periods balance sheet (see pages 5 and 6 of thisdocument), prepare the following Financial Reports in good form using Microsoft Excel

Accounting Il Practice set Acc 112-4w1 [compatibility Mode] Search in Documen Insert Design Layout References Mailings Review View t Share Home AaBb Alan BbCcDd Paste No spacing LHeading 1 Heading 2 Title subtitle Subtle Emph Style Pane Be Prepared Adjusted Trial Balance ry 31 2016. Credits Account ID Account Description Debits 001 Cash 687,490.00 vable 3,000.00 1022 Allowance for Doubtful Acc 460.00 027 nterest Receivable 60.00 1031 Notes Receivable 0,000.00 1051 Merchandise Inventory 5,190.00 1101 Store supplies 0,000.00 ffice supple 1125 Prepaid Insurance 2,800.00 Land 414,250.00 Building 400,000.00 1412 Accum Dep: Building 45,750.00 1431 Office Equipment 90,000.00 Dep: offi quipm 7.500.00 1451 one Equipment 125,000.00 1452 Accu Depr: Stor 15,800.00 quipm 69,300.00 2001 Accounts Payable 25,000.00 Payable 7,500.00 interest Payable 4,778.00 2101 Notes Payable long term 200,000.00 2301 B ds Payable 800,000.00 23,500.00 Bonds Payable 3001 Preferred Stoc 400,000.00 3011 C Stock 105,000.00 3101 Paid in Capital In Excessof par Prefer 15.000.00 3111 Paid Capital in Excess of pa r: Com 166.250.00 3121 Pald in Capital Treasury Stock 2,000.00 3300 Retained Eernines 53940.000 3351 Treasury stock 72,000.00. 4001 Sal 139,000.00 4002 Seles Discount 800,00 4000 Sales Returns&Allowance 3,000.00 5001 Cost of Goods 5old 84,560,00. 5010 nsurance Expense Gene 200.00 5012 Repairs Expense: office 2,500.00 Page 4 of 6 721 Words English (US Double-click to Edit Microsoft Excel Worksheet

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!