Teaching International Trade and Finance Using Computer Spreadsheets

By Gregorowicz, Philip; Hegji, Charles E. | American Economist, Fall 2000 | Go to article overview
Save to active project

Teaching International Trade and Finance Using Computer Spreadsheets

Gregorowicz, Philip, Hegji, Charles E., American Economist

Philip Gregorowicz [*]

Charles E. Hegji [*]

The possibility of the use of computer spreadsheet models as an aid to teaching economics is clearly established. The work of Smith and Smith (1988), Smith and Ellis (1990), Clark and Hegji (1997) and others clearly demonstrates that computer spreadsheets can be used to model standard micro economic concepts such as marginal revenue, marginal cost, and value of marginal product. Hegji (1998) has shown that managerial economics topics such as determining the firm's optimal level of advertising can be readily modeled with computer spreadsheets. The present paper builds on this approach by developing examples in which computer spreadsheets can be used to enhance the teaching of international economics and finance.

The importance of using computer spreadsheets to teach international economics comes from two sources. First, there has been a growing interest in international economics by the teaching profession. This is suggested by the increased international coverage in most principles of economics texts written since 1990. Second, the authors believe that topics covered in international trade and finance are difficult for most students. The idea of modeling international economics topics with computer spreadsheets is that this approach allows students to learn through experimentation. We are convinced that a hands-on approach is an effective way to teach such material.

With this in mind, the present paper develops several examples of how computer spreadsheets can be used as an aid in teaching international economics. The choice has been made based on the authors' experiences.

Using Supply and Demand Curves to Determine Exports and Imports in a Two Country Model

The following example was adapted from Managerial Economics: Theory, Applications, and Cases by Edwin Mansfield. A two-country model is assumed, with supply and demand curves for a single product specified for each country. The object of the exercise is to determine imports and exports for both countries.

Suppose that the supply (s) and demand (d) curves for a product manufactured and purchased in both the United States (u) and Germany (g) are given by

[[Q.sup.u].sub.s] = 5 + 2.6[P.sub.u],

[[Q.sup.u].sub.d] = 100 - 2[P.sub.u],

[[Q.sup.g].sub.s] = 2 + 2[P.sub.g],

[[Q.sup.g].sub.d] = 120 - 4[P.sub.g]. (1)

Prices in the United States are measured in $, while prices in Germany are in DDM.

Solution to above problem requires an exogenous exchange rate. Given this exchange rate, prices can be converted to a single currency. Given this conversion, the "law of one price" is invoked by equating worldwide supply and demand, and solving for the worldwide equilibrium price and quantity. Substituting this price into (1) obtains the quantities supplied and demanded in the two countries. These quantities can, in turn, be used to determine if a country is a net exporter or importer of the good.

Suppose that the exchange rate is e = 1.6 DM/$. This implies that [P.sub.g] = l.6[P.sub.u]. Substituting into (1), and letting

[[Q.sup.u].sub.s] + [[Q.sup.g].sub.s] = [[Q.sup.u].sub.d] + [[Q.sup.g].sub.d], (2)

results in an equilibrium price [P.sub.u], = $15 = 24 DM = [P.sub.g]. With these prices, the US demands 70 units of the above good and supplies 44 units. Germany demands 24 units and supplies 50 units. Therefore, the US imports 26 units and Germany exports 26 units.

An important concept for students to grasp is how these net export and import positions change with the exchange rate. The spreadsheet in Example 1 is set up to do this.

The exchange rate in DM/$ is entered into one cell in Column A of the spreadsheet. This exchange rate is used in the formulas in the remainder of the spreadsheet. The $ price of the good is entered in Col B, with US demand and supply expressed as a function of this price in Cols C and D.

The rest of this article is only available to active members of Questia

Sign up now for a free, 1-day trial and receive full access to:

  • Questia's entire collection
  • Automatic bibliography creation
  • More helpful research tools like notes, citations, and highlights
  • Ad-free environment

Already a member? Log in now.

Notes for this article

Add a new note
If you are trying to select text to create highlights or citations, remember that you must now click or tap on the first word, and then click or tap on the last word.
Loading One moment ...
Project items
Cite this article

Cited article

Citations are available only to our active members.
Sign up now to cite pages or passages in MLA, APA and Chicago citation styles.

Cited article

Teaching International Trade and Finance Using Computer Spreadsheets


Text size Smaller Larger
Search within

Search within this article

Look up

Look up a word

  • Dictionary
  • Thesaurus
Please submit a word or phrase above.
Print this page

Print this page

Why can't I print more than one page at a time?

While we understand printed pages are helpful to our users, this limitation is necessary to help protect our publishers' copyrighted material and prevent its unlawful distribution. We are sorry for any inconvenience.
Full screen

matching results for page

Cited passage

Citations are available only to our active members.
Sign up now to cite pages or passages in MLA, APA and Chicago citation styles.

Cited passage

Welcome to the new Questia Reader

The Questia Reader has been updated to provide you with an even better online reading experience.  It is now 100% Responsive, which means you can read our books and articles on any sized device you wish.  All of your favorite tools like notes, highlights, and citations are still here, but the way you select text has been updated to be easier to use, especially on touchscreen devices.  Here's how:

1. Click or tap the first word you want to select.
2. Click or tap the last word you want to select.

OK, got it!

Thanks for trying Questia!

Please continue trying out our research tools, but please note, full functionality is available only to our active members.

Your work will be lost once you leave this Web page.

For full access in an ad-free environment, sign up now for a FREE, 1-day trial.

Already a member? Log in now.

Are you sure you want to delete this highlight?