● 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