## Paper instructions

Excel Project – Chapters 11 & 12 (worth 100 points) Garcia*Content can not be shared without explicit permission from the instructor***These slides are supplemental to your Textbook and the Publisher PPT Slides; not all items (on exams) are discussed in these slides; you are still responsible for reading the textbook**Copyrighted Content – Do Not Distribute1

International Finance and Excel modeling ProjectREAD INSTRUCTIONS CAREFULY (next slides)DO THE BEST WORK YOU CAN AND TAKE PRIDE IN YOUR WORKEXCEL MODELING IS ONE OF THE MOST VALUABLE SKILLS IN THE WORKPLACE; THIS PROJECT WILL GIVE YOU SOME EXPERIENCETHIS IS INDIVIDUAL WORK, BE HONEST!I CAN PROVIDE GENERAL GUIDANCE, COME TO WEEKLY ZOOM HOURSONLY SUBMIT FILES IN EXCEL (NO “NUMBERS” FROM MAC)HAVE FUN LEARNING A SKILL THAT WILL MAKE YOU \$\$\$Copyrighted Content – Do Not Distribute2

From Chapter 11 – Translation ExposureKnowing 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 MethodCreate 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. Highlight in yellow the cells that the user can update AND the model updates automatically. Build the model with the user in mind.•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. Copyrighted Content – Do Not Distribute3