{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Calculator"],"not_rendered":{"defined_names":11},"read":"whole","date_system":"1900"}

{"sheet":"Calculator","index":0,"n_rows":24,"n_cols":5,"rows_kept":24,"merged":[[0,1,0,4],[1,1,1,2],[1,3,1,4],[2,1,2,2],[2,3,2,4],[7,1,7,4],[8,5,8,6],[17,1,17,4],[18,1,18,2]]}
[null,"Payoff student loans or invest?"]
[null,"Excess funds for loan payoff or investment:",null,{"v":200,"d":"$200"}]
[null,"Student loan info",null,"Investment info"]
[null,"Loan balance",{"v":40000,"d":"$40,000"},"Current invested amount",{"v":5000,"d":"$5,000"}]
[null,"Annual interest rate",{"v":0.048,"d":"4.80%"},"Annual rate of return",{"v":0.08,"d":"8.00%"}]
[null,"Current monthly payment",{"v":400,"d":"$400"}]
[]
[null,"OPTION A: Use excess funds as additional loan payoff"]
[null," ","Original schedule","With additional payment","Student loan payoff savings"]
[null,"Monthly payment",{"$f":"CurrentMonthlyPayment","v":{"v":400,"d":"$400"}},{"$f":"IFERROR(CurrentMonthlyPayment+ExtraFund,\"\")","v":{"v":600,"d":"$600"}}]
[null,"Loan repayment",{"$f":"IFERROR(NPER(AnnualInterestRate/12,C10,-LoanBalance)/12,\"\")","v":{"v":10.663470734821898,"d":"10.7 yrs"}},{"$f":"IFERROR(NPER(AnnualInterestRate/12,D10,-LoanBalance)/12,\"\")","v":{"v":6.47447553011527,"d":"6.5 yrs"}},{"$f":"IFERROR(OriginalYearsLoanRepayment-ImprovedYearsLoanRepayment,\"\")","v":{"v":4.188995204706628,"d":"4.2 yrs"}}]
[null,"Interest paid",{"$f":"IFERROR(-CUMIPMT(AnnualInterestRate/12,OriginalYearsLoanRepayment*12,LoanBalance,1,OriginalYearsLoanRepayment*12,0),\"\")","v":{"v":11183.156329182006,"d":"$11,183"}},{"$f":"IFERROR(-CUMIPMT(AnnualInterestRate/12,ImprovedYearsLoanRepayment*12,LoanBalance,1,ImprovedYearsLoanRepayment*12,0),\"\")","v":{"v":6614.818940230085,"d":"$6,615"}},{"$f":"IFERROR(C12-D12,\"\")","v":{"v":4568.337388951921,"d":"$4,568"}}]
[null,"Investment growth during loan payment",null,null,{"$f":"IFERROR(FV(AnnualRateOfReturn/12,ImprovedYearsLoanRepayment*12,0,-CurrentInvestedAmount),\"\")","v":{"v":8378.568389495107,"d":"$8,379"}}]
[null,{"$f":"IF(E13=\"\",\"\",\"Initial fund of \" & TEXT(CurrentInvestedAmount,\"$#,##0\") & \". No additional monthly fund during loan repayment of \"  & TEXT(ImprovedYearsLoanRepayment,\"0.0\") & \" years\")","v":"Initial fund of $5,000. No additional monthly fund during loan repayment of 6.5 years"}]
[null,"Investment growth after loan payment",null,null,{"$f":"IFERROR(FV(AnnualRateOfReturn/12,E11*12,-IncreasedMonthlyPayment,-E13),\"\")","v":{"v":47390.944355082494,"d":"$47,391"}}]
[null,{"$f":"IF(TotalFundsOptionA=\"\",\"\",\"Initial fund of \" & TEXT(E13,\"$#,##0\") & \". Monthly investment of \" & TEXT(IncreasedMonthlyPayment,\"$0\") & \" for \" & TEXT(E11,\"0.0\") & \" years\")","v":"Initial fund of $8,379. Monthly investment of $600 for 4.2 years"}]
[]
[null,"OPTION B: Invest excess funds"]
[null,{"$f":"\"Investment growth for \" & TEXT(C11,\"0.0\") & \" year(s)\"","v":"Investment growth for 10.7 year(s)"},null,null,{"$f":"IFERROR(-FV(AnnualRateOfReturn/12,OriginalYearsLoanRepayment*12,ExtraFund,CurrentInvestedAmount),\"\")","v":{"v":51907.83923315416,"d":"$51,908"}}]
[null,{"$f":"IF(TotalFundsOptionB=\"\",\"\",\"Initial fund of \" & TEXT(CurrentInvestedAmount,\"$#,##\") & \". Monthly investment of \" & TEXT(ExtraFund,\"$0\") & \" for \" & TEXT(OriginalYearsLoanRepayment,\"0.0\") & \" years\")","v":"Initial fund of $5,000. Monthly investment of $200 for 10.7 years"}]
[]
[null,{"$f":"\"Funds growth comparison after the original loan term of \" & TEXT(C11,\"0.0\") & \" year(s)\"","v":"Funds growth comparison after the original loan term of 10.7 year(s)"}]
[null,"OPTION A: Loan payoff",null,null,{"$f":"TotalFundsOptionA","v":{"v":47390.944355082494,"d":"$47,391"}}]
[null,"OPTION B: Invest",null,null,{"$f":"TotalFundsOptionB","v":{"v":51907.83923315416,"d":"$51,908"}}]