Jump to content

CC spreadsheet for Open Office


Recommended Posts


  • Replies 76
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

Popular Posts

just FYI, Open Office has fallen out of favour with the cool kids. Everyone is using LibreOffice which is claimed to be more secured seehttps://www.zdnet.com/article/openoffice-is-dead-long-live-libre

Thank you. Wonderful tool.

Great spreadsheet! Thanks!!! This may be a stupid question but what is the Preferred UT 25%???

 

Sent from my SM-G935T using Tapatalk

"Preferred UT 25%" = Preferred Credit Line Utilization of 25%

(example: If your Credit Limit on one of your Credit Cards is 100.00 and you want maintain a balance of no more than 25%

( i.e. You Prefer to keep your Credit "Utilization" at no more than 25%) or less then that is an example of your "Preferred UT %"

 

On the spreadsheet, you can set it to whatever % you want it based on your needs

& how much of a Positive Impact you'd like to

have on your Credit Score in the short-term:

25% UT for some Positive Impact, on your score.

20% UT for a slightly more Positive Impact on your score.

15% UT for a significantly more Positive Impact on your score.

10% UT for a very Positive Impact on your score.

5% UT for a very very Positive Impact on your score.

 

And regardless of your Credit Limit on each of your Credit Cards,

I've heard that you can have the absolute Greatest Impact on your Score over the Short Term

by getting your Statement Balance down to $3.00 if its a Discover Credit Card

and $2.00 on all other major Credit Cards (Visa, MasterCard, American Express)

Based on the number in your preferred UT, the spread sheet will calculate the exact payment you need to make

so that your "Preferred UT XX%" is maintained on each of your credit cards/ credit lines.

Link to post
Share on other sites

 

Great spreadsheet! Thanks!!! This may be a stupid question but what is the Preferred UT 25%???

 

Sent from my SM-G935T using Tapatalk

"Preferred UT 25%" = Preferred Credit Line Utilization of 25%

(example: If your Credit Limit on one of your Credit Cards is 100.00 and you want maintain a balance of no more than 25%

( i.e. You Prefer to keep your Credit "Utilization" at no more than 25%) or less then that is an example of your "Preferred UT %"

 

On the spreadsheet, you can set it to whatever % you want it based on your needs

& how much of a Positive Impact you'd like to

have on your Credit Score in the short-term:

25% UT for some Positive Impact, on your score.

20% UT for a slightly more Positive Impact on your score.

15% UT for a significantly more Positive Impact on your score.

10% UT for a very Positive Impact on your score.

5% UT for a very very Positive Impact on your score.

 

And regardless of your Credit Limit on each of your Credit Cards,

I've heard that you can have the absolute Greatest Impact on your Score over the Short Term

by getting your Statement Balance down to $3.00 if its a Discover Credit Card

and $2.00 on all other major Credit Cards (Visa, MasterCard, American Express)

Based on the number in your preferred UT, the spread sheet will calculate the exact payment you need to make

so that your "Preferred UT XX%" is maintained on each of your credit cards/ credit lines.

Thank you so much. So $2 is better than 0% utilization?

 

Sent from my SM-G935T using Tapatalk

Link to post
Share on other sites

 

Thank you so much. So $2 is better than 0% utilization?

 

Sent from my SM-G935T using Tapatalk

 

 

 

Yes - -but only in a specific scenario. Take a clean report with a zero dollar balance on ALL accounts, and check the FICO's. Now let *ONE* account report a very small balance, and you'll see a FICO increase of a few points. Some accounts won't report a balance of a dollar or less, so $2 is generally considered the lowest balance that will reliably report.

 

Consider this an advanced technique for getting the absolute maximum FICO score from a clean report (and keep in mind we're only talking a few points). If you have multiple accounts reporting a balance, this will do nothing for you.

 

ETA - On the "Preferred UT %" column - If your objective is to maximize your FICO scores, only let one account report less than 5% utilization (but more than $2). But if you're going to carry more than that minimum balance on one or more accounts, the "Preferred UT %" column calculates the maximum balance for each account, at a user-defined utilization level. The key thing here is that you are defining what that utilization level is - "Preferred" means your personal preference - not FICO's.

 

e.g. Say you want to make use of a Balance Transfer offer, but you want to stay below 25% utilization, because single-account utilization of 25% or more is a significant FICO trigger. Set the "Preferred UT %" to 25, and the column will display what your maximum balance would be.

Edited by JeffeVerde
Link to post
Share on other sites
  • 1 year later...
On 8/24/2008 at 5:11 PM, breeze said:

fixed up to work with OO courtesy of taylortr.

CCCS2008.ods

That leads to a breeze question :D

 

 

Sorry, there is a problem

This attachment is not available. It may have been removed or the person who shared it may not have permission to share it to this location.

Error code: 2C171/1

Link to post
Share on other sites
  • 9 months later...
  • 4 weeks later...
  • Admin
On 4/7/2019 at 11:51 AM, MarvBear said:

The downloadable link is in the first post and is still available for download.  It is an OO file, but will open in xlsx format also.

I can still go to the first post and download it in OO format.  I literally just tried and saved it.  It works.  If you want the excel version go 

I just checked it and that link is also working.

Link to post
Share on other sites
On 3/5/2017 at 11:46 AM, JeffeVerde said:

ETA - On the "Preferred UT %" column - If your objective is to maximize your FICO scores, only let one account report less than 5% utilization (but more than $2).

Hello, Is there a spreadsheet that explains how to maximize score? I remember something along those lines from years ago. Link if possible, please? 😀

Link to post
Share on other sites
  • 2 weeks later...
  • Admin

Both the Open Office and the Excel version are downloadable and are functional.   Google docs will auto convert an Excel file to its own format.  We haven't placed any restrictions on the availability of the file(s).  You may have a problem with your browser or operating system setting.  

Link to post
Share on other sites
  • 2 months later...
22 hours ago, Gohigherjer said:

How do I get permission to download the file?


Sent from my iPhone using Tapatalk

It is only available to members and above.  Once you are here a bit longer and make a few more posts you will get promoted to member and then should be able to access it.

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.





  • Member Statistics

    • Total Members
      183,037
    • Most Online
      2,046

    Newest Member
    jaxagent
    Joined
×
×
  • Create New...

Important Information

Guidelines