{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Introduction","Financial Calculator"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":13,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Introduction","index":0,"n_rows":36,"n_cols":5,"rows_kept":36,"cut":false,"hidden":false,"merged":[[1,1,1,8],[3,1,3,8]]}
[]
[null,{"$f":"'Financial Calculator'!B2:P2","v":"Financial Calculator for Excel (LT12)"}]
[null,null,null,null,"2017-10-09"]
[null,"Personal Finance: Another Perspective"]
[]
[null,"Purpose:"]
[null,"The purpose of this spreadsheet is to give an Excel template for a financial calculator."]
[null,"It is written in Excel, and uses the Excel financial functions.  Again, as with all "]
[null,"financial estimates, if you use reasonable estimates your results are likely to be "]
[null,"reasonable as well."]
[]
[null,"Disclosure:"]
[null,"The purpose of this spreadsheet and this class is to help you get your financial house in"]
[null,"order and to help you on your road to financial self-reliance.  If there are mistakes in this "]
[null,"spreadsheet, please bring them to our attention and we will correct them in upcoming "]
[null,"versions.  The teacher, and BYU, specifically disclaim any liability, or responsibility for "]
[null,"claims, loss, or risk incurred, directly or indirectly, from using this material."]
[]
[null,"Instructions and Notes:"]
[null,"1.  Input data in the green cells only.  Hit [Clear] before each problem to clear the previous information."]
[null,"If the answer is  #DIV/0, there is likely not enough information to answer the problem.  Use the "]
[null,"Inputs Needed Table (in yellow) to make sure you have sufficient information to solve the problem.  "]
[]
[null,"2. In using this calculator, assume that money you pay out to invest is negative, i.e. you pay it out."]
[null,"Then,  when you receive money the sign should be positive, i.e. you receive the money."]
[null,"For example, you have invested $3,000 each year for 15 years at 8% interest.  Since you pay the "]
[null,"$3,000 out each year the sign should be negative.  When you solve for your Future Value [Calculate"]
[null,"FV] the answer will come back a positive number, i.e.  PMT = -3,000, N = 15, P/Y = 1, I = 8%, then "]
[null,"solve for Future Value [Calculate FV] = $81,456.  This is the amount of money you will have at the "]
[null,"end of 15 years assuming your investments returned 8% each year."]
[]
[null,"3.  If you see arrows in Column D, click on Clear and reinput your estimates.  You have a circular "]
[null,"reference."]
[]
[null,"4.  If you input your nominal rate and inflation in the Calculator, it will automatically calculate your "]
[null,"real return using the correct formula, which is (1+nominal rate)/(1+ inflation)-1."]

{"sheet":"Financial Calculator","index":1,"n_rows":50,"n_cols":24,"rows_kept":50,"cut":false,"hidden":false,"merged":[[5,6,5,8],[1,1,1,15],[2,1,2,15],[4,10,4,14],[4,1,4,3],[5,1,5,4]]}
[]
[null,"Financial Calculator for Excel (LT12)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Notes:"]
[null,"Personal Finance: Another Perspective",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"This is a simple calculator to help you with your financial calculations."]
[]
[null,"Excel Financial Calculator (LT12)",null,null,null,null,"Time Value Calculations",null,null,null,"Inputs Needed",null,null,null,null,null,null,"It uses Excel macros and VBA.  If you have any questions, or notice"]
[null,"  The Future Value is $36,564.47",null,null,null,null,"Click to Calculate",null,null,null,"PV","N","I","FV","PMT",null,null,"any problems, please let me know."]
[null,"  Present Value =","PV",-10000,null,null,null,null,null,"PV needs:",null,"x","x","x",null,null,null,"Thanks.    Bryan"]
[null,null,null,null,null,null,null,null,null,null,null,"x","x",null,"x"]
[null,"Years/Periods* =","N",20,null,null,null,null,null,null,null,"x","x","x","x",null,null,"Calculator and Excel Notes:"]
[null,"Payments/Year =","P/Yr",12,null,null,null,null,null,"FV:","x","x","x",null,null,null,null,"1. When you are investing or putting money out, make sure the sign is negative"]
[null,null,"(Compounding: Ann. = 1, Mon. = 12, Qrtly. = 4)",null,null,null,null,null,null,null,null,"x","x",null,"x",null,null,"2. When calculating I with a PV and FV, make sure the PV is negative"]
[null,"  Annual Interest =","Ireal",{"$f":"(1+D13)/(1+D14)-1","v":6.4999999999999947E-2},null,null,null,null,null,null,"x","x","x",null,"x",null,null,"3.  Never change or type over cell D12.  If you do, copy cell X12 to D12 =>",null,null,null,null,null,{"$f":"(1+X13)/(1+X14)-1","v":0}]
[null,"Ann. Nom. Rate =","Inom",6.5000000000000002E-2,null,null,null,null,null,"I:","x","x",null,"x",null,null,null,"4. The negative is the minus sign (-) or in (parenthesis), not the <10> bracket signs"]
[null,"Ann. Inflation =","Iinfl",null,null,null,null,null,null,null,"x","x",null,null,"x",null,null,"5. You do not need to divide your interest rate by 12.  This calculator does it automatically from your payments per year"]
[null,null,{"$f":"PY&\" Period Rate = \"","v":"12 Period Rate = "},{"$f":"IF(D13=\"\",\"\",D13/PY)","v":5.4166666666666669E-3},null,null,null,null,null,null,"x","x",null,"x","x",null,null,"6.      Ireal","is your real interest rate.  It is calculated automatically"]
[null,"  Future Value =","FV",{"$f":"FV(I/PY,N*PY,PMT,PV,endperiod)","v":36564.467018910145},null,null,null,null,null,"PMT:","x","x","x",null,null,null,null,"7.      Inom","is your nominal interest rate that you input"]
[null,null,null,null,null,null,null,null,null,null,null,"x","x","x",null,null,null,"8.      Iinfl","is your inflation rate that you input"]
[null,"  Payments =","PMT",null,null,null,null,null,null,null,"x","x","x","x",null,null,null,"9. The Excel Formulas used are:"]
[null,null,{"$f":"IF(endperiod=1,\"     Analysis uses Begin Mode\",\"\")","v":""},null,null,null,null,null,null,"N:","x",null,"x","x",null,null,null,"PV","=PV(I/PY,N*PY,PMT,FV,Type)"]
[null,"  Type =","Type",null,null,null,null,null,null,null,"x",null,"x","x","x",null,null,"FV","=FV(I/PY,N*PY,PMT,PV,Type)"]
[null,null,"Payments at: End = 0, Begin = 1",null,null,null,null,null,null,null,"x",null,"x",null,"x",null,null,"Rate","=RATE(N*PY,PMT,PV,FV)*PY"]
[null," The Excel formula for FV is =FV(I/PY,N*PY,PMT,PV,endperiod)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PMT","=PMT(I/PY,N*PY,PV,FV,Type)"]
[null,"Instructions and Notes:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nper","=NPER(I/PY,PMT,PV,FV,Type)"]
[null,"1.  Input data in the green cells only.  Hit [Clear] before each problem to clear the previous information.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"10.  Type refers to whether the payments are at the end (0) or beginning of the period (1)"]
[null,"If the answer is  #DIV/0, there is likely not enough information to answer the problem.  Use the "]
[null,"Inputs Needed Table (in yellow) to make sure you have sufficient information to solve the problem.  "]
[]
[null,"2. In using this calculator, assume that money you pay out to invest is negative, i.e. you pay it out."]
[null,"Then when you receive money the sign should be positive, i.e. you receive the money into your hands."]
[null,"For example, you have invested $3,000 each year for 15 years at 8% interest.  Since you pay the "]
[null,"$3,000 out each year the sign should be negative.  When you solve for your Future Value [Calculate"]
[null,"FV] the answer will come back a positive number, i.e.  PMT = -3,000, N = 15, P/Y = 1, I = 8%, then "]
[null,"solve for Future Value [Calculate FV] = $81,456.  This is the amount of money you will have at the "]
[null,"end of 15 years assuming your investments returned 8% each year."]
[]
[null,"3.  If you see arrows in Column D, click on Clear and reinput your estimates.  You have a circular "]
[null,"reference."]
[]
[null,"4. If you see a #Div/0!, it usually means you are missing one of the inputs.  Check the \"Inputs Needed\" "]
[null,"table (three inputs are required at a minimum for all solutions, and some use 4).  A common error is"]
[null,"not including your Payments per Year, which for annual payments is 1."]
[]
[null,"5. When inputting your nominal interest rate, put in the annual rate.  It automatically looks at the periods per "]
[null,"year, and if is is less an 1, divides the interest rate by the number of periods."]
[]
[null,"6.  If you input your nominal rate and inflation in the Calculator, it will automatically calculate your "]
[null,"real return using the correct formula, which is (1+nominal rate)/(1+ inflation)-1."]
[]
[null,"7.  If you have the P/Yr in months, then the Years/Periods must be in years.  For example if your period was "]
[null,"77 months, put \"=77/12\" or 6.42 in the years and P/Yr = 12."]