Business Finance Homework Help

From Chapter 11 – Translation Exposure

Knowing how to create Excel models is highly regarded skill in the workplace. This exercise will give you a taste of the work that goes into creating a workable, organized and clean looking model. You will need to create 2 models in total from chapter 11. Create an Excel model identical to Exhibit 11.5 – Current Rate Method

Create an Excel model identical to Exhibit 11.6 – Temporal Method

•Models must be formatted in the same manner as textbook (clean look and I am picky about this !)•Models should use formulas where it is necessary (point of models is to automate the work) I will check your formulas.

•Create model so the user can simply enter whatever ending rate they desire, and the model computes the translation adjustment automatically. It is good practice to highlight such cells to inform / guide the user, making the model very user friendly and simple for the user to know out how to use it.

•Label your tabs according to the exhibit #.

•Highest grades will be given to those that have a workable model (accurate when I change the ending rate) that looks good (formatted like the textbook); average grade will be given to those that show good effort but cannot build a workable model that is accurate but looks good (formatted according to textbook). Low grade will be given to inaccurate, poorly formatted, incomplete, hardcoded models.

From Chapter 12 – Operating Exposure

Knowing how to create Excel models is highly regarded skill in the workplace. This exercise will give you a taste of the work that goes into creating a workable, organized and clean looking model. You will need to create 2 models in total from chapter 12. After reading the chapter:

Create an Excel model identical to Exhibit 12.5 – Ganado German Valuation: Baseline Analysis

•Models should be formatted in the same manner as textbook (clean look)

•Models should use formulas where it is necessary (point of models is to automate the work)

•Highlight in yellow the cells that can be changed by the user (the point is to guide the user); the model should recompute the Present Value calculation automatically, by changing the input cells.

•Highest grades will be given to those that have a workable model (accurate when I change the ending rate) that looks good (formatted like the textbook); average grade will be given to those that show good effort but cannot build a workable model that is accurate but looks good (formatted according to textbook). Low grade will be given to inaccurate, poorly formatted, incomplete, hardcoded models.

After you create the first model, make a copy (new tab) and change your assumptions (highlighted in yellow) to make the spreadsheet identical to Exhibit 12.6 – This is your second model! If you create your first model right, your second model can be created in a shorter time.

Label your tabs according to the exhibit #.

Summary

Your spreadsheet will consist of 5 tabs: 1.Exhibit 11.5, 2.Exhibit 11.6, 3. Exhibit 12.5, 4. Exhibit 12.6, 5.Notes – insert a text box on the sheet and in it, write a comprehensive paragraph of how you went about building the model. How was your experience. What did you know, what did you have to learn, how did you learn it, how long in took you, etc. Be as comprehensive as you want.