Prepare a multi-step income statement, a statement of retained earnings, and a classified balance sheet at the end of each day (November 15th, 16th, 17th) using accrual accounting. Treat each day as a separate accounting period-as if each day is a year. Make sure to report current and non-current in regard to assets and liabilities when developing these statements. On Friday Greta took $1,000 out of her personal savings to fund the venture.
1.
Income Statement | |||
Nov 15 | Nov 16 | Nov 17 | |
Sales | $ 2,835 | $ 7,000 | $ 6,055 |
Cost of Goods Sold | 1,863 | 4,600 | 3,979 |
Gross Profit | 972 | 2,400 | 2,076 |
Operating Expenses | |||
Booth Fee Expense | 480 | - | |
Salaries Expense | 150 | 150 | 350 |
Inventory Loss | - | 437 | - |
Total Operating Expenses | 630 | 587 | 350 |
Net Income | $ 342 | $ 1,813 | $ 1,726 |
2.
Statement of Retained Earnings | |||
Nov 15 | Nov 16 | Nov 17 | |
Beginning balance | $ 0 | $ 342 | $ 2,155 |
Net Income | 342 | 1,813 | 1,726 |
Ending balance | $ 342 | $ 2,155 | $ 3,881 |
3.
Balance Sheet | |||
Nov 15 | Nov 16 | Nov 17 | |
Assets | |||
Cash | $ 3,845 | $ 9,620 | $ 4,881 |
Accounts Receivable | 0 | 1,225 | 0 |
Inventory | 897 | 1,150 | 0 |
Clean Up Fee Deposit | 140 | 140 | 0 |
Total Assets | $ 4,882 | $ 12,135 | $ 4,881 |
Liabilities and Equity | |||
Accounts Payable | 2,760 | 8,050 | 0 |
Salaries Payable | 150 | 300 | 0 |
Unearned Revenue | 630 | 630 | 0 |
Greta, Capital | 1,000 | 1,000 | 1,000 |
Retained Earnings | 342 | 2,155 | 3,881 |
Total Liabilities and Equity | $ 4,882 | $ 12,135 | $ 4,881 |
Prepare a multi-step income statement, a statement of retained earnings, and a classified balance sheet at...
BA211 – Financial Accounting Project: Valentine’s Day Chocolate Prelude, January 14th: Cupid and his family, as is their regular routine, visit the local farmers’ market on their weekly shopping trip. Deborah, a local candy-producer and friend of Cupid’s family, is selling her candy at the market. Cupid tells Deborah how much he likes her candy. Deborah knows that Cupid is a budding entrepreneur and asks if he will try selling her boxed Valentine’s chocolates at the Food & Gift Festival...
Stacy and her family visit the local weekend farmers' market on their weekly shopping trip. Deborah, a local candy-producer and friend of Stacy's family, sells her candy at a booth at the market during December and February, to meet demand for the holidays and Valentine's Day. Deborah no longer wants to work weekends but wants to continue to maintain interest in her product among farmers' market customers. Deborah knows that Stacy is a budding entrepreneur and asks if she would...
Conduct a multi step income statement, statement of retained earnings, and classified balance sheet for the following Adjusted Trial Balance December 31, 2017 DEBIT 8,000 4,005 CREDIT 500 1001 80 22.000 150 4,000 1,800 4001 Cash Accounts Receivable Allowance for Doubtful Accounts Short term Note Receivable Interest Receivable Supplies Inventory Prepaid Expenses Equipment Accumulated Depreciation Copyrights Accounts Payable Interest Payable Unearned Revenue Long Term Note Payable Common Stock Paid-in-Capital In Excess of Par - CS Retained Earnings (1/1/17) Dividends Sales...
Prepare a Trial Balance, Multi Step Income Statement, Retained Earnings Statement, and Classified Balance Sheet the values needed are all the way on the left in the photo. i started the trial balance (the green chart) but could not get both sides to equal. ACCT 251 EXCEL ASSIGNMENT - PREPARING FINANCIAL STATEMENTS IN EXCEL (see instructions tab for detailed instructions) Prepare a multi-step income statement: Prepare a retained earnings statement: Prepare a classified balance sheet: 1,001,360 101,360 591,680 Service Revenue...
Prepare a trial balance, multi-step income statement, statement of retained earnings, and classified balance sheet for Porter Company as of December 31, 2017 using the information on the preceeding tab. THERE ARE EXACTLY ENOUGH HIGHLIGHTED LINES FOR EACH ONE 1ACCT 251 EXCEL ASSIGNMENT PREPARING FINANCIAL STATEMENTS IN EXCEL Prepare a trial balance, multi-step income statement, statement of retained earnings, and classified balance sheet for Porter Company as of December 31, 2017 using the information on the preceeding tab. Working together...
Chapter 14, Problem 1CPP Only need help with 5 - 8. I have 1 - 4 answered. thank you, The Tusquittee Company is a retail company that began operations on October 1, 2018, when it incorporated in the state of North Carolina. The Tusquittee Company is authorized to issue 100,000 shares of $1 par value common stock and 50,000 shares of 5%, $50 par value preferred stock. The company sells a product that includes a one-year warranty and records estimated...
Part Five Instructions Prepare an Adjusted Trial Balance, then an Income Statement, Statement of Retained Earnings and a Balance Sheet and staple them to the inside front cover of the practice set in the correct order as listed here. These statements should be done in Word or Excel. Transactions Deposit No. / Check No. Date Description 1. April Morales met with her lawyer and CPA for advice on starting the business. They decided that Ms. Morales would organize the business...
i just need help on #4. preparing income statement, retained earnings statement, and the balance sheet. Accounting Cycle Project (Group) ACCT3303 Spring 2020 Assignments Required: 1) Making journal entries for each transaction in chronological order. 2) Posting to the general ledger and prepare trial balance before adjustment 3) Making adjusting entries and prepare adjusted trial balance. 4) Prepare Income Statement, Retained Earnings Statement, and Balance Sheet 5) Making closing entries 6) Put all your work on excel spreadsheet. Each group...