Would You Recognize a Financial Scam If It Didn’t Ask for Money?

Many financial scams today do not look like scams at all. Fraudsters often use familiar tools, polite language, and simple requests, which is why many people fall for them. Some of the most effective scams never ask for our password, Social security number, or money at first. They seem harmless. But the information collected can later be used to open the door to fraud.

Let’s see how this unfolds. 

As we open our computer, we receive the following message. 

At first glance, there is no request for passwords or money. The message feels urgent but not dramatic. Still, it suggests serious consequences if we don’t act. 

It seems reasonable enough, so we submit the form. No losses today. 

The harm comes later. 

Armed with our personal information, scammers can now target us more precisely and effectively. Fraudsters constantly collect and sell lists of potential victims. Once we fall for a minor scam, we may be added to what are known as “mooch lists” and targeted repeatedly. 

Soon after, we receive a follow-up from someone pretending to be our bank, credit card company, or government agency. Scammers can “spoof” phone numbers: the caller ID can say the call or text is from a bank, even if untrue. This second contact feels even more convincing, because it includes our name and account type and appears to be a logical continuation of the first message. We are urged to confirm account numbers, move money to a “temporary” account, or receive a one-time passcode sent to our phone. At this stage, real money is often lost.

What’s especially concerning is how easy it is to create a convincing scam. Would you have known we created the form in Google Forms in under five minutes? It uses no malware, is hosted on a trusted platform, and asks for “harmless” information that can later be exploited. Now imagine what more advanced technology can do to make scams look even more official. 

Who is Affected?

While financial scams affect anyone, older adults (ages 60 and over) tend to report higher median losses than younger age groups. Why do older adults tend to be targeted? 

The Federal Bureau of Investigation (FBI) highlights several reasons: 

  • Seniors usually have money saved up.
  • Seniors tend to be trusting and polite. 
  • Seniors may be less likely to report fraud, because they don’t know how or feel embarrassed at being scammed. 

A Scientific American article also explains that artificial intelligence (AI) has worsened senior fraud. Scammers now use AI to manipulate voices, videos, photographs, and documents, making scams far more convincing. 

Social isolation can also play a role. Losing a spouse or divorce may leave some older adults without support systems or skills their partners once handled. 

How Much is Lost?

According to the Federal Trade Commission (FTC), seniors who reported fraud lost $2.4 billion in 2024 — up from $600 million in 2020, a four-fold increase. 

Even more troubling, the FTC believes actual losses are far higher because most fraud goes unreported. Estimates range from $10 billion to $80 billion annually.

This problem is devastating to anyone, but especially to seniors, who may not be able to earn back what they have lost. 

How is This Happening? 

There are many ways seniors are being scammed.Here are a few common: 

  • Business Impersonator Scams: A caller claims to be from a well-known company and demands payment for a subscription renewal using gift cards. Or someone posing as Amazon or a bank claims there is a fraudulent charge and instructs you to move money to a “safe” account, which actually belongs to the scammer. 
  • Government Impersonator Scams: A fraudster claims to be from the Social Security Administration and says your Social Security number has been suspended because of suspicious activity. The scammer demands immediate payment through gift cards or wire transfers to avoid arrest. 
  • Grandkid and Family Scams: A scammer impersonates a grandchild or relative in distress and urgently asks for money often through gift cards or wire transfers, which do not require identification. 
  • Investment Scams: You are invited to a “free lunch” seminar, where scammers pose as  financial advisors. They promise high returns on “safe” or exclusive investments that may be fake, unethical, or impossible to exit without heavy penalties. 
  • Tech Support Scams: A pop-up claims your computer is infected with a virus. The scammer asks for remote access to “fix” the problem and then demands payment or installs malicious software to steal login information. 
  • “You’ve Won” Scams: You are told you won a prize, but must first pay fees for taxes, shipping, or processing. No prize ever arrives, and scammers often continue requesting more money. 

Investment scams, business impersonation, and government impersonation scams account for the highest reported losses among older adults. Other common frauds include charity fraud, health insurance fraud, home repair scams, identity theft, job scams, romance scams, and unwanted calls and texts. 

Why This Issue Hits Close to Home

Our family has been living in Rancho Palos Verdes, California (RPV) for the past five years. Recently, we heard several elderly friends had been targeted by financial scammers. As we looked deeper, we realized that fraud against seniors is an important and growing problem, especially in our community. 

