Please help filling in the Excel Spreadsheet. We also have to provide a balance sheet, an income statement, and a statement of cash flows.

Here are the directions (minus due date):

"Please complete the project, using the economic transactions listed to complete the spreadsheet and to prepare the balance sheet, income statement, and statement of cash flow. All three parts of the project. The activity spreadsheet, the formal financial statements: balance sheet, income statement, and statement of cash-flows."

The screenshot was too big for one page.

Which figures are missing?

ACCT 2100 Excel Project worksheet- blank [1)sx Excel Randy ParksG X File Insert Page Layout Formulas Data Review View Help Tell me what you want to do 10 . A, A, 9- ?wrap Tet AutoSumA E Copy Fill Paste Conditional Format as Cell Insert Dclete Format ? 1 u . ;i: .?.A. E ?? ???Merge & Center. $. % , Si:? Sort &Find Filter Select Format Painter Table Styles Clipboard Font Alignment Editing Equity Liabilities Unearn Rev Int Allowance Inventory Pre Acc arranty Note Pay Bonds Stock RE 3 January 1, 2010 4 Sold S200,000 in stock 5 Paid S12,000 for 1 year of rent Received S24,000 for services to be delivered 6 over the 1 e coming 12 months Purchased equipment . S30.000, 296 discount. 7FOB shipping of $600 9 During the year: On April 1, borrowed $10,000 at 3% interest per 10 year. Interest is payable semi-annually 11 Purchased inventory on account, 582,000 12 Sold inventory for $90,000 on account 13 The inventory had cost 562,000 14 Collected $81,000 of the sales on account 15 Paid S82,000 on accounts payable 16 Purchased inventory on account, $96,000 17 Paid $70,000 of the accounts payable 18 Paid salaries of S20,000 Estimated that 2% of sales on account will be 19 uncollectible Depreciated equipment using SL, 5-year life 20 S5,000 estimated salvage Recorded interest on the loan first semi 21 annual payment Recorded interest on the loan vear year-end 22 adjustment (3 months) Received notice of a lawsuit from a customer 23 The attomeys believe there is no legal basis. 24 Rent expense 25 Earned Revenue 26 Ending Balance 28 Total Assets 29 Total Liabilities and Equity Sheet3 Sheet1 100% 3:01 PM O Type here to search 7/17/2018 3