Zetatron is an all-equity firm with 100 million shares outstanding, which are currently trading for $7.50 per share. A month ago, Zetatron announced it will change its capital structure by borrowing $100 million in short-term debt, borrowing $100 million in long-term debt, and issuing $100 million of preferred stock. The $300 million raised by these issues, plus another $50 million in cash that Zetatron already has, will be used to repurchase existing shares of stock. The transaction is scheduled to occur today. Assume perfect capital markets. Required:
a. What is the market value balance sheet for Zetatron

i. Before this transaction?
ii. After the new securities are issued but before the share repurchase?
iii. After the share repurchase?

b. At the conclusion of this transaction, how many shares outstanding will Zetatron have, and what will the value of those shares be?

The beach dude (bd) employs a legion of current and former surfers as salespeople who push its surfing-oriented products to various customers (usually retail outlets). this case describes bd's sales and collection process. each bd salesperson works with a specific group of customers throughout the year. in fact, they often surf with their customers to try out the latest surf gear. the bd salespeople act laid-back, but they work hard for their sales. each sale often involves hours of surfing with their customers while the customers sample all the latest surf wear. because bd makes the best surfing products, the customers look forward to the visits from the bd salespeople. and they often buy a lot of gear. each sale is identified by a unique invoice number and usually involves many different products. customers pay for each sale in full within 30 days, but they can combine payments for multiple sales. bd manages its clothing inventory by item (e.g., xl bd surfer logo t-shirts), identified by product number, but it also classifies the items by clothing line (the lines are differentiated by price points as well as the intended use of the clothing, e.g., surfing products, casual wear, . draw a uml class diagram that describes the beach dudes sales and collection process.b. using microsoft access, implement a relational database from your uml class diagram. identify at least three fields per table.c. describe how you would use the relational database to determine the beach dude’s accounts receivable.

Suppose the following items were taken from the balance sheet of nike, inc. (all dollars are in millions.) 1. cash $ 2,316.7 7. inventory $ 2,245.6 2. accounts receivable 2,786.2 8. income taxes payable 80.3 3. common stock 2,841.1 9. equipment 1,783.8 4. notes payable 291.2 10. retained earnings 6,162.5 5. buildings 3,959.7 11. accounts payable 2,624.6 6. mortgage payable 1,092.3 perform each of the following. classify each of these items as an asset, liability, or stockholders’ equity, and determine the total dollar amount for each classification. (enter amounts in millions up to 1 decimal place, e.g. 45.5 million.) cash accounts receivable common stock notes payable buildings mortgage payable inventory income taxes payable equipment retained earnings accounts payable assets $ 13092 liability $ 4088.4 stockholders’ equity $ 9003.6 etextbook and media determine nike’s accounting equation by calculating the value of total assets, total liabilities, and total stockholders’ equity. (enter amounts in millions up to 1 decimal place, e.g. 45.5 million.) total assets = total liabilities + total stockholders’ equity

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?