HybridGunZ Posted March 4, 2017 Share Posted March 4, 2017 Great spreadsheet! Thanks!!! This may be a stupid question but what is the Preferred UT 25%??? Sent from my SM-G935T using Tapatalk Quote Link to comment Share on other sites More sharing options...
bankitbandit Posted March 4, 2017 Share Posted March 4, 2017 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. Quote Link to comment Share on other sites More sharing options...
HybridGunZ Posted March 5, 2017 Share Posted March 5, 2017 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 Quote Link to comment Share on other sites More sharing options...
JeffeVerde Posted March 5, 2017 Share Posted March 5, 2017 (edited) 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 March 5, 2017 by JeffeVerde Quote Link to comment Share on other sites More sharing options...
Ehhgead Posted July 2, 2018 Share Posted July 2, 2018 On 9/3/2008 at 10:47 AM, Promethyl said: This is only useful if you carry a balance on your credit cards. I can sing my balances a song: Na na na na Na na na na Hey hey hey Good-bye Quote Link to comment Share on other sites More sharing options...
Ehhgead Posted July 2, 2018 Share Posted July 2, 2018 Where is the link to the file? Quote Link to comment Share on other sites More sharing options...
Zanshiro Posted July 2, 2018 Share Posted July 2, 2018 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 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 Quote Link to comment Share on other sites More sharing options...
Admin breeze Posted July 2, 2018 Author Admin Share Posted July 2, 2018 Pam question. It may not have finished finding stuff, or it may have lost it. I dunno. The XL file will usually open in OO, if the XL file is available. Quote Link to comment Share on other sites More sharing options...
Admin MarvBear Posted April 7, 2019 Admin Share Posted April 7, 2019 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. Quote Link to comment Share on other sites More sharing options...
wnc817 Posted May 4, 2019 Share Posted May 4, 2019 Still getting the download error saying it's not available.. Quote Link to comment Share on other sites More sharing options...
Admin MarvBear Posted May 4, 2019 Admin Share Posted May 4, 2019 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. Quote Link to comment Share on other sites More sharing options...
wnc817 Posted May 4, 2019 Share Posted May 4, 2019 It's not working for me in FF or Chrome. Maybe I have a permissions issue because my account hasn't been used in years? (Trying the xls link) Quote Link to comment Share on other sites More sharing options...
wnc817 Posted May 4, 2019 Share Posted May 4, 2019 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? 😀 Quote Link to comment Share on other sites More sharing options...
REM505 Posted May 17, 2019 Share Posted May 17, 2019 When I go to open the first link I get an error click to see error Quote Link to comment Share on other sites More sharing options...
REM505 Posted May 17, 2019 Share Posted May 17, 2019 Does anyone have a Google docs version? Quote Link to comment Share on other sites More sharing options...
Admin MarvBear Posted May 17, 2019 Admin Share Posted May 17, 2019 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. Quote Link to comment Share on other sites More sharing options...
REM505 Posted May 18, 2019 Share Posted May 18, 2019 Those worked for me thank you! Quote Link to comment Share on other sites More sharing options...
Gohigherjer Posted July 30, 2019 Share Posted July 30, 2019 How do I get permission to download the file?Sent from my iPhone using Tapatalk Quote Link to comment Share on other sites More sharing options...
CTSoxFan Posted July 31, 2019 Share Posted July 31, 2019 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. Quote Link to comment Share on other sites More sharing options...
Gohigherjer Posted July 31, 2019 Share Posted July 31, 2019 Oh okay, I thought it might be something along those lines. Thank you for your reply Sent from my iPhone using Tapatalk Quote Link to comment Share on other sites More sharing options...
Kat58 Posted July 31, 2019 Share Posted July 31, 2019 1 hour ago, Gohigherjer said: Oh okay, I thought it might be something along those lines. Thank you for your reply Sent from my iPhone using Tapatalk And... Welcome to CB! Quote Link to comment Share on other sites More sharing options...
hegemony Posted July 31, 2019 Share Posted July 31, 2019 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-libreoffice/ Zanshiro and MarvBear 1 1 Quote Link to comment Share on other sites More sharing options...
Admin MarvBear Posted July 31, 2019 Admin Share Posted July 31, 2019 Ok, Thanks for the information hegemony. I just formatted for Libre Office. I think I did it correctly. Any member can download it with the following link. CCCS2008 (1).ods Quote Link to comment Share on other sites More sharing options...
hegemony Posted July 31, 2019 Share Posted July 31, 2019 it opened fine for me; but I didn't check all the formulas. Quote Link to comment Share on other sites More sharing options...
Gohigherjer Posted July 31, 2019 Share Posted July 31, 2019 And... Welcome to CB! Thanks Kat! I look forward to working with the resources and information which has already been very encouraging. We all need all the support we can get when dealing with credit!Sent from my iPhone using Tapatalk Quote Link to comment Share on other sites More sharing options...
Recommended Posts
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.