Mantooth Manufacturing Company experienced the following accounting events during its first year of operation. With the exception of the adjusting entries for depreciation, assume that all transactions are cash transactions.
1. Acquired $50,000 by issuing common stock.
2. Paid $8,000 for the materials used to make its products, all of which were started and completed during the year.
3. Paid salaries of $4,400 to selling and administrative employees.
4. Paid wages of $7,000 to production workers.
5. Paid $9,600 for furniture used in selling and administrative offices. The furniture was acquired on January
1. It had a $1,600 estimated salvage value and a four-year useful life.
6. Paid $13,000 for manufacturing equipment. The equipment was acquired on January
1. It had a $1,000 estimated salvage value and a three-year useful life.
7. Sold inventory to customers for $25,000 that had cost $14,000 to make. Construct a spreadsheet of the financial statements model as shown here:

Required
Place formulas in row 16 to automatically add the columns. Also add formulas in column S to calculate net income after each event, and add formulas in row 18 to compute total assets and equity. Notice that you must enter the events since only the first one is shown as an example. Spreadsheet Tips
1. The column widths are set by choosing Format, then Column, and then Width.
2. The shading in columns B, N, and T is added by highlighting a column and choosing Format, then Cells, and then clicking on the tab titled Patterns and choosing a color.
3. The sum function is an easy way to add a column or row. For example, the formula in cell C16 is 5SUM(C6:C15).
4. As an example of the formulas in column S (net income), the formula in cell S7 is 5O72Q7.
5. If you find that some of the columns are too far to the right to appear on your screen, you can set the zoom level to show the entire spreadsheet. The zoom is set by choosing View, then Zoom, and then clicking on Custom and typing 100 percent in the box. The shortcut method to set the zoom is to click in the box on the right side of the top tool bar that appears immediately below the menu.

Transcribed Image Text:

WI F] 1 Chapter 1- Mastering Excel к R Name Equty Retained Assets Manuf. + Inventory+ Equip 4 Event No. 6. Office Common Net + Earnings Revenue - Expenses = Income Cash $50,000 Furn. Stock $50,000 8. 11 Dep. 12 13 Dep. 14 7. 15 16 Totals $50,000 $50,000 17 18 $50,000 Total Assets Total Equity $50,000 19 0123 4S67 o