.

b) Suppose there is a group of individuals on which you have individual-level data. Suppose, for those with wages below some level ˜w, a policy is implemented to have them work more. You have in your data hours worked, several individual characteristics, the wages, and year. The policy is implemented in the year 2000, and you have data for the year 1998 and 2002.

What type of estimation strategy would you use to determine the effect of the policy? What is it called? Write the specific regression specification you would use; make sure to explicitly indicate what you would use as control variables.

Given the following information, what is the percentage change in the price of the bonds if interest rates suddenly rise by 2%?

(Please show your work as I am attempting to work out similar problems in excel.)

(b) The USA has run continuous trade deficits since 1980.

(i) Discuss these external deficits, making sure to describe the role of national savings, investment and net exports.

(ii) Briefly describe the evolution of American foreign assets/liabilities, and discuss the sustainability of this situation. (15)

(c) During the years 2002 to 2010, the current account of the Eurozone’s Balance of International Payments was broadly in balance with the rest of the world, running either small annual surpluses or small annual deficits. However, discuss the external balances within the Eurozone during this period, and their significance as a contributor to the financial crisis between 2007 and 2014.

Assume you invest $2000 on February 1, 1993, $2000 on February 1, 1994, $2000 on February 1, 1995,   $2000 on February 1, 1996, $2000 on February 1, 1997, $2000 on February 1, 1998, $0 on February 1, 1999,  $0 on February 1, 2000, $0 on February 1, 2001,   $0 on February 1, 2002, and $0 on February 1, 2003.  What is the value of those investments on  February 1, 2003?  Assume that any money that is invested will earn an interest rate of 10%, compounded annually.

a. 15,431

b. 22,593

c. 37,062

d. 24,852

e. 49,045

.Read the quote and discuss what you think the author means by ‘passively calculating standard ratios’.

Corporations have substantial incentives to exploit the fact that accounting principles are neither fixed for all time nor so precise as to be open to only a single interpretation. Analysts, who appreciate the magnitude of the economic stakes, as well as the latitude available under the accounting rules, will see clearly that a verdict derived by passively calculating standard ratios may prove dangerously naive.

Source: Fridson, M & Fernando, A 2002, Financial statement analysis: a practitioner’s guide, 3rd edn, John Wiley & Sons, New York

The data in the table below gives sales revenue for Continental Divide Mining from 1995 to 2005.

YEAR YEARS SINCE 1990 SALES REVENUE (MILLIONS)
1995 2.6155
1998 3.3131
1999 3.9769
2000 4.5494
2001 4.8949
2002 5.1686
2003 4.9593
2005 4.7489

(a) Complete the missing column in the table.
(b) Use Excel to determine the quadratic regression model, y, that best represents sales revenue as a
function of, x, the number of years since 1990. Round three decimal places.

(a) Find the year in which there is maximum revenue and find the maximum revenue. Write solution as a
complete sentence.

Below are some data from the land of milk and honey.

YEAR       PRICE OF MILK        QUANTITY OF MILK    PRICE OF HONEY        QUANTITY OF HONEY

2001                $1                                100 Qts.                     $2                               50 qts.

2002                $1                                200                              $2                                100

2003                $2                                200                              $4                                100

1. Compute for each year the following below using 2001 as the base year.

a) nominal GDP

b) real GDP,and

c) the GDP deflator for each year, using 2001 as the base year.

2. Why do economists use real GDP rather than nominal GDP to gauge economic well being?

Sales planning primarily entails planning sales volumes, and one of the most important tasks performed by sales employees is to draw up a sales plan on the basis of their current sales, Bill McDermott became CEO of SAP America in 2002. He had spent 17 years in sales and sales management at Xerox and served as executive vice president of worldwide sales and operations at Siebel Systems. His leadership at SAP has produced overall growth of about 14 percent in a flat market.

Q1. In your opinion, how Bill McDermott create a sales Plan and set goals for SAP products?

((No copy-paste, please))

Identify whether the following statements are True, False or Uncertain. Explain your answers

(a) From consumption surveys, there is clear evidence that the poor (those living on less than $1.25 a day) spend almost all (around 90%) of their income on food consumption.

(b) Banerjee, Deaton and Duflo (2004) found that villagers could not utilize government health services regularly because the clinics were only open on Thursdays.

(c) If the S-shaped relationship between health tomorrow and health today holds in reality, then interventions providing moderate short-run improvements in health may be even more effective over the long run.

Valuing a Stock with Three-Stage Dividend Discount Model Mocha-Cola In the morning of Tuesday, January 3rd 2004, Robert Smart, a security analyst at Armani Investment was reviewing the 2003 financial statements of Mocha-Cola as requested by one of their most important clients, Mr. Jin Qian. Mr. Jin Qian has accumulated a significant amount of wealth through Armani’s recommendations in the past and now he was interested in investing a sizeable amount of his wealth into Mocha-Cola stocks. Mocha-Cola, the world famous soft drink company, was able to increase its market value consistently over the last several decades. While Mocha-Cola’s growth in the domestic soft drink market has leveled off in the past few years due to aggressive marketing campaigns of its competitors (especially by TipsyCola), the analysts expect that the firm will continue to expand thanks to the introduction of new products and increased demand for Mocha-Cola products by international markets. The initial analyses carried by Robert Smart revealed that Mocha-Cola reported earnings per share of $3.00 in 2003, and paid dividends per share of $0.75. Mr. Smart asked his assistant, Paul Brook, to gather further information on Mocha-Cola as reported by other analysts. Paul’s summary of analyst reports indicated that Mocha-Cola’s earnings would grow at their extraordinary level of 20% at least for the next five years (from 2004 to 2008). While Mr. Smart concurs with this expectation, he thinks that it should decline linearly each year after the high growth period to a stable growth rate of 5% in 2013 due to severe competition in the soft-drink industry. Paul Brook also noted that according to analysts’ reports payout ratio was expected to remain unchanged from 2004 to 2008, after which it would increase each year equally to reach its steady state value of 80% in 2013. By the end of the day, Mr. Smart was already tired and overwhelmed with the amount of information accumulated. He asked Paul to calculate the stock price of MochaCola by using three-stage dividend discount model and assuming a 15% required rate of return. The results were expected to be ready for presentation by 10:00 a.m. on Wednesday. While Paul was very proficient in terms of putting necessary inputs together as he did in this task, he had never actually run the three-stage dividend discount model on his own. He took another sip from his coffee and got ready to prepare a full, fresh pot that he was going to need for the rest of the night.

Please show excel formulas !