Which is more important: the bond market (inflation) or reshoring industry?

by

Luke Groman outlines 2 factions within the US government:

  1. Whatever is good for the bond market should be US Policy:
    • We need to fight inflation.  This is the Larry Summers view that we need high unemployment to fight inflation even if this means a deep recession/recession
  2. We need to reshore, even if this leads to high inflation.
    • A faction within the Pentagon realized the the current dollar-based system requires us to outsource our manufacturing because a strong dollar makes US exports uncompetitive.
    • This outsourcing of manufacturing weakens the military supply-chain and has prompted the military to publish on this subject in 2010 and 2018.
    • The decision to sanction Russia may have been intentionally designed to precipitate a shift away from the dollar’s status as global reserve asset (but not US dollar as global reserve currency)

 
[Read more…]

Alternative News Sources

by

Here are some alternative news sources I’ve found online.  I’ve chosen them to supplement the normal “mainstream” media.

I’d be interested in your opinion of them.  Do you have other sources you find useful?

 

 

 

 

International English News Sites:

  • First Post (India): private English-language international channel
  • Deutsche Welle News (German)  Deutsche Welle is Germany’s international broadcaster, producing content in 30 languages.

Economics/Bitcoin #

Ukraine Military #

  • Lawrence Wilkerson – former Chief of Staff for Colin Powell
  • Ray McGoovern – former CIA Analyst who prepared the Presidential Daily briefing.  He testified against US at the United Nations over the Nordstream bombing
  • Scott Ritter:  former Marine Ilead nuclear disarmament with Soviet Union, former outspoken Iraq weapons inspector
  • Douglas Magregor – former Colonel who has been an advisor to the Secretary of Defense under Trump
  • Judge Andrew Napalitano: former Judge, Foxnews Commentator (Libertarian)

Geostrategy

Threats to the Petrodollar: Ukraine War & BRICS

by

“Foreign Affairs” semi-openly admits to “Petrodollar” defense

Foreign-Affairs-The Dollar Still Dominates



 

What is the Petrodollar?

  • The Petrodollar system is based on buyers paying for oil in US dollars. 1
  • Petrodollar recycling is when oil producers lend their suplus dollars back the the US, financing the US debt or buying US assets. 2 3
  • In the Russia/Ukraine war, Russia required “unfriendly” buyers to pay for their energy in rubles, creating a “petroruble“.
  • In a break from the past, Saudi Arabia is now considering selling oil to China in Chinese yuan. 4

Why this “Foreign Affairs” article is interesting:

I’m not surprised by the content of Carla Norrlöf’s recent “Foreign Affairs” article.  I’ve seen most of this material before from less credentialed sources on the internet (and in books), but I think it is outside of the Overton window for television. If a guest on a network like CNBC started talking about the Petrodollar, I think the producer would cut to commercial break.

[Read more…]

  1. The US made an agreement with Saudi Arabia in 1974 that it would require buyers to pay for oil in dollars. This increases demand for dollars, which increases demand for interest-bearing dollars (US Treasuries), which means more people are willing to finance US debt.↩

  2. After the US quadrupled its grain export prices shortly after the 1971 gold suspension, the oil-exporting countries quadrupled their oil prices. US diplomats had let Saudi Arabia and other Arab countries know that they could charge as much as they wanted for their oil, but that the US would treat it as an act of war not to keep their oil proceeds in US dollar assets.↩

  3. When countries hold dollars, they usually buy US treasury bonds (US debt), so as to get interest on their dollars. The more people that want US dollars, the easier it is for the US to run perpetual deficits and finance that debt. ↩

  4. This decreases demand for US dollars, hence demand for US Treasuries (US debt)↩

  5. In the past, I’ve seen people deny that it matters whether oil is priced in dollars and whether the dollar is a dominant global reserve currency.  Professor Norrlöf ‘s article confirms that not all the critics are “delusional conspiracy theorists.” ↩

Calculating Interest Rates with Excel

by

Here’s an article I wrote for Microfinance Transparency in February 24, 2010:

Chuck Waterfield and Alexandra Fiorillo, MFTransparency’s CEO and VP respectively, have been doing many presentations about how interest rates can be calculated using our excel tool, but we haven’t yet featured a story on our blog about our data collection process and our corresponding excel tool. Although technical, interest rate calculations are really at the heart of MFTransparency’s mission and calculating accurate interest rates is vital to providing transparent pricing data. So today, I would like to give you a brief demonstration of the IRR and XIRR Excel functions, as a way to provide background for the techniques we’ve used to automate interest rate calculations on our website.

For those of you less familiar with excel, this spreadsheet software offers numerous formulas allowing quick and easy calculations within each spreadsheet. As it is particularly geared towards financial use, there are ready-made formulas specifically meant for calculating interest rates. The most basic (but still powerful) calculation is the internal rate of return.

IRR() : Internal Rate of Return

The internal rate of return formula is capable of taking a cash flow and returning the per-period interest rate. It assumes equal lengths of time between each amount in the cash flow. Let’s first start with a sample spreadsheet of loan payments, and use the IRR function to calculate the interest rate.

Screenshot: Excel IRR function

You can see that by applying the IRR formula, we get an “Internal Rate of Return” for the loan. This IRR can then be multiplied by the number of periods in a year to get the APR. Annual Percentage Rate is the standardized format most commonly used in the United States.

  • APR = IRR * n, where n is the number of payments per year.
  • 24.09% = 0.0200757 * 12

The EIR takes into account the effect of compound interest and can be calculated using the formula. This is the standardized interest rate often reported in European countries:

  • EIR = ((1+IRR)^n) -1)
  • 26.94% = ((1+ 0.0200757)^12)-1)

The IRR function is sufficient when there are equal (or near equal) periods between repayments, but what about when repayments occur irregularly? Prior to Excel 2007, there was no easy solution… but thankfully the wizards at microsoft have now provided us with a solution:

XIIR(): accounts for actual payment dates

As mentioned above, the XIRR function is useful for loans with irregular repayment schedules, and is only available in newer versions of Excel (2007) and in recent versions of Open Office.

Excel 2007 XIIR function

Notice that the XIRR function takes into account the payment dates in addition to the payment amounts. It actually provides us with the EIR (so annualized interest rate WITH compounding) for the cash flow in question. We won’t get into the math behind this, but suffice it to say that this formula is powerful, and a significant step up in allowing accurate calculations of interest rates. If you download the sample spreadsheet and play with the numbers, you can see the effect that an early first payment and a short month (February) have on the XIIR result.

  • better EIR = Excel XIIR()
  • XIRR() = 32.16%

So XIRR is a more accurate way to calculate the interest rate because it takes into account both actual payment dates and the effect of compound interest.

These tools are what allow MFTransparency to calculate accurate interest rates that are comparable between MFIs, despite different/irregular repayment schedules, additional fees, etc. So while they may seem mundane, they are actually the crux of transparent pricing!

In a future post, I’ll explain how software programmers can efficiently add advanced Excel 2007-like XIRR calculations to their software programs.

Further Information

For those of you who would like to know more about interest rate calculation, I encourage you to check out the following:

The next post in this series, “Calculating Interest Rates Using Newton’s Method” is a more advanced version of this article that explains the algorithm behind the XIIR formula, and how this technique can be applied in programming languages like C#, python, or Java.

P.S. For investors, Excel’s XIRR feature can also be used to calculate a Personal Investment Rate of Return, which is more relevant than the values that appear in a fund’s prospectus because it takes into account the investor’s actual purchase history.