1. Analyze the paragraphs above for evidence of business transactions. As you do so,
prepare an Excel spreadsheet that includes every financial statement account involved
(e.g., cash, accounts receivable, supplies, property & equipment, etc.). Use the
spreadsheet format from Exhibit 2-1 as a model. (Hint: To make sure you enter the
transactions correctly and completely, number the transactions consecutively as you
recognize them.)
2. From the spreadsheet you created in requirement 1, prepare the single step income
statement of Abel Electronics, Inc., using generally accepted accounting principles, for
the three months ended December 31, 2016.
3. From the spreadsheet you created in requirement 1, prepare the statement of
retained earnings of Abel Electronics, Inc. for the three months ended December 31,
2016.
4. From the spreadsheet you created in requirement 1, prepare the balance sheet for
Abel Electronics, Inc., as of December 31, 2016.
5. Analyze the account “cash” that you created in requirement 1, and prepare a
statement of cash flows for Abel Electronics, Inc., for the three months ended
December 31, 2016. Divide the various increases and decreases to the account into
three categories: operating, investing, and financing. Discuss among your team
members what these categories mean. (Challenge)
6. Thoroughly analyze Abel Electronics, Inc.’s creditworthiness for the loan at South
Congress Bank. For this purpose, assume that the term of the loan is 5 years, and that
the principal balance is not due and payable until the end of the term of the loan. Only
interest is payable yearly. Use all of the ratios you have learned so far. Consider not
only Abel’s present position but its position should the loan be granted. If you were a
loan officer for the bank, would you approve Abel’s request for the loan? Why or why
not?