{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["حاسبة قرض"],"not_rendered":{"defined_names":22},"read":"whole","date_system":"1900"}

{"sheet":"حاسبة قرض","index":0,"n_rows":375,"n_cols":8,"rows_kept":375,"merged":[[0,2,0,7]]}
[null,null,"حاسبة قرض بسيطة"]
[]
[{"$nulls":4},"أدخل القيم"]
[null,null,"مبلغ القرض"]
[null,null,"معدل الفائدة السنوي"]
[null,null,"فترة القرض بالسنوات"]
[null,null,"تاريخ بداية القرض"]
[]
[null,null,"الدفعة الشهرية",null,{"$f":"IF(Values_Entered,Monthly_Payment,\"\")","v":""}]
[null,null,"عدد الدفعات",null,{"$f":"IF(Values_Entered,Loan_Years*12,\"\")","v":""}]
[null,null,"إجمالي الفائدة",null,{"$f":"IF(Values_Entered,Total_Cost-Loan_Amount,\"\")","v":""}]
[null,null,"إجمالي تكلفة القرض",null,{"$f":"IF(Values_Entered,Monthly_Payment*Number_of_Payments,\"\")","v":""}]
[]
[]
[null,"رقم الدفعة","تاريخ الدفعة","بداية الموازنة","الدفعة","رأس المال","الفائدة","نهاية الموازنة"]
[null,{"$f":"IF(Loan_Not_Paid*Values_Entered,Payment_Number,\"\")","v":""},{"$f":"IF(Loan_Not_Paid*Values_Entered,Payment_Date,\"\")","v":""},{"$f":"IF(Loan_Not_Paid*Values_Entered,Beginning_Balance,\"\")","v":""},{"$f":"IF(Loan_Not_Paid*Values_Entered,Monthly_Payment,\"\")","v":""},{"$f":"IF(Loan_Not_Paid*Values_Entered,Principal,\"\")","v":""},{"$f":"IF(Loan_Not_Paid*Values_Entered,Interest,\"\")","v":""},{"$f":"IF(Loan_Not_Paid*Values_Entered,Ending_Balance,\"\")","v":""}]
[null,{"$f":"IF(Loan_Not_Paid*Values_Entered,Payment_Number,\"\")","v":""},"","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"",{"$f":"IF(Loan_Not_Paid*Values_Entered,Payment_Date,\"\")","v":""},{"$f":"IF(Loan_Not_Paid*Values_Entered,Beginning_Balance,\"\")","v":""},{"$f":"IF(Loan_Not_Paid*Values_Entered,Monthly_Payment,\"\")","v":""},{"$f":"IF(Loan_Not_Paid*Values_Entered,Principal,\"\")","v":""},{"$f":"IF(Loan_Not_Paid*Values_Entered,Interest,\"\")","v":""},{"$f":"IF(Loan_Not_Paid*Values_Entered,Ending_Balance,\"\")","v":""}]
[null,{"$f":"IF(Loan_Not_Paid*Values_Entered,Payment_Number,\"\")","v":""},"","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"",{"$f":"IF(Loan_Not_Paid*Values_Entered,Payment_Date,\"\")","v":""},{"$f":"IF(Loan_Not_Paid*Values_Entered,Beginning_Balance,\"\")","v":""},{"$f":"IF(Loan_Not_Paid*Values_Entered,Monthly_Payment,\"\")","v":""},{"$f":"IF(Loan_Not_Paid*Values_Entered,Principal,\"\")","v":""},{"$f":"IF(Loan_Not_Paid*Values_Entered,Interest,\"\")","v":""},{"$f":"IF(Loan_Not_Paid*Values_Entered,Ending_Balance,\"\")","v":""}]
[null,{"$f":"IF(Loan_Not_Paid*Values_Entered,Payment_Number,\"\")","v":""},"","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"",{"$f":"IF(Loan_Not_Paid*Values_Entered,Payment_Date,\"\")","v":""},{"$f":"IF(Loan_Not_Paid*Values_Entered,Beginning_Balance,\"\")","v":""},{"$f":"IF(Loan_Not_Paid*Values_Entered,Monthly_Payment,\"\")","v":""},{"$f":"IF(Loan_Not_Paid*Values_Entered,Principal,\"\")","v":""},{"$f":"IF(Loan_Not_Paid*Values_Entered,Interest,\"\")","v":""},{"$f":"IF(Loan_Not_Paid*Values_Entered,Ending_Balance,\"\")","v":""}]
[null,{"$f":"IF(Loan_Not_Paid*Values_Entered,Payment_Number,\"\")","v":""},"","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"",{"$f":"IF(Loan_Not_Paid*Values_Entered,Payment_Date,\"\")","v":""},{"$f":"IF(Loan_Not_Paid*Values_Entered,Beginning_Balance,\"\")","v":""},{"$f":"IF(Loan_Not_Paid*Values_Entered,Monthly_Payment,\"\")","v":""},{"$f":"IF(Loan_Not_Paid*Values_Entered,Principal,\"\")","v":""},{"$f":"IF(Loan_Not_Paid*Values_Entered,Interest,\"\")","v":""},{"$f":"IF(Loan_Not_Paid*Values_Entered,Ending_Balance,\"\")","v":""}]
[null,{"$f":"IF(Loan_Not_Paid*Values_Entered,Payment_Number,\"\")","v":""},"","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"",{"$f":"IF(Loan_Not_Paid*Values_Entered,Payment_Date,\"\")","v":""},{"$f":"IF(Loan_Not_Paid*Values_Entered,Beginning_Balance,\"\")","v":""},{"$f":"IF(Loan_Not_Paid*Values_Entered,Monthly_Payment,\"\")","v":""},{"$f":"IF(Loan_Not_Paid*Values_Entered,Principal,\"\")","v":""},{"$f":"IF(Loan_Not_Paid*Values_Entered,Interest,\"\")","v":""},{"$f":"IF(Loan_Not_Paid*Values_Entered,Ending_Balance,\"\")","v":""}]
[null,{"$f":"IF(Loan_Not_Paid*Values_Entered,Payment_Number,\"\")","v":""},"","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]