G 1. ABC Bank has new loan requests of $225 million, needs to purchase $75 million in U. S. Treasury securities to meet pledging requirements, and anticipates draws against credit lines of $65 million. Deposits received today total $155 million and the bank expects to bring in an additional $235 million next week. What is the bank's estimated funds gap for the coming week?

Chance company had two operating divisions, one manufacturing farm equipment and the other office supplies. both divisions are considered separate components as defined by generally accepted accounting principles. the farm equipment component had been unprofitable, and on september 1, 2018, the company adopted a plan to sell the assets of the division. the actual sale was completed on december 15, 2018, at a price of $600,000. the book value of the division’s assets was $1,000,000, resulting in a before-tax loss of $400,000 on the sale. the division incurred a before-tax operating loss from operations of $130,000 from the beginning of the year through december 15. the income tax rate is 40%. chance’s after-tax income from its continuing operations is $350,000. required: prepare an income statement for 2018 beginning with income from continuing operations. include appropriate eps disclosures assuming that 100,000 shares of common stock were outstanding throughout the year. (amounts to be deducted should be indicated with a minus sign. round eps answers to 2 decimal places.)

Alandowner and his neighbor purchased adjoining undeveloped lots. after both built homes on their respective lots, the landowner suggested to the neighbor that a common driveway be built where the two lots joined. the neighbor agreed. the landowner and the neighbor split the cost of constructing the driveway and entered into a written agreement to equally share the costs of its upkeep and maintenance. the agreement was recorded in the county recorder's office. two years later, the neighbor built a new driveway located entirely on his lot. the common driveway, which the landowner continued to use but which the neighbor no longer used, began to deteriorate. the landowner asked the neighbor for money to maintain the common driveway, but the neighbor refused to contribute. three years later, the neighbor conveyed his lot to a friend. the friend entered into possession and used only the driveway built by the neighbor. by this time, the common driveway had deteriorated badly and contained numerous potholes. the landowner asked the friend to pay half of what it would take to repair the common driveway. the friend refused. the landowner repaired the driveway and sued the friend for 50% of the cost of repairs. will the landowner prevail?

Excel allows you to take a lot of data and organize it in one document. what are some of the features you can use to clarify, emphasize, and differentiate your data?