Based on data from the U.S. Census Bureau, roughly 33% of RPV residents are 60 years and over. In other words, one in three residents in our community is a senior. 

This is significantly higher than the national average. While about 18% of U.S. residents are 65 or older, approximately 26% of RPV residents fall into that age group. 

Unfortunately, there is no local fraud data published for RPV. But can we estimate how many seniors in our community experienced fraud? Yes. A spreadsheet, along with a few other pieces of data, can lead us to an estimate! 

RPV has about 40,000 residents, and one-third or approximately 13,333 people are over 60 years old. According to a national survey, 5.4% of seniors experience financial fraud each year. Applying that rate locally suggests that roughly 714 seniors in Rancho Palos Verdes may experience fraud annually (13,333 x 5.4%). 

But this is only a starting point.

Given what we know about our community, we can adjust the national rate modestly up or down using widely-accepted indicators: age composition within seniors, financial exposure, and technology exposure.

Cast your eyes on the table below.

IndicatorImpactRPV Reality
Age composition among seniorsolder cohorts have higher fraud vulnerabilityOlder-than-average senior population
Financial exposurescammers tend to target those with higher assets Above-average household wealth
and high homeownership
Technology exposuremore tech exposure means more scam opps (e.g., phishing)High broadband access, smartphone, and email use

For each indicator, we ask a simple question: Is RPV lower, about average, or higher than the U.S. overall? Given an older than average senior population, above-average household wealth, and high smartphone usage and broadband access, RPV likely falls above the national average for each measure.

To reflect our community’s older age profile, higher asset levels, and greater technology exposure, we apply a modest vulnerability adjustment of 5% for each proxy. We combined these adjustments conservatively and rounded down to avoid overstating risk. This approach follows standard practice when local outcome data is unavailable and results in a vulnerability multiplier of 1.15.

Using this multiplier, our adjusted estimate suggests that over 820 seniors in our community may experience fraud each year.

Feel free to use this same spreadsheet to estimate senior fraud in your own community. Save a copy to your Google drive and edit the yellow-shaded input boxes for population and percentage of seniors. We found these statistics on the U.S. Census Bureau Quick Facts site. 

Awareness is the First Step toward Prevention

Can we reach these 700 to 900 seniors in our community before it is too late?

Scams succeed when people feel rushed, scared, or uninformed. The good news is that awareness can interrupt that cycle. Staying informed about common scam tactics is one of the most powerful defenses we have. As Francis Bacon once said, “Knowledge is power.”

The U.S. Department of Justice maintains a list of trending elder fraud threats to help people recognize financial exploitation. But information alone isn’t enough—it has to be shared.

If you receive a message like the one at the start of this article, stop, think, and verify. Be suspicious of “phishing,” which happens when you receive an email that looks reputable but asks you to call a fraudulent number, respond to the email, or go to a website and enter personal information. You might even be asked to look at an attachment, which then gives scammers access to your computer if you open it.

Train your eye to notice red flags:

  • Vague language (“your account,” “our system”)
  • Urgent deadlines
  • Requests for personal information
  • Links asking you to “verify” or “confirm”
  • Messages that don’t address you by name
  • No clear way to independently verify the sender

When in doubt, lean toward caution. If you never initiated the contact, do not click, reply, or enter any information, even if the page looks professional. 

Be vigilant if you receive a call from a “bank representative” who says you need to send money to another account via a wire transfer to reverse fraud on your account. A bank would never ask you to send money to yourself. When in doubt, hang up and call your bank directly using the number on the back of your card or account statement.

If you see a pop-up message or locked screen, shut down your device and enable pop-up blockers. When you need to check an account, go directly to the organization’s official website, or call a number you already trust.

Protecting Our Community Starts Now

Financial scams are no longer rare or obvious. They are designed to blend into everyday life. But awareness spreads faster than fraud when communities talk openly and look out for one another. Share what you learn. Stay curious. Check in on those around you.

Fraud prevention does not require advanced technology. It starts with simple conversations, trusted relationships, and a willingness to pause and verify. Together, let’s make our community a harder target for fraud.

How a 6% mortgage rate should affect home prices

