Model Bucket

Purchasing Power Parity - Create & compare product pricing in multiple countries.

This model allows for an accurate comparison of products across various markets. It is a 'purchasing power parity' model or PPP for short. It allows you to create a list of products and the countries they are sold in. Input the prices in various currencies (and optionally their release dates) and it will provide insight into how cheap and/or expensive it is compared to all applicable markets.

Useful for any company that sells products in multiple countries, for analysis of another company's product portfolio strategy (example Apple data is provided), and many other uses.

NOTE: This is built for google spreadsheets and requires some of its functionality. It is only usable if uploaded to your google docs account. Its direct functionality in native excel will vary greatly and is not recommended.

The basic inputs for the model are:
- A list of product names (and optional date it was released in each market)
- A list of applicable address country markets (accepts up to 47 markets)
- Currencies that will be traded (top 50 are already builtin)
- Tax & duty values for each country (again lots of data already provided)

The output includes:
- A dashboard that allows you to select a single product to compare it to every market based on the primary market.
- A most expensive and least expensive market analysis
- An index based on the US pricing
- An index based on lowest price per product
- An index based on highest price per product
- An index based on mean price per product

  • Screenshot
  • Screenshot
  • Screenshot
  • Screenshot
  • Screenshot
  • Screenshot
  • Screenshot
  • Screenshot

About the author

tomfrazier

2 models
-----
tomfrazier avatar Ask author a question

Reviews

This model has no reviews yet

Be the first to purchase this model and leave a review. Add this to your cart

Need some help?

This modeller has offered to support this model, you can commission them to support your model and customise it through Model Factory.

Get Support

Can't find what you need? No problem.

Start a Model Factory job for FREE and engage a professional to build your model for you.

Start Job