For YOU

hs240_unit2_template_3.xlsx

Instructions

Instructions
Part 1 of the Unit 2 Assignment consists of completing three key financial statement templates: the Balance Sheet, Operating Statement and Statement of Cash Flow. These three financial statements are located in this Excel Spreadsheet. You can view each template by click on the tabs at the bottom of the spreadsheet. Below you will find an example of a completed balance sheet. Use this as a reference when completing the templates.
Navigate to each template by clicking the appropriate tab at the bottom of the spreadsheet.
		Keepuwell Clinic
		Balance Sheet
		As of December 31, 20XX
			LIABILITIES &
	ASSETS		NET ASSETS
			Liabilities
	Current Assets	$ 1,000.00	Current liabilities	$ 1,000.00
			Long-term liabilities	$ 2,000.00
	Fixed Assets	$ 2,000.00	Total Liabilities	$ 3,000.00
			Net Assets
	Investments	$ 3,000.00	Unrestricted	$ 1,000.00
			Temporarily Restricted	$ 2,000.00
	Intangibles	$ 4,000.00	Permanently Restricted	$ 4,000.00
			Total Net Assets	$ 7,000.00
			TOTAL LIABILITIES &
	TOTAL ASSETS	$ 10,000.00	NET ASSETS	$ 10,000.00

Template 1
Balance Sheet (Simple Example)
See Chapter 5 for a discussion of this topic.
Instructions: Below is a simple example of a Balance Sheet. You may change the name of the company in the heading to your company, change the date, and replace the xxx's with your values. (Complete the highlighted areas.) The totals will be calculated automatically.
		Keepuwell Clinic
		Balance Sheet
		As of December 31, 20XX
			LIABILITIES &
	ASSETS		NET ASSETS
			Liabilities
	Current Assets	xxx	Current liabilities	xxx
			Long-term liabilities	xxx
	Fixed Assets	xxx	Total Liabilities	$0
			Net Assets
	Investments	xxx	Unrestricted	xxx
			Temporarily Restricted	xxx
	Intangibles	xxx	Permanently Restricted	xxx
			Total Net Assets	$0
			TOTAL LIABILITIES &
	TOTAL ASSETS	$ - 0	NET ASSETS	$0

Template 2
Operating Statement (Simple Example)
See Chapter 5 for a discussion of this topic.
Below is a simple example of an Operating Statement. You may change the name of the company in the
heading to your company, change the date, and replace the xxx's with your values. The total will
be calculated automatically.
	Keepuwell Clinic
	Operating Statement
	For the Year Ending December 31, 20XX
	Revenues	xxx
	Less Expenses	xxx
	NET INCOME	ERROR:#VALUE!

Template 3
Cash Flow Statement (Simple Example)
See Chapter 5 for a discussion of this topic.
Below is a simple example of a Statement of Cash Flows. You may
change the name of the company in the heading to your company, change the date,
and replace the xxx's with your values. The totals will be calculated automatically.
	Keepuwell Clinic
	Statement of Cash Flows
	For the Year Ending December 31, 20XX
	Cash Flows from Operating Activities
	Collections	xxx
	Payments to Suppliers	xxx
	Payments to Employees	xxx
	Other	xxx
	Net Cash from Operating Activities	$ - 0
	Cash Flows from Investing Activities
	Purchase of New Equipment	xxx
	Other	xxx
	Net Cash Used for Investing Activities	$ - 0

	Cash Flows from Financing Activities
	Borrowing from Creditors	xxx
	Debt Payment	xxx
	Other	xxx
	Net Cash from Financing Activities	$ - 0
	NET INCREASE/(DECREASE) IN CASH	$ - 0
	CASH, BEGINNING OF YEAR	xxx
	CASH, END OF YEAR	ERROR:#VALUE!