{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["תשלום בלון להלוואה"],"not_rendered":{"defined_names":13},"read":"whole","date_system":"1900"}

{"sheet":"תשלום בלון להלוואה","index":0,"n_rows":12,"n_cols":3,"rows_kept":12,"merged":[[1,1,1,2],[6,1,6,2]]}
["                                                                                                                                                                                                                                                                                                                                                            ","תשלום בלון להלוואה","תאריך"]
[null,"התחייבויות"]
[null,"סכום הקרן של ההלוואה",{"v":10000,"d":"₪ 10,000.00"}]
[null,"שיעור ריבית שנתית",{"v":0.0585,"d":"5.85%"}]
[null,"תקופת סילוקין (בשנים)",15]
[null,"שנים עד לתשלום הבלון",5]
[null,"נתונים פיננסיים עיקריים"]
[null,"תשלום חודשי",{"$f":"IFERROR(IF(SUM(Assumptions)>0,ROUND(PMT(Rate/12,Period*12,-Principal),2),\"\"),\"\")","v":{"v":83.58,"d":"₪ 83.58"}}]
[null,"סך התשלומים החודשיים",{"$f":"IFERROR(IF(AND(MonthlyPayment>0,YearsUntilPayment>0),YearsUntilPayment*12*MonthlyPayment,\"\"),\"\")","v":{"v":5014.8,"d":"₪ 5,014.80"}}]
[null,"הסכום הכולל ששולם",{"$f":"IFERROR(IF(AND(MonthlyPayment>0,YearsUntilPayment>0),TotalMonthlyPayments+BalloonPayment,\"\"),\"\")","v":{"v":12594.464455242689,"d":"₪ 12,594.46"}}]
[null,"סך הריבית",{"$f":"IFERROR(IF(OR(TotalAmountPaid>0,YearsUntilPayment>0),TotalAmountPaid-Principal,\"\"),\"\")","v":{"v":2594.464455242689,"d":"₪ 2,594.46"}}]
[null,"תשלום בלון",{"$f":"IFERROR(IF(AND(SUM(Assumptions2)>0,SUM(MonthlyPayment)>0),PV(Rate/12,(Period-YearsUntilPayment)*12,-MonthlyPayment),\"\"),\"\")","v":{"v":7579.664455242689,"d":"₪ 7,579.66"}}]