Today’s post will be an application of our 2019 house rent vs. buy spreadsheet. With the recent jump in mortgage rates to near 6%, we wonder how much house prices are supposed to be down (in theory) if a buyer were perfectly rational and would demand the same internal rate of return from their housing purchase decision.

We’ll pull up our mortgage spreadsheet and enter in some very average metrics for the US:

Home price: $375k, Median rent: $1,800/month, time spent in house before selling: 8 years, rent and other cost inflation: 3.5%, down payment: 20%

We’ll start our mortgage rate at 3.5%, and found the IRR to be 8.12%.

With a mortgage rate of 6%, in order to keep the IRR of buying the house at 8.12%, the house price would have to be $283,430, which is 24% less than the original house price!

A 2019 update of our House Rent vs Buy IRR Spreadsheet

This post will be a quick update to our original buy vs. rent spreadsheet post, given changes in the economics of housing due to the Tax Cuts and Jobs Act from late 2017. First, a quick review of how the original sheet worked: we had taken the main costs and benefits of home ownership as inputs and calculated what IRR you effectively were earning on your down payment:

Major changes to the spreadsheet include:

1. Mortgage interest is now only deductible for the first $750k. We adjust the formula for the tax benefit of the mortgage interest deduction to include an if statement that checks if the mortgage balance is above $750k. If so, the tax benefit is limited to deducting interest on the $750k.

2. The value of the property tax deduction is likely lower due to the cap on state, local, and property tax deductions at $10k.

3. The standard deduction is much higher: $24k for a married couple for 2019 versus $12,700 in 2017. This makes it more likely people end up just taking the standard deduction, which means the property tax deduction is not used, or could make the part of the mortgage interest that is under the $24k cap not useful.

We’ll work on both of these problems together, with some simplifying assumptions. First, we’ll ask users to input their income, average tax rate, and other federal tax deduction items (charitable giving, etc), and whether they are married. This will give a sense of whether they were already at the $10k SALT cap, and therefore implies the property tax deduction wouldn’t be worth anything to them. Also, only the portion of the mortgage interest that puts the user above the standard deduction is worth anything, so we add that logic in as well:

(36 hours later…)

Okay, we kept running into complicating factors, and the formulas we’re now using for the mortgage and property tax deductions have gotten very convoluted (check out the formula below that calculates what portion of the mortgage interest deduction is not really a marginal benefit because it was needed to put you over the standard deduction). Here’s what we have, rather than try to explain it step by step, try walking through it yourself, or if you have a better solution, let us know!

Check out the spreadsheet here: home buy vs rent complex 2019 update

How much “should” house prices be down in California?

An application of our IRR based Buy vs Rent spreadsheet

Based on a casual look at the economy, things are going pretty well –  unemployment is down and GDP growth is strong. So it would seem to make sense that U.S. home prices are up about 3.5% so far this year, right?

But if we rewind the clock by a year, many of the economic factors involved in owning a home in the U.S. have gone the wrong way:

Let’s use a spreadsheet to compare the values of three hypothetical houses in California – today versus from one year ago – based on changes in mortgage rates, marginal tax rates, and mortgage interest deductibility requirements.  Continue reading “How much “should” house prices be down in California?”

Prom Draft: NO. Prom Match: YES! (Residency Match Algorithm Spreadsheet)

Back in 2014, a group of male students had the creative but misguided idea of holding a prom draft to select dates for prom, a formal dance typically held at the end of high school. The very obvious problems involved having payments for high draft picks and taking the girls’ preferences out of the process.

With that in mind, we thought instead of a Prom draft, why not organize a Prom match? The matching system for medical residency has been in place since 1952, and even led to a Nobel Prize. In the residency match system, each applicant ranks his or her acceptable choices, and each school ranks its acceptable residents. Then the algorithm attempts to make the best or most optimal matches, among all parties.

So, let’s dive into how we can create a spreadsheet that optimizes students’ date preferences for prom. Continue reading “Prom Draft: NO. Prom Match: YES! (Residency Match Algorithm Spreadsheet)”

Make a Group Brainstorming and Idea Ranking Google Spreadsheet

Often, we find ourselves in a group meeting where we have to come up with new ideas and then choose the best one. For example…

1) A speaker is coming to talk to a group, but only has time for the best 5 questions from the group.

