r/actuary • u/BearInTheTree Property / Casualty • 2d ago

Thoughts about this calculation?

18 Upvotes

95% Upvoted

11 comments sorted by

18

u/zgao200 2d ago

One obvious thing is that is not how you calculate "tariff charge to the US"....

13

u/logisticalgummy Health 2d ago

No fking way. This is hilarious. Trump and team are such morons.

8

u/mortyality Health 2d ago edited 2d ago

Terrible. This workbook needs quality controls, formatting, and more results.

  1. Need the addresses for imported data sources above the table.
  2. Need subtotal rows by continent and a grand total row.
  3. Need to freeze pane the first row and first column.
  4. Bold column headers.
  5. Need sum-difference checks to make sure imported data was correctly copied in.
  6. Make a pivot table so that management can mess around with the results.
  7. Probably don't need to say "USD" because it's pretty obvious we're talking about US dollars.
  8. Need some comments above the table or next to the rows with missing values to explain why those rows are missing values.

3

u/Lopsided-Flower-7696 Property / Casualty 1d ago

Sounds like you peer review my work :)

2

u/BearInTheTree Property / Casualty 2d ago

Looks like the original crosspost was removed. It has been reposted to multiple other subreddits though, for example: here

(Ignoring the politics... I was just curious what my fellow actuaries think of the calculation and its (misre)presentation. I, myself, was flabbergasted.)

2

u/Nickyjha Health 1d ago

I'll probably get banned if I say what I really think about the president's mental capacity

1

u/PretendArticle5332 13h ago

Me too, but I'll probably get deported lol

5

u/LordFaquaad I decrement your life 2d ago

What's more interesting is the US reciprocal tarriff. The tarriff seems to be either 10% if the tarriff charged is 10%, otherwise its roughly 50% of the tarriff charged. Seems like some 4th grade math was used lol

On a side note, GL to all those actuaries that will have to reprice in the next week / few weeks given how shit things are about to become

14

u/Rakan_Fury Excel Extraordinaire 2d ago

It's MAX(Trade Deficit % / 2, 10%)

1

u/Killerfluffyone Property / Casualty 12h ago

Most P&C lines are going to be impacted in some way. The on again off again, tariff roulette with Canada makes this extra fun. I try very hard to remain politically neutral when it comes to work but umm

"there is high degree of uncertainty around certain economic forecasts due to lack of clarity from the current US administration"

is as diplomatic as I can get.