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 much is your low interest rate mortgage worth?

One of the ideas floating around lately is that if you were lucky enough to secure a low interest rate, it is actually a hidden asset in your net worth.

Of course, it’s a little more complicated than that, for example if you move/sell you have to repay your mortgage and that asset would disappear, which is not what typical assets actually do.

But let’s have some fun for a moment and pretend that by borrowing at a low rate we have effectively shorted a 30 year bond, and see how much value we have generated by this trade.

We’ll repurpose our debt amortization spreadsheet from an earlier post.

All we need to do now is to to add a few additional inputs – how many years are left on the mortgage, and what the current mortgage rate is. We’ll then calculate the net present value of the remaining mortgage payments for each year using the current mortgage rate as the discount rate. The difference between that NPV and your mortgage principal is the “asset value”. 

In this example, in year 5 on an original $500k mortgage at 3.25%, the “asset value” of keeping this mortgage when the current market mortgage rate is 7.9% is $170k!

You can play with the Google Spreadsheet here

Spreadsheetsolving.com’s compilation of free, customizable, printable math worksheet generator spreadsheets

With summer starting, we thought it would be helpful to put all of our math worksheet generator spreadsheet posts into one (somewhat) organized list. We’ve been creating these spreadsheets over the past three years to help supplement math learning for our own kids.

Note that all of these spreadsheet generators are done in Microsoft Excel. In order to use the free Google Sheets software, you can download and save the .xlsx file onto your computer, go to Google Sheets, and then hit File->Import-> Upload, and select the file. It might need some minor formatting/fitting to print.

Math Worksheets

General Math Worksheet generator – allows parent to set the maximum number size, and what operation, generates a random math worksheet: random math worksheet

Fill in the blank Math Worksheet generator – similar to the prior math worksheet, but instead of figuring out the sum in a standard (addend + addend = sum) problem, one of the three is randomly blank and the student fills in the blank: Math Worksheet generator

Division Math Worksheet generator – the logic and format for a division math worksheet generator was slightly different from the previous: Division Math Worksheet

Addition and Subtraction Math Facts speed spreadsheet – similar to the general purpose spreadsheet but designed to be a speed test of addition and subtraction math facts: Addition and Subtraction Math Facts Speed Worksheet

Number sequence pattern math worksheet generator – here you have a sequence of numbers and can choose spacing, number size, number of blanks for the student to fill out: Number Sequence Pattern Math Worksheet

Math Dice style worksheet – students try use math functions on the randomly generated input numbers to get to the answer number: Math Dice Worksheet

Practice with time math worksheet generator: Time Math Worksheet

Math word problem worksheet generator – this one is a bit crude, but perhaps someone could expand upon it: Math Word Problem Worksheet

Printable Flash Cards

General Purpose Flash Cards with user input and double sided printing: https://spreadsheetsolving.com/create-and-print-physical-flash-cards-with-this-microsoft-excel-template/

Addition and subtraction with math facts under 20 – Here we use our general purpose flash cards spreadsheet and enter in some math facts that students should have memorized: https://spreadsheetsolving.com/printable-math-facts-flash-cards-for-single-digit-addition-and-subtraction-with-carrying/

Multiplication Flash Cards: https://spreadsheetsolving.com/printable-multiplication-flash-cards-spreadsheet/

Division Flash Cards: https://spreadsheetsolving.com/printable-division-facts-flash-cards-spreadsheet/

Printable division facts flash cards spreadsheet

Today’s post is another extension of our series on flash cards. Since we made our multiplication flash cards last, the division flash cards were easy to make by reversing the multiplication answers:

We basically need double the flash cards since 20 divided by 5 and 20 divided by 4 are two different problems, whereas 4×5 and 5×4 are effectively the same.

Download the printable division flash cards spreadsheet here:

Printable Division Math Worksheet Generator Spreadsheet

Today we’ll build a dedicated division spreadsheet, where we set parameters for the problems and print an unlimited number of different division worksheets.

The inputs we’ll allow the user to enter are the maximum dividend (number to be divided) size, the maximum divisor, and whether or not we want to have the answers be able to have remainders.

So if the user selects yes or “y” for the remainder, the problem is relatively simple – we’ll have a random number for the answer between (1,100) for the dividend, and then a random number between (1,10) for the divisor.

If the user selects “n”, we’ll have a random number between (1,10) for the divisor, and then a random number between 1 and the max dividend/current divisor for the answer, then we’ll multiply the answer by the divisor to get the dividend.

Here’s how it looks like in full:

You can download the printable Microsoft Excel file here:

Printable time and clock math worksheet generator

Today’s printable math work sheet generator will center around the concept of time.

We’ll have two types of questions – one will ask the student to draw in the hands on a blank clock face for a random time. The other type of question will be a word problem that provides a start time and a time increment and asks the student to calculate the finish time. We would have loved to generate a random clock face time and ask what time it is but that turns out to be incredibly difficult in a spreadsheet.

To create the random times, we use the formula =RANDBETWEEN(1,12) for the hours, and then =RANDBETWEEN(0,59) for the minutes, then use the formula =TIME(hours, minutes, 0 seconds) for the time to display. We also added in some logic to allow for the times to round to 5’s if the user puts in a “y” in cell E2.

Check out the spreadsheet here:

Here’s how the final product looks:

Printable Multiplication Flash Cards spreadsheet

Today’s post is another extension of our very flexible Printable Flash Card Generator Spreadsheet. We plugged in the single digit multiplication combinations from 2-9 into the second sheet. To print the cards, print the first sheet two-sided, flip on the long edge, then cut the cards out.

