team hw

Cash Flow Data MT 480 Project

RC 5-15
	MT 480 Unit 3 Case Study Smith Loan Review Data for Teams
	Comparative Balance Sheets and Cash Flow Statement Worksheet
	ASSETS		2017		2016	Did Cash Go Up or Down?
	Cash and marketable securities	$	$ 33,411	$	$ 16,566	$ 16,845
					A/R went down (good or bad for cash?)
	Accounts Receivable	$	260,205	$	318,768	$ 58,563	You collected outstanding Accounts Rec (quickly)
							Explain 2/10 net 30 payment terms.
	Inventory	$	423,819	$	352,740	$ (71,079)	You built up/have more inventory on hand in 2014.
							Explain Economic Order Quantity (EOQ).
	Other current assets	$	41,251	$	29,912	$ (11,339)
	Total Current Assets	$	758,686	$	717,986	$ (40,700)
	Plant Property and Equipment	$	1,512,675	$	1,403,220	$ (109,455)	You bought PP&E in 2017
							explain MACRS
	Goodwill and other assets	$	382,145	$	412,565	$ 30,420
	Total Assets	$	2,653,506	$	2,533,771	(119,735)
	LIABILITIES AND EQUITY
	Accounts Payable	$	378,236	$	332,004	$ 46,232	You owe vendors money but have not paid them yet.
							What is a Mechanics Lien?
	Wages Payable	$	14,487	$	7,862	$ 6,625	What is the Accrual Accounting concept here?
	Accrued income taxes	$	21,125	$	16,815	$ 4,310
	Total Current Liabilities	$	$ 413,848	$	$ 356,681	$ 57,167
	Long-Term Debt: Bank Notes	$	679,981	$	793,515	$ (113,534)	The loan balance went down during 2014.
							Explain collateral and UCC1 forms.
	Total Liabilities	$	1,093,829	$	1,150,196	(56,367)
	Total Common Equity	$	1,559,677	$	1,383,575	176,102
	Total Liabilities and Equity	$	2,653,506	$	2,533,771	119,735
In addition, it was reported that the company had a net income of $3,155,848 and depreciation expenses were equal to $212,366 during 2014.
	Net Income		$3,155,848
	Depreciation		$212,366
	Dividends Paid		-$2,966,412

XYZ Bank told Bob to increase cash to $70,000 from 2016 to 2017. But cash increased from $16,566 in 2016 to just $33,411 in 2017, well short of $70,000. Why?...Question 68 in Unit 1. See link to text and also Seminar in week 1 and 2.

Explain how the six highlighted accounts impacted cash flow from one year to the next. The accounts either added or reduced the cash balance from one year to the next. I.e., the accounts were either a Source or Use of cash.

This one worksheet provides all the data you need to complete the project. You may want to assign each team member a respective "Explain."

Denial Letter Process to Submit List which student did which of the six accounts at the top left of paper. Note any student in your group who did not submit work. Once the denial leter complete, one file will be sent to the instructor via the Compiler: include team name in file label. The graded paper, with rubric, will be returned to Compiler. The Compiler will share final grading with the instructor notes to the team members.

Denial Letter Process to Prepare The arrows present the 2016 to 2017 change in account balance. The Team project focuses on the six highlighted accounts.  These accounts correspond to the denial letter sent to the client. For example, the balance for Accounts Receivable went down by $58,563. A Team member will analyze the significance of that change and present that information and more in the denial letter.

Sheet2

Sheet3