● Using the consolidated financial statements created, students will then use Excel modeling to translate the consolidated income statement and balance sheet from the English pounds to U. S. dollars based on exchange rates provided.( The U. S. dollar is the functional currency.)
Requirements:
● This project should be prepared as a report for your supervisor.
● The report should be visually pleasing.
● As many computations as possible should be done by the model with the exception of entering the original financial statement data.
● The report should utilize“ macros” and other built-in features found in Excel.
Milestones
Milestone One: Initial Model
In task 5-1, you will submit the initial Excel model for the report that shows the consolidation entries and the final income statement and balance sheet. This milestone will be graded using the Final Project Milestone One Rubric.
Milestone Two: Model and Exchange Rates