Spreadsheet Assignment Mastering ExcelRequireda. Enter the following headings for the hori...

Spreadsheet Assignment Mastering Excel

Required

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. jr

(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.

{Note: The amounts on the statement of cash flows can be referenced to the Cash account on the balance sheet. In other words, recording the cash amounts twice is not necessary. Instead enter formulas in the Statement of Cash Flows column equating those cell addresses to the respective cell in the Cash column. Notice that the  formula in cell 06 (statement of cash flows) is set equal to cell B6 (cash on the balance sheet). Once the formula is completed for cell 06, it can be easily copied to cells  07 through Oil.) |

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 Bl. Position the cursor on B1 until a fat cross appears. Click and drag the cursor across B1 through Gl. Click on the Merge and Center icon (it is highlighted in the screen in the toolbar). M

(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 06) until a thin cross appears. Click and drag the cursor down through the desired locations to copy to (through cell 011).

(4) To enter the dollar sign, choose Format, Cells, and Currency.