{"text_format":"3","workbook":"xls","n_sheets":1,"sheets":["Loan and Credit Planner"],"not_rendered":{"external_links":1,"defined_names":1},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Loan and Credit Planner","index":0,"n_rows":42,"n_cols":6,"rows_kept":42,"merged":[[0,0,0,7],[2,2,5,7],[7,2,7,6],[9,5,14,6],[17,2,17,6],[19,5,24,6],[27,2,27,6],[29,5,38,6],[41,2,42,7]],"flags":["formulas_cached_only"]}
["Loan and Credit Planner"]
[]
[null,null,"Use the following worksheet to plan for a future loan or better understand a current loan. Type into the yellow cells, and Excel will calculate the results in the green cells. These tools provide estimates only. They are not intended for professional use. Check with your lending institution for more detailed information."]
[]
[]
[]
[]
[null,null,"How much will my monthly payments be?"]
[]
[null,null,"Loan amount",{"v":20000,"d":"$20,000.00"},null,"Use this section to calculate the monthly payments for a loan. You supply the information in the yellow cells of the table, and Excel will calculate the monthly payment. By varying the loan  amount, interest rate, and term, you can find the loan conditions most suited to your needs and means."]
[null,null,"Annual interest rate (percent– e.g., 8.75)",{"v":0.0875,"d":"8.75%"}]
[null,null,"Term (years)",5]
[null,null,"Monthly payment",{"v":412.74465413891596,"d":"$412.74"}]
[]
[]
[]
[]
[null,null,"What is the balance on my loan principal?"]
[]
[null,null,"Original amount of the loan",{"v":20000,"d":"$20,000.00"},null,"Use this section to calculate the balance remaining on your loan. Type in the original principal amount, the annual interest rate, the term of the loan (in years), and the loan (in years), and the number of monthly payments you've made so far."]
[null,null,"Annual interest rate (e.g., 9.25)",{"v":0.0925,"d":"9.25%"}]
[null,null,"Term of the loan (years)",5]
[null,null,"Number of monthly payments made",24]
[null,null,"Current balance",{"v":13084.195125427561,"d":"$13,084.20"}]
[]
[]
[]
[null,null,"How can I pay down my credit balance?"]
[]
[null,null,"Current balance",{"v":3000,"d":"$3,000.00"},null,"Suppose you'd like to pay down your credit-card balance over the next months to reduce the interest charges. Use this section to calculate the monthly  payments you'll need to make, assuming you do not add any further charges to the account in the mean-time. For example, let's say your current balance is $10,000 and you'd like to reduce that to $2,000 over the next six months. Fill in your current balance, your balance goal, the interest rate you're being charged and the number of months to reach your goal. Excel will calculate your monthly payment."]
[null,null,"Balance goal *",{"v":0,"d":"$0.00"}]
[null,null,"Annual interest rate (percent–e.g., 16.5)",{"v":0.165,"d":"16.50%"}]
[null,null,"No. of months for paying down the loan",24]
[null,null,"Total payments",{"v":3542.5692960392826,"d":"$3,542.57"}]
[null,null,"Monthly payment required",{"v":147.60705400163678,"d":"$147.61"}]
[null,null,"* If you want to pay off your balance completely,"]
[null,null,"   enter 0 as balance goal."]
[]
[]
[]
[]
[null,null,"This worksheet is locked to preserve the formulas that calculate your results. To unlock the worksheet, go to the Tools menu, select Protection, then choose Unprotect Sheet. This sheet does not use a password."]