Excel activities

/Excel activities
­

Spreadsheet Math: Two Investments Walk Into A Classroom…

Ok, not the best title but let’s run with it. Let’s start with a question:

You have a choice between two investments of $100,000:

  • Investment #1: Earns a consistent 8% return every year (put aside the fact that an investment like this doesn’t exist at the current time; it’s been a while since you could buy a 30 year Treasury Bond with that kind of return).
  • Investment #2: Has an average return of 8% per year but has “lumpier returns” aka it has more volatile returns but the returns each year are in the top 10% of fund returns. Some years it is up, some years it is down, but overall it averages the same 8% return as Investment #1.

Which investment has a higher balance at the end of the 20 year period?

NGPF is always at the ready…

You know we here at NGPF are always happy to help, which is why we didn’t think twice about responding to a unique email we received through our website. Dorothy was trying to solve a problem involving her church group: It’s got members who have joined at various points, anywhere from the past year to being a charter, founding member of the organization. They wanted to buy funeral flowers, as the members pass away, at varying price points based on length of membership. Dorothy turned to NGPF for a solution for keeping account of these flower purchases.

Now, this is not typically the type of support NGPF is in the business of offering, but, as mentioned before, we love to help! So, I created a quick spreadsheet so that Dorothy and her group can track their funeral flower spending. I love spreadsheets, so it was a perfect project for a Friday morning!

And, it ties in nicely to a little teaser promo here — NGPF surveyed earlier this year about spreadsheet usage in your classrooms, and we’ve identified it as an area where teens (and some teachers) could use a little support. That’s why one of our focuses for Spring semester will

By |December 13th, 2016|Excel activities, New Products|

NGPF: Tim Talks to Pat Page, Award-Winning Educator and Passionate Advocate for Financial Education

 6ptl3-8h_400x400

Thanks to Pat Page for the great conversation we recently had on the NGPF podcast. Pat shared her insights and expertise on many topics that financial educators will find helpful. You will learn about Pat’s approach to using technology in her classroom, teaching spreadsheets, using pithy phrases to focus student attention and telling stories that bring financial topics to life. You will also hear the inspiring story of how a group of students at her high school lobbied the Rhode Island legislature to make financial literacy a priority in the state. Enjoy!

Details:

These 16 Pages Will Teach Your Students All They Need to Know About Investing…

download-15Here’s a free (and simple) guide to investing from Dr. William Bernstein that brings some clarity to investing. The title tells it all, If You Can – How Millenials Can Get Rich Slowly (it’s really only 14 pages of text and well worth the 15 minutes). Will be a great extension activity and/or long-form reading assignment at the end of your investing unit. Here’s the tantalizing question that the booklet opens with:

Would you believe me if I told you there is an investment strategy that a seven-year old could understand, will take you fifteen minutes per year, outperform 90% of finance professionals in the long run and make you a millionaire over time?

Interactive and Activity Idea: How Worried Are You About Your Economic Situation?

From NPR:

Screen Shot 2016-03-19 at 11.09.44 PM

Marketplace has developed their own Economic Anxiety Index to go beyond the traditional economic figures you hear spouted about on a regular basis (i.e., unemployment rate, new jobs created, GDP, CPI).  After providing some identifying information (see above), the quiz asks some general questions about your financial situation (including “Do you lose sleep over your financial situation?”). It then asks some questions about your employment situation, housing, other expenses, saving for retirement, paying for college, car payments, medical bills and student loan payments (anyone anxious yet?). It then provides a great interactive you to allow the survey respondent to compare their results with others across many different dimensions.

So, while many of these questions aren’t relevant for your high school students, I thought it would be instructive for students to go through this process:

Day 9 of the 24 Hour Personal Finance Course: Creating a Monthly College Budget

Today was Day 9 of our Presonal Finance in 24 Hours course, Day 2 of Budgeting in College, and one of my favorite lessons. Go ahead and click if you want to see the whole plan, with all of the resources, but here are some of my favorite moments I’d like to highlight:

Day 8 of the 24 Hour Personal Finance Course: Big Picture College Budget

First off — it’s Jessica, not Tim. While Tim taught the month of February at Eastside College Prep (in East Palo Alto, CA), I’m doing March, when we’ll cover budgeting and credit. So, I’m going to write the post-course updates, but I’m MUCH less prolific a blogger than Tim, so expect less.

My budgeting unit is two instructional days plus the case study, so today we did the big picture, semester-level budget. So, not so much, “How much are you spending on toothpaste?” but “You’re gonna need some money for miscellaneous expenses…”

Here’s the lesson plan I put together, with all the links to resources. I will say that resource 6, “Unanticipated Budget Changes” relies on a correctly completed spreadsheet from resource 5, “Three Students Budget for the Semester.” And not all of my students were able to finish resource 5 in the allotted time, so I skipped resource 6 altogether. In retrospect, I should have let the few students who did move quickly self-pace onto resource 6 themselves for an extra challenge. That said, I think resource 5 is EXTREMELY valuable as some students were confused by even categorizing items as “income” or “expenses,” and, at a higher level, the

The $1 Million Bet: An Index Fund vs. The Best Stock Pickers

This Planet Money podcast: Brilliant vs. Boring (21 minutes) will engage your students and deepen their understanding of the philosophies underpinning active vs. passive management.

Here’s the teaser: