Prompt: Please only solve 9-31 using excel inputs, do not provide raw mathematical calculations Please just provide step by step excel operations I.e. step 1, step 2, step 3, each having excel inputsfor each problem. Separate each problems answers and work. Prompt: Use information from 9-29 and 9-30 to solve 9-31 but do not attempt to solve 9-29 and 9-30 because they are already solved. Problem 9-31:

9-31. Use the ending balances from Problem 9-30 to prepare a balance sheet.

	HELP
Statement of Financial Position
as of the End of the Fiscal Year
	Assets
	Current assets
	Cash
	Accounts receivable
	Supplies
	Total current assets	$0
	Long-term assets
	Furniture
	Total long-term assets	$0
	Total Assets	$0
	Liabilities & Net Assets
	Liabilities
	Short-term liabilities
	Accounts payable
	Wages payable
	Total short-term liabilities	$0
	Total liabilities	$0
	Net assets
	Without donor restrictions
	With donor restrictions
	Total net assets	$0
	Liabilities & Net Assets	$0

Prompt: Please provide a definitive excel answer for each step and show the calculated final answer Prompt: Do not start steps from arbitrary excel cells i.e., A1, B2, A2, A3 inset Xy, Etc. State the inputs for the name of the item on the balance sheet and the equations of items needed to be calculated Prompt: What are the answers to these inputs for the question below Prompt: I repeat DO NOT feed inputs like A1 = cash flow, A2 = Office sign, etc. instead give the values for the inputs and the equations necessary to calculate them with the name of the item. I will put them in their respective cell because my excel sheet has different cell parameters. 9-29. The Hospital for Ending Long-term Problems (HELP) had the following financial events during the year: HELP collected $250,000 in cash that it had billed to the federal government under Medicare. The money had been earned in the prior fiscal year and was recorded as revenue then. HELP paid back $100,000 it borrowed at the end of last year on a line of credit. The bank did not charge interest. HELP bought $25,000 in supplies to treat patients. HELP paid the supplier for all the supplies with cash. HELP belongs to the state hospital association, and its membership is current (meaning it is paid up through the end of the year). HELP receives an invoice for $75,000 for next year's fees but has not paid it yet. HELP replaced many of the patient examination tables. They cost $50,000 and HELP put $10,000 down in cash. The rest is still owed. HELP paid $65,000 it owed employees from last year. Employees had earned this last fiscal year, and it was recorded as an expense then. Show the impact of these transactions on the fundamental equation of accounting. (Optional: Show journal entries using debits and credits. See Appendix 9-A.) 9-30. HELP started the year with the following account balances (shown in alphabetical order): Accounts Receivable

$300,000

Cash

135,000

Accounts Payable

0

Equipment

70,000

Line of Credit

100,000

Net Assets with donor restrictions

217,000

Net Assets without donor restrictions

125,000

Supplies

7,000

Wages Payable

70,000 Excel chart and data with ending balances from 9-29 and 9-30 solved below:

		Assets	=		Liabilities and Net Assets
								Liabilities	Net Assets
										Without	With
	Accounts			Accounts	Wages	Line of	Donor	Donor
Cash	Receivable	Supplies	Equipment	Payable	Payable	Credit	Restrictions	Restrictions
	Beginning Balance	$135,000	$300,000	$7,000	$70,000			$70,000	$100,000	$125,000	$217,000
	Transaction # 1	250000	(250000)
	Transaction # 2	(100000)							($100,000)
	Transaction # 3	(25000)		25000
	Transaction # 4						75000
	Transaction # 5	(10000)			50000		40000
	Transaction # 6	(65000)						(65000)
	Ending Balance	$185,000	$50,000	$32,000	$120,000		$115,000	$5,000	$0	$125,000	$217,000