Download the printable multiplication flashcard spreadsheet here:

Build a T-Ball or Softball lineup and positions generator

This season marks my youth softball coaching debut, an opportunity to impart my likely outdated baseball knowledge on a group of 5 and 6 year old girls. Beyond trying to stay positive and excited for an hour plus, the main challenge of coaching is organizing all the various tasks that come up.

One such task is setting a weekly lineup, which requires setting a batter order and assigning fielding positions by inning.

Some of the key rules that we’ll want to implement in the lineup:

  1. Randomize the batting order each week.
  2. Rotate the players on defense so that players don’t spend two innings in a row in the outfield, and the choice spots (pitcher, 1B) get fairly distributed.

Spreadsheet Logic

First we enter in all the names of the girls on the team, and for each week, we’ll assign a random number 1-10 which will be their spot in the order:

Then we can put them in order using Index(match):

Then we want to set up a rotation for the field – we use two columns, with the right column showing what position they will play after playing the left column. Players will rotate from LF to 3B to LCF to SS to RCF to 2B and so on:

We’ll then set the positions for the first inning, then for each subsequent inning, we’ll lookup the next position from the table above with vlookup:

And that’s the spreadsheet, you can check it out here: Softball Lineup Generator

To save a copy, go to File –> Make a copy

Addition and Subtraction Math Facts Speed Worksheet

Today’s post will be another variation of our generic Math Worksheet Generator that we’ve posted before. This worksheet will give students the opportunity to practice their addition and subtraction math facts, so that eventually  things like 9+7 = 16 and 17-9 = 8 will come more quickly.

For the subtraction facts spreadsheet, we made the first number a random number between 11 and 18, and the second number a random number between the first number minus 9 and 9, in order to make the answer a single digit math fact.

For the addition spreadsheet, we made the answer a random number between 11 and 18, and then hid it, then filled in the two addends with one random number and then the answer minus the random number.

Check out the spreadsheet here. We’d also recommend using a stopwatch to help students try to increase speed: Addition and Subtraction Speed Worksheet

Dave and Busters breakeven tickets per chip under different chip cost and ticket value scenarios

Today we’ll continue with the theme from our last post on a Google Sheet Dave and Busters profitability tracker. One frequent question that arises in the Dave and Busters Reddit forum is: How many tickets does one need to be winning to be “profitable”?

The answer is usually some combination of “it depends”; it is based on chip cost and ticket value (and perhaps some mentions of finger traps, etc.).

To solve this problem, first we enter a formula for the breakeven tickets given a value/ticket and cost/chip. With some simple algebra, we find that:

breakeven ticket/chip = (cost per chip) / (value per ticket)

Here’s that depicted in spreadsheet form:

Next, we’ll make a data table which inputs various different costs per chip (based on the different price points of the tickets that are offered), and various different values per ticket. The output is this nice table below:

We can confirm we’re only an “advantage player” when it comes to redeeming for burgers and churros for ourselves at 10 tickets per chip breakeven.

Download the Excel spreadsheet here: Dave and Busters ticket breakeven calculator

You can also enter your own values in the Cost per chip (cells B26: B35) and Value per ticket (cells C25: J25).

Build a Dave and Busters tracker for chips spent, tickets earned and “profit”

This simple Google spreadsheet will help you keep track of your Dave & Busters visits and whether they were “profitable”.

Growing up, the local Tilt arcade was one of my favorite places to spent a weekend afternoon. As an adult, I remember being intrigued by an article on advantage players at Dave and Busters – people could win enough tickets to carve out some nice side income.

How many tickets do you need to win per credit played in order to be an advantage player? Today’s spreadsheet will solve that problem!

First, calculate what tickets are worth

We can figure out what tickets are worth by taking the value of a prize and dividing by the number of tickets. A YouTube tour of the Dave and Busters Ontario location from Arcade & Travel Adventures shows the prize center, which has an Oculus Quest 2 for 130k tickets, Airpods pro for 75k tickets.  Amazon has the Oculus Quest 2 for $400 and Airpods pro for $180.  The Oculus implies each ticket is worth 0.308 cents and the Airpods imply each ticket is worth .024 cents.

Next, calculate the cost of chips

The best deal appears to be paying $100 to get 750 chips.  This would result in a cost of about 13.3 cents per chip.

Finally, create the tracker

Our tracker will just be a simple ledger – the user will enter the date, the number of chips spent, and the number of tickets won. The spreadsheet will then calculate the value of the chips spent, the value of the tickets won, and the theoretical profit from the session. Over time by keeping track of all the sessions played, you can find out if you are profitable. Here’s how it looks, including one of my sessions at D&B where I “made” negative $7.88. Oh well, we’ll stick to the spreadsheets.

Check out the spreadsheet here: Dave and Busters Google spreadsheet tracker

Note: You can click File –> Save a Copy to save a copy for yourself to use.

Note 2: It looks like it takes about 43-44 tickets per chip in order to be “profitable” with the Value/ticket around 0.3 cents and Cost per chip around $0.13.

Create a customizable and printable check-off calendar spreadsheet

Now that are kids are getting older, we want to start getting them into good daily habits. This usually requires quite a bit of encouragement / threatening, but what might work best at the end of the day is bribery.

We created this customizable check off calendar that allows the user to pick their “tasks”, the number of days (up to 30), and the prize (we recently introduced our kids to Dave & Busters and they love it). The spreadsheet then lists the tasks with a check box for the number of days selected. The key logic here was the IF() Function.

The spreadsheet can be downloaded here. Enjoy! Habits Calendar Spreadsheet