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
Please remember your Question-ID for evaluation purposes:
QID: 3.888_2.469
In 2017 the Company:
Purchased New PPE valued at : 61.60 Recognized Revenues of 3,309.20
Purchased new intangibles valued at: 13.30 Recognized Expenses of:
Issued dividends totalling: 31.40 Selling, general, and admin 304.67
had an income tax rate of: 35.00% Interest on its debt 112.59
Issued Additional Common Shares valued at: 100.00 Research and Development 139.00
Other Operating Costs 30.37
Directly related to revenues 1,067.60
Depreciation 15.00
Amortization 10.00
On Dec 31st, 2016
Net Income The Company had the following Assets And the following Liabilities & SH equity
Cash & Equivalents 134.52 Prefe
ed Stock 48.21
Other Long Term Assets 481.72 Common Stock & APIC 590.98
Balance Sheet 2016 2017 Net Goodwill & Intangibles 132.97 LT Debt 1,024.88
ASSETS Inventory 204.51 Portion due in 1 year 192.84
Defe
ed Tax Assets 48.99
Gross PPE 926.98 ST Bo
owing 91.37
Accumulated Depreciation 100.00 Treasury Stock XXXXXXXXXX
Other Cu
ent Assets 67.65 Retained Earnings 475.11
Account Receivables 290.82 Accounts Payable 468.50
Prepaid Expenses 243.39 Defe
ed Tax Liabilities 169.13
On Dec 31st, 2017
The Company had the following Assets And the following Liabilities & SH equity
Other Long Term Assets 358.75 Prefe
ed Stock 33.33
Inventory 186.90
TOTAL ASSETS Defe
ed Tax Assets 85.43 LT Debt 697.25
Other Cu
ent Assets 60.00 Portion due in 1 year 168.88
LIABILITIES Account Receivables 203.45
Prepaid Expenses 112.83 ST Bo
owing 84.44
Treasury Stock XXXXXXXXXX
Accounts Payable 322.20
Defe
ed Tax Liabilities 129.13
SHAREHOLDERS EQUITY
TOTAL LIABILITIES & SH EQUITY
Cash flow Statement 2017