I need to create a transactions worksheet with the information attached.

Accounts payable $27,000

Accounts receivable $ 26,000

Cash $10,000

Inventory $25,000

Notes payable 270,000

Permanently Restricted Net Assets 100,000

Pledges Receivable 350,000

Property, Plant, and equip, net 350,000

Temporarily Restricted net assets 30,000

Unrestricted net assets 302,000

Wages Payable 32,000

PROBLEM 10-17 SOLUTION (Financial Statement) This Worksheet page contains just the Activity Statement. The Statement of Financial Position and the Cash Flow Statement are on separate Worksheets within this file. See tabs at the bottom of this page. ARCH Activity Statement for the Year Ending December 31, Year 2 Revenues and support Donation revenue Sales revenue Total revenues and support $80,000 110,000 $190,000 Expenses: Grant Expense $50,000 Cost of goods sold 58,000 Wage expense Interest expense Bad debts Depreciation 90,000 3,000 2,000 40,000 Total expenses $243,000 Increase/(Decrease) in net assets ($53,000) ARCH Statement of Financial Position as of December 31, Year 2 and Year 1 Assets Liabilities & Net Assets Year 2 Year 1 Year 2 Year 1 Current assets Liabilities Cash $335,000 $10,000 Current liabilities Accounts receivable, net of 36,000 26,000 Accounts payable $87,000 $27,000 estimated uncollectibles of Wages payable 47,000 32,000 $2,000 in Year 2 Total current liab. $134,000 $59,000 Pledges receivable Inventory Total current assets 50,000 350,000 27,000 $25,000 $448,000 $411,000 Long-term liabilities Notes payable 0 $320,000 $270,000 Total long-term liab. $320,000 $270,000 Total liabilities $454,000 $329,000 Long-term assets Fixed assets Buildings & Equip., net Total long-term assets Total assets $325,000 $350,000 $325,000 $350,000 $773,000 $761,000 Net assets Unrestricted $69,000 $302,000 Temp. restricted 110,000 30,000 Perm. restricted 100,000 100,000 Total net assets $279,000 $432,000 Total equities $733,000 $761,000 ARCH Statement of Cash Flows for the Year Ending December 31, Year 2 Cash flows from operating activities Decrease in unrestricted net assets Add expenses not requiring cash: Depreciation Bad Debts Other adjustments: Subtract the increase in accounts receivables Add the decrease in pledges receivable Subtract the increase in inventory Add the increase in wages payable Net cash from operating activities Cash flows from investing activities Purchase of PPE Net cash used in investing activities ($53,000) 40,000 (10,000) 300,000 (2,000) 15,000 $350,000 $25,000 $25,000 Cash flows from financing activities Borrowing with notes Net cash from financing activities ($50,000) ($50,000) Net increase/(decrease) in cash Cash, beginning of year Cash, end of year $325,000 10,000 $335,000