Instructions:

Unit 5 ? MBA6016 - Jul 11 2016 to Aug 19 2016 - Section 103

• This Excel document contains unique details and cells specific to the problems that you must use to derive your solutions. Where numeric solutions are expected, provide full detail of the process used to reach the solution using Excel. Where analysis is expected, use information from the textbook to inform your analysis, not replace it, incorporating creativity, critical thinking, and real-life perspectives. Cite all resource materials used in your analysis, using proper APA format.A thorough, professional presentation of your analysis and results is an important consideration. Enhance your presentation skills by using applicable tools such as tables, graphs, diagrams, and commentary as appropriate in all assignments in this course.

UNIT 5: TEXTBOOK PROBLEMS CHAPTER 16: PROBLEM 1 Dividend Dividend Tax Stock Price $6.30 25% $83 Step 1: Calculate the After-Tax Dividend Step 2: Ex-Dividend Price = CHAPTER 16: PROBLEM 4 (a through d) # of shares of stock outstanding Stock Price 270,000 $73 A. B. C. D. CHAPTER 16: PROBLEM 7 Stock Dividend # of shares of stock outstanding 25% 25,000 Market Value Balance Sheet: Cash Fixed Assets Total $145,000 $598,000 $743,000 Debt Equity Total $127,000 $616,000 $743,000 Find the market price of stock by using the equity and # of shares outstanding New shares outstanding = New Stock price = CHAPTER 16: PROBLEM 16a Dividend Payout Ratio Earnings Per Share Adjustment Rate Dividend 1 year from now = $2.05 40% $6.20 0.3 UNIT 6: TEXTBOOK PROBLEMS CHAPTER 18: PROBLEM 2 Net Worth Long-term Debt Net Working Capital (Excluding Cash) Fixed Assets Current Liabilities $13,205 $8,200 $3,205 $17,380 $1,630 Cash = Net Working Capital (Including Cash) = Current Assets = CHAPTER 19: PROBLEM 1 (a through d) # of shares outstanding Current Stock Price # of new shares outstanding in the future (rights offering) Price of New Stock (or rights) 490,000 $75 80,000 $71 A. New Market Value of the Company = B. # of Rights Needed = C. Ex-Rights Price = D. Value of the Right = rights per new share CHAPTER 20: PROBLEM 4a Spot exchange rate for the Canadian Dollar 6 month forward rate U.S. Dollar $1.04 $1.06 $1.00 One Canadian Dollar is worth (If amount is below 1, then the U.S. dollar is worth mor CHAPTER 20: PROBLEM 5a British Pound Exchange Rate= Japanese Yen Exchange Rate= Cross Rate in terms of Yen per Pound = 89 1 = = $1 $1.62 en the U.S. dollar is worth more and vice versa.)