can someone send me the solution. i need this in excel file.

1 THE NOMINAL EFFECTIVE EXCHANGE RATES (\"NEER\") & THE REAL EFFECTIVE EXCHANGE RATES (\"REER\") GROUP ASSIGNMENT PROF HARVEY PONIACHEK, SPRING 2017 DERIVE THE NEER AND THE REER BY APPLYING THE FOLOWING MODELS. THIS ASSIGNMENT SHOULD BE PERFORMED BY TEAMS OF UP TO 4 STUDENTS (BUT DEFINITELY NOT MORE), HOWEVER INDIVIDUAL WORK IS ACCEPTABLE. THE OBJECTIVE OF THIS ASSIGNMENT IS TO FAMILIARIZE YOU WITH THE APPLICATION OF FINANCIAL MODELS, INTRODUCE YOU TO MARKET DATA SOURCES, AND PROVIDE YOU WITH THE OPPORTUNITY TO INTERPRETE EMPIRICAL FINDINGS. THE ASSIGNMENT SHOULD BE SUBMITTED FOR GRADING ON THE DUE DATE. A COUPLE OF ASSIGNMENTS WOULD BE SELECTED FOR PRESENTED IN CLASS. I. THE NOMINAL EFFECTIVE EXCHANGE RATE (NEER) INDEX DERIVE THE NEER BY APPLYING THE FOLOWING MODELS, FROM 2005 TO 2015, BY USING YEAR END DATA FROM THE SOURCES CITED BELOW:: NEER FC/ $, t+1 = [FC / $ n, t+1 / FC/ $ n, t] W n, t where the variable are defined as follows: t goes from 2005 to 2015, with the base year being 2005, FC/ $ n, t is the indirect quote of currency n per the $ in year t, n is the number of foreign countries (that are listed below), Wn is the export share (%) of the U.S. to each country, and sigma relates to aggregation for country n=1 to N, and each derivation for the N countries is done for each year, from 2005 TO 2015 THE WEIGHTED RATIOS ARE CREATED FOR EACH COUNTRY AND SUMMED UP FOR ALL THE n COUNTRIES TO CONSTITUTE THE INDEX FOR THE SPECIFIC YEAR. THE NEER INDEX MEASURES THE EVOLUTION OF THE $ FROM THE PERSPECTIVE OF THE U.S. MAIN TRADING PARTNERS (THAT ARE LISTED BELOW). 1. QUOTES ARE INDIRECT, FC/ $, AND FOR END OF YEAR RATES. 2. Wn MEASURES THE % SHARE OF U.S. EXPORT TO COUNTRY n, and Wn=1 3. THE $ INDEX IS SET AT 100 IN 2005, WHICH IS THE BASE YEAR. THE INDEX MEASURES THE VALUE OF THE $ FROM A FOREIGN PERSPECTIVE (FOREIGN TERMS). 1 2 4. WHEN THE INDEX IS ABOVE 100, IT IMPLIES THAT THE DOLLAR APPRECIATED; AND WHEN IT IS BELOW 100, IT IMPLIES THAT THE $ DEPRECIATED. WHEN THE INDEX FOR A SPECIFIC YEAR IS 100 IT IMPLIES THAT ON A TRADE WEIGHTED BASIS THE DOLLAR HAS NOT CHANGES, 5. FOR DIRECT QUOTES, $/FC, IF NEER >100 IT IMPLIES THE $ DEPRECIATED; AND IF NEER 100 IT IMPLIES THAT THE $ APPRECIATED ON A REAL EFFECTIVE BASIS; AND IF REER