Class Assignment 1J

Question and Problem SetsPurpose of AssignmentStudents should understand the operating and cash cycles of a company, the mechanics in preparing a cash budget, the use of exchange rates and interest rate parity in international finance and valuation of a company in a merger and acquisition.Assignment Steps Resources: Tutorial help on Excel® and Word® functions can be found on the Microsoft®Office website. There are also additional tutorials via the web that offer support for office products. Complete the following Questions and Problems from each chapter as indicated. Show all work and analysis.Prepare in Microsoft® Excel® or Word. Ch. 18: Questions 3 & 11 (Questions and Problems section)Ch. 20: Questions 8 & 14 (Questions and Problems section)Ch. 21: Questions 4 & 7 (Questions and Problems section)Ch. 26: Questions 1 & 2 (Questions and Problems section): Microsoft® Excel® template provided for Problem 2Format your assignment consistent with APA guidelines if submitting in Microsoft® Word.No Plagiarism
untitled_spreadsheet__8_.xlsx

Unformatted Attachment Preview

Chapter 26
Problems 2, 4, 5, 10
Input boxes in tan
Output boxes in yellow
Given data in blue
Calculations in red
Answers in green
NOTE: Some functions used in these spreadsheets may require that
the “Analysis ToolPak” or “Solver Add-in” be installed in Excel.
To install these, click on “Tools|Add-Ins” and select “Analysis ToolPak”
and “Solver Add-In.”
Chapter 26
Question 2
Input Area:
Firm X
Firm Y
Total earnings
Shares outstanding
Per-share values
Market
Book
Merger premium
Output Area:
Asset from X (book value)
Asset from Y (market value)
Purchase price of Y
Goodwill
Total assets XY = Total equity XY
$
$
$
$
$
–
…
Purchase answer to see full
attachment