It should to be answerd by Excel.

Please show formulas.

w Human capital: Consider an individual who lives for two periods. In the first period, the individual may either work or go to school (but not both). In the second period, the individual will work regardless of what was done in the first period. If the individual foregoes schooling and decides to work, she will earn $200 in period 1 and $250 in period 2. If she decides to get an education in the first period, her wage in period 2 will be $575. The direct cost of schooling in period 1 is $100. Discounting begins in the first period. Calculate the internal rate of return. (The internal rate of return is the discount rate such the benefits of going to school equal the costs of going to school.) Use Excel's formula "IRR". Check your answer by using Goal Seek. tperiod 1 and S250 in perio 2