Competency in Excel
hardydemarri18
EA2-A1-FinancialStatements-AshantiHardy.xlsxIncome Statement
| Frozen Fractals Corp | ||
| Income Statement | ||
| For the Month Ended December 31,2016 | ||
| Revenue: | ||
| Sales Revenue | $ 41,000 | |
| Rent Revenue | $ 8,500 | |
| Total Revenue | $ 49,500 | |
| Expense: | ||
| Auto Expense | $ 9,400 | |
| Telephone Expense | $ 6,100 | |
| Office Expense | $ 4,000 | |
| Utilities Expense | $ 3,600 | |
| Supplies Expense | $ 2,500 | |
| Total Expense: | $ 25,600 | |
| Net Income | $ 23,900 | |
| Office Expense is Acceptable |
Statement of O.E.
| Frozen Fractals Corp | ||
| Statement of O.E. | ||
| Period Ending 31st of December | ||
| Jacqueline Elise, Capital – 12/1/2016 | $ 73,200 | |
| Net Income | $ 23,900 | |
| $ 97,100 | ||
| Jacqueline Elise, Drawing– 12/1/2016 | $ 3,000 | |
| Jacqueline Elise, Capital – 12/1/2016 | $ 94,100 | |
Balance Sheet
| Frozen Fractals Corp. | ||
| Balance Sheet | ||
| 12/31/16 | ||
| Assets: | ||
| Cash | $ 61,000 | |
| Accounts Receivable | $ 4,100 | |
| Furniture | $ 8,000 | |
| Land | $ 27,000 | |
| Total Assets: | $ 100,100 | |
| Liabilities: | ||
| Accounts Payable | $ 6,000 | |
| Owner's Equity | ||
| William Buffalo, Capital | $ 94,100 | |
| Total Liabilities & Owner's Equity | $ 100,100.00 | |
