Enter the following headings for the horizontal statements model onto a blank sp
ID: 2490586 • Letter: E
Question
Enter the following headings for the horizontal statements model onto a blank spreadsheet b. Under the appropriate headings, record the effect of each of the following accounting events for the first month of operation. 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 entire heading in cell B1. Position the cursor on BI 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 011). (4) To enter the dollar sign, choose format, cells, and currency.Explanation / Answer
Cash land liabiltiy common Retained income expense net amount activity Stock Earnings income 6,100 6,100 6,100 Financing -4,000 4000 -4,000 investing 3,000 3,000 3,000 700 700 700 700 700 operating -300 -300 -300 -300 -300 operating -100 -100 -100 financing 5,400 4000 3,000 6,100 300 700 -300 400 5,400
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.