a. Enter the following headings for the horizontal statements model onto a blank spreadsheet.
b. Under the appropriate headings, record the effects of each of the following accounting events for the first month of operations. The first event has been recorded as an example.
(1) Acquired $6,100 from the issue of common stock.
(2) Paid $4,400 to purchase land.
(3) Borrowed $3,000 cash.
(4) Provided services to customers and received $700 in cash.
(5) Paid $300 for expenses.
(6) Paid a $100 dividend to the stockholders.
c. Using formulas, sum each of the quantitative columns to arrive at the end-of-month amounts reported on the financial statements.
Spreadsheet Tips
(1) Center the heading Balance Sheet across columns by entering the entire heading in cell B1. Position the cursor on B1 until a fat cross appears. Click and drag the cursor across B1 through G1. Click on the Merge and Center icon (it is highlighted in the screen in the toolbar).
(2) Enter arithmetic signs as headings by placing an apostrophe in front of the sign. For example, to enter the equal sign in cell D4, enter ‘=.
(3) Copy cells by positioning the cursor in the bottom right corner of the cell to copy from (such as cell O6) until a thin cross appears. Click and drag the cursor down through the desired locations to copy to (through cell O11).
(4) To enter the dollar sign, choose Format, Cells, and Currency.

  • CreatedOctober 26, 2013
  • Files Included
Post your question