Exotic Adventures, a chain of stores servicing the ecotourism industry, has provided you with the following list of accounts and balances for the year ended June 30, 2012. Amounts shown are in thousands of dollars. You have been asked by the company's chief financial officer (CFO) to use a spreadsheet to prepare financial statements for Exotic Adventures, including an income statement, a statement of retained earrings, a classified balance sheet, and a statement of cash flows. The CFO can't remember the accounts receivable balance. She asks you to figure it out when you prepare the balance sheet
The financial information presented here is accumulated in a file named FINANCIAL on the website for this book at cengagebraincom You are encouraged to use this file for preparing your statements and to use the information In this file as a Data section for your answer. Place the statements in the space below the data. The financial statements should be shown in thousands of dollars just as in the Data Section Exotic Adventures is a privately held company, so earrings per !share Information is not required.

Additional information required for the statement of cash flows:
€¢ Exotic Adventures sold a large amount of obsolete and worn-out fixtures for $128.8. The fixtures originally cost $248.0 and had been depreciated down to a net book value of $20.0.
€¢ Additional common stock, 24,000 shares, was issued for $76,000 in July. The par value of the stock is $2 per share.
€¢ Write off of goodwill and amortization of copyrights is included in other operating expenses.
€¢ No bonds were retired during the year. No additional notes payable were issued during the year.
€¢ Short-term investments of 5220.0 were made during the year. Exotic Adventures also sold $e
€¢ 2 short-term investments at no gain or loss. Review the Model-Building Problem Checklist on page 154 to ensure that your model is complete. When done, preview the printout to make sure that the worksheet will print neatly, and then print the worksheet Check figure:
Total assets, $3,385.2 To test your model, suppose the auditors made the following three adjustments to the June 30, 2012, balances: sales were reduced by $100,000 to 9.073.2: inventories were increased by $60,000 to 750.2: and accounts payable were increased by $160.000 to 924.8. Record these adjustments to your model. Does your balance sheet still balance? Print the worksheet again. Check figure: Total assets, $3,445.2
CHART (optional)
Using the test data worksheet, create a pie chart showing all major sources of funding for Exotic Adventures at year-end: current liabilities, long-term liabilities, and stockholders' equity.

Transcribed Image Text:

Years Ended June 30 2012 $764.8 2011 $771.8 315.8 473.6 729.0 25.8 256.0 12.6 30.0 516.6 1,166.4 98.8 422.4 22.4 6,488.0 204.0 Accounts payable (for inventory purchases) Accounts receivable Accumulated depreciation-building Accumulated depreciation-fixtures Advances from customers Advertising expense Allowance for bad debts Bad debt expense Bonds payable (due 9/1/13) Buildings Cash Common stock Copyrights Cost of goods sold Depreciation expense Discontinued operations loss (net of tax) Dividends declared on common Dividends declared on preferred Fixtures Gain on sale of old fixtures Goodwill Income tax expense Income tax payable Interest expense Interest payable Inventories Land Long-term notes payable Other operating expenses Paid-in capital in excess of par 512.8 689.6 21.0 271.0 12.6 23.0 916.6 1,166.4 112.8 470.4 20.8 5,727.8 227.8 376.6 201.8 21.2 1,789.4 108.8 106.8 280.2 75.0 77.6 14.2 690.2 201.8 99.4 691.2 361.4 180.0 21.2 1,737.0 113.4 40.0 100.0 70.0 9.4 510.2 201.8 121.6 1,000.0 333.4 265.8 65.6 265.8 84.2 650.0 538.2 1,428.0 Prepaid advertising Rent expense Retained earnings (beginning of year) Salaries expense Salaries payable Sales Short-term investments Short-term notes payable Supplies expense Treasury stock (at cost 613.0 1212 9,173.210,766.0 56.0 27.8 324.0 228.2 267.8 94 256.4 228.2