You are working at finance department of company XYZ. Your manager asks you to prepare the financial reports using the data related to XYZ. Fill in the green cells. (Use excel formulas in your calculations)

	Name - Surname:
		2015	2014		BALANCE SHEET				CASH FLOWS
	Net Sales	189.094.750,00	184.893.187,00		Assets	2015	2014		Cash Flows From Operations
	Accounts Payable	23.154.826,00	20.136.691,00		Current Assets:				Net Income
	Accounts Receivable	77.936.546,00	52.563.783,00		Cash and Marketable Securities	753.729,00	18.092.152,00		Noncash expenses
	Administrative Expenses	79.314.088,00	62.865.506,00						Depriciation and Amortization
	Cost of Goods Sold	96.859.099,00	99.733.745,00						Changes in working capital
	Depreciation	16.014.314,00	15.638.590,00						Decrease in accounts receivable
	Dividends Paid	0,00	0,00		Total Current Assets				Decrease in inventories
	Interest Expense	2.650.827,00	8.101.383,00						Decrease in other assets
	Inventories	25.966.347,00	16.250.062,00		Fixed Assets:				Increase in accounts payable
	Other Current Assets	1.255.006,00	1.148.563,00		Net Fixed Assets				Addition to (reduction in) short-term notes payable
	Short-term Debt	16.501.871,00	0,00						Increase in other current liabilities
	Other current liabilites	67.073.748,00	51.136.627,00		Intangible Assets (goodwill)	1.333.624,00	764.941,00		Cash Flows From Operations
	Long-term debt	4.065.016,00	3.197.259,00		Long-term Investment	4.310.153,00	304.971,00		Cash Flows From Investments
	Total Tax	0,00	0,00						Cash provided by (used for) disposal of (additions to) property, plant, & equipment
	INCOME STATEMENT				Total Assets				Sales of other investments
		2015	2014						Change in intangible
					Liabilities & Shareholders Equity				Cash Flows From Investments
					Current Liabilities:				Cash Provided by Financial Acts
									Addition to (reduction in) long-term debt
									Dividends paid
					Total Current Liabilities				Net issues (repurchases) of stocks
									Cash Provided by (Used for) Financing Acts
	Net Income								NET INCREASE (DECREASE) IN CASH AND CASH EQUIVALENTS	0,00
					Other long-term liabilities	0,00	0,00
	Dividends Paid
	Addition to Retained Earnings				Total Liabilities
					Common stock and other paid-in capital	590.554.165,00	590.554.165,00
					Retained earnings		476.789.029,00
					Treasury stock	0,00	0,00
					Total Shareholders Equity	590.554.165,00	113.765.136,00
					Total Liabilities and Shareholders Equity	590.554.165,00	113.765.136,00

EXERCISE 1 You are working at tinance department of company ABC. Your manager asks you to prepare the tinancial reports using the data related to ABC. Fill in the green cells. (Use excel formulas in your calculations) Name Surname: DALANCE SHEET CASH FLOws Flows From Operations Income 189 084 750,00 23 154 826,00 77.936.545,00 79.314.088,00 96.859.099,00 16.014.314,00 184 893.187 Accounts Payable Accounts Receivable Current Assets: Cash and Marketable Securities 20.136691 52 563.783 62 865.505 99.733.745 15.638.5 729,00 180Noncosh expenses De?r?c?tion and Amortization in woking capital Cost of Goods Sold Depreciation Dividends Paid Interest Expense 0,00 Total Current Assets Decrease in inventories Decrease in other assets Incresse in accounts payable Addition to (reduction in) short-term notes payable Increase in other current liabilities 8101.383 2.550.827,00 25.966.347,00 1.255.00,00 16.501.871,00 67 073 748,0D 4065.016,00 Fixed Assets Net Fixed Assets Other Current Assets Short-term Debt Other current liabilites Long-term debt Total T 51 136 627 3.197.259 Intangible Assets lgoodwill) Lone-term Investment 1.333,624,00764 941 4.310.153,00 804971.00 h rlows From Operatlons Cash Flows From investments provided by lused for) disposel of ditions to) property, plant, & equipment les of other investments INCOME STATEMENT Total Assets in intangible Flows From Investments s & shareholders Equity t Liabilities: Addition to (reduction in) lonc-term debt peid Total Current Liabiities ssues (repurchases) of stocks Provided by (Used for) Financing Acts Net Income INCREASE (DECREASE) IN CASH AND CASH Other long-term liabilities Dividends Paid Adcition to Retained Earnl Common stock and other paid-in capital Retained earnings 590.554.165,00 590.554 165 476.789.029 0,00 shareholders Equity Total Liabiities and Shareholders E 590.554.165 113.765.136 EXERCISE 1 You are working at tinance department of company ABC. Your manager asks you to prepare the tinancial reports using the data related to ABC. Fill in the green cells. (Use excel formulas in your calculations) Name Surname: DALANCE SHEET CASH FLOws Flows From Operations Income 189 084 750,00 23 154 826,00 77.936.545,00 79.314.088,00 96.859.099,00 16.014.314,00 184 893.187 Accounts Payable Accounts Receivable Current Assets: Cash and Marketable Securities 20.136691 52 563.783 62 865.505 99.733.745 15.638.5 729,00 180Noncosh expenses De?r?c?tion and Amortization in woking capital Cost of Goods Sold Depreciation Dividends Paid Interest Expense 0,00 Total Current Assets Decrease in inventories Decrease in other assets Incresse in accounts payable Addition to (reduction in) short-term notes payable Increase in other current liabilities 8101.383 2.550.827,00 25.966.347,00 1.255.00,00 16.501.871,00 67 073 748,0D 4065.016,00 Fixed Assets Net Fixed Assets Other Current Assets Short-term Debt Other current liabilites Long-term debt Total T 51 136 627 3.197.259 Intangible Assets lgoodwill) Lone-term Investment 1.333,624,00764 941 4.310.153,00 804971.00 h rlows From Operatlons Cash Flows From investments provided by lused for) disposel of ditions to) property, plant, & equipment les of other investments INCOME STATEMENT Total Assets in intangible Flows From Investments s & shareholders Equity t Liabilities: Addition to (reduction in) lonc-term debt peid Total Current Liabiities ssues (repurchases) of stocks Provided by (Used for) Financing Acts Net Income INCREASE (DECREASE) IN CASH AND CASH Other long-term liabilities Dividends Paid Adcition to Retained Earnl Common stock and other paid-in capital Retained earnings 590.554.165,00 590.554 165 476.789.029 0,00 shareholders Equity Total Liabiities and Shareholders E 590.554.165 113.765.136