Computer stocks currently provide an expected rate of return of 16%. mbi, a large computer company, will pay a year-end dividend of $2 per share. if the stock is selling at $50 per share, what must be the market’s expectation of the growth rate of mbi dividends?

You are the manager in charge of global operations at bankglobal – a large commercial bank that operates in a number of countries around the world. you must decide whether or not to launch a new advertising campaign in the u.s. market. your accounting department has provided the accompanying statement, which summarizes the financial impact of the advertising campaign on u.s. operations. in addition, you recently received a call from a colleague in charge of foreign operations, and she indicated that her unit would lose $8 million if the u.s. advertising campaign were launched. your goal is to maximize bankglobal’s value. should you launch the new campaign? explain. pre-advertising campaign post-advertising campaign total revenues $18,610,900 $31,980,200 variable cost tv airtime 5,750,350 8,610,400 ad development labor 1,960,580 3,102,450 total variable costs 7,710,930 11,712,850 direct fixed cost depreciation – computer equipment 1,500,000 1,500,000 total direct fixed cost 1,500,000 1,500,000 indirect fixed cost managerial salaries 8,458,100 8,458,100 office supplies 2,003,500 2,003,500 total indirect fixed cost $10,461,600 $10,461,600

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?

Suppose you win a small lottery and have the choice of two ways to be paid: you can accept the money in a lump sum or in a series of payments over time. if you pick the lump sum, you get $2,950 today. if you pick payments over time, you get three payments: $1,000 today, $1,000 1 year from today, and $1,000 2 years from today. 1) at an interest rate of 6% per year, the winner would be better off accepting the (lump sum / payments over time), since it has the greater present value. 2) at an interest rate of 9% per year, the winner would be better off accepting the (lump sum / payments over time), since it has the greater present value. 3) years after you win the lottery, a friend in another country calls to ask your advice. by wild coincidence, she has just won another lottery with the same payout schemes. she must make a quick decision about whether to collect her money under the lump sum or the payments over time. what is the best advice to give your friend? a) the lump sum is always better. b) the payments over time are always better. c) it will depend on the interest rate; advise her to get a calculator. d) none of these answers is good advice.