Credit Cards Center Credit cards from our partners
Reply
Frequent Contributor
Posts: 348
Registered: ‎08-17-2012
0

Re: How To Determine AAoA?


Wolf3 wrote:

Equifax CR shows AAoA.    The others do not.

 

It is calculated on all accounts (open and closed).


Does eq backdoor show aaoa? Or just myFico report?

EQ 778 | TU 776
Barclay US Airways WMC 7.5k | BCE 5.8k | BofA Travel Rewards 9.1k | Chase Marriott Premier 13k | Citi TYP WMC 6.5k | Freedom Visa Sig 8k| Discover it 10k
Senior Contributor
Posts: 3,322
Registered: ‎05-05-2011
0

Re: How To Determine AAoA?

AAoA includes ALL accounts -- open or closed -- that appear on your CR. So, in effect, you have to calc your AAoA separately for each CRA, unless you happen to have all 3 exactly the same.

 

Here's an Excel s/sht that was posted by another poster at an earlier time. I just cut and pasted it into Excel and it has worked for me just great. Here's the post that I saved:

**********************************************

 

I had some spare time so I decided to create an Excel spreadsheet to keep track of my credit accounts (CC's, loans, etc) and it turned out quite nice.  The way I have it set up is that after inputting the CC information (e.g., opening date, balance, CL), the "Age" and "Util" values will automatically be generated.  Also, the formulas toward the bottom of the sheet calculate overall util four different ways (util across all accounts open and closed, util on all open accounts, util on all open and closed revolving accounts, and util on only open revolving accounts).  Also, oldest account age and AAoA are calculated and displayed in months and years.

 

Rather than emailing the spreadsheet, I have copied the formulas in a Microsoft Excel 2007 format and pasted them below.  You should be able to copy and paste the below information directly into Excel 2007 (I don't know if it will work on earlier versions).  When you first paste it into Excel, it will look pretty funky, but if you click the clipboard icon that appears at the bottom right corner of the area you pasted and click "Match Destination Format", it should look much cleaner then.  For the final touches, you'll want to change the format of the "Date Opened" column to a month/year format and then change the "Util" column to a percentage format (right click the top of the column and select "Format Cells").

 

 

Account Name

Date Opened

Age

Balance

Limit

Util

Type

Status

card

40645

=IF(B2<>"",(TODAY()-B2)/31, "")

284

3900

=IF(E2<>"", D2/E2, "")

Revolving

Open

card

38443

=IF(B3<>"",(TODAY()-B3)/31, "")

0

12500

=IF(E3<>"", D3/E3, "")

Revolving

Closed

card

39173

=IF(B4<>"",(TODAY()-B4)/31, "")

0

5500

=IF(E4<>"", D4/E4, "")

Revolving

Open

card

39753

=IF(B5<>"",(TODAY()-B5)/31, "")

0

4000

=IF(E5<>"", D5/E5, "")

Revolving

Closed

card

39814

=IF(B6<>"",(TODAY()-B6)/31, "")

0

5850

=IF(E6<>"", D6/E6, "")

Revolving

Open

card

38657

=IF(B7<>"",(TODAY()-B7)/31, "")

0

2900

=IF(E7<>"", D7/E7, "")

Revolving

Open

card

38657

=IF(B8<>"",(TODAY()-B8)/31, "")

0

2900

=IF(E8<>"", D8/E8, "")

Revolving

Open

card

38657

=IF(B9<>"",(TODAY()-B9)/31, "")

0

3900

=IF(E9<>"", D9/E9, "")

Revolving

Open

card

40026

=IF(B10<>"",(TODAY()-B10)/31, "")

0

6000

=IF(E10<>"", D10/E10, "")

Revolving

Closed

card

40391

=IF(B11<>"",(TODAY()-B11)/31, "")

8500

8500

=IF(E11<>"", D11/E11, "")

Installment

Open

 

 

=IF(B12<>"",(TODAY()-B12)/31, "")

 

 

=IF(E12<>"", D12/E12, "")

 

 

 

 

=IF(B13<>"",(TODAY()-B13)/31, "")

 

 

=IF(E13<>"", D13/E13, "")

 

 

 

 

=IF(B14<>"",(TODAY()-B14)/31, "")

 

 

=IF(E14<>"", D14/E14, "")

 

 

 

 

=IF(B15<>"",(TODAY()-B15)/31, "")

 

 

=IF(E15<>"", D15/E15, "")

 

 

 

 

=IF(B16<>"",(TODAY()-B16)/31, "")

 

 

=IF(E16<>"", D16/E16, "")

 

 

 

 

=IF(B17<>"",(TODAY()-B17)/31, "")

 

 

=IF(E17<>"", D17/E17, "")

 

 

 

 

=IF(B18<>"",(TODAY()-B18)/31, "")

 

 

=IF(E18<>"", D18/E18, "")

 

 

 

 

=IF(B19<>"",(TODAY()-B19)/31, "")

 

 

=IF(E19<>"", D19/E19, "")

 

 

 

 

 

 

 

 

 

 

 

 

=IF(B21<>"",(TODAY()-B21)/31, "")

 

 

=IF(E21<>"", D21/E21, "")

 

 

 

 

=SUM(C2:C21)

=SUM(D221)

=SUM(E2:E21)

=AVERAGE(F2:F21)

(all accounts)

 

 

 

 

 

 

=AVERAGEIF(H2:H21,"Open",(F2:F21))

(all open accounts)

 

 

 

 

 

 

=AVERAGEIF(G2:G21, "Revolving", F2:F21)

(all revolving)

 

 

 

 

 

 

=AVERAGEIFS(F2:F21, H2:H21, "Open", G2:G21, "Revolving")

(open revolving)

 

 

 

 

 

 

 

 

 

 

 

=MAX(C2:C21)

Oldest (in months)

 

 

 

 

 

 

=C22/COUNT(C2:C21)

AAoA (in months)

 

 

 

 

 

 

=C27/12

Oldest (in years)

 

 

 

 

 

 

=C28/12

AAoA (in years)

 

 

 

 

 

 

NOTE: For the overall util formulas to calculate correctly, the value under the "Type" column should be either "Revolving" or "Installment" and the value under the "Status" column should read either "Open" or "Closed".

 

I thought this would be helpful to others so I'm just passing it along.  Let me know if you have any problems getting it to work.

 

~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*
EQ FICO 750 | TU FICO 761 (Walmart) | EX FAKO 767 | Goal: 800+

Edits, funky spacing and spelling due to my iPad not getting along with the forum editor!

Valued Contributor
Posts: 2,299
Registered: ‎07-23-2012
0

Re: How To Determine AAoA?

what is the opening date? 40645? 

 

like for example july of 2012? what would i put in? 

Current: Discover Fico 709 3/15 Walmart Fico 743 4/15

Inquiries (24 Months): EQ 6 TU 1 EX 6 | Most Recent: 4/09/2015
Over 12 Months:9


2015 Goals:
Lower Utility
Earn Cash Back

Amex Zync(Unicorn)
Chase Freedom$1500
Discover IT$7,400
Citi DC $10,000
Citizens Mastercard$7,000
Senior Contributor
Posts: 3,322
Registered: ‎05-05-2011
0

Re: How To Determine AAoA?

I didn't make the s/sht. All I did is copy and paste the OP and it has worked just the way it was in Excel. The only thing I did was to add my CC names in the left column and the acutal date they were opened in the appropriate column. The age automatically calculates based on today's date, which is in the formula somewhere. The other thing you need to do is note in the right col if an acct is open or closed, since that affects the formula somehow.

 

I always put the month/date/year. So, for July 2012, I would put 7/1/12, since AAoA is calc based on entire month.

 

 

 

 

 

~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*
EQ FICO 750 | TU FICO 761 (Walmart) | EX FAKO 767 | Goal: 800+

Edits, funky spacing and spelling due to my iPad not getting along with the forum editor!

Valued Contributor
Posts: 2,287
Registered: ‎09-16-2011
0

Re: How To Determine AAoA?


creditnocash wrote:

what is the opening date? 40645? 

 

like for example july of 2012? what would i put in? 


it looks like its treating your date as a number, right click the cell, and format cells->  number catagory->  date 

 

Cards: Chase Southwest 20k & CSP 10k & Freedom 6.6k & Amtrak 4.6k, FNBO DISC 14.9k Oregon Duck 5k, & AMEX BCP 15k & Hilton Surpass 7.5k & Delta Gold 6k & Zync NPSL, Fidelity AMEX 12k Sally Mae5k Sams Club MC 10k, Paypal Extras MC 6k, CapOne Venture 15k, QS 2.5k, QS 750, Amazon 5k, Walmart 10k, Citi Simplicity 7k, HHonors Gold 1k (moved 5k CL to Simplicity), Discover IT 10k and a nice stack of store cards.
Last APP/HP 4/22/2015
Contributor
Posts: 94
Registered: ‎06-16-2012
0

Re: How To Determine AAoA?

So you calculate ur average age of account based on the date the account is open or the first statement ?
Discover IT Student $3k. Bankameri better balance $3k.
Chase freedom 2.5k
Valued Contributor
Posts: 2,299
Registered: ‎07-23-2012
0

Re: How To Determine AAoA?


jamesdwi wrote:

creditnocash wrote:

what is the opening date? 40645? 

 

like for example july of 2012? what would i put in? 


it looks like its treating your date as a number, right click the cell, and format cells->  number catagory->  date 

 


this worked. THANKS!!. 

 

 

Current: Discover Fico 709 3/15 Walmart Fico 743 4/15

Inquiries (24 Months): EQ 6 TU 1 EX 6 | Most Recent: 4/09/2015
Over 12 Months:9


2015 Goals:
Lower Utility
Earn Cash Back

Amex Zync(Unicorn)
Chase Freedom$1500
Discover IT$7,400
Citi DC $10,000
Citizens Mastercard$7,000
Highlighted
New Contributor
Posts: 51
Registered: ‎08-14-2012
0

Re: How To Determine AAoA?


creditnocash wrote:

 

as for aaoa i think my fico rounds because mine says one year but its less then that... 

 


They round up if you're less than one year, but not once your average is above one year.

Valued Contributor
Posts: 2,110
Registered: ‎12-29-2011
0

Re: How To Determine AAoA?

My AAoA was 1 year and 9 months but I recently opened three new credit cards (at different times this year) and now my AAoA is 9 months. I have a feeling its going to drop even more soon once my latest credit card starts reporting.

The truth is out there...
FICO scores: 764 (EQ) 732 (EX) 757 (TU) 9/14 | Goal score: 750+ (all 3)
Tradelines: Capital One QS NPSL (5.0k) | Discover IT (6.0k) | Walmart Mastercard (5.0k) | Chase Freedom NPSL (7.3k) | Citi Simplicity (9.3k)






Moderator Emeritus
Posts: 32,869
Registered: ‎08-04-2007
0

Re: How To Determine AAoA?


maiden_girl wrote:

My AAoA was 1 year and 9 months but I recently opened three new credit cards (at different times this year) and now my AAoA is 9 months. I have a feeling its going to drop even more soon once my latest credit card starts reporting.


 

I was appropriately corrected once, and I'll pass this forward, but your AAoA didn't change. FICO rounds down to the nearest who number so your AAoA was 1 year. But what I didn't know until recently was that FICO will always score you with an AAoA of 1 year. So, at 9 months, it doesn't round down to "0", but your AAoA remained at one year. No AAoA change for you. On the flip side though, if you hadn't opened up those CCs, in 3 months it would turn 2 years. Now it will take a year and 3 months before it hits a year. On the whole, one or two years doesn't make a big difference. It's all good.

Advertiser Disclosure: The listings that appear on myFICO are from companies from which myFICO receives compensation, which may impact how and where products appear on myFICO (including, for example, the order in which they appear). myFICO does not review or include all companies or all available products.
† Credit cards for FICO Score ranges: The score ranges are guidelines based on actual applicant approvals and having a FICO Score in a particular range does not guarantee you will be approved for credit cards recommended in that range.

Copyright ©2001-2015 Fair Isaac Corporation. All rights reserved.   | Terms of Use | Privacy Policy | Sitemap

IMPORTANT INFORMATION: All FICO® Score products made available on myFICO.com include a FICO® Score 8, along with additional FICO® Score versions. Your lender or insurer may use a different FICO® Score than the versions you receive from myFICO, or another type of credit score altogether. Learn more

FICO, myFICO, Score Watch, The score lenders use, and The Score That Matters are trademarks or registered trademarks of Fair Isaac Corporation. Equifax Credit Report is a trademark of Equifax, Inc. and its affiliated companies. Many factors affect your FICO Score and the interest rates you may receive. Fair Isaac is not a credit repair organization as defined under federal or state law, including the Credit Repair Organizations Act. Fair Isaac does not provide "credit repair" services or advice or assistance regarding "rebuilding" or "improving" your credit record, credit history or credit rating. FTC's website on credit.