Income statement, balance sheet and cash flow. Plz finish this excel and send it back to me....

Question

Income statement, balance sheet and cash flow. Plz finish this excel and send it back to me. Deadline is 23:00 p.m. EST. Thx

Question GO-CASH YOUTH Pre-Modeling Evaluation Income Statement2017Given the following information, complete 2017's income statement and balance sheet, and generate a cashflow statement for 2017 Please link all cells by formula, the balance sheet MUST balance to get a passing grade Revenue Please remember your Question-ID for evaluation purposes: QID:3.888_2.469 In 2017 the Company: Purchased New PPE valued at :61.60Recognized Revenues of 3,309.20 Purchased new intangibles valued at:13.30Recognized Expenses of: Issued dividends totalling: 31.40Selling, general, and admin304.67 had an income tax rate of:35.00%Interest on its debt112.59 Issued Additional Common Shares valued at:100.00Research and Development139.00 Other Operating Costs30.37 Directly related to revenues1,067.60 Depreciation15.00 Amortization10.00 On Dec 31st, 2016 Net IncomeThe Company had the following AssetsAnd the following Liabilities & SH equity Cash & Equivalents134.52Preferred Stock48.21 Other Long Term Assets481.72Common Stock & APIC590.98 Balance Sheet20162017Net Goodwill & Intangibles132.97LT Debt1,024.88 ASSETSInventory204.51Portion due in 1 year192.84 Deferred Tax Assets48.99 Gross PPE926.98ST Borrowing91.37 Accumulated Depreciation100.00Treasury Stock- 436.62 Other Current Assets67.65Retained Earnings475.11 Account Receivables290.82Accounts Payable468.50 Prepaid Expenses243.39Deferred Tax Liabilities169.13 On Dec 31st, 2017 The Company had the following AssetsAnd the following Liabilities & SH equity Other Long Term Assets358.75Preferred Stock33.33 Inventory186.90 TOTAL ASSETSDeferred Tax Assets85.43LT Debt697.25 Other Current Assets60.00Portion due in 1 year168.88 LIABILITIESAccount Receivables203.45 Prepaid Expenses112.83ST Borrowing84.44 Treasury Stock- 304.18 Accounts Payable322.20 Deferred Tax Liabilities129.13 SHAREHOLDERS EQUITY TOTAL LIABILITIES & SH EQUITY Cash flow Statement2017

38882469-zahqsiq2.xlsx

Sumit · Accepted Answer

Question
	GO-CASH YOUTH Pre-Modeling Evaluation
		Income Statement		2017		Given the following information, complete 2017's income statement and balance sheet, and generate a cashflow statement for 2017
						Please link all cells by formula, the balance sheet MUST balance to get a passing grade
		Revenue		3,309.20
	Less:	Selling, general, and admin		304.67		Please remember your Question-ID for evaluation purposes:
		Interest on its debt		112.59		QID:	3.888_2.469
		Research and Development		139.00
		Other Operating Costs		30.37		In 2017 the Company:
		Directly related to revenues		1,067.60		Purchased New PPE valued at :	61.60		Recognized Revenues of 	3,309.20
		Depreciation		15.00		Purchased new intangibles valued at:	13.30		Recognized Expenses of:
		Amortization		10.00		Issued dividends totalling	31.40		Selling, general, and admin	304.67
		EBT		1,629.97		had an income tax rate of:	35.00%		Interest on its debt	112.59
	Less:	Tax Rate		570.49		Issued Additional Common Shares valued at:	100.00		Research and Development	139.00
		Net Income		1,059.48					Other Operating Costs	30.37
	Less:	Dividend paid 		31.40					Directly related to revenues	1,067.60
		Transferred to Surplus		1,028.08					Depreciation	15.00
									Amortization	10.00
						On Dec 31st,

Question GO-CASH YOUTH Pre-Modeling Evaluation Income Statement 2017 Given the following information, complete 2017's income statement and balance sheet, and generate a cashflow statement for 2017...

Answer To: Question GO-CASH YOUTH Pre-Modeling Evaluation Income Statement 2017 Given the following...

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment