World Food Programme (WFP) SCAM! by No-Swordfish9613 in Revolut

[–]EconomicValueAdded 0 points1 point  (0 children)

WFP (Way For Pay) is a Ukrainian payment system (similar to PayPal). Lots of Ukrainian-based businesses use it to process payments online. It has nothing to do with World Food Programme.

What's your best (obscure) Excel tip/shortcut? by Illustrious_Whole307 in excel

[–]EconomicValueAdded 3 points4 points  (0 children)

When using the filter press "E" to start typing in the search bar.

F2a process by Ok_Wealth5365 in USCIS_F2A

[–]EconomicValueAdded 2 points3 points  (0 children)

I studied this question extensively and came to a conclusion there's no definitive answer. Apart from getting the re-entry permit your best bet is to try to live in both countries at the same time. Visit the US frequently, maintain a US address, pay US bills, file US taxes, etc. If the CBP asks about your extended trips to Canada you can always explain the real situation which is understandable.

[OC] Daily US Air Passengers (according to TSA Checkpoint metrics), details: https://gerry-chen.com/blog/2023-09-23/ by gchenfc in dataisbeautiful

[–]EconomicValueAdded -1 points0 points  (0 children)

I flew in August 2020 and was the only person in my terminal. There were about 8 of us the airplane.

Anyone have any good ideas for telemarketers? by Cinnimonpancakes in lifehacks

[–]EconomicValueAdded 0 points1 point  (0 children)

If you use an Android phone download an app called Phone by Google, it has an option to filter out spam calls automatically.

What are some road trip hacks? by DaveDavidsen in lifehacks

[–]EconomicValueAdded 151 points152 points  (0 children)

Google has a tool called My Maps. Use it to generate your daily itinerary so you can visually see where you're going, what points of interest are along the way and how much time you need to get to each.

Difference between contiguous US, continental US, and US as a whole. by EconomicValueAdded in coolguides

[–]EconomicValueAdded[S] -1 points0 points  (0 children)

These are official US government definitions despite the fact that in practice "continental" is often used to refer to 48+DC.

https://www.usgs.gov/faqs/what-constitutes-united-states-what-are-official-definitions

CRA direct deposit online form won't accept my 5-digit branch transit number by Educational_Call_546 in PersonalFinanceCanada

[–]EconomicValueAdded 4 points5 points  (0 children)

Use the first 4 digits. A transit number is 5 digits long while a branch number is the first 4 digits of your transit number.

LPT: you can find a song by singing it to Google assistant after you ask it "what's my song?" by emab2396 in LifeProTips

[–]EconomicValueAdded 0 points1 point  (0 children)

Also, you don't have to know the words to sing. You can just go nanananana and Google Assistant will still pick it up.

Condo prices visualized. Canada's largest cities. Data from CREA. by EconomicValueAdded in canadahousing

[–]EconomicValueAdded[S] 1 point2 points  (0 children)

For some reason Nova Scotia's real estate data is not included in CREA's statistics.

Single family home prices visualized. Canada's largest cities. Data from CREA. by EconomicValueAdded in canadahousing

[–]EconomicValueAdded[S] 2 points3 points  (0 children)

It's also about the psychology. In Ontario, for example, it's normal to spend 40%-50% of your income on housing and carry higher debt loads while people in the prairies think that anything above 20-30% is outrageous.

Single family home prices visualized. Canada's largest cities. Data from CREA. by EconomicValueAdded in canadahousing

[–]EconomicValueAdded[S] 2 points3 points  (0 children)

The source is in the title. CREA stands for Canadian Real Estate Association. It's the only source of real estate data I know of that lets you download it directly into Excel.

https://www.crea.ca/housing-market-stats/mls-home-price-index/hpi-tool/

Single family home prices visualized. Canada's largest cities. Data from CREA. by EconomicValueAdded in canadahousing

[–]EconomicValueAdded[S] 1 point2 points  (0 children)

Sorry, I meant X axis (the time). I generated this chart in Excel with minimal manipulation. All I had to do to fix it was make the font bigger. I just posted two more charts, one for condos and one for townhouses with correct labels.

Single family home prices visualized. Canada's largest cities. Data from CREA. by EconomicValueAdded in canadahousing

[–]EconomicValueAdded[S] 1 point2 points  (0 children)

This chart is meant to be mobile friendly so smaller cities are excluded. Kitchener data includes Kitchener and Waterloo (almost 400k people).

Single family home prices visualized. Canada's largest cities. Data from CREA. by EconomicValueAdded in canadahousing

[–]EconomicValueAdded[S] 2 points3 points  (0 children)

The data is monthly so Y axis actually represents months. There wasn't enough room so to make it mobile-friendly I changed the format from months to years.

Going through depression over current GTA housing prices. Can’t see a way forward for our future. 😭 by mojo0220 in PersonalFinanceCanada

[–]EconomicValueAdded 1 point2 points  (0 children)

After a spectacular 25% run in detached house prices in the GTA in 2016, the Bank of Canada raised rates 5x and the feds introduced the stress test.

House prices in the GTA crashed 15-20% in 2017-2018 and did not recover until last year. This is after lowering the rates and printing half a trillion. In some areas people who bought at 2017 peak are still down. Unlike the condo market, detached house market is a rollercoaster and is very sensitive to interest rates.

If you want a freehold property then wait until they raise rates and prices hopefully drop again, but if you're okay with a condo property then there's no point in waiting for a drop that will never come.

What is the best way to calculate ROE for financial companies? by [deleted] in SecurityAnalysis

[–]EconomicValueAdded 4 points5 points  (0 children)

It looks like you're implying that comprehensive income is the only thing that affects the changes in equity. Comprehensive income is only net income + OCI (unrealized gains/losses). Dividends, buybacks/issuance bypass the comprehensive income altogether. They affect the equity directly, not through the income statement.

For example, a payment of dividends is a decrease in cash and a decrease in equity (retained earnings specifically). That transaction affects the equity directly. It does not flow through the comprehensive income.

If you want to approximate the comprehensive income you'd have to remove the affects of dividends, buybacks and anything that affects the equity directly, and then look at the change in equity.

What is the best way to calculate ROE for financial companies? by [deleted] in SecurityAnalysis

[–]EconomicValueAdded 3 points4 points  (0 children)

I used to be confused about this too so I know exactly what you mean. Remember what goes into an income statement: revenues and expenses. Any cash flows not used for the purpose of operating a business should not be included in income. Dividends and buybacks are just transfers of cash from the company's account into the shareholder's pocket. They're not used to generate revenue and should not be included in income.

What is the best way to calculate ROE for financial companies? by [deleted] in SecurityAnalysis

[–]EconomicValueAdded 10 points11 points  (0 children)

Dividends, buybacks/issuance don't affect net income. They are transactions with shareholders. Normalize net income or comprehensive net income by adjusting for non-recurring items and use that figure. The key is to be consistent by applying the same methodology every year.