When you take out a mortgage your home becomes the collateral

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

Winners of the georgia lotto drawing are given the choice of receiving the winning amount divided equally over 2121 years or as a lump-sum cash option amount. the cash option amount is determined by discounting the annual winning payment at 88% over 2121 years. this week the lottery is worth $1616 million to a single winner. what would the cash option payout be?

Dr. sperry, a biologist, is using excel to track growth rates of different populations of bacteria. she has a very complex formula in one cell. it begins with “round”. dr. sperry would like to see exactly how excel’s calculation reached the final rounded value that she sees in the cell. what could dr. sperry do to best understand how the calculation was made? try different formulas on her own until she reaches the value shown in excel click on the evaluate formula button in the formulas tab and then click “step in” select the cell and then look at the formula in the formula field of the ribbon remove “round” from the formula in order to see the actual value before rounding