Please do not post in this thread. If the thread is open to posts, its because I'm working on it.
All of the cash back excel spreadsheet images are calculated without consideration for sign up bonuses, if any. Sign up bonuses change frequently, and selecting cards based on sign up bonuses is not the purpose of these calculations.
If there are mistakes or omissions, please send me a private message.
Latest additions:
1) Add FICO 9 providers to Free Credit Scores chart
Previous additions:
1) Add PCMCU to Non-Category spend cards
2) Add Paypal Cashback to Non-Category spend cards
3) Add RBFCU Cashback to Non-Category spend cards
This is a comparison to show earning potential of the Wells Fargo Propel 365 card.
This is a list of co-branded Bank of America cards for various Colleges.
Alpha Omicron Pi Fraternity (world points)
Alumnae Association of Smith College
Alumni Association of the University of Michigan
Alumni Association of the University of Virginia
Arkansas Alumni Association
Association of Former Students of Texas AM University
Auburn Spirit Foundation
Brandeis University
Brown Alumni Association
California Alumni Association
Catholic University of America Alumni Association
Central Michigan University (world points)
Clemson Alumni Association
College of the Holy Cross General Alumni Association
East Carolina University Alumni Association
Florida Atlantic University National Alumni Association
Florida International University Foundation
Fordham University
General Alumni Assoc of Univ of N Carolina at Chapel Hill
Georgetown University Alumni Association
George Washington Alumni Association
Georgia Southern University Foundation
Howard University Department of Alumni Relations
Indiana University Alumni Association
Iowa State University Alumni Association
Johns Hopkins Alumni Association
LaSalle University Alumni Association
LSU Alumni Association
Mississippi State University Alumni Association
Mizzou Alumni Association
Missouri State University
New Mexico State University Alumni Association
New York University Alumni Association
Northeastern University
Oswego Alumni Association
Penn State Alumni Association
Phi Theta Kappa International Honor Society
Seminole Boosters
Sigma Theta Tau International Honor Society of Nursing
St John's University New York
Stanford Alumni Association
State University of Iowa Alumni Association
Temple University
Texas State Alumni Association
UB Alumni Association
UCLA Alumni Association
University of Arizona Alumni Association
University of California Irvine Alumni Association
University of Central Florida Alumni Association
University of Colorado Boulder Alumni Association
University of Delaware Alumni Association
University of Georgia
University of Houston Alumni Association
University of Miami
University of Minnesota Alumni Association
University of Missouri Alumni Association
University of New Hampshire Alumni Association
University of New Mexico Alumni Association
University of Northern Iowa Alumni Association
University of Notre Dame
University of Pennsylvania - Wharton
University of Scranton Alumni Association
University of Southern California
University of Southern Mississippi Alumni Association
University of Texas Ex Students Association
University of Virginia Alumni Association
Wake Forest University
Washington State University Alumni Association (Alaska Airlines)
Washington State University Alumni Association Cash Rewards
William and Mary Alumni Association
Others
American Association of Family Physicians
American Association for Justice
American Bar Association travel rewards
American Institute of CPAs (World Points)
American Psychological Association
American Society of Civil Engineers
American Society of Mechanical Engineers
American Society of Radiologic Technologists
American Student Dental Association
American Veterinary Medical Association
Asiana Airlines american express
Azamara Club Cruises (MyCruise points)
Bass Pro Shop 5% cash back
California Teachers Association
Celebrity Cruises (MyCruise Points)
Connecticut State Dental Association
Golden Key International Honour Society
Interval International (World Points)
Maryland State Dental Association
National Children's Cancer Society
National Trust for Historic Preservation
New York Yankees + authentic stadium dirt...
Norwegian Cruise Line (World points)
Royal Carribean International (MyCruise Points)
Spirit Airlines 2X miles
Texas Rangers + authentic stadium dirt...
Here is a link to an AAoA calculator Excel spreadsheet I created:
https://drive.google.com/file/d/0B5Sv0qIpc3ULXzJUU3BNaXllcVk/view?usp=sharing
I'm hosting the file on Google Docs, but it is written in Excel, so download the file after clicking on that link.
Currently it contains sample data from some of my cards.
Open Date is the date the card/loan was opened. You can enter future cards/loans that you have not actually obtained yet.
Todays Date column is whatever date you want to calculate the AAoA for, just edit the first date as all the others auto fill from that one.
Drop Date is the date the credit card/line will drop off of your credit reports. Leave it blank if the card is staying open indefinitely. Positive trade lines usually drop off 10 years after being closed, and Negative trade lines drop in 7 years. So, you may have to estimate this date.
So, you can have credit lines that will fall off your credit reports on a certain estimated date, and you can have new cards that will be opened at a future date, if you want. This also means that you can set Today's Date to be sometime in the past, and cards that haven't been opened yet will be ignored in the AAoA calculation. Once your cards data is in the spreadsheet, just change Today's Date to calculate a new AAoA.
Just don't set Today's Date to a time before you had any credit at all...