2) A team of journalists gives story ideas for next week’s magazine. Or a team of comedy writers throws out sketch ideas for next week’s show.

3) A group of friends comes up with ideas for their next business venture.

We’ll use #3 as our example. We use Google Spreadsheets for this project, because Google Spreadsheets easily allows multiple people to edit the same spreadsheet at the same time.  Continue reading “Make a Group Brainstorming and Idea Ranking Google Spreadsheet”

Will the Tax Cuts and Jobs Act make you pay more or less in taxes?

House and Senate Republicans have passed a major tax bill. It makes big changes to how the government taxes its citizens. Most notably, corporations and some individuals will pay less tax (corporate rate lowered to 21%, lower individual brackets, higher standard deduction), but many deductions like the state and local deduction and personal exemption will be limited to pay for it and the deficit will likely go up.

How would this affect you? Is the backlash against certain Republican lawmakers in high tax states like California fair? Do I sense a spreadsheet in the making? After 3 prior tax posts including How to Estimate Taxes, a Marriage Tax Penalty Calculator, and an analysis of the Trump Tax Plan, you would think we had suffered enough…but here we go!

Sneak Peak – Our results indicate that married Californian homeowners making under about $700k are better off under the new plan, while those making over $700k are worse off. Disclaimer – this is really complicated, we might have made some errors (please let us know if you see any), and your mileage may definitely vary:

Continue reading “Will the Tax Cuts and Jobs Act make you pay more or less in taxes?”

How to compare rewards credit cards with the NPV() function

In this post, we’ll show you how to compare different credit cards that have different sign-up bonuses, annual fees, rewards, etc. We’ll use the NPV function, which allows us to compare different streams of cash flows that come at different times.

A word of caution: Our post assumes that you’ll pay off your credit card in full each month. As we mentioned in our personal finance modeling post, the rate of return earned on investments is one of the key factors in achieving long term financial independence. We assumed getting a 4% return on our investments…the average interest rate you’d have to pay on a credit card balance is 15%! That’s like having a huge negative investment, which could keep you in the poor house. Continue reading “How to compare rewards credit cards with the NPV() function”

What’s the expected value of your Powerball ticket?

As the Powerball jackpot grows to over $300 million, we start to wonder if maybe buying a ticket is “worth it.” While the lottery is “worth it” in that ticket sales goes to things like state education, buying tickets is typically not worth it for yo because the projected payoff is far less than the ticket price. Continue reading “What’s the expected value of your Powerball ticket?”

How much money do you need to retire?

As mentioned before, we love browsing through the questions and answers on Quora. Every Quora session reveals financial success stories, inside views into jobs and companies, and some practical life advice.

One topic that comes up frequently is how much money one needs to stop working. That is a question that spreadsheets are well-suited to solve! Let’s build our Financial Freedom Spreadsheet Calculator. Continue reading “How much money do you need to retire?”

Build a weighted lottery spreadsheet to decide on lunch with friends

Taking a walk and grabbing lunch is one of the simple pleasures of the workday. Unless of course, you bring your lunch to work. Sometimes with a group of people it is hard to decide on where everyone should go to lunch together. Maybe only one person enjoys the guilty pleasure of Taco Bell, while the others want to stick with Whole Foods. Or maybe half of the group wants burgers and the other half pizza.

Here’s a relatively simple Google Mobile spreadsheet. It’s part 2 of our mobile phone spreadsheet series (See Part 1 on Tracking New Year’s Resolutions) that uses a weighted lottery to fairly determine where to go for lunch, taking into account each person’s individual preferences. Basically, each person gets 10 “points” to allocate to three restaurant choices. Each point is effectively a lottery ticket, and the spreadsheet randomly chooses the restaurant, with the probability weighted by how many points each restaurant has received. Continue reading “Build a weighted lottery spreadsheet to decide on lunch with friends”

Track New Year’s Resolutions on Mobile Sheets

This is the first in a series of posts focused on the Google Sheets app on our mobile phone, rather than the typical desktop spreadsheets. We use the mobile Google Sheets app to set our New Year’s Resolutions and track what percentage of days we have fulfilled our promises. Hopefully, having this tracker on our phone and nearby at all times makes it slightly easier to fulfill our resolutions! Continue reading “Track New Year’s Resolutions on Mobile Sheets”