Using the Assumptions provided below for the UWP Corporation, complete their Cash Flows Statement for the period ending December 31, 2020 Note: For this Financial Statement, you will need to

1). select the correct Cash Flow from the list below and place it under the correct cash flow sub-heading in column B. Multiples may apply.

2). Place the adjacent cash flow amount ($$) in the tally field (column D). HINT! Amounts are already correct for each item

3). Create the Excel formula that calculates the totals in the Blue/Gray Cells

4). All assumptions should be used

	Assumptions (Balance Sheet):
	35,000	Accounts Payable
	15,000	Accounts Receivables
	30,000	Acquistion Premium
	100,000	Building Annex, Furniture
	35,000	Building Loan
	5,000	Cash-on-hand
	10,000	Commercial Paper
	10,000	Current week - Invoiced
	30,000	Government Grants
	50,000	RE
	5,000	Income Tax
	20,000	Intellectual Property trademarks
	15,000	Interest payable - outstanding debt
	10,000	Licensing Fees
	30,000	Machinery, Computors
	3,000	Marketable Securities
	15,000	Net Surplus (upward)
	100,000	Proceeds from Common Stock sale
	12,000	E-books, Manuscripts for sale

Please create balance sheet