{"text_format":"2","workbook":"xlsx","n_sheets":10,"sheets":["Read Me","Quick Check","Questionaire","Review","Summary","12-Month Cash Flow","10-Year Cash Flow","Energy Calculation","1st Loan Repayment","2nd Loan Repayment"],"not_rendered":{"charts":7,"images":12,"macros":0,"external_links":0,"defined_names":183,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Read Me","index":0,"n_rows":29,"n_cols":3,"rows_kept":29,"cut":false,"hidden":false,"merged":[[28,1,28,8],[8,1,8,8],[0,0,0,8],[2,0,2,8],[4,0,4,8],[6,1,6,8],[7,1,7,8],[21,2,21,8],[9,1,9,8],[10,1,10,8],[12,1,12,8],[13,2,13,8],[14,2,14,8],[15,2,15,8],[16,2,16,8],[17,2,17,8],[18,2,18,8],[19,2,19,8],[20,2,20,8],[22,2,22,8],[24,1,24,8],[25,1,25,8],[26,1,26,8],[27,1,27,8]]}
["Read Me Sheet"]
[]
["PUE Mini Business Plan Calculator"]
[]
["This spreadsheet tool is a supplement to the \"Photovoltaics for Productive Use Applications: A Catalogue of DC-Appliances\" (GIZ HERA, 2015). This tool is designed for use by field facilitators, business development advisors, business mentors, technology suppliers and other practitioners in the field of rural development."]
[]
["Objective:","To determine the core financial performance of a business idea or concept, using solar PV technology, during the planning phase and during periodic performance evaluations"]
["Version:","1.0 (Dec 2015)"]
["Authors:","Robert Schultz"]
[null,"Caspar Priesemann"]
["Download link:","https://energypedia.info/wiki/File:PUE_Mini_Business_Plan_Calculator.xlsx"]
[]
["Instructions:","The tool comprises a total of 10 sheets:"]
[null,"Read Me","to serve as introduction and provide instructions"]
[null,"Quick Check","Basic data entry! To conduct a basic financial performance evaluation of a business idea"]
[null,"Questionnaire","Detailed data entry! Step-by-step completion of the most important business planning aspects"]
[null,"Review","Not for data entry! Automatic calculations and review of the values entered into the Questionnaire, with indications of the impact of values on overall business performance"]
[null,"Summary","Not for data entry! Automatic calculation and graphic presentation of business performance according to data entered in the Questionnaire"]
[null,"12-Month Cash Flow","Not for data entry! Automatic calculation of cash flow in the first year of operation"]
[null,"10-Year Cash Flow","Not for data entry!  Automatic calculation of cash flow over the first 10 years of operation"]
[null,"Energy Calculation","Not for data entry! Automatic calculation of solar PV System technical sizing and comparison with a selected alternative electricity source"]
[null,"1st Loan Repayment","Not for data entry! Automatic calculation of monthly loan repayments as required by 1st bank selected"]
[null,"2nd Loan Repayment","Not for data entry! Automatic calculation of monthly loan repayments as required by 2nd bank selected"]
[]
["Hints:","Only enter values in cells with the colour white only"]
[null,"Quick Check is only a basic check and data is not linked with other sheets"]
[null,"Questionnaire is the only sheet were value changes are made, to then compare with the automatic results in the Summary Sheet"]
[null,"Show the Energy Calculation to a solar PV supplier to provide guidance on the size and cost of the solar PV System "]
[null,"The symbol \"$\" is representative of money in general and does not relate to any specific currency and no currency conversion is required"]

{"sheet":"Quick Check","index":1,"n_rows":34,"n_cols":4,"rows_kept":34,"cut":false,"hidden":false,"merged":[[0,0,0,3],[1,0,1,3]]}
["Quick Check Sheet"]
["This Quick Check Sheet serves as a very first rough assessment on whether your business idea is potentially successful. values need only be estimates. Business planning requires clear thinking. Therefore, if this Quick Check sheet gives a positive result, please proceed to the more detailed Questionnaire Sheet. "]
[null,null,"Value","Unit"]
["A","INCOME"]
["A.1","Unit price of main product sold",0,"$/unit"]
["A.2","Quantity of main product sold per month",0,"qty"]
["A.3","Value of any other products or services sold per month",0,"$/month"]
[null,"Estimated income per month:",{"$f":"(C5*C6)+C7","v":0},"$/month"]
["B","EXPENDITURE"]
["B.1","Monthly fixed costs (salaries, rent, bank loan, etc)",0,"$/month"]
["B.2","Monthly variable costs (materials, consumables, etc)",0,"$/month"]
["B.3","Any other monthly expenses",0,"$/month"]
[null,"Estimated expenditure per month:",{"$f":"SUM(C10:C12)","v":0},"$/month"]
["C","START-UP"]
["C.1","Once-off start-up expenses (building renovations, registration fees, etc)",0,"$"]
[null,"Estimated cost for start-up:",{"$f":"C15","v":0}]
[]
["D","INVESTMENT"]
["D.1","Estimated cost of all electrical appliances",0,"$"]
["D.2","Estimated cost of Solar PV System",0,"$"]
[null,"Estimated cost of technology/equipment:",{"$f":"SUM(C19:C20)","v":0},"$"]
[]
[]
[null,"PROFIT OR LOSS?"]
[null,"Year 1",{"$f":"($C$8*12)-($C$13*12)-$C$16-$C$21","v":0}]
[null,"Year 2",{"$f":"($C$8*12)-($C$13*12)+C25","v":0}]
[null,"Year 3",{"$f":"($C$8*12)-($C$13*12)+C26","v":0}]
[null,"Year 4",{"$f":"($C$8*12)-($C$13*12)+C27","v":0}]
[null,"Year 5",0]
[null,"Year 6",0]
[null,"Year 7",0]
[null,"Year 8",0]
[null,"Year 9",0]
[null,"Year 10",0]

{"sheet":"Questionaire","index":2,"n_rows":115,"n_cols":8,"rows_kept":115,"cut":false,"hidden":false,"merged":[[81,0,82,2],[97,0,97,2],[88,1,88,6],[89,1,89,6],[78,2,78,3],[70,2,70,3],[74,2,74,3],[75,2,75,3],[76,2,76,3],[77,2,77,3],[62,2,62,3],[66,2,66,3],[67,2,67,3],[68,2,68,3],[69,2,69,3],[54,2,54,3],[58,2,58,3],[59,2,59,3],[60,2,60,3],[61,2,61,3],[20,1,21,2],[50,2,50,3],[51,2,51,3],[52,2,52,3],[53,2,53,3],[27,2,27,3],[28,2,28,3],[29,2,29,3],[30,2,30,3],[0,1,0,7],[1,0,1,7],[14,7,17,7],[13,2,13,4],[14,2,14,4],[4,4,4,5],[5,4,5,5],[6,4,6,5],[7,4,7,5],[8,4,8,5],[9,4,9,5],[10,4,10,5]]}
[null,"Questionnaire Sheet"]
["To consider whether your business idea has prospects for success, several key questions need to be answered. Please look at the below and answer the questions one at a time. Do not feel overwhelmed, but simply take it step by step. This questionnaire allows you to think about your future business in a systematic way so that you can make an informed decision and avoid common pitfalls."]
[null,"Questions",null,null,null,"Value","Unit","Hints"]
["A","Your business identity"]
["A.1","What is the name of your (new) business?",{"$nulls":4},"text"]
["A.2","What is the main products that you will be selling?",{"$nulls":4},"text","e.g. furniture, chickens, clothes, milk, general groceries"]
["A.3","What is the main services you will be selling?",{"$nulls":4},"text","e.g. hair cutting, phone charging, construction, maintenance"]
["A.4","What will be the essential input materials you need to buy for your business?",{"$nulls":4},"text","Without these materials (e.g. wood, cloth, eggs) your business cannot produce anything "]
["A.5","What will be the optional input materials you need to buy for your business?",{"$nulls":4},"text","With these materials you can produce better quality products, but they are not essential"]
["A.6","What will be the essential consumables you need to buy for your business?",{"$nulls":4},"text","Without these materials (e.g. nails, glue, yarn, needles, chick feed, paper, printer cartridges) your business cannot produce anything."]
["A.7","What will be the optional consumables you need to buy for your business?",{"$nulls":4},"text","With these materials you can produce better quality products, but they are not essential"]
[]
["B","Your business income"]
[null,"Your are selling the product:",{"$f":"E6","v":0}]
[null,"Your are selling the service:",{"$f":"E7","v":0},{"$nulls":4},"Using your best judgement, consider how much income you can make. This is total income before any expenses. Please think about the maximum, average and lowest income possible in the market that you serve and for the size of your future business. If unsure make a guess and the tool will assist in showing whether your guessed income will be sufficient."]
["B.1","In a very good month, what income could you expect?",null,null,"Scenario: Strong",0,"$/month"]
["B.2","In an average month, what is the income you can expect?",null,null,"Scenario: Stable",0,"$/month"]
["B.3","In a very bad month, what is the income you can expect?",null,null,"Scenario: Weak",0,"$/month"]
[]
["C","Your business expenditure"]
["C.1","How much will your once-off start-up expenses be for establishing your business, such as:"]
["C.1.1",null,null,null,"registration fees",0,"$","Fees paid to a registrar of companies or other authority"]
["C.1.2",null,null,null,"legal fees",0,"$","Fees paid for legal documents drawn up by legal firm, as required by a registrar of companies or other authority"]
["C.1.3",null,null,null,"renovation of business premises",0,"$","Buidling alterations, additions or improvements necessary for your new business"]
["C.1.4",null,null,null,"any initial materials ",0,"$","Initial materials may include some input materials, furniture, vehicles, non-electric appliances and other equipment"]
["C.1.5",null,null,null,"various",0,"$"]
["C.2","How much will your recurring monthly expenses be that you must to consider, such as:"]
["C.2.1","What will all the",{"$f":"E8","v":0},null,"cost you per month if you are busy?",0,"$/month"]
["C.2.2","What will all the",{"$f":"E9","v":0},null,"cost you per month if you are busy?",0,"$/month"]
["C.2.3","What will all the",{"$f":"E10","v":0},null,"cost you per month if you are busy?",0,"$/month"]
["C.2.4","What will all the",{"$f":"E11","v":0},null,"cost you per month if you are busy?",0,"$/month"]
["C.3","How much will your recurring monthly general expenses be, such as:"]
["C.3.1",null,null,null,"phone costs",0,"$/month","For your telephone, fax, mobile, email and internet connection"]
["C.3.2",null,null,null,"transport costs",0,"$/month","For own transport needs to go to clients or shops to buy materials; includes fuel and regular maintenance expenses"]
["C.3.3",null,null,null,"delivery costs",0,"$/month","For delivery costs by another transporter to your business premises"]
["C.3.4",null,null,null,"rent of business premises",0,"$/month","If you do not own your own premises; this could also include funds you wish to save for regular building renovation or improvement"]
["C.3.5",null,null,null,"staff salaries",0,"$/month"]
["C.3.6",null,null,null,"taxes and duties",0,"$/month"]
["C.3.7",null,null,null,"sub-contractors",0,"$/month","Regularly paid to another company to work on your behalf"]
["C.3.8",null,null,null,"advertising",0,"$/month","For producing information materials, participate in events and other activities to promote your business"]
["C.3.9",null,null,null,"water, electricity and other utilities",0,"$/month","If you pay for these services and not produce/generate them yourself"]
["C.3.10",null,null,null,"insurance fees",0,"$/month","Insurance for your equipment and premises against fire, theft, accidents and other"]
["C.3.11",null,null,null,"bookkeeping or accounting fees",0,"$/month","For regular administration support done by another company on your behalf"]
["C.3.12",null,null,null,"various",0,"$/month"]
["C.3.13",null,null,null,"various",0,"$/month"]
[]
["C.4","What annual price increases for your costs do you expect?",null,null,null,0,"%/annum","Inflation, regular price increases as a result of fuel price increases or other external factors"]
[]
["D","Your electric equipment"]
["D.1.1","What type is the 1st Appliance that your business needs?",{"$nulls":4},"text"]
["D.1.2","What will the",{"$f":"F50","v":0},null,"cost you to buy?",null,"$"]
["D.1.3","How much power does the ",{"$f":"F50","v":0},null,"need?",null,"Watt","Check in the equipment specifications what the power rating (W) of the equipment is; if a set of equipment, then add all the W together"]
["D.1.4","Will the",{"$f":"F50","v":0},null,"operate on DC or AC?",null,"AC or DC","Check in the equipment specifications whether DC (Input Voltage less than 20V) or AC (Input Voltage more than 100V)"]
["D.1.5","How many hours will the",{"$f":"F50","v":0},null,"run in a day if you are busy?",null,"hrs/day","This is the length of time that the equipment will operate, or be charged every day"]
["D.1.6","How many ",{"$f":"F50","v":0},null,"do you need?",null,"qty"]
["D.1.7","For the maintenance and repair costs for the",null,{"$f":"F50","v":0},"how much will you save per month?",null,"$/month","This is the money you willingly save every month so that you can easily replace the equipment if broken"]
[]
["D.2.1","What type is the 2nd Appliance that your business needs?",{"$nulls":4},"text"]
["D.2.2","What will the",{"$f":"F58","v":0},null,"cost you to buy?",null,"$"]
["D.2.3","How much power does the ",{"$f":"F58","v":0},null,"need?",null,"Watt","Check in the equipment specifications what the power rating (W) of the equipment is; if a set of equipment, then add all the W together"]
["D.2.4","Will the",{"$f":"F58","v":0},null,"operate on DC or AC?",null,"AC or DC","Check in the equipment specifications whether DC (Input Voltage less than 20V) or AC (Input Voltage more than 100V)"]
["D.2.5","How many hours will the",{"$f":"F58","v":0},null,"run in a day if you are busy?",null,"hrs/day","This is the length of time that the equipment will operate, or be charged every day"]
["D.2.6","How many ",{"$f":"F58","v":0},null,"do you need?",null,"qty"]
["D.2.7","For the maintenance and repair costs for the",null,{"$f":"F58","v":0},"how much will you save per month?",null,"$/month","This is the money you willingly save every month so that you can easily replace the equipment if broken"]
[]
["D.3.1","What type is the 3rd Appliance that your business needs?",{"$nulls":4},"text"]
["D.3.2","What will the",{"$f":"F66","v":0},null,"cost you to buy?",null,"$"]
["D.3.3","How much power does the ",{"$f":"F66","v":0},null,"need?",null,"Watt","Check in the equipment specifications what the power rating (W) of the equipment is; if a set of equipment, then add all the W together"]
["D.3.4","Will the",{"$f":"F66","v":0},null,"operate on DC or AC?",null,"AC or DC","Check in the equipment specifications whether DC (Input Voltage less than 20V) or AC (Input Voltage more than 100V)"]
["D.3.5","How many hours will the",{"$f":"F66","v":0},null,"run in a day if you are busy?",null,"hrs/day","This is the length of time that the equipment will operate, or be charged every day"]
["D.3.6","How many ",{"$f":"F66","v":0},null,"do you need?",null,"qty"]
["D.3.7","For the maintenance and repair costs for the",null,{"$f":"F66","v":0},"how much will you save per month?",null,"$/month","This is the money you willingly save every month so that you can easily replace the equipment if broken"]
[]
["D.4.1","What type is the 4th Appliance that your business needs?",{"$nulls":4},"text"]
["D.4.2","What will the",{"$f":"F74","v":0},null,"cost you to buy?",null,"$"]
["D.4.3","How much power does the ",{"$f":"F74","v":0},null,"need?",null,"Watt","Check in the equipment specifications what the power rating (W) of the equipment is; if a set of equipment, then add all the W together"]
["D.4.4","Will the",{"$f":"F74","v":0},null,"operate on DC or AC?",null,"AC or DC","Check in the equipment specifications whether DC (Input Voltage less than 20V) or AC (Input Voltage more than 100V)"]
["D.4.5","How many hours will the",{"$f":"F74","v":0},null,"run in a day if you are busy?",null,"hrs/day","This is the length of time that the equipment will operate, or be charged every day"]
["D.4.6","How many ",{"$f":"F74","v":0},null,"do you need?",null,"qty"]
["D.4.7","For the maintenance and repair costs for the",null,{"$f":"F74","v":0},"how much will you save per month?",null,"$/month","This is the money you willingly save every month so that you can easily replace the equipment if broken"]
[]
["For operating your electrical equipment from a solar PV System, the system's PV module capacity should be:"]
[null,null,null,{"$f":"'Energy Calculation'!B11","v":0},"Watt peak (Wp)","Note: an average of  ",5,"sunshine hours per day is assumed, if this needs to be adjusted please change value"]
[]
["D.5.1","Your solar PV System should have a battery storage large enough to provide power for how many days?",null,null,null,1,"days","How many days of power if there is limited sunshine? \nNote: 1 day is the minium requirement, as the battery storage also serves to provide stable power"]
["D.5.2","The total cost for such a PV system installed at your business premises is how much?",{"$nulls":4},"$","Obtain quotation from PV supplier"]
["D.5.3","How much do the batteries for your PV system cost if you need to replace them all?",{"$nulls":4},"$","Obtain quotation from PV supplier"]
[]
[null,"Comparison with alternative electricity system:"]
[null,"Note: this is optional and considers only the payback period between the solar PV System and another electricity generation technology (e.g. diesel generator); this alternative is not considered in the business calculation."]
[null,"What electricity generation technology are you considering as alternative?",{"$nulls":4},"text","None, Diesel engine, petrol engine, grid electricity"]
[null,"How much do/would you spend on ",null,{"$f":"F91","v":0},"every month?",0,"$/month","Amount spent on fuel or grid electricity"]
[null,"For the maintenance and repair costs for the",null,{"$f":"F91","v":0},"how much do/would you have to save monthly?",0,"$/month"]
[null,"If you are planning to buy a new",null,{"$f":"F91","v":0},"how much will it cost you?",0,"$","Obtain quotation from supplier"]
[]
[]
["E","Funding your business"]
["You will need at least the following sum for your business to get started:",null,null,{"$f":"Summary!$D$18","v":0},"$"]
[]
["E.1","If you have access to grant money to start your business, how much can you get?",null,null,null,0,"$","Grant money is a gift you may receive from a relative, a family contribution or support from another organisation or government"]
["E.2","How much own funds (capital) do you have to start your business?",null,null,null,0,"$"]
[]
["E.3","If you need a bank loan, what is the name of the 1st Bank?",{"$nulls":4},"text"]
["E.3.1","How much money from",null,{"$f":"F103","v":0},"do you want to borrow?",0,"$"]
["E.3.2","How much interest will",null,{"$f":"F103","v":0},"charge you every year?",0,"%/annum"]
["E.3.3","To pay off your debts to ",null,{"$f":"F103","v":0},"will be for how many years?",null,"years"]
["E.3.4","How much deposit does",null,{"$f":"F103","v":0},"require to approve your loan?",0,"%"]
["E.3.5","What is the preferred date on which you want to have the loan to be available for you to start your business?",{"$nulls":4},"dd/mm/yyyy","Note: Add any date. This is important for loan repayment calculation."]
[]
["E.4","If you need another bank loan, what is the name of the 2nd Bank?",{"$nulls":4},"text"]
["E.4.1","How much money from",null,{"$f":"F110","v":0},"do you want to borrow?",0,"$"]
["E.4.2","How much interest will",null,{"$f":"F110","v":0},"charge you every year?",0,"%/annum"]
["E.4.3","To pay off your debts to ",null,{"$f":"F110","v":0},"will be for how many years?",null,"years"]
["E.4.4","How much deposit does",null,{"$f":"F110","v":0},"require to approve your loan?",0,"%"]
["E.4.5","What is the preferred date on which you want to have the loan to be available for you to start your business?",{"$nulls":4},"dd/mm/yyyy","Note: Add any date. This is important for loan repayment calculation."]

{"sheet":"Review","index":3,"n_rows":39,"n_cols":6,"rows_kept":39,"cut":false,"hidden":false,"merged":[[0,1,0,5],[1,0,1,5]]}
[null,"Review Sheet"]
["This Review Sheet gives you an overview of the general technical and financial aspects of your future business. The results in this review can be changed by re-entering values in the Questionnaire Sheet."]
[null,"Name of business:",null,{"$f":"Questionaire!$E$5","v":0}]
[null,"Type of main products:",null,{"$f":"Questionaire!$E$6","v":0}]
[null,"Type of main services:",null,{"$f":"Questionaire!$E$7","v":0}]
[null,"Technical and Financial Aspects",null,"Value","Unit","Sensitive to:"]
["B","Your business income"]
[null,{"$f":"Questionaire!$E$16","v":"Scenario: Strong"},null,{"$f":"Questionaire!$F$16","v":0},"$/month","If your market is strong, your product and service in high demand. But markets change!"]
[null,{"$f":"Questionaire!$E$17","v":"Scenario: Stable"},null,{"$f":"Questionaire!$F$17","v":0},"$/month","If your market is stable and your product and service is in regular demand. But markets change!"]
[null,{"$f":"Questionaire!$E$18","v":"Scenario: Weak"},null,{"$f":"Questionaire!$F$18","v":0},"$/month","If your market is weak and there is low demand for your product and service. But markets change!"]
[]
["C","Your business expenditure"]
[null,"Total start-up expenses (excluding equipment)",null,{"$f":"SUM(Questionaire!$F$22:$F$26)","v":0},"$"]
[null,"Total monthly material and consumables expenses:",null,{"$f":"SUM(Questionaire!$F$28:$F$31)","v":0},"$/month"]
[null,"Total recurring monthly regular expenses:",null,{"$f":"SUM(Questionaire!$F$33:$F$45)","v":0},"$/month"]
[null,"Annual price increases:",null,{"$f":"Questionaire!$F$47","v":0},"%/annum","The higher → the faster your expenses increase and you need to adjust your sales prices regularly"]
[]
["D","Your electric equipment"]
[null,"Total number of electric appliances:",null,{"$f":"'Energy Calculation'!$C$8","v":0},"qty","The higher → the larger the investment cost and electricity demand and consumption"]
[null,"Total cost for electrical appliances:",null,{"$f":"(Questionaire!$F$51*Questionaire!$F$55)+(Questionaire!$F$59*Questionaire!$F$63)+(Questionaire!$F$67*Questionaire!$F$71)+(Questionaire!$F$75*Questionaire!$F$79)","v":0},"$","The higher → the larger the investment cost and electricity demand and consumption"]
[null,"Total cost for solar PV System:",null,{"$f":"Questionaire!$F$86","v":0},"$","The higher → the larger the investment cost and electricity demand and consumption"]
[null,"Monthly savings for appliance maintenance and repairs:",null,{"$f":"Questionaire!$F$56+Questionaire!$F$64+Questionaire!$F$72+Questionaire!$F$80","v":0},"$/month","The higher → the more funds saved for the future"]
[null,"Monthly savings for solar PV System maintenance and repairs:",null,{"$f":"'Energy Calculation'!$C$20","v":0},"$/month","The higher → the more funds saved for the future"]
[null,"Total power that all your appliances need is: ",null,{"$f":"'Energy Calculation'!$B$8","v":0},"Watts","Maximum power, if all appliances are connected at the same time"]
[null,"Total electricity consumption of all your appliances per day is:",null,{"$f":"'Energy Calculation'!$F$8","v":0},"Wh/day","Maximum consumption, if all appliances are working at the same time"]
[null,"Total PV module capacity of your solar PV System:",null,{"$f":"'Energy Calculation'!$B$11","v":0},"Wp","The higher → the more expensive the system"]
[null,"Total battery storage capacity of your solar PV System:",null,{"$f":"'Energy Calculation'!$B$15","v":0},"Wh","To reduce: decrease days of autonomy and only work during day time when the sun is shining"]
[null,"DC-to-AC inverter required (electronic device necessary for 110V or 230V AC appliances)?",null,{"$f":"'Energy Calculation'!$B$12","v":"No"},"Yes or No?","If YES → additional cost for the solar PV System, higher power demand and maintenance cost"]
[null,"Days of autonomy",null,{"$f":"Questionaire!$F$85","v":1},"days","The higher → the larger the battery storage required and maintenance cost"]
[null,"The solar PV System, compared with alternative, has a pay back period of:",null,{"$f":"'Energy Calculation'!$B$27","v":37},"Months","The shorter → the more economic sense a solar PV System makes"]
[]
["E","Funding your business"]
[null,"Total start-up funds required by your business:",null,{"$f":"Summary!$D$18","v":0},"$","The higher → the more careful planning is required"]
[null,"Total own money and grant:",null,{"$f":"Questionaire!$F$100+Questionaire!$F$101","v":0},"$","The higher → the less money needs to be borrowed"]
[null,"Total money borrowed from bank(s):",null,{"$f":"Questionaire!$F$104+Questionaire!$F$111","v":0},"$","The higher the money borrowed → the higher the loan repayment amount\nif RED: This value is too low to start your business "]
[null,"Average interest paid:",null,{"$f":"AVERAGE(Questionaire!$F$105, Questionaire!$F$112)","v":0},"%/annum","Higher the interest → the higher the payment to the bank over the entire loan period"]
[null,"Average loan period (pay back):",null,{"$f":"AVERAGE(Questionaire!$F$106,Questionaire!$F$113)","v":{"$error":"#DIV/0!"}},"years","The longer the loan period → the lower the monthly repayment to the bank"]
[null,"Monthly loan repayment amount to:",{"$f":"Questionaire!$F$103","v":0},{"$f":"'1st Loan Repayment'!Scheduled_Monthly_Payment","v":"0"},"$/month","Influenced by interest rate and loan period"]
[null,"Monthly loan repayment amount to:",{"$f":"Questionaire!F110","v":0},{"$f":"'2nd Loan Repayment'!Scheduled_Monthly_Payment","v":"0"},"$/month","Influenced by interest rate and loan period"]

{"sheet":"Summary","index":4,"n_rows":30,"n_cols":8,"rows_kept":30,"cut":false,"hidden":false,"merged":[[21,1,21,2],[22,1,22,2],[23,1,23,2],[0,1,0,8],[20,1,20,2],[3,3,3,5],[4,3,4,5],[5,3,5,5],[6,3,6,5],[15,1,15,2],[16,1,16,2],[7,3,7,5],[8,3,8,5],[11,3,11,5],[12,3,12,5],[13,3,13,5],[8,1,8,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[3,1,3,2],[4,1,4,2],[5,1,5,2],[6,1,6,2],[7,1,7,2],[26,7,29,8],[14,3,14,5],[15,3,15,5],[16,3,16,5],[17,3,17,5],[24,7,24,8],[10,7,10,8],[6,7,6,8],[8,7,8,8],[16,7,16,8],[23,7,23,8],[7,7,7,8],[11,7,11,8],[12,7,12,8],[13,7,13,8],[14,7,14,8],[15,7,15,8],[17,7,17,8],[19,7,19,8],[20,7,20,8],[21,7,21,8],[22,7,22,8],[1,3,1,5],[5,7,5,8],[4,7,4,8],[3,7,3,8],[2,7,2,8]]}
[null,"Summary Sheet"]
[null,null,null,"Value",null,null,"Unit","Notes"]
[null,"Basic information"]
[null,"Name of business:",null,{"$f":"Questionaire!$E$5","v":0},null,null,"text"]
[null,"Type of main products:",null,{"$f":"Questionaire!$E$6","v":0},null,null,"text"]
[null,"Type of main services:",null,{"$f":"Questionaire!$E$7","v":0},null,null,"text"]
[null,"Total investment costs for assets",null,{"$f":"D12+D13","v":0},null,null,"$","includes all appliances and PV system"]
[null,"Total own funding or grant funding available:",null,{"$f":"Questionaire!$F$100+Questionaire!$F$101","v":0},null,null,"$"]
[null,"Total amount borrowed from bank(s)",null,{"$f":"Questionaire!$F$104+Questionaire!$F$111","v":0},null,null,"$","if RED: This value is too low to start your business"]
[]
[null,"Start-up investment and expenses"]
[null,"Cost of all electric appliances:",null,{"$f":"(Questionaire!$F$51*Questionaire!$F$55)+(Questionaire!$F$59*Questionaire!$F$63)+(Questionaire!$F$67*Questionaire!$F$71)+(Questionaire!$F$75*Questionaire!$F$79)","v":0},null,null,"$"]
[null,"Cost of PV system:",null,{"$f":"Questionaire!$F$86","v":0},null,null,"$"]
[null,"Cost of input materials and consumables:",null,{"$f":"SUM('12-Month Cash Flow'!$C$14:$C$15)","v":0},null,null,"$"]
[null,"Bank loan deposits required:",null,{"$f":"(Questionaire!$F$104*Questionaire!$F$107)+(Questionaire!$F$111*Questionaire!$F$114)","v":0},null,null,"$"]
[null,"Once-off start-up expenses:",null,{"$f":"SUM(Questionaire!$F$22:$F$26)","v":0},null,null,"$"]
[null,"1st Month operational expenses:",null,{"$f":"F25-D14","v":0},null,null,"$","All operational expenses and loan repayment for 1st month"]
[null,"Total funds required for 1st month:",null,{"$f":"SUM(D12:F17)-D14","v":0},null,null,"$/month"]
[]
[null,"Running expenses (monthly)"]
[null,"Recurring running expenses for operations:",null,null,null,{"$f":"SUM('12-Month Cash Flow'!$C$16:$C$28)","v":0},"$/month"]
[null,"Cost of input materials and consumables:",null,null,null,{"$f":"SUM('12-Month Cash Flow'!$C$14:$C$15)","v":0},"$/month"]
[null,"Loan repayments to bank(s) per month:",null,null,null,{"$f":"'12-Month Cash Flow'!$D$30+'12-Month Cash Flow'!$D$31","v":0},"$/month"]
[null,"Savings for equipment maintenance and replacements:",null,null,null,{"$f":"SUM(Review!$D$22:$D$23)","v":0},"$/month","includes all appliances and PV system"]
[null,"Total monthly expenses:",null,null,null,{"$f":"SUM(F21:F24)","v":0},"$/month"]
[]
[null,"Annual Profit/Loss per Scenario (cash end of year)","Year 1","Year 3","Year 5","Year 7","Year 10","Profit declines over time because of annual price increases (inflation, etc). Therefore you have to increase your sales prices from time to time to adjust."]
[null,{"$f":"Questionaire!$E$16","v":"Scenario: Strong"},{"$f":"'10-Year Cash Flow'!C35","v":0},{"$f":"'10-Year Cash Flow'!E35","v":0},{"$f":"'10-Year Cash Flow'!G35","v":0},{"$f":"'10-Year Cash Flow'!I35","v":0},{"$f":"'10-Year Cash Flow'!L35","v":0}]
[null,{"$f":"Questionaire!$E$17","v":"Scenario: Stable"},{"$f":"'10-Year Cash Flow'!C71","v":0},{"$f":"'10-Year Cash Flow'!E71","v":0},{"$f":"'10-Year Cash Flow'!G71","v":0},{"$f":"'10-Year Cash Flow'!I71","v":0},{"$f":"'10-Year Cash Flow'!L71","v":0}]
[null,{"$f":"Questionaire!$E$18","v":"Scenario: Weak"},{"$f":"'10-Year Cash Flow'!C107","v":0},{"$f":"'10-Year Cash Flow'!E107","v":0},{"$f":"'10-Year Cash Flow'!G107","v":0},{"$f":"'10-Year Cash Flow'!I107","v":0},{"$f":"'10-Year Cash Flow'!L107","v":0}]

{"sheet":"12-Month Cash Flow","index":5,"n_rows":109,"n_cols":17,"rows_kept":109,"cut":false,"hidden":false,"merged":[[86,3,86,14],[0,1,0,16],[37,1,37,16],[74,1,74,16],[12,3,12,14],[49,3,49,14]]}
[null,"12-Month Cash Flow"]
[null,{"$f":"Questionaire!E16","v":"Scenario: Strong"},"Company name:",null,{"$f":"Questionaire!$E$5","v":0},{"$nulls":4},"Fiscal Year Begins:",{"$f":"Questionaire!$F$108","v":"00:00:00"}]
[null,null,"Start-up",{"$f":"K2","v":"00:00:00"},{"$f":"DATE(YEAR(D3),MONTH(D3)+1,1)","v":"1900-02-01"},{"$f":"DATE(YEAR(E3),MONTH(E3)+1,1)","v":"1900-03-01"},"1900-04-01","1900-05-01","1900-06-01","1900-07-01","1900-08-01","1900-09-01","1900-10-01","1900-11-01","1900-12-01","Year 1","Year 2"]
[null,"STRONG: CASH AVAILABLE (beginning of month)",{"$f":"Questionaire!$F$100+Questionaire!$F$101","v":0},{"$f":"C35","v":0},0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"O35","v":0}]
[]
[null,"CASH RECEIPTS"]
[null,"Cash Sales",null,{"$f":"Questionaire!$F$16","v":0},{"$f":"Questionaire!$F$16","v":0},{"$f":"Questionaire!$F$16","v":0},{"$f":"Questionaire!$F$16","v":0},{"$f":"Questionaire!$F$16","v":0},{"$f":"Questionaire!$F$16","v":0},{"$f":"Questionaire!$F$16","v":0},{"$f":"Questionaire!$F$16","v":0},{"$f":"Questionaire!$F$16","v":0},{"$f":"Questionaire!$F$16","v":0},{"$f":"Questionaire!$F$16","v":0},{"$f":"Questionaire!$F$16","v":0},{"$f":"SUM(D7:O7)","v":0},{"$f":"SUM(D7:O7)","v":0}]
[null,"Other Sales"]
[null,"TOTAL CASH RECEIPTS",{"$f":"SUM(C7:C7)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Total Cash Available (before cash out)",{"$f":"(C4+C9)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"(Q4+Q9)","v":0}]
[]
[null,"CASH PAID OUT"]
[null,"start-up expense",{"$f":"SUM(Questionaire!$F$22:$F$26)","v":0},0,{"$nulls":11},{"$f":"SUM(C13:O13)","v":0},0]
[null,"input materials",{"$f":"Questionaire!$F$28+Questionaire!$F$29","v":0},{"$f":"C14","v":0},{"$f":"D14","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C14:O14)","v":0},{"$f":"P14+(P14*Questionaire!$F$47)","v":0}]
[null,"consumables",{"$f":"Questionaire!$F$30+Questionaire!$F$31","v":0},{"$f":"C15","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C15:O15)","v":0},{"$f":"P15+(P15*Questionaire!$F$47)","v":0}]
[null,{"$f":"Questionaire!$E$33","v":"phone costs"},{"$f":"Questionaire!$F$33","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"P16+(P16*Questionaire!$F$47)","v":0}]
[null,{"$f":"Questionaire!$E$34","v":"transport costs"},{"$f":"Questionaire!$F$34","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"P17+(P17*Questionaire!$F$47)","v":0}]
[null,{"$f":"Questionaire!$E$35","v":"delivery costs"},{"$f":"Questionaire!$F$35","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"P18+(P18*Questionaire!$F$47)","v":0}]
[null,{"$f":"Questionaire!$E$36","v":"rent of business premises"},{"$f":"Questionaire!$F$36","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"P19+(P19*Questionaire!$F$47)","v":0}]
[null,{"$f":"Questionaire!$E$37","v":"staff salaries"},{"$f":"Questionaire!$F$37","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"P20+(P20*Questionaire!$F$47)","v":0}]
[null,{"$f":"Questionaire!$E$38","v":"taxes and duties"},{"$f":"Questionaire!$F$38","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"P21+(P21*Questionaire!$F$47)","v":0}]
[null,{"$f":"Questionaire!$E$39","v":"sub-contractors"},{"$f":"Questionaire!$F$39","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"P22+(P22*Questionaire!$F$47)","v":0}]
[null,{"$f":"Questionaire!$E$40","v":"advertising"},{"$f":"Questionaire!$F$40","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"P23+(P23*Questionaire!$F$47)","v":0}]
[null,{"$f":"Questionaire!$E$41","v":"water, electricity and other utilities"},{"$f":"Questionaire!$F$41","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"P24+(P24*Questionaire!$F$47)","v":0}]
[null,{"$f":"Questionaire!$E$42","v":"insurance fees"},{"$f":"Questionaire!$F$42","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"P25+(P25*Questionaire!$F$47)","v":0}]
[null,{"$f":"Questionaire!$E$43","v":"bookkeeping or accounting fees"},{"$f":"Questionaire!$F$43","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"P26+(P26*Questionaire!$F$47)","v":0}]
[null,{"$f":"Questionaire!$E$44","v":"various"},{"$f":"Questionaire!$F$44","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"P27+(P27*Questionaire!$F$47)","v":0}]
[null,{"$f":"Questionaire!$E$45","v":"various"},{"$f":"Questionaire!$F$45","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"P28+(P28*Questionaire!$F$47)","v":0}]
[null,"SUBTOTAL",{"$f":"SUM(C13:C28)","v":0},{"$f":"SUM(D13:D28)","v":0},{"$f":"SUM(E13:E28)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(P13:P28)","v":0},{"$f":"SUM(Q13:Q28)","v":0}]
[null,"Monthly loan repayment to 1st Bank",null,{"$f":"'1st Loan Repayment'!Scheduled_Monthly_Payment","v":"0"},{"$f":"D30","v":"0"},{"$f":"E30","v":"0"},"0","0","0","0","0","0","0","0","0",{"$f":"SUM(C30:O30)","v":0},{"$f":"P30","v":0}]
[null,"Monthly loan repayment to 2nd Bank",null,{"$f":"'2nd Loan Repayment'!Scheduled_Monthly_Payment","v":"0"},{"$f":"D31","v":"0"},{"$f":"E31","v":"0"},"0","0","0","0","0","0","0","0","0",{"$f":"SUM(C31:O31)","v":0},{"$f":"P31","v":0}]
[null,{"$f":"Review!$B$22","v":"Monthly savings for appliance maintenance and repairs:"},null,{"$f":"Review!$D$22","v":0},{"$f":"D32","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C32:O32)","v":0},{"$f":"P32","v":0}]
[null,{"$f":"Review!$B$23","v":"Monthly savings for solar PV System maintenance and repairs:"},null,{"$f":"Review!$D$23","v":0},{"$f":"D33","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,"TOTAL CASH PAID OUT",{"$f":"SUM(C29:C33)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Cash Position (end of month)",{"$f":"(C10-C34)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"(Q10-Q34)","v":0}]
[]
[]
[null,"12-Month Cash Flow"]
[null,{"$f":"Questionaire!E17","v":"Scenario: Stable"},"Company name:",null,{"$f":"Questionaire!$E$5","v":0},{"$nulls":4},"Fiscal Year Begins:",{"$f":"Questionaire!$F$108","v":"00:00:00"}]
[null,null,"Start-up",{"$f":"K39","v":"00:00:00"},{"$f":"DATE(YEAR(D40),MONTH(D40)+1,1)","v":"1900-02-01"},{"$f":"DATE(YEAR(E40),MONTH(E40)+1,1)","v":"1900-03-01"},{"$f":"DATE(YEAR(F40),MONTH(F40)+1,1)","v":"1900-04-01"},{"$f":"DATE(YEAR(G40),MONTH(G40)+1,1)","v":"1900-05-01"},{"$f":"DATE(YEAR(H40),MONTH(H40)+1,1)","v":"1900-06-01"},{"$f":"DATE(YEAR(I40),MONTH(I40)+1,1)","v":"1900-07-01"},{"$f":"DATE(YEAR(J40),MONTH(J40)+1,1)","v":"1900-08-01"},{"$f":"DATE(YEAR(K40),MONTH(K40)+1,1)","v":"1900-09-01"},{"$f":"DATE(YEAR(L40),MONTH(L40)+1,1)","v":"1900-10-01"},{"$f":"DATE(YEAR(M40),MONTH(M40)+1,1)","v":"1900-11-01"},{"$f":"DATE(YEAR(N40),MONTH(N40)+1,1)","v":"1900-12-01"},"Year 1","Year 2"]
[null,"STABLE: CASH AVAILABLE (beginning of month)",{"$f":"Questionaire!$F$100+Questionaire!$F$101","v":0},{"$f":"C72","v":0},0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"O72","v":0}]
[]
[null,"CASH RECEIPTS"]
[null,"Cash Sales",null,{"$f":"Questionaire!$F$17","v":0},{"$f":"Questionaire!$F$17","v":0},{"$f":"Questionaire!$F$17","v":0},{"$f":"Questionaire!$F$17","v":0},{"$f":"Questionaire!$F$17","v":0},{"$f":"Questionaire!$F$17","v":0},{"$f":"Questionaire!$F$17","v":0},{"$f":"Questionaire!$F$17","v":0},{"$f":"Questionaire!$F$17","v":0},{"$f":"Questionaire!$F$17","v":0},{"$f":"Questionaire!$F$17","v":0},{"$f":"Questionaire!$F$17","v":0},{"$f":"SUM(D44:O44)","v":0},{"$f":"SUM(D44:O44)","v":0}]
[null,"Other Sales"]
[null,"TOTAL CASH RECEIPTS",{"$f":"SUM(C44:C44)","v":0},{"$f":"SUM(D44:D44)","v":0},{"$f":"SUM(E44:E44)","v":0},{"$f":"SUM(F44:F44)","v":0},{"$f":"SUM(G44:G44)","v":0},{"$f":"SUM(H44:H44)","v":0},{"$f":"SUM(I44:I44)","v":0},{"$f":"SUM(J44:J44)","v":0},{"$f":"SUM(K44:K44)","v":0},{"$f":"SUM(L44:L44)","v":0},{"$f":"SUM(M44:M44)","v":0},{"$f":"SUM(N44:N44)","v":0},{"$f":"SUM(O44:O44)","v":0},{"$f":"SUM(P44:P44)","v":0},{"$f":"SUM(Q44:Q44)","v":0}]
[null,"Total Cash Available (before cash out)",{"$f":"(C41+C46)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"(Q41+Q46)","v":0}]
[]
[null,"CASH PAID OUT"]
[null,"start-up expense",{"$f":"SUM(Questionaire!$F$22:$F$26)","v":0},0,{"$nulls":11},{"$f":"SUM(C50:O50)","v":0},0]
[null,"input materials",{"$f":"Questionaire!$F$28+Questionaire!$F$29","v":0},{"$f":"C51","v":0},{"$f":"D51","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C51:O51)","v":0},{"$f":"P51+(P51*Questionaire!$F$47)","v":0}]
[null,"consumables",{"$f":"Questionaire!$F$30+Questionaire!$F$31","v":0},{"$f":"C52","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C52:O52)","v":0},{"$f":"P52+(P52*Questionaire!$F$47)","v":0}]
[null,{"$f":"Questionaire!$E$33","v":"phone costs"},{"$f":"Questionaire!$F$33","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"P53+(P53*Questionaire!$F$47)","v":0}]
[null,{"$f":"Questionaire!$E$34","v":"transport costs"},{"$f":"Questionaire!$F$34","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"P54+(P54*Questionaire!$F$47)","v":0}]
[null,{"$f":"Questionaire!$E$35","v":"delivery costs"},{"$f":"Questionaire!$F$35","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"P55+(P55*Questionaire!$F$47)","v":0}]
[null,{"$f":"Questionaire!$E$36","v":"rent of business premises"},{"$f":"Questionaire!$F$36","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"P56+(P56*Questionaire!$F$47)","v":0}]
[null,{"$f":"Questionaire!$E$37","v":"staff salaries"},{"$f":"Questionaire!$F$37","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"P57+(P57*Questionaire!$F$47)","v":0}]
[null,{"$f":"Questionaire!$E$38","v":"taxes and duties"},{"$f":"Questionaire!$F$38","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"P58+(P58*Questionaire!$F$47)","v":0}]
[null,{"$f":"Questionaire!$E$39","v":"sub-contractors"},{"$f":"Questionaire!$F$39","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"P59+(P59*Questionaire!$F$47)","v":0}]
[null,{"$f":"Questionaire!$E$40","v":"advertising"},{"$f":"Questionaire!$F$40","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"P60+(P60*Questionaire!$F$47)","v":0}]
[null,{"$f":"Questionaire!$E$41","v":"water, electricity and other utilities"},{"$f":"Questionaire!$F$41","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"P61+(P61*Questionaire!$F$47)","v":0}]
[null,{"$f":"Questionaire!$E$42","v":"insurance fees"},{"$f":"Questionaire!$F$42","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"P62+(P62*Questionaire!$F$47)","v":0}]
[null,{"$f":"Questionaire!$E$43","v":"bookkeeping or accounting fees"},{"$f":"Questionaire!$F$43","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"P63+(P63*Questionaire!$F$47)","v":0}]
[null,{"$f":"Questionaire!$E$44","v":"various"},{"$f":"Questionaire!$F$44","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"P64+(P64*Questionaire!$F$47)","v":0}]
[null,{"$f":"Questionaire!$E$45","v":"various"},{"$f":"Questionaire!$F$45","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"P65+(P65*Questionaire!$F$47)","v":0}]
[null,"SUBTOTAL",{"$f":"SUM(C50:C65)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Monthly loan repayment to 1st Bank",null,{"$f":"'1st Loan Repayment'!Scheduled_Monthly_Payment","v":"0"},{"$f":"D67","v":"0"},{"$f":"E67","v":"0"},"0","0","0","0","0","0","0","0","0",{"$f":"SUM(C67:O67)","v":0},{"$f":"P67","v":0}]
[null,"Monthly loan repayment to 2nd Bank",null,{"$f":"'2nd Loan Repayment'!Scheduled_Monthly_Payment","v":"0"},{"$f":"D68","v":"0"},{"$f":"E68","v":"0"},"0","0","0","0","0","0","0","0","0"]
[null,{"$f":"Review!$B$22","v":"Monthly savings for appliance maintenance and repairs:"},null,{"$f":"Review!$D$22","v":0},{"$f":"D69","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C69:O69)","v":0},{"$f":"P69","v":0}]
[null,{"$f":"Review!$B$23","v":"Monthly savings for solar PV System maintenance and repairs:"},null,{"$f":"Review!$D$23","v":0},{"$f":"D70","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,"TOTAL CASH PAID OUT",{"$f":"SUM(C66:C70)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Cash Position (end of month)",{"$f":"(C47-C71)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"(Q47-Q71)","v":0}]
[]
[]
[null,"12-Month Cash Flow"]
[null,{"$f":"Questionaire!E18","v":"Scenario: Weak"},"Company name:",null,{"$f":"Questionaire!$E$5","v":0},{"$nulls":4},"Fiscal Year Begins:",{"$f":"Questionaire!$F$108","v":"00:00:00"}]
[null,null,"Start-up",{"$f":"K76","v":"00:00:00"},{"$f":"DATE(YEAR(D77),MONTH(D77)+1,1)","v":"1900-02-01"},{"$f":"DATE(YEAR(E77),MONTH(E77)+1,1)","v":"1900-03-01"},{"$f":"DATE(YEAR(F77),MONTH(F77)+1,1)","v":"1900-04-01"},{"$f":"DATE(YEAR(G77),MONTH(G77)+1,1)","v":"1900-05-01"},{"$f":"DATE(YEAR(H77),MONTH(H77)+1,1)","v":"1900-06-01"},{"$f":"DATE(YEAR(I77),MONTH(I77)+1,1)","v":"1900-07-01"},{"$f":"DATE(YEAR(J77),MONTH(J77)+1,1)","v":"1900-08-01"},{"$f":"DATE(YEAR(K77),MONTH(K77)+1,1)","v":"1900-09-01"},{"$f":"DATE(YEAR(L77),MONTH(L77)+1,1)","v":"1900-10-01"},{"$f":"DATE(YEAR(M77),MONTH(M77)+1,1)","v":"1900-11-01"},{"$f":"DATE(YEAR(N77),MONTH(N77)+1,1)","v":"1900-12-01"},"Year 1","Year 2"]
[null,"WEAK: CASH AVAILABLE (beginning of month)",{"$f":"Questionaire!$F$100+Questionaire!$F$101","v":0},{"$f":"C109","v":0},0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"O109","v":0}]
[]
[null,"CASH RECEIPTS"]
[null,"Cash Sales",null,{"$f":"Questionaire!$F$18","v":0},{"$f":"Questionaire!$F$18","v":0},{"$f":"Questionaire!$F$18","v":0},{"$f":"Questionaire!$F$18","v":0},{"$f":"Questionaire!$F$18","v":0},{"$f":"Questionaire!$F$18","v":0},{"$f":"Questionaire!$F$18","v":0},{"$f":"Questionaire!$F$18","v":0},{"$f":"Questionaire!$F$18","v":0},{"$f":"Questionaire!$F$18","v":0},{"$f":"Questionaire!$F$18","v":0},{"$f":"Questionaire!$F$18","v":0},{"$f":"SUM(D81:O81)","v":0},{"$f":"SUM(D81:O81)","v":0}]
[null,"Other Sales"]
[null,"TOTAL CASH RECEIPTS",{"$f":"SUM(C81:C81)","v":0},{"$f":"SUM(D81:D81)","v":0},{"$f":"SUM(E81:E81)","v":0},{"$f":"SUM(F81:F81)","v":0},{"$f":"SUM(G81:G81)","v":0},{"$f":"SUM(H81:H81)","v":0},{"$f":"SUM(I81:I81)","v":0},{"$f":"SUM(J81:J81)","v":0},{"$f":"SUM(K81:K81)","v":0},{"$f":"SUM(L81:L81)","v":0},{"$f":"SUM(M81:M81)","v":0},{"$f":"SUM(N81:N81)","v":0},{"$f":"SUM(O81:O81)","v":0},{"$f":"SUM(P81:P81)","v":0},{"$f":"SUM(Q81:Q81)","v":0}]
[null,"Total Cash Available (before cash out)",{"$f":"(C78+C83)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"(Q78+Q83)","v":0}]
[]
[null,"CASH PAID OUT"]
[null,"start-up expense",{"$f":"SUM(Questionaire!$F$22:$F$26)","v":0},0,{"$nulls":11},{"$f":"SUM(C87:O87)","v":0},0]
[null,"input materials",{"$f":"Questionaire!$F$28+Questionaire!$F$29","v":0},{"$f":"C88","v":0},{"$f":"D88","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C88:O88)","v":0},{"$f":"P88+(P88*Questionaire!$F$47)","v":0}]
[null,"consumables",{"$f":"Questionaire!$F$30+Questionaire!$F$31","v":0},{"$f":"C89","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C89:O89)","v":0},{"$f":"P89+(P89*Questionaire!$F$47)","v":0}]
[null,{"$f":"Questionaire!$E$33","v":"phone costs"},{"$f":"Questionaire!$F$33","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"P90+(P90*Questionaire!$F$47)","v":0}]
[null,{"$f":"Questionaire!$E$34","v":"transport costs"},{"$f":"Questionaire!$F$34","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"P91+(P91*Questionaire!$F$47)","v":0}]
[null,{"$f":"Questionaire!$E$35","v":"delivery costs"},{"$f":"Questionaire!$F$35","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"P92+(P92*Questionaire!$F$47)","v":0}]
[null,{"$f":"Questionaire!$E$36","v":"rent of business premises"},{"$f":"Questionaire!$F$36","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"P93+(P93*Questionaire!$F$47)","v":0}]
[null,{"$f":"Questionaire!$E$37","v":"staff salaries"},{"$f":"Questionaire!$F$37","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"P94+(P94*Questionaire!$F$47)","v":0}]
[null,{"$f":"Questionaire!$E$38","v":"taxes and duties"},{"$f":"Questionaire!$F$38","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"P95+(P95*Questionaire!$F$47)","v":0}]
[null,{"$f":"Questionaire!$E$39","v":"sub-contractors"},{"$f":"Questionaire!$F$39","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"P96+(P96*Questionaire!$F$47)","v":0}]
[null,{"$f":"Questionaire!$E$40","v":"advertising"},{"$f":"Questionaire!$F$40","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"P97+(P97*Questionaire!$F$47)","v":0}]
[null,{"$f":"Questionaire!$E$41","v":"water, electricity and other utilities"},{"$f":"Questionaire!$F$41","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"P98+(P98*Questionaire!$F$47)","v":0}]
[null,{"$f":"Questionaire!$E$42","v":"insurance fees"},{"$f":"Questionaire!$F$42","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"P99+(P99*Questionaire!$F$47)","v":0}]
[null,{"$f":"Questionaire!$E$43","v":"bookkeeping or accounting fees"},{"$f":"Questionaire!$F$43","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"P100+(P100*Questionaire!$F$47)","v":0}]
[null,{"$f":"Questionaire!$E$44","v":"various"},{"$f":"Questionaire!$F$44","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"P101+(P101*Questionaire!$F$47)","v":0}]
[null,{"$f":"Questionaire!$E$45","v":"various"},{"$f":"Questionaire!$F$45","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"P102+(P102*Questionaire!$F$47)","v":0}]
[null,"SUBTOTAL",{"$f":"SUM(C87:C102)","v":0},{"$f":"SUM(D87:D102)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Monthly loan repayment to 1st Bank",null,{"$f":"'1st Loan Repayment'!Scheduled_Monthly_Payment","v":"0"},{"$f":"D104","v":"0"},{"$f":"E104","v":"0"},"0","0","0","0","0","0","0","0","0",{"$f":"SUM(C104:O104)","v":0},{"$f":"P104","v":0}]
[null,"Monthly loan repayment to 2nd Bank",null,{"$f":"'2nd Loan Repayment'!Scheduled_Monthly_Payment","v":"0"}]
[null,{"$f":"Review!$B$22","v":"Monthly savings for appliance maintenance and repairs:"},null,{"$f":"Review!$D$22","v":0},{"$f":"D106","v":0},{"$f":"E106","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(C106:O106)","v":0},{"$f":"P106","v":0}]
[null,{"$f":"Review!$B$23","v":"Monthly savings for solar PV System maintenance and repairs:"},null,{"$f":"Review!$D$23","v":0},{"$f":"D107","v":0},{"$f":"E107","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,"TOTAL CASH PAID OUT",{"$f":"SUM(C103:C107)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Cash Position (end of month)",{"$f":"(C84-C108)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"(Q84-Q108)","v":0}]

{"sheet":"10-Year Cash Flow","index":6,"n_rows":107,"n_cols":14,"rows_kept":107,"cut":false,"hidden":false,"merged":[[84,3,84,12],[0,1,0,13],[36,1,36,13],[72,1,72,13],[12,3,12,12],[48,3,48,12]]}
[null,"10-Year Cash Flow"]
[null,{"$f":"Questionaire!E16","v":"Scenario: Strong"},"Company name:",null,{"$f":"Questionaire!$E$5","v":0},{"$nulls":4},"Fiscal Year Begins:",{"$f":"Questionaire!$F$108","v":"00:00:00"}]
[null,null,"Year 1","Year 2","Year 3","Year 4","Year 5","Year 6","Year 7","Year 8","Year 9","Year 10","Year 11","Year 12"]
[null,"STRONG: CASH AVAILABLE (beginning of year)",{"$f":"Questionaire!$F$100+Questionaire!$F$101","v":0},{"$f":"C35","v":0},{"$f":"D35","v":0},{"$f":"E35","v":0},{"$f":"F35","v":0},0,0,0,0,0,0,0]
[]
[null,"CASH RECEIPTS"]
[null,"Cash Sales",{"$f":"'12-Month Cash Flow'!Q9","v":0},{"$f":"C7","v":0},{"$f":"D7","v":0},{"$f":"E7","v":0},{"$f":"F7","v":0},{"$f":"G7","v":0},0,0,0,0,0]
[null,"Other Sales"]
[null,"TOTAL CASH RECEIPTS",{"$f":"SUM(C7:C7)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"Total Cash Available (before cash out)",{"$f":"(C4+C9)","v":0},{"$f":"(D4+D9)","v":0},{"$f":"(E4+E9)","v":0},{"$f":"(F4+F9)","v":0},{"$f":"(G4+G9)","v":0},{"$f":"(H4+H9)","v":0},0,0,0,0,0]
[]
[null,"CASH PAID OUT"]
[null,"start-up expense",{"$f":"'12-Month Cash Flow'!$P$13","v":0},0]
[null,"input materials",{"$f":"'12-Month Cash Flow'!$P$14","v":0},{"$f":"C14+(C14*Questionaire!$F$47)","v":0},{"$f":"D14+(D14*Questionaire!$F$47)","v":0},{"$f":"E14+(E14*Questionaire!$F$47)","v":0},{"$f":"F14+(F14*Questionaire!$F$47)","v":0},{"$f":"G14+(G14*Questionaire!$F$47)","v":0},{"$f":"H14+(H14*Questionaire!$F$47)","v":0},{"$f":"I14+(I14*Questionaire!$F$47)","v":0},{"$f":"J14+(J14*Questionaire!$F$47)","v":0},{"$f":"K14+(K14*Questionaire!$F$47)","v":0},{"$f":"L14+(L14*Questionaire!$F$47)","v":0}]
[null,"consumables",{"$f":"'12-Month Cash Flow'!$P$15","v":0},{"$f":"C15+(C15*Questionaire!$F$47)","v":0},{"$f":"D15+(D15*Questionaire!$F$47)","v":0},{"$f":"E15+(E15*Questionaire!$F$47)","v":0},{"$f":"F15+(F15*Questionaire!$F$47)","v":0},{"$f":"G15+(G15*Questionaire!$F$47)","v":0},{"$f":"H15+(H15*Questionaire!$F$47)","v":0},{"$f":"I15+(I15*Questionaire!$F$47)","v":0},{"$f":"J15+(J15*Questionaire!$F$47)","v":0},{"$f":"K15+(K15*Questionaire!$F$47)","v":0},{"$f":"L15+(L15*Questionaire!$F$47)","v":0}]
[null,{"$f":"Questionaire!$E$33","v":"phone costs"},{"$f":"'12-Month Cash Flow'!$P$16","v":0},{"$f":"C16+(C16*Questionaire!$F$47)","v":0},{"$f":"D16+(D16*Questionaire!$F$47)","v":0},{"$f":"E16+(E16*Questionaire!$F$47)","v":0},{"$f":"F16+(F16*Questionaire!$F$47)","v":0},{"$f":"G16+(G16*Questionaire!$F$47)","v":0},{"$f":"H16+(H16*Questionaire!$F$47)","v":0},{"$f":"I16+(I16*Questionaire!$F$47)","v":0},{"$f":"J16+(J16*Questionaire!$F$47)","v":0},{"$f":"K16+(K16*Questionaire!$F$47)","v":0},{"$f":"L16+(L16*Questionaire!$F$47)","v":0}]
[null,{"$f":"Questionaire!$E$34","v":"transport costs"},{"$f":"'12-Month Cash Flow'!$P$17","v":0},{"$f":"C17+(C17*Questionaire!$F$47)","v":0},{"$f":"D17+(D17*Questionaire!$F$47)","v":0},{"$f":"E17+(E17*Questionaire!$F$47)","v":0},{"$f":"F17+(F17*Questionaire!$F$47)","v":0},{"$f":"G17+(G17*Questionaire!$F$47)","v":0},{"$f":"H17+(H17*Questionaire!$F$47)","v":0},{"$f":"I17+(I17*Questionaire!$F$47)","v":0},{"$f":"J17+(J17*Questionaire!$F$47)","v":0},{"$f":"K17+(K17*Questionaire!$F$47)","v":0},{"$f":"L17+(L17*Questionaire!$F$47)","v":0}]
[null,{"$f":"Questionaire!$E$35","v":"delivery costs"},{"$f":"'12-Month Cash Flow'!$P$18","v":0},{"$f":"C18+(C18*Questionaire!$F$47)","v":0},{"$f":"D18+(D18*Questionaire!$F$47)","v":0},{"$f":"E18+(E18*Questionaire!$F$47)","v":0},{"$f":"F18+(F18*Questionaire!$F$47)","v":0},{"$f":"G18+(G18*Questionaire!$F$47)","v":0},{"$f":"H18+(H18*Questionaire!$F$47)","v":0},{"$f":"I18+(I18*Questionaire!$F$47)","v":0},{"$f":"J18+(J18*Questionaire!$F$47)","v":0},{"$f":"K18+(K18*Questionaire!$F$47)","v":0},{"$f":"L18+(L18*Questionaire!$F$47)","v":0}]
[null,{"$f":"Questionaire!$E$36","v":"rent of business premises"},{"$f":"'12-Month Cash Flow'!$P$19","v":0},{"$f":"C19+(C19*Questionaire!$F$47)","v":0},{"$f":"D19+(D19*Questionaire!$F$47)","v":0},{"$f":"E19+(E19*Questionaire!$F$47)","v":0},{"$f":"F19+(F19*Questionaire!$F$47)","v":0},{"$f":"G19+(G19*Questionaire!$F$47)","v":0},{"$f":"H19+(H19*Questionaire!$F$47)","v":0},{"$f":"I19+(I19*Questionaire!$F$47)","v":0},{"$f":"J19+(J19*Questionaire!$F$47)","v":0},{"$f":"K19+(K19*Questionaire!$F$47)","v":0},{"$f":"L19+(L19*Questionaire!$F$47)","v":0}]
[null,{"$f":"Questionaire!$E$37","v":"staff salaries"},{"$f":"'12-Month Cash Flow'!$P$20","v":0},{"$f":"C20+(C20*Questionaire!$F$47)","v":0},{"$f":"D20+(D20*Questionaire!$F$47)","v":0},{"$f":"E20+(E20*Questionaire!$F$47)","v":0},{"$f":"F20+(F20*Questionaire!$F$47)","v":0},{"$f":"G20+(G20*Questionaire!$F$47)","v":0},{"$f":"H20+(H20*Questionaire!$F$47)","v":0},{"$f":"I20+(I20*Questionaire!$F$47)","v":0},{"$f":"J20+(J20*Questionaire!$F$47)","v":0},{"$f":"K20+(K20*Questionaire!$F$47)","v":0},{"$f":"L20+(L20*Questionaire!$F$47)","v":0}]
[null,{"$f":"Questionaire!$E$38","v":"taxes and duties"},{"$f":"'12-Month Cash Flow'!$P$21","v":0},{"$f":"C21+(C21*Questionaire!$F$47)","v":0},{"$f":"D21+(D21*Questionaire!$F$47)","v":0},{"$f":"E21+(E21*Questionaire!$F$47)","v":0},{"$f":"F21+(F21*Questionaire!$F$47)","v":0},{"$f":"G21+(G21*Questionaire!$F$47)","v":0},{"$f":"H21+(H21*Questionaire!$F$47)","v":0},{"$f":"I21+(I21*Questionaire!$F$47)","v":0},{"$f":"J21+(J21*Questionaire!$F$47)","v":0},{"$f":"K21+(K21*Questionaire!$F$47)","v":0},{"$f":"L21+(L21*Questionaire!$F$47)","v":0}]
[null,{"$f":"Questionaire!$E$39","v":"sub-contractors"},{"$f":"'12-Month Cash Flow'!$P$22","v":0},{"$f":"C22+(C22*Questionaire!$F$47)","v":0},{"$f":"D22+(D22*Questionaire!$F$47)","v":0},{"$f":"E22+(E22*Questionaire!$F$47)","v":0},{"$f":"F22+(F22*Questionaire!$F$47)","v":0},{"$f":"G22+(G22*Questionaire!$F$47)","v":0},{"$f":"H22+(H22*Questionaire!$F$47)","v":0},{"$f":"I22+(I22*Questionaire!$F$47)","v":0},{"$f":"J22+(J22*Questionaire!$F$47)","v":0},{"$f":"K22+(K22*Questionaire!$F$47)","v":0},{"$f":"L22+(L22*Questionaire!$F$47)","v":0}]
[null,{"$f":"Questionaire!$E$40","v":"advertising"},{"$f":"'12-Month Cash Flow'!$P$23","v":0},{"$f":"C23+(C23*Questionaire!$F$47)","v":0},{"$f":"D23+(D23*Questionaire!$F$47)","v":0},{"$f":"E23+(E23*Questionaire!$F$47)","v":0},{"$f":"F23+(F23*Questionaire!$F$47)","v":0},{"$f":"G23+(G23*Questionaire!$F$47)","v":0},{"$f":"H23+(H23*Questionaire!$F$47)","v":0},{"$f":"I23+(I23*Questionaire!$F$47)","v":0},{"$f":"J23+(J23*Questionaire!$F$47)","v":0},{"$f":"K23+(K23*Questionaire!$F$47)","v":0},{"$f":"L23+(L23*Questionaire!$F$47)","v":0}]
[null,{"$f":"Questionaire!$E$41","v":"water, electricity and other utilities"},{"$f":"'12-Month Cash Flow'!$P$24","v":0},{"$f":"C24+(C24*Questionaire!$F$47)","v":0},{"$f":"D24+(D24*Questionaire!$F$47)","v":0},{"$f":"E24+(E24*Questionaire!$F$47)","v":0},{"$f":"F24+(F24*Questionaire!$F$47)","v":0},{"$f":"G24+(G24*Questionaire!$F$47)","v":0},{"$f":"H24+(H24*Questionaire!$F$47)","v":0},{"$f":"I24+(I24*Questionaire!$F$47)","v":0},{"$f":"J24+(J24*Questionaire!$F$47)","v":0},{"$f":"K24+(K24*Questionaire!$F$47)","v":0},{"$f":"L24+(L24*Questionaire!$F$47)","v":0}]
[null,{"$f":"Questionaire!$E$42","v":"insurance fees"},{"$f":"'12-Month Cash Flow'!$P$25","v":0},{"$f":"C25+(C25*Questionaire!$F$47)","v":0},{"$f":"D25+(D25*Questionaire!$F$47)","v":0},{"$f":"E25+(E25*Questionaire!$F$47)","v":0},{"$f":"F25+(F25*Questionaire!$F$47)","v":0},{"$f":"G25+(G25*Questionaire!$F$47)","v":0},{"$f":"H25+(H25*Questionaire!$F$47)","v":0},{"$f":"I25+(I25*Questionaire!$F$47)","v":0},{"$f":"J25+(J25*Questionaire!$F$47)","v":0},{"$f":"K25+(K25*Questionaire!$F$47)","v":0},{"$f":"L25+(L25*Questionaire!$F$47)","v":0}]
[null,{"$f":"Questionaire!$E$43","v":"bookkeeping or accounting fees"},{"$f":"'12-Month Cash Flow'!$P$26","v":0},{"$f":"C26+(C26*Questionaire!$F$47)","v":0},{"$f":"D26+(D26*Questionaire!$F$47)","v":0},{"$f":"E26+(E26*Questionaire!$F$47)","v":0},{"$f":"F26+(F26*Questionaire!$F$47)","v":0},{"$f":"G26+(G26*Questionaire!$F$47)","v":0},{"$f":"H26+(H26*Questionaire!$F$47)","v":0},{"$f":"I26+(I26*Questionaire!$F$47)","v":0},{"$f":"J26+(J26*Questionaire!$F$47)","v":0},{"$f":"K26+(K26*Questionaire!$F$47)","v":0},{"$f":"L26+(L26*Questionaire!$F$47)","v":0}]
[null,{"$f":"Questionaire!$E$44","v":"various"},{"$f":"'12-Month Cash Flow'!$P$27","v":0},{"$f":"C27+(C27*Questionaire!$F$47)","v":0},{"$f":"D27+(D27*Questionaire!$F$47)","v":0},{"$f":"E27+(E27*Questionaire!$F$47)","v":0},{"$f":"F27+(F27*Questionaire!$F$47)","v":0},{"$f":"G27+(G27*Questionaire!$F$47)","v":0},{"$f":"H27+(H27*Questionaire!$F$47)","v":0},{"$f":"I27+(I27*Questionaire!$F$47)","v":0},{"$f":"J27+(J27*Questionaire!$F$47)","v":0},{"$f":"K27+(K27*Questionaire!$F$47)","v":0},{"$f":"L27+(L27*Questionaire!$F$47)","v":0}]
[null,{"$f":"Questionaire!$E$45","v":"various"},{"$f":"'12-Month Cash Flow'!$P$28","v":0},{"$f":"C28+(C28*Questionaire!$F$47)","v":0},{"$f":"D28+(D28*Questionaire!$F$47)","v":0},{"$f":"E28+(E28*Questionaire!$F$47)","v":0},{"$f":"F28+(F28*Questionaire!$F$47)","v":0},{"$f":"G28+(G28*Questionaire!$F$47)","v":0},{"$f":"H28+(H28*Questionaire!$F$47)","v":0},{"$f":"I28+(I28*Questionaire!$F$47)","v":0},{"$f":"J28+(J28*Questionaire!$F$47)","v":0},{"$f":"K28+(K28*Questionaire!$F$47)","v":0},{"$f":"L28+(L28*Questionaire!$F$47)","v":0}]
[null,"SUBTOTAL",{"$f":"SUM(C13:C28)","v":0},{"$f":"SUM(D13:D28)","v":0},{"$f":"SUM(E13:E28)","v":0},0,0,0,0,0,0,0,0]
[null,{"$f":"'12-Month Cash Flow'!$B$30","v":"Monthly loan repayment to 1st Bank"},{"$f":"'12-Month Cash Flow'!$P$30","v":0},{"$f":"IF('1st Loan Repayment'!Loan_Years<2,\"0\",$C$30)","v":"0"},{"$f":"IF('1st Loan Repayment'!Loan_Years<3,\"0\",$C$30)","v":"0"},{"$f":"IF('1st Loan Repayment'!Loan_Years<4,\"0\",$C$30)","v":"0"},{"$f":"IF('1st Loan Repayment'!Loan_Years<5,\"0\",$C$30)","v":"0"},{"$f":"IF('1st Loan Repayment'!Loan_Years<6,\"0\",$C$30)","v":"0"},{"$f":"IF('1st Loan Repayment'!Loan_Years<7,\"0\",$C$30)","v":"0"},{"$f":"IF('1st Loan Repayment'!Loan_Years<8,\"0\",$C$30)","v":"0"},{"$f":"IF('1st Loan Repayment'!Loan_Years<9,\"0\",$C$30)","v":"0"},{"$f":"IF('1st Loan Repayment'!Loan_Years<10,\"0\",$C$30)","v":"0"},{"$f":"IF('1st Loan Repayment'!Loan_Years<11,\"0\",$C$30)","v":"0"}]
[null,{"$f":"'12-Month Cash Flow'!$B$31","v":"Monthly loan repayment to 2nd Bank"},{"$f":"'12-Month Cash Flow'!$P$31","v":0},{"$f":"IF('2nd Loan Repayment'!Loan_Years<2,\"0\",$C$31)","v":"0"},{"$f":"IF('2nd Loan Repayment'!Loan_Years<3,\"0\",$C$31)","v":"0"},{"$f":"IF('2nd Loan Repayment'!Loan_Years<4,\"0\",$C$31)","v":"0"},{"$f":"IF('2nd Loan Repayment'!Loan_Years<5,\"0\",$C$31)","v":"0"},{"$f":"IF('2nd Loan Repayment'!Loan_Years<6,\"0\",$C$31)","v":"0"},{"$f":"IF('2nd Loan Repayment'!Loan_Years<7,\"0\",$C$31)","v":"0"},{"$f":"IF('2nd Loan Repayment'!Loan_Years<8,\"0\",$C$31)","v":"0"},{"$f":"IF('2nd Loan Repayment'!Loan_Years<9,\"0\",$C$31)","v":"0"},{"$f":"IF('2nd Loan Repayment'!Loan_Years<10,\"0\",$C$31)","v":"0"},{"$f":"IF('2nd Loan Repayment'!Loan_Years<11,\"0\",$C$31)","v":"0"}]
[null,{"$f":"Review!$B$22","v":"Monthly savings for appliance maintenance and repairs:"},{"$f":"'12-Month Cash Flow'!$P$32","v":0},{"$f":"C32","v":0},0,0,{"$f":"F32","v":0},0,0,0,0,0,0]
[null,{"$f":"Review!$B$23","v":"Monthly savings for solar PV System maintenance and repairs:"},{"$f":"'12-Month Cash Flow'!$P$33","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"TOTAL CASH PAID OUT",{"$f":"SUM(C29:C33)","v":0},{"$f":"SUM(D29:D33)","v":0},{"$f":"SUM(E29:E33)","v":0},{"$f":"SUM(F29:F33)","v":0},{"$f":"SUM(G29:G33)","v":0},0,0,0,0,0,0]
[null,"Cash Position (end of year)",{"$f":"C10-C34","v":0},{"$f":"(D10-D34)","v":0},{"$f":"(E10-E34)","v":0},{"$f":"(F10-F34)","v":0},{"$f":"(G10-G34)","v":0},0,0,0,0,0,0]
[]
[null,"10-Year Cash Flow"]
[null,{"$f":"Questionaire!E17","v":"Scenario: Stable"},"Company name:",null,{"$f":"Questionaire!$E$5","v":0},{"$nulls":4},"Fiscal Year Begins:",{"$f":"Questionaire!$F$108","v":"00:00:00"}]
[null,null,"Year 1","Year 2","Year 3","Year 4","Year 5","Year 6","Year 7","Year 8","Year 9","Year 10","Year 11","Year 12"]
[null,"STABLE: CASH AVAILABLE (beginning of year)",{"$f":"Questionaire!$F$100+Questionaire!$F$101","v":0},{"$f":"C71","v":0},{"$f":"D71","v":0},{"$f":"E71","v":0},{"$f":"F71","v":0},0,0,0,0,0,0,0]
[]
[null,"CASH RECEIPTS"]
[null,"Cash Sales",{"$f":"'12-Month Cash Flow'!Q46","v":0},{"$f":"C43","v":0},{"$f":"D43","v":0},{"$f":"E43","v":0},{"$f":"F43","v":0},{"$f":"G43","v":0},0,0,0,0,0]
[null,"Other Sales"]
[null,"TOTAL CASH RECEIPTS",{"$f":"SUM(C43:C43)","v":0},{"$f":"SUM(D43:D43)","v":0},{"$f":"SUM(E43:E43)","v":0},{"$f":"SUM(F43:F43)","v":0},{"$f":"SUM(G43:G43)","v":0},{"$f":"SUM(H43:H43)","v":0},{"$f":"SUM(I43:I43)","v":0},{"$f":"SUM(J43:J43)","v":0},{"$f":"SUM(K43:K43)","v":0},{"$f":"SUM(L43:L43)","v":0},{"$f":"SUM(M43:M43)","v":0}]
[null,"Total Cash Available (before cash out)",{"$f":"(C40+C45)","v":0},{"$f":"(D40+D45)","v":0},{"$f":"(E40+E45)","v":0},{"$f":"(F40+F45)","v":0},{"$f":"(G40+G45)","v":0},{"$f":"(H40+H45)","v":0},{"$f":"(I40+I45)","v":0},{"$f":"(J40+J45)","v":0},{"$f":"(K40+K45)","v":0},{"$f":"(L40+L45)","v":0},{"$f":"(M40+M45)","v":0}]
[]
[null,"CASH PAID OUT"]
[null,"start-up expense",{"$f":"'12-Month Cash Flow'!$P$13","v":0},0]
[null,"input materials",{"$f":"'12-Month Cash Flow'!$P$14","v":0},{"$f":"C50+(C50*Questionaire!$F$47)","v":0},{"$f":"D50+(D50*Questionaire!$F$47)","v":0},{"$f":"E50+(E50*Questionaire!$F$47)","v":0},{"$f":"F50+(F50*Questionaire!$F$47)","v":0},{"$f":"G50+(G50*Questionaire!$F$47)","v":0},{"$f":"H50+(H50*Questionaire!$F$47)","v":0},{"$f":"I50+(I50*Questionaire!$F$47)","v":0},{"$f":"J50+(J50*Questionaire!$F$47)","v":0},{"$f":"K50+(K50*Questionaire!$F$47)","v":0},{"$f":"L50+(L50*Questionaire!$F$47)","v":0}]
[null,"consumables",{"$f":"'12-Month Cash Flow'!$P$15","v":0},{"$f":"C51+(C51*Questionaire!$F$47)","v":0},{"$f":"D51+(D51*Questionaire!$F$47)","v":0},{"$f":"E51+(E51*Questionaire!$F$47)","v":0},{"$f":"F51+(F51*Questionaire!$F$47)","v":0},{"$f":"G51+(G51*Questionaire!$F$47)","v":0},{"$f":"H51+(H51*Questionaire!$F$47)","v":0},{"$f":"I51+(I51*Questionaire!$F$47)","v":0},{"$f":"J51+(J51*Questionaire!$F$47)","v":0},{"$f":"K51+(K51*Questionaire!$F$47)","v":0},{"$f":"L51+(L51*Questionaire!$F$47)","v":0}]
[null,{"$f":"Questionaire!$E$33","v":"phone costs"},{"$f":"'12-Month Cash Flow'!$P$16","v":0},{"$f":"C52+(C52*Questionaire!$F$47)","v":0},{"$f":"D52+(D52*Questionaire!$F$47)","v":0},{"$f":"E52+(E52*Questionaire!$F$47)","v":0},{"$f":"F52+(F52*Questionaire!$F$47)","v":0},{"$f":"G52+(G52*Questionaire!$F$47)","v":0},{"$f":"H52+(H52*Questionaire!$F$47)","v":0},{"$f":"I52+(I52*Questionaire!$F$47)","v":0},{"$f":"J52+(J52*Questionaire!$F$47)","v":0},{"$f":"K52+(K52*Questionaire!$F$47)","v":0},{"$f":"L52+(L52*Questionaire!$F$47)","v":0}]
[null,{"$f":"Questionaire!$E$34","v":"transport costs"},{"$f":"'12-Month Cash Flow'!$P$17","v":0},{"$f":"C53+(C53*Questionaire!$F$47)","v":0},{"$f":"D53+(D53*Questionaire!$F$47)","v":0},{"$f":"E53+(E53*Questionaire!$F$47)","v":0},{"$f":"F53+(F53*Questionaire!$F$47)","v":0},{"$f":"G53+(G53*Questionaire!$F$47)","v":0},{"$f":"H53+(H53*Questionaire!$F$47)","v":0},{"$f":"I53+(I53*Questionaire!$F$47)","v":0},{"$f":"J53+(J53*Questionaire!$F$47)","v":0},{"$f":"K53+(K53*Questionaire!$F$47)","v":0},{"$f":"L53+(L53*Questionaire!$F$47)","v":0}]
[null,{"$f":"Questionaire!$E$35","v":"delivery costs"},{"$f":"'12-Month Cash Flow'!$P$18","v":0},{"$f":"C54+(C54*Questionaire!$F$47)","v":0},{"$f":"D54+(D54*Questionaire!$F$47)","v":0},{"$f":"E54+(E54*Questionaire!$F$47)","v":0},{"$f":"F54+(F54*Questionaire!$F$47)","v":0},{"$f":"G54+(G54*Questionaire!$F$47)","v":0},{"$f":"H54+(H54*Questionaire!$F$47)","v":0},{"$f":"I54+(I54*Questionaire!$F$47)","v":0},{"$f":"J54+(J54*Questionaire!$F$47)","v":0},{"$f":"K54+(K54*Questionaire!$F$47)","v":0},{"$f":"L54+(L54*Questionaire!$F$47)","v":0}]
[null,{"$f":"Questionaire!$E$36","v":"rent of business premises"},{"$f":"'12-Month Cash Flow'!$P$19","v":0},{"$f":"C55+(C55*Questionaire!$F$47)","v":0},{"$f":"D55+(D55*Questionaire!$F$47)","v":0},{"$f":"E55+(E55*Questionaire!$F$47)","v":0},{"$f":"F55+(F55*Questionaire!$F$47)","v":0},{"$f":"G55+(G55*Questionaire!$F$47)","v":0},{"$f":"H55+(H55*Questionaire!$F$47)","v":0},{"$f":"I55+(I55*Questionaire!$F$47)","v":0},{"$f":"J55+(J55*Questionaire!$F$47)","v":0},{"$f":"K55+(K55*Questionaire!$F$47)","v":0},{"$f":"L55+(L55*Questionaire!$F$47)","v":0}]
[null,{"$f":"Questionaire!$E$37","v":"staff salaries"},{"$f":"'12-Month Cash Flow'!$P$20","v":0},{"$f":"C56+(C56*Questionaire!$F$47)","v":0},{"$f":"D56+(D56*Questionaire!$F$47)","v":0},{"$f":"E56+(E56*Questionaire!$F$47)","v":0},{"$f":"F56+(F56*Questionaire!$F$47)","v":0},{"$f":"G56+(G56*Questionaire!$F$47)","v":0},{"$f":"H56+(H56*Questionaire!$F$47)","v":0},{"$f":"I56+(I56*Questionaire!$F$47)","v":0},{"$f":"J56+(J56*Questionaire!$F$47)","v":0},{"$f":"K56+(K56*Questionaire!$F$47)","v":0},{"$f":"L56+(L56*Questionaire!$F$47)","v":0}]
[null,{"$f":"Questionaire!$E$38","v":"taxes and duties"},{"$f":"'12-Month Cash Flow'!$P$21","v":0},{"$f":"C57+(C57*Questionaire!$F$47)","v":0},{"$f":"D57+(D57*Questionaire!$F$47)","v":0},{"$f":"E57+(E57*Questionaire!$F$47)","v":0},{"$f":"F57+(F57*Questionaire!$F$47)","v":0},{"$f":"G57+(G57*Questionaire!$F$47)","v":0},{"$f":"H57+(H57*Questionaire!$F$47)","v":0},{"$f":"I57+(I57*Questionaire!$F$47)","v":0},{"$f":"J57+(J57*Questionaire!$F$47)","v":0},{"$f":"K57+(K57*Questionaire!$F$47)","v":0},{"$f":"L57+(L57*Questionaire!$F$47)","v":0}]
[null,{"$f":"Questionaire!$E$39","v":"sub-contractors"},{"$f":"'12-Month Cash Flow'!$P$22","v":0},{"$f":"C58+(C58*Questionaire!$F$47)","v":0},{"$f":"D58+(D58*Questionaire!$F$47)","v":0},{"$f":"E58+(E58*Questionaire!$F$47)","v":0},{"$f":"F58+(F58*Questionaire!$F$47)","v":0},{"$f":"G58+(G58*Questionaire!$F$47)","v":0},{"$f":"H58+(H58*Questionaire!$F$47)","v":0},{"$f":"I58+(I58*Questionaire!$F$47)","v":0},{"$f":"J58+(J58*Questionaire!$F$47)","v":0},{"$f":"K58+(K58*Questionaire!$F$47)","v":0},{"$f":"L58+(L58*Questionaire!$F$47)","v":0}]
[null,{"$f":"Questionaire!$E$40","v":"advertising"},{"$f":"'12-Month Cash Flow'!$P$23","v":0},{"$f":"C59+(C59*Questionaire!$F$47)","v":0},{"$f":"D59+(D59*Questionaire!$F$47)","v":0},{"$f":"E59+(E59*Questionaire!$F$47)","v":0},{"$f":"F59+(F59*Questionaire!$F$47)","v":0},{"$f":"G59+(G59*Questionaire!$F$47)","v":0},{"$f":"H59+(H59*Questionaire!$F$47)","v":0},{"$f":"I59+(I59*Questionaire!$F$47)","v":0},{"$f":"J59+(J59*Questionaire!$F$47)","v":0},{"$f":"K59+(K59*Questionaire!$F$47)","v":0},{"$f":"L59+(L59*Questionaire!$F$47)","v":0}]
[null,{"$f":"Questionaire!$E$41","v":"water, electricity and other utilities"},{"$f":"'12-Month Cash Flow'!$P$24","v":0},{"$f":"C60+(C60*Questionaire!$F$47)","v":0},{"$f":"D60+(D60*Questionaire!$F$47)","v":0},{"$f":"E60+(E60*Questionaire!$F$47)","v":0},{"$f":"F60+(F60*Questionaire!$F$47)","v":0},{"$f":"G60+(G60*Questionaire!$F$47)","v":0},{"$f":"H60+(H60*Questionaire!$F$47)","v":0},{"$f":"I60+(I60*Questionaire!$F$47)","v":0},{"$f":"J60+(J60*Questionaire!$F$47)","v":0},{"$f":"K60+(K60*Questionaire!$F$47)","v":0},{"$f":"L60+(L60*Questionaire!$F$47)","v":0}]
[null,{"$f":"Questionaire!$E$42","v":"insurance fees"},{"$f":"'12-Month Cash Flow'!$P$25","v":0},{"$f":"C61+(C61*Questionaire!$F$47)","v":0},{"$f":"D61+(D61*Questionaire!$F$47)","v":0},{"$f":"E61+(E61*Questionaire!$F$47)","v":0},{"$f":"F61+(F61*Questionaire!$F$47)","v":0},{"$f":"G61+(G61*Questionaire!$F$47)","v":0},{"$f":"H61+(H61*Questionaire!$F$47)","v":0},{"$f":"I61+(I61*Questionaire!$F$47)","v":0},{"$f":"J61+(J61*Questionaire!$F$47)","v":0},{"$f":"K61+(K61*Questionaire!$F$47)","v":0},{"$f":"L61+(L61*Questionaire!$F$47)","v":0}]
[null,{"$f":"Questionaire!$E$43","v":"bookkeeping or accounting fees"},{"$f":"'12-Month Cash Flow'!$P$26","v":0},{"$f":"C62+(C62*Questionaire!$F$47)","v":0},{"$f":"D62+(D62*Questionaire!$F$47)","v":0},{"$f":"E62+(E62*Questionaire!$F$47)","v":0},{"$f":"F62+(F62*Questionaire!$F$47)","v":0},{"$f":"G62+(G62*Questionaire!$F$47)","v":0},{"$f":"H62+(H62*Questionaire!$F$47)","v":0},{"$f":"I62+(I62*Questionaire!$F$47)","v":0},{"$f":"J62+(J62*Questionaire!$F$47)","v":0},{"$f":"K62+(K62*Questionaire!$F$47)","v":0},{"$f":"L62+(L62*Questionaire!$F$47)","v":0}]
[null,{"$f":"Questionaire!$E$44","v":"various"},{"$f":"'12-Month Cash Flow'!$P$27","v":0},{"$f":"C63+(C63*Questionaire!$F$47)","v":0},{"$f":"D63+(D63*Questionaire!$F$47)","v":0},{"$f":"E63+(E63*Questionaire!$F$47)","v":0},{"$f":"F63+(F63*Questionaire!$F$47)","v":0},{"$f":"G63+(G63*Questionaire!$F$47)","v":0},{"$f":"H63+(H63*Questionaire!$F$47)","v":0},{"$f":"I63+(I63*Questionaire!$F$47)","v":0},{"$f":"J63+(J63*Questionaire!$F$47)","v":0},{"$f":"K63+(K63*Questionaire!$F$47)","v":0},{"$f":"L63+(L63*Questionaire!$F$47)","v":0}]
[null,{"$f":"Questionaire!$E$45","v":"various"},{"$f":"'12-Month Cash Flow'!$P$28","v":0},{"$f":"C64+(C64*Questionaire!$F$47)","v":0},{"$f":"D64+(D64*Questionaire!$F$47)","v":0},{"$f":"E64+(E64*Questionaire!$F$47)","v":0},{"$f":"F64+(F64*Questionaire!$F$47)","v":0},{"$f":"G64+(G64*Questionaire!$F$47)","v":0},{"$f":"H64+(H64*Questionaire!$F$47)","v":0},{"$f":"I64+(I64*Questionaire!$F$47)","v":0},{"$f":"J64+(J64*Questionaire!$F$47)","v":0},{"$f":"K64+(K64*Questionaire!$F$47)","v":0},{"$f":"L64+(L64*Questionaire!$F$47)","v":0}]
[null,"SUBTOTAL",{"$f":"SUM(C49:C64)","v":0},{"$f":"SUM(D49:D64)","v":0},0,0,0,0,0,0,0,0,0]
[null,{"$f":"'12-Month Cash Flow'!$B$30","v":"Monthly loan repayment to 1st Bank"},{"$f":"'12-Month Cash Flow'!$P$30","v":0},{"$f":"IF('1st Loan Repayment'!Loan_Years<2,\"0\",$C$30)","v":"0"},{"$f":"IF('1st Loan Repayment'!Loan_Years<3,\"0\",$C$30)","v":"0"},{"$f":"IF('1st Loan Repayment'!Loan_Years<4,\"0\",$C$30)","v":"0"},{"$f":"IF('1st Loan Repayment'!Loan_Years<5,\"0\",$C$30)","v":"0"},{"$f":"IF('1st Loan Repayment'!Loan_Years<6,\"0\",$C$30)","v":"0"},{"$f":"IF('1st Loan Repayment'!Loan_Years<7,\"0\",$C$30)","v":"0"},{"$f":"IF('1st Loan Repayment'!Loan_Years<8,\"0\",$C$30)","v":"0"},{"$f":"IF('1st Loan Repayment'!Loan_Years<9,\"0\",$C$30)","v":"0"},{"$f":"IF('1st Loan Repayment'!Loan_Years<10,\"0\",$C$30)","v":"0"},{"$f":"IF('1st Loan Repayment'!Loan_Years<11,\"0\",$C$30)","v":"0"}]
[null,{"$f":"'12-Month Cash Flow'!$B$31","v":"Monthly loan repayment to 2nd Bank"},{"$f":"'12-Month Cash Flow'!$P$31","v":0},{"$f":"IF('2nd Loan Repayment'!Loan_Years<2,\"0\",$C$31)","v":"0"},{"$f":"IF('2nd Loan Repayment'!Loan_Years<3,\"0\",$C$31)","v":"0"},{"$f":"IF('2nd Loan Repayment'!Loan_Years<4,\"0\",$C$31)","v":"0"},{"$f":"IF('2nd Loan Repayment'!Loan_Years<5,\"0\",$C$31)","v":"0"},{"$f":"IF('2nd Loan Repayment'!Loan_Years<6,\"0\",$C$31)","v":"0"},{"$f":"IF('2nd Loan Repayment'!Loan_Years<7,\"0\",$C$31)","v":"0"},{"$f":"IF('2nd Loan Repayment'!Loan_Years<8,\"0\",$C$31)","v":"0"},{"$f":"IF('2nd Loan Repayment'!Loan_Years<9,\"0\",$C$31)","v":"0"},{"$f":"IF('2nd Loan Repayment'!Loan_Years<10,\"0\",$C$31)","v":"0"},{"$f":"IF('2nd Loan Repayment'!Loan_Years<11,\"0\",$C$31)","v":"0"}]
[null,{"$f":"Review!$B$22","v":"Monthly savings for appliance maintenance and repairs:"},{"$f":"'12-Month Cash Flow'!$P$32","v":0},{"$f":"C68","v":0},0,0,0,0,0,0,0,0,0]
[null,{"$f":"Review!$B$23","v":"Monthly savings for solar PV System maintenance and repairs:"},{"$f":"'12-Month Cash Flow'!$P$33","v":0},{"$f":"C69","v":0},0,0,0,0,0,0,0,0,0]
[null,"TOTAL CASH PAID OUT",{"$f":"SUM(C65:C69)","v":0},{"$f":"SUM(D65:D69)","v":0},{"$f":"SUM(E65:E69)","v":0},{"$f":"SUM(F65:F69)","v":0},{"$f":"SUM(G65:G69)","v":0},{"$f":"SUM(H65:H69)","v":0},{"$f":"SUM(I65:I69)","v":0},{"$f":"SUM(J65:J69)","v":0},{"$f":"SUM(K65:K69)","v":0},{"$f":"SUM(L65:L69)","v":0},{"$f":"SUM(M65:M69)","v":0}]
[null,"Cash Position (end of year)",{"$f":"C46-C70","v":0},{"$f":"(D46-D70)","v":0},{"$f":"(E46-E70)","v":0},{"$f":"(F46-F70)","v":0},{"$f":"(G46-G70)","v":0},{"$f":"(H46-H70)","v":0},{"$f":"(I46-I70)","v":0},{"$f":"(J46-J70)","v":0},{"$f":"(K46-K70)","v":0},{"$f":"(L46-L70)","v":0},{"$f":"(M46-M70)","v":0}]
[]
[null,"10-Year Cash Flow"]
[null,{"$f":"Questionaire!E18","v":"Scenario: Weak"},"Company name:",null,{"$f":"Questionaire!$E$5","v":0},{"$nulls":4},"Fiscal Year Begins:",{"$f":"Questionaire!$F$108","v":"00:00:00"}]
[null,null,"Year 1","Year 2","Year 3","Year 4","Year 5","Year 6","Year 7","Year 8","Year 9","Year 10","Year 11","Year 12"]
[null,"WEAK: CASH AVAILABLE (beginning of year)",{"$f":"Questionaire!$F$100+Questionaire!$F$101","v":0},{"$f":"C107","v":0},{"$f":"D107","v":0},{"$f":"E107","v":0},{"$f":"F107","v":0},0,0,0,0,0,0,0]
[]
[null,"CASH RECEIPTS"]
[null,"Cash Sales",{"$f":"'12-Month Cash Flow'!Q83","v":0},{"$f":"C79","v":0},{"$f":"D79","v":0},{"$f":"E79","v":0},{"$f":"F79","v":0},{"$f":"G79","v":0},0,0,0,0,0]
[null,"Other Sales"]
[null,"TOTAL CASH RECEIPTS",{"$f":"SUM(C79:C79)","v":0},{"$f":"SUM(D79:D79)","v":0},{"$f":"SUM(E79:E79)","v":0},{"$f":"SUM(F79:F79)","v":0},{"$f":"SUM(G79:G79)","v":0},{"$f":"SUM(H79:H79)","v":0},{"$f":"SUM(I79:I79)","v":0},{"$f":"SUM(J79:J79)","v":0},{"$f":"SUM(K79:K79)","v":0},{"$f":"SUM(L79:L79)","v":0},{"$f":"SUM(M79:M79)","v":0}]
[null,"Total Cash Available (before cash out)",{"$f":"(C76+C81)","v":0},{"$f":"(D76+D81)","v":0},{"$f":"(E76+E81)","v":0},{"$f":"(F76+F81)","v":0},{"$f":"(G76+G81)","v":0},{"$f":"(H76+H81)","v":0},{"$f":"(I76+I81)","v":0},{"$f":"(J76+J81)","v":0},{"$f":"(K76+K81)","v":0},{"$f":"(L76+L81)","v":0},{"$f":"(M76+M81)","v":0}]
[]
[null,"CASH PAID OUT"]
[null,"start-up expense",{"$f":"'12-Month Cash Flow'!$P$13","v":0},0]
[null,"input materials",{"$f":"'12-Month Cash Flow'!$P$14","v":0},{"$f":"C86+(C86*Questionaire!$F$47)","v":0},{"$f":"D86+(D86*Questionaire!$F$47)","v":0},{"$f":"E86+(E86*Questionaire!$F$47)","v":0},{"$f":"F86+(F86*Questionaire!$F$47)","v":0},{"$f":"G86+(G86*Questionaire!$F$47)","v":0},{"$f":"H86+(H86*Questionaire!$F$47)","v":0},{"$f":"I86+(I86*Questionaire!$F$47)","v":0},{"$f":"J86+(J86*Questionaire!$F$47)","v":0},{"$f":"K86+(K86*Questionaire!$F$47)","v":0},{"$f":"L86+(L86*Questionaire!$F$47)","v":0}]
[null,"consumables",{"$f":"'12-Month Cash Flow'!$P$15","v":0},{"$f":"C87+(C87*Questionaire!$F$47)","v":0},{"$f":"D87+(D87*Questionaire!$F$47)","v":0},{"$f":"E87+(E87*Questionaire!$F$47)","v":0},{"$f":"F87+(F87*Questionaire!$F$47)","v":0},{"$f":"G87+(G87*Questionaire!$F$47)","v":0},{"$f":"H87+(H87*Questionaire!$F$47)","v":0},{"$f":"I87+(I87*Questionaire!$F$47)","v":0},{"$f":"J87+(J87*Questionaire!$F$47)","v":0},{"$f":"K87+(K87*Questionaire!$F$47)","v":0},{"$f":"L87+(L87*Questionaire!$F$47)","v":0}]
[null,{"$f":"Questionaire!$E$33","v":"phone costs"},{"$f":"'12-Month Cash Flow'!$P$16","v":0},{"$f":"C88+(C88*Questionaire!$F$47)","v":0},{"$f":"D88+(D88*Questionaire!$F$47)","v":0},{"$f":"E88+(E88*Questionaire!$F$47)","v":0},{"$f":"F88+(F88*Questionaire!$F$47)","v":0},{"$f":"G88+(G88*Questionaire!$F$47)","v":0},{"$f":"H88+(H88*Questionaire!$F$47)","v":0},{"$f":"I88+(I88*Questionaire!$F$47)","v":0},{"$f":"J88+(J88*Questionaire!$F$47)","v":0},{"$f":"K88+(K88*Questionaire!$F$47)","v":0},{"$f":"L88+(L88*Questionaire!$F$47)","v":0}]
[null,{"$f":"Questionaire!$E$34","v":"transport costs"},{"$f":"'12-Month Cash Flow'!$P$17","v":0},{"$f":"C89+(C89*Questionaire!$F$47)","v":0},{"$f":"D89+(D89*Questionaire!$F$47)","v":0},{"$f":"E89+(E89*Questionaire!$F$47)","v":0},{"$f":"F89+(F89*Questionaire!$F$47)","v":0},{"$f":"G89+(G89*Questionaire!$F$47)","v":0},{"$f":"H89+(H89*Questionaire!$F$47)","v":0},{"$f":"I89+(I89*Questionaire!$F$47)","v":0},{"$f":"J89+(J89*Questionaire!$F$47)","v":0},{"$f":"K89+(K89*Questionaire!$F$47)","v":0},{"$f":"L89+(L89*Questionaire!$F$47)","v":0}]
[null,{"$f":"Questionaire!$E$35","v":"delivery costs"},{"$f":"'12-Month Cash Flow'!$P$18","v":0},{"$f":"C90+(C90*Questionaire!$F$47)","v":0},{"$f":"D90+(D90*Questionaire!$F$47)","v":0},{"$f":"E90+(E90*Questionaire!$F$47)","v":0},{"$f":"F90+(F90*Questionaire!$F$47)","v":0},{"$f":"G90+(G90*Questionaire!$F$47)","v":0},{"$f":"H90+(H90*Questionaire!$F$47)","v":0},{"$f":"I90+(I90*Questionaire!$F$47)","v":0},{"$f":"J90+(J90*Questionaire!$F$47)","v":0},{"$f":"K90+(K90*Questionaire!$F$47)","v":0},{"$f":"L90+(L90*Questionaire!$F$47)","v":0}]
[null,{"$f":"Questionaire!$E$36","v":"rent of business premises"},{"$f":"'12-Month Cash Flow'!$P$19","v":0},{"$f":"C91+(C91*Questionaire!$F$47)","v":0},{"$f":"D91+(D91*Questionaire!$F$47)","v":0},{"$f":"E91+(E91*Questionaire!$F$47)","v":0},{"$f":"F91+(F91*Questionaire!$F$47)","v":0},{"$f":"G91+(G91*Questionaire!$F$47)","v":0},{"$f":"H91+(H91*Questionaire!$F$47)","v":0},{"$f":"I91+(I91*Questionaire!$F$47)","v":0},{"$f":"J91+(J91*Questionaire!$F$47)","v":0},{"$f":"K91+(K91*Questionaire!$F$47)","v":0},{"$f":"L91+(L91*Questionaire!$F$47)","v":0}]
[null,{"$f":"Questionaire!$E$37","v":"staff salaries"},{"$f":"'12-Month Cash Flow'!$P$20","v":0},{"$f":"C92+(C92*Questionaire!$F$47)","v":0},{"$f":"D92+(D92*Questionaire!$F$47)","v":0},{"$f":"E92+(E92*Questionaire!$F$47)","v":0},{"$f":"F92+(F92*Questionaire!$F$47)","v":0},{"$f":"G92+(G92*Questionaire!$F$47)","v":0},{"$f":"H92+(H92*Questionaire!$F$47)","v":0},{"$f":"I92+(I92*Questionaire!$F$47)","v":0},{"$f":"J92+(J92*Questionaire!$F$47)","v":0},{"$f":"K92+(K92*Questionaire!$F$47)","v":0},{"$f":"L92+(L92*Questionaire!$F$47)","v":0}]
[null,{"$f":"Questionaire!$E$38","v":"taxes and duties"},{"$f":"'12-Month Cash Flow'!$P$21","v":0},{"$f":"C93+(C93*Questionaire!$F$47)","v":0},{"$f":"D93+(D93*Questionaire!$F$47)","v":0},{"$f":"E93+(E93*Questionaire!$F$47)","v":0},{"$f":"F93+(F93*Questionaire!$F$47)","v":0},{"$f":"G93+(G93*Questionaire!$F$47)","v":0},{"$f":"H93+(H93*Questionaire!$F$47)","v":0},{"$f":"I93+(I93*Questionaire!$F$47)","v":0},{"$f":"J93+(J93*Questionaire!$F$47)","v":0},{"$f":"K93+(K93*Questionaire!$F$47)","v":0},{"$f":"L93+(L93*Questionaire!$F$47)","v":0}]
[null,{"$f":"Questionaire!$E$39","v":"sub-contractors"},{"$f":"'12-Month Cash Flow'!$P$22","v":0},{"$f":"C94+(C94*Questionaire!$F$47)","v":0},{"$f":"D94+(D94*Questionaire!$F$47)","v":0},{"$f":"E94+(E94*Questionaire!$F$47)","v":0},{"$f":"F94+(F94*Questionaire!$F$47)","v":0},{"$f":"G94+(G94*Questionaire!$F$47)","v":0},{"$f":"H94+(H94*Questionaire!$F$47)","v":0},{"$f":"I94+(I94*Questionaire!$F$47)","v":0},{"$f":"J94+(J94*Questionaire!$F$47)","v":0},{"$f":"K94+(K94*Questionaire!$F$47)","v":0},{"$f":"L94+(L94*Questionaire!$F$47)","v":0}]
[null,{"$f":"Questionaire!$E$40","v":"advertising"},{"$f":"'12-Month Cash Flow'!$P$23","v":0},{"$f":"C95+(C95*Questionaire!$F$47)","v":0},{"$f":"D95+(D95*Questionaire!$F$47)","v":0},{"$f":"E95+(E95*Questionaire!$F$47)","v":0},{"$f":"F95+(F95*Questionaire!$F$47)","v":0},{"$f":"G95+(G95*Questionaire!$F$47)","v":0},{"$f":"H95+(H95*Questionaire!$F$47)","v":0},{"$f":"I95+(I95*Questionaire!$F$47)","v":0},{"$f":"J95+(J95*Questionaire!$F$47)","v":0},{"$f":"K95+(K95*Questionaire!$F$47)","v":0},{"$f":"L95+(L95*Questionaire!$F$47)","v":0}]
[null,{"$f":"Questionaire!$E$41","v":"water, electricity and other utilities"},{"$f":"'12-Month Cash Flow'!$P$24","v":0},{"$f":"C96+(C96*Questionaire!$F$47)","v":0},{"$f":"D96+(D96*Questionaire!$F$47)","v":0},{"$f":"E96+(E96*Questionaire!$F$47)","v":0},{"$f":"F96+(F96*Questionaire!$F$47)","v":0},{"$f":"G96+(G96*Questionaire!$F$47)","v":0},{"$f":"H96+(H96*Questionaire!$F$47)","v":0},{"$f":"I96+(I96*Questionaire!$F$47)","v":0},{"$f":"J96+(J96*Questionaire!$F$47)","v":0},{"$f":"K96+(K96*Questionaire!$F$47)","v":0},{"$f":"L96+(L96*Questionaire!$F$47)","v":0}]
[null,{"$f":"Questionaire!$E$42","v":"insurance fees"},{"$f":"'12-Month Cash Flow'!$P$25","v":0},{"$f":"C97+(C97*Questionaire!$F$47)","v":0},{"$f":"D97+(D97*Questionaire!$F$47)","v":0},{"$f":"E97+(E97*Questionaire!$F$47)","v":0},{"$f":"F97+(F97*Questionaire!$F$47)","v":0},{"$f":"G97+(G97*Questionaire!$F$47)","v":0},{"$f":"H97+(H97*Questionaire!$F$47)","v":0},{"$f":"I97+(I97*Questionaire!$F$47)","v":0},{"$f":"J97+(J97*Questionaire!$F$47)","v":0},{"$f":"K97+(K97*Questionaire!$F$47)","v":0},{"$f":"L97+(L97*Questionaire!$F$47)","v":0}]
[null,{"$f":"Questionaire!$E$43","v":"bookkeeping or accounting fees"},{"$f":"'12-Month Cash Flow'!$P$26","v":0},{"$f":"C98+(C98*Questionaire!$F$47)","v":0},{"$f":"D98+(D98*Questionaire!$F$47)","v":0},{"$f":"E98+(E98*Questionaire!$F$47)","v":0},{"$f":"F98+(F98*Questionaire!$F$47)","v":0},{"$f":"G98+(G98*Questionaire!$F$47)","v":0},{"$f":"H98+(H98*Questionaire!$F$47)","v":0},{"$f":"I98+(I98*Questionaire!$F$47)","v":0},{"$f":"J98+(J98*Questionaire!$F$47)","v":0},{"$f":"K98+(K98*Questionaire!$F$47)","v":0},{"$f":"L98+(L98*Questionaire!$F$47)","v":0}]
[null,{"$f":"Questionaire!$E$44","v":"various"},{"$f":"'12-Month Cash Flow'!$P$27","v":0},{"$f":"C99+(C99*Questionaire!$F$47)","v":0},{"$f":"D99+(D99*Questionaire!$F$47)","v":0},{"$f":"E99+(E99*Questionaire!$F$47)","v":0},{"$f":"F99+(F99*Questionaire!$F$47)","v":0},{"$f":"G99+(G99*Questionaire!$F$47)","v":0},{"$f":"H99+(H99*Questionaire!$F$47)","v":0},{"$f":"I99+(I99*Questionaire!$F$47)","v":0},{"$f":"J99+(J99*Questionaire!$F$47)","v":0},{"$f":"K99+(K99*Questionaire!$F$47)","v":0},{"$f":"L99+(L99*Questionaire!$F$47)","v":0}]
[null,{"$f":"Questionaire!$E$45","v":"various"},{"$f":"'12-Month Cash Flow'!$P$28","v":0},{"$f":"C100+(C100*Questionaire!$F$47)","v":0},{"$f":"D100+(D100*Questionaire!$F$47)","v":0},{"$f":"E100+(E100*Questionaire!$F$47)","v":0},{"$f":"F100+(F100*Questionaire!$F$47)","v":0},{"$f":"G100+(G100*Questionaire!$F$47)","v":0},{"$f":"H100+(H100*Questionaire!$F$47)","v":0},{"$f":"I100+(I100*Questionaire!$F$47)","v":0},{"$f":"J100+(J100*Questionaire!$F$47)","v":0},{"$f":"K100+(K100*Questionaire!$F$47)","v":0},{"$f":"L100+(L100*Questionaire!$F$47)","v":0}]
[null,"SUBTOTAL",{"$f":"SUM(C85:C100)","v":0},{"$f":"SUM(D85:D100)","v":0},0,0,0,0,0,0,0,0,0]
[null,{"$f":"'12-Month Cash Flow'!$B$30","v":"Monthly loan repayment to 1st Bank"},{"$f":"'12-Month Cash Flow'!$P$30","v":0},{"$f":"IF('1st Loan Repayment'!Loan_Years<2,\"0\",$C$30)","v":"0"},{"$f":"IF('1st Loan Repayment'!Loan_Years<3,\"0\",$C$30)","v":"0"},{"$f":"IF('1st Loan Repayment'!Loan_Years<4,\"0\",$C$30)","v":"0"},{"$f":"IF('1st Loan Repayment'!Loan_Years<5,\"0\",$C$30)","v":"0"},{"$f":"IF('1st Loan Repayment'!Loan_Years<6,\"0\",$C$30)","v":"0"},{"$f":"IF('1st Loan Repayment'!Loan_Years<7,\"0\",$C$30)","v":"0"},{"$f":"IF('1st Loan Repayment'!Loan_Years<8,\"0\",$C$30)","v":"0"},{"$f":"IF('1st Loan Repayment'!Loan_Years<9,\"0\",$C$30)","v":"0"},{"$f":"IF('1st Loan Repayment'!Loan_Years<10,\"0\",$C$30)","v":"0"},{"$f":"IF('1st Loan Repayment'!Loan_Years<11,\"0\",$C$30)","v":"0"}]
[null,{"$f":"'12-Month Cash Flow'!$B$31","v":"Monthly loan repayment to 2nd Bank"},{"$f":"'12-Month Cash Flow'!$P$31","v":0},{"$f":"IF('2nd Loan Repayment'!Loan_Years<2,\"0\",$C$31)","v":"0"},{"$f":"IF('2nd Loan Repayment'!Loan_Years<3,\"0\",$C$31)","v":"0"},{"$f":"IF('2nd Loan Repayment'!Loan_Years<4,\"0\",$C$31)","v":"0"},{"$f":"IF('2nd Loan Repayment'!Loan_Years<5,\"0\",$C$31)","v":"0"},{"$f":"IF('2nd Loan Repayment'!Loan_Years<6,\"0\",$C$31)","v":"0"},{"$f":"IF('2nd Loan Repayment'!Loan_Years<7,\"0\",$C$31)","v":"0"},{"$f":"IF('2nd Loan Repayment'!Loan_Years<8,\"0\",$C$31)","v":"0"},{"$f":"IF('2nd Loan Repayment'!Loan_Years<9,\"0\",$C$31)","v":"0"},{"$f":"IF('2nd Loan Repayment'!Loan_Years<10,\"0\",$C$31)","v":"0"},{"$f":"IF('2nd Loan Repayment'!Loan_Years<11,\"0\",$C$31)","v":"0"}]
[null,{"$f":"Review!$B$22","v":"Monthly savings for appliance maintenance and repairs:"},{"$f":"'12-Month Cash Flow'!$P$32","v":0},{"$f":"C104","v":0},0,0,0,0,0,0,0,0,0]
[null,{"$f":"Review!$B$23","v":"Monthly savings for solar PV System maintenance and repairs:"},{"$f":"'12-Month Cash Flow'!$P$33","v":0},{"$f":"C105","v":0},0,0,0,0,0,0,0,0,0]
[null,"TOTAL CASH PAID OUT",{"$f":"SUM(C101:C105)","v":0},{"$f":"SUM(D101:D105)","v":0},{"$f":"SUM(E101:E105)","v":0},{"$f":"SUM(F101:F105)","v":0},{"$f":"SUM(G101:G105)","v":0},{"$f":"SUM(H101:H105)","v":0},{"$f":"SUM(I101:I105)","v":0},{"$f":"SUM(J101:J105)","v":0},{"$f":"SUM(K101:K105)","v":0},{"$f":"SUM(L101:L105)","v":0},{"$f":"SUM(M101:M105)","v":0}]
[null,"Cash Position (end of year)",{"$f":"C82-C106","v":0},{"$f":"(D82-D106)","v":0},{"$f":"(E82-E106)","v":0},{"$f":"(F82-F106)","v":0},{"$f":"(G82-G106)","v":0},{"$f":"(H82-H106)","v":0},{"$f":"(I82-I106)","v":0},{"$f":"(J82-J106)","v":0},{"$f":"(K82-K106)","v":0},{"$f":"(L82-L106)","v":0},{"$f":"(M82-M106)","v":0}]

{"sheet":"Energy Calculation","index":7,"n_rows":27,"n_cols":38,"rows_kept":27,"cut":false,"hidden":false,"merged":[[0,0,0,7],[21,0,21,5]]}
["Energy calculation"]
[]
["Type of appliance","Wattage (W)","Qty","Hrs/day","AC?","Wh/day"]
[{"$f":"Questionaire!F50","v":0},{"$f":"Questionaire!F52","v":0},{"$f":"Questionaire!F55","v":0},{"$f":"Questionaire!F54","v":0},{"$f":"IF(Questionaire!F53=\"AC\",\"AC\",\"\")","v":""},{"$f":"(B4*C4*D4)","v":0}]
[{"$f":"Questionaire!F58","v":0},{"$f":"Questionaire!F60","v":0},{"$f":"Questionaire!F63","v":0},{"$f":"Questionaire!F62","v":0},{"$f":"IF(Questionaire!F61=\"AC\",\"AC\",\"\")","v":""},{"$f":"(B5*C5*D5)","v":0}]
[{"$f":"Questionaire!F66","v":0},{"$f":"Questionaire!F68","v":0},{"$f":"Questionaire!F71","v":0},{"$f":"Questionaire!F70","v":0},{"$f":"IF(Questionaire!F69=\"AC\",\"AC\",\"\")","v":""},{"$f":"(B6*C6*D6)","v":0}]
[{"$f":"Questionaire!F74","v":0},{"$f":"Questionaire!F76","v":0},{"$f":"Questionaire!F79","v":0},{"$f":"Questionaire!F78","v":0},{"$f":"IF(Questionaire!F77=\"AC\",\"AC\",\"\")","v":""},{"$f":"(B7*C7*D7)","v":0}]
["Total:",{"$f":"SUM(B4:B7)","v":0},{"$f":"SUM(C4:C7)","v":0},0,null,{"$f":"SUM(F4:F7)","v":0}]
["Full sunshine hours per day:",{"$f":"Questionaire!$G$83","v":5},"hrs/day"]
["System losses",0.2,"%"]
["PV module capacity required:",{"$f":"(B15/B9)+((B15/B9)*B10)","v":0},"Wp"]
["Inverter?",{"$f":"IF(COUNTIF(E4:E7,\"AC\"),\"Yes\",\"No\")","v":"No"}]
["Days of Autonomy:",{"$f":"Questionaire!F85","v":1}]
["Depth of Discharge:",0.6,"%"]
["Energy storage:",{"$f":"((F8*B13)+((F8*B13)/B14))","v":0},"Wh"]
[]
[]
[null,"Investment cost ($)","Maintenance cost ($/month)","Fuel cost ($/month)","Annual increase ($/annum)"]
[{"$f":"Questionaire!F91","v":0},{"$f":"Questionaire!F94","v":0},{"$f":"Questionaire!F93","v":0},{"$f":"Questionaire!F92","v":0},{"$f":"Questionaire!$F$47","v":0}]
["PV System",{"$f":"Questionaire!F86","v":0},{"$f":"(Questionaire!F87/36)","v":0},0,{"$f":"Questionaire!$F$47","v":0}]
[]
["PV System vs Alternative: Amortisation Period (months) and total costs ($)",{"$nulls":5},"Company name:",null,{"$f":"Questionaire!E5","v":0}]
[null,"Investment cost","Month1","Month2","Month3","Month4","Month5","Month6","Month7","Month8","Month9","Month10","Month11","Month12","Month13","Month14","Month15","Month16","Month17","Month18","Month19","Month20","Month21","Month22","Month23","Month24","Month25","Month26","Month27","Month28","Month29","Month30","Month31","Month32","Month33","Month34","Month35","Month36"]
[{"$f":"A19","v":0},{"$f":"B19","v":0},{"$f":"B24+$C$19+$D$19+(($C$19+$D$19)*($E$19/12))","v":0},{"$f":"C24+$C$19+$D$19+(($C$19+$D$19)*($E$19/12))","v":0},{"$f":"D24+$C$19+$D$19+(($C$19+$D$19)*$E$19/12)","v":0},{"$f":"E24+$C$19+$D$19+(($C$19+$D$19)*$E$19/12)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"A20","v":"PV System"},{"$f":"B20","v":0},{"$f":"B25+$C$20+$D$20+(($C$20+$D$20)*($E$20/12))","v":0},{"$f":"C25+$C$20+$D$20+(($C$20+$D$20)*($E$20/12))","v":0},{"$f":"D25+$C$20+$D$20+(($C$20+$D$20)*($E$20/12))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Payback?",{"$f":"IF(B24>B25,TRUE)","v":false},{"$f":"IF(C24>C25,TRUE)","v":false},false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,{"$f":"IF(AB24>AB25,TRUE)","v":false},{"$f":"IF(AC24>AC25,TRUE)","v":false},{"$f":"IF(AD24>AD25,TRUE)","v":false},{"$f":"IF(AE24>AE25,TRUE)","v":false},{"$f":"IF(AF24>AF25,TRUE)","v":false},{"$f":"IF(AG24>AG25,TRUE)","v":false},{"$f":"IF(AH24>AH25,TRUE)","v":false},{"$f":"IF(AI24>AI25,TRUE)","v":false},{"$f":"IF(AJ24>AJ25,TRUE)","v":false},{"$f":"IF(AK24>AK25,TRUE)","v":false},{"$f":"IF(AL24>AL25,TRUE)","v":false}]
["Payback month:",{"$f":"37-(COUNTIF(C26:AL26,\"TRUE\"))","v":37}]

{"sheet":"1st Loan Repayment","index":8,"n_rows":374,"n_cols":10,"rows_kept":374,"cut":false,"hidden":false,"merged":[[3,1,3,3],[3,5,3,7],[0,0,0,9]]}
["1st Loan Repayment"]
["Bank:",{"$f":"Questionaire!F103","v":0}]
[]
[null,"Enter Values",null,null,null,"Loan Summary"]
[null,null,"Loan Amount",{"$f":"E5","v":0},{"$f":"Questionaire!$F$104","v":0},null,"Scheduled Payment",{"$f":"IF(Values_Entered,-PMT(Interest_Rate/Num_Pmt_Per_Year,Loan_Years*Num_Pmt_Per_Year,Loan_Amount),\"0\")","v":"0"}]
[null,null,"Annual Interest Rate",{"$f":"E6","v":0},{"$f":"Questionaire!$F$105","v":0},null,"Scheduled Number of Payments",{"$f":"IF(Values_Entered,Loan_Years*Num_Pmt_Per_Year,\"\")","v":""}]
[null,null,"Loan Period in Years",{"$f":"E7","v":0},{"$f":"Questionaire!$F$106","v":0},null,"Actual Number of Payments",{"$f":"IF(Values_Entered,Number_of_Payments,\"\")","v":""}]
[null,null,"Number of Payments Per Year",12,null,null,"Total Early Payments",{"$f":"IF(Values_Entered,SUMIF(Beg_Bal,\">0\",Extra_Pay),\"\")","v":""}]
[null,null,"Start Date of Loan",{"$f":"E9","v":"00:00:00"},{"$f":"Questionaire!F108","v":"00:00:00"},null,"Total Interest",{"$f":"IF(Values_Entered,SUMIF(Beg_Bal,\">0\",Int),\"\")","v":""}]
[null,null,"Optional Extra Payments",0]
[]
[]
["PmtNo.","Payment Date","Beginning Balance","Scheduled Payment","Extra Payment","Total Payment","Principal","Interest","Ending Balance","Cumulative Interest"]
[]
[{"$f":"IF(Values_Entered,1,\"\")","v":""},{"$f":"IF(Pay_Num<>\"\",DATE(YEAR(Loan_Start),MONTH(Loan_Start)+(Pay_Num)*12/Num_Pmt_Per_Year,DAY(Loan_Start)),\"\")","v":""},{"$f":"IF(Values_Entered,Loan_Amount,\"\")","v":""},{"$f":"IF(Pay_Num<>\"\",Scheduled_Monthly_Payment,\"\")","v":""},{"$f":"IF(AND(Pay_Num<>\"\",Sched_Pay+Scheduled_Extra_Payments<Beg_Bal),Scheduled_Extra_Payments,IF(AND(Pay_Num<>\"\",Beg_Bal-Sched_Pay>0),Beg_Bal-Sched_Pay,IF(Pay_Num<>\"\",0,\"\")))","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(Pay_Num<>\"\",Sched_Pay+Extra_Pay<Beg_Bal),Sched_Pay+Extra_Pay,IF(Pay_Num<>\"\",Beg_Bal,\"\"))","v":{"$error":"#VALUE!"}},{"$f":"IF(Pay_Num<>\"\",Total_Pay-Int,\"\")","v":""},{"$f":"IF(Pay_Num<>\"\",Beg_Bal*(Interest_Rate/Num_Pmt_Per_Year),\"\")","v":""},{"$f":"IF(AND(Pay_Num<>\"\",Sched_Pay+Extra_Pay<Beg_Bal),Beg_Bal-Princ,IF(Pay_Num<>\"\",0,\"\"))","v":{"$error":"#VALUE!"}},{"$f":"SUM($H$15:$H15)","v":0}]
[{"$f":"IF(Values_Entered,A15+1,\"\")","v":""},"",{"$f":"IF(Pay_Num<>\"\",I15,\"\")","v":""},{"$f":"IF(Pay_Num<>\"\",Scheduled_Monthly_Payment,\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"IF(Pay_Num<>\"\",Total_Pay-Int,\"\")","v":""},{"$f":"IF(Pay_Num<>\"\",Beg_Bal*Interest_Rate/Num_Pmt_Per_Year,\"\")","v":""},{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H16)","v":0}]
["","","",{"$f":"IF(Pay_Num<>\"\",Scheduled_Monthly_Payment,\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H17)","v":0}]
["","","",{"$f":"IF(Pay_Num<>\"\",Scheduled_Monthly_Payment,\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H18)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H19)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H20)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H21)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H22)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H23)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H24)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H25)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H26)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H27)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H28)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H29)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H30)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H31)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H32)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H33)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H34)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H35)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H36)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H37)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H38)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H39)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H40)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H41)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H42)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H43)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H44)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H45)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H46)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H47)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H48)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H49)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H50)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H51)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H52)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H53)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H54)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H55)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H56)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H57)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H58)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H59)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H60)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H61)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H62)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H63)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H64)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H65)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H66)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H67)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H68)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H69)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H70)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H71)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H72)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H73)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H74)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H75)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H76)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H77)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H78)","v":0}]
["",{"$f":"IF(Pay_Num<>\"\",DATE(YEAR(Loan_Start),MONTH(Loan_Start)+(Pay_Num)*12/Num_Pmt_Per_Year,DAY(Loan_Start)),\"\")","v":""},"","",{"$f":"IF(AND(Pay_Num<>\"\",Sched_Pay+Scheduled_Extra_Payments<Beg_Bal),Scheduled_Extra_Payments,IF(AND(Pay_Num<>\"\",Beg_Bal-Sched_Pay>0),Beg_Bal-Sched_Pay,IF(Pay_Num<>\"\",0,\"\")))","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(Pay_Num<>\"\",Sched_Pay+Extra_Pay<Beg_Bal),Sched_Pay+Extra_Pay,IF(Pay_Num<>\"\",Beg_Bal,\"\"))","v":{"$error":"#VALUE!"}},"","",{"$f":"IF(AND(Pay_Num<>\"\",Sched_Pay+Extra_Pay<Beg_Bal),Beg_Bal-Princ,IF(Pay_Num<>\"\",0,\"\"))","v":{"$error":"#VALUE!"}},{"$f":"SUM($H$15:$H79)","v":0}]
[{"$f":"IF(Values_Entered,A79+1,\"\")","v":""},"",{"$f":"IF(Pay_Num<>\"\",I79,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"IF(Pay_Num<>\"\",Total_Pay-Int,\"\")","v":""},{"$f":"IF(Pay_Num<>\"\",Beg_Bal*Interest_Rate/Num_Pmt_Per_Year,\"\")","v":""},{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H80)","v":0}]
["","","",{"$f":"IF(Pay_Num<>\"\",Scheduled_Monthly_Payment,\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H81)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H82)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H83)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H84)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H85)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H86)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H87)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H88)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H89)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H90)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H91)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H92)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H93)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H94)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H95)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H96)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H97)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H98)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H99)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H100)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H101)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H102)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H103)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H104)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H105)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H106)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H107)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H108)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H109)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H110)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H111)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H112)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H113)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H114)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H115)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H116)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H117)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H118)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H119)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H120)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H121)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H122)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H123)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H124)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H125)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H126)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H127)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H128)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H129)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H130)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H131)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H132)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H133)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H134)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H135)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H136)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H137)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H138)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H139)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H140)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H141)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H142)","v":0}]
["",{"$f":"IF(Pay_Num<>\"\",DATE(YEAR(Loan_Start),MONTH(Loan_Start)+(Pay_Num)*12/Num_Pmt_Per_Year,DAY(Loan_Start)),\"\")","v":""},"","",{"$f":"IF(AND(Pay_Num<>\"\",Sched_Pay+Scheduled_Extra_Payments<Beg_Bal),Scheduled_Extra_Payments,IF(AND(Pay_Num<>\"\",Beg_Bal-Sched_Pay>0),Beg_Bal-Sched_Pay,IF(Pay_Num<>\"\",0,\"\")))","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(Pay_Num<>\"\",Sched_Pay+Extra_Pay<Beg_Bal),Sched_Pay+Extra_Pay,IF(Pay_Num<>\"\",Beg_Bal,\"\"))","v":{"$error":"#VALUE!"}},"","",{"$f":"IF(AND(Pay_Num<>\"\",Sched_Pay+Extra_Pay<Beg_Bal),Beg_Bal-Princ,IF(Pay_Num<>\"\",0,\"\"))","v":{"$error":"#VALUE!"}},{"$f":"SUM($H$15:$H143)","v":0}]
[{"$f":"IF(Values_Entered,A143+1,\"\")","v":""},"",{"$f":"IF(Pay_Num<>\"\",I143,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"IF(Pay_Num<>\"\",Total_Pay-Int,\"\")","v":""},{"$f":"IF(Pay_Num<>\"\",Beg_Bal*Interest_Rate/Num_Pmt_Per_Year,\"\")","v":""},{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H144)","v":0}]
["","","",{"$f":"IF(Pay_Num<>\"\",Scheduled_Monthly_Payment,\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H145)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H146)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H147)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H148)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H149)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H150)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H151)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H152)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H153)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H154)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H155)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H156)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H157)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H158)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H159)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H160)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H161)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H162)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H163)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H164)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H165)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H166)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H167)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H168)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H169)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H170)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H171)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H172)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H173)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H174)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H175)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H176)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H177)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H178)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H179)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H180)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H181)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H182)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H183)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H184)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H185)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H186)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H187)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H188)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H189)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H190)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H191)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H192)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H193)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H194)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H195)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H196)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H197)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H198)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H199)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H200)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H201)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H202)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H203)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H204)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H205)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H206)","v":0}]
["",{"$f":"IF(Pay_Num<>\"\",DATE(YEAR(Loan_Start),MONTH(Loan_Start)+(Pay_Num)*12/Num_Pmt_Per_Year,DAY(Loan_Start)),\"\")","v":""},"","",{"$f":"IF(AND(Pay_Num<>\"\",Sched_Pay+Scheduled_Extra_Payments<Beg_Bal),Scheduled_Extra_Payments,IF(AND(Pay_Num<>\"\",Beg_Bal-Sched_Pay>0),Beg_Bal-Sched_Pay,IF(Pay_Num<>\"\",0,\"\")))","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(Pay_Num<>\"\",Sched_Pay+Extra_Pay<Beg_Bal),Sched_Pay+Extra_Pay,IF(Pay_Num<>\"\",Beg_Bal,\"\"))","v":{"$error":"#VALUE!"}},"","",{"$f":"IF(AND(Pay_Num<>\"\",Sched_Pay+Extra_Pay<Beg_Bal),Beg_Bal-Princ,IF(Pay_Num<>\"\",0,\"\"))","v":{"$error":"#VALUE!"}},{"$f":"SUM($H$15:$H207)","v":0}]
[{"$f":"IF(Values_Entered,A207+1,\"\")","v":""},"",{"$f":"IF(Pay_Num<>\"\",I207,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"IF(Pay_Num<>\"\",Total_Pay-Int,\"\")","v":""},{"$f":"IF(Pay_Num<>\"\",Beg_Bal*Interest_Rate/Num_Pmt_Per_Year,\"\")","v":""},{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H208)","v":0}]
["","","",{"$f":"IF(Pay_Num<>\"\",Scheduled_Monthly_Payment,\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H209)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H210)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H211)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H212)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H213)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H214)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H215)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H216)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H217)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H218)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H219)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H220)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H221)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H222)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H223)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H224)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H225)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H226)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H227)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H228)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H229)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H230)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H231)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H232)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H233)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H234)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H235)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H236)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H237)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H238)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H239)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H240)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H241)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H242)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H243)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H244)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H245)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H246)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H247)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H248)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H249)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H250)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H251)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H252)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H253)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H254)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H255)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H256)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H257)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H258)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H259)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H260)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H261)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H262)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H263)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H264)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H265)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H266)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H267)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H268)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H269)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H270)","v":0}]
["",{"$f":"IF(Pay_Num<>\"\",DATE(YEAR(Loan_Start),MONTH(Loan_Start)+(Pay_Num)*12/Num_Pmt_Per_Year,DAY(Loan_Start)),\"\")","v":""},"","",{"$f":"IF(AND(Pay_Num<>\"\",Sched_Pay+Scheduled_Extra_Payments<Beg_Bal),Scheduled_Extra_Payments,IF(AND(Pay_Num<>\"\",Beg_Bal-Sched_Pay>0),Beg_Bal-Sched_Pay,IF(Pay_Num<>\"\",0,\"\")))","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(Pay_Num<>\"\",Sched_Pay+Extra_Pay<Beg_Bal),Sched_Pay+Extra_Pay,IF(Pay_Num<>\"\",Beg_Bal,\"\"))","v":{"$error":"#VALUE!"}},"","",{"$f":"IF(AND(Pay_Num<>\"\",Sched_Pay+Extra_Pay<Beg_Bal),Beg_Bal-Princ,IF(Pay_Num<>\"\",0,\"\"))","v":{"$error":"#VALUE!"}},{"$f":"SUM($H$15:$H271)","v":0}]
[{"$f":"IF(Values_Entered,A271+1,\"\")","v":""},"",{"$f":"IF(Pay_Num<>\"\",I271,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"IF(Pay_Num<>\"\",Total_Pay-Int,\"\")","v":""},{"$f":"IF(Pay_Num<>\"\",Beg_Bal*Interest_Rate/Num_Pmt_Per_Year,\"\")","v":""},{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H272)","v":0}]
["","","",{"$f":"IF(Pay_Num<>\"\",Scheduled_Monthly_Payment,\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H273)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H274)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H275)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H276)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H277)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H278)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H279)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H280)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H281)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H282)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H283)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H284)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H285)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H286)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H287)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H288)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H289)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H290)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H291)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H292)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H293)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H294)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H295)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H296)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H297)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H298)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H299)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H300)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H301)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H302)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H303)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H304)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H305)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H306)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H307)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H308)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H309)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H310)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H311)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H312)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H313)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H314)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H315)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H316)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H317)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H318)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H319)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H320)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H321)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H322)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H323)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H324)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H325)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H326)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H327)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H328)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H329)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H330)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H331)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H332)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H333)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H334)","v":0}]
["",{"$f":"IF(Pay_Num<>\"\",DATE(YEAR(Loan_Start),MONTH(Loan_Start)+(Pay_Num)*12/Num_Pmt_Per_Year,DAY(Loan_Start)),\"\")","v":""},"","",{"$f":"IF(AND(Pay_Num<>\"\",Sched_Pay+Scheduled_Extra_Payments<Beg_Bal),Scheduled_Extra_Payments,IF(AND(Pay_Num<>\"\",Beg_Bal-Sched_Pay>0),Beg_Bal-Sched_Pay,IF(Pay_Num<>\"\",0,\"\")))","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(Pay_Num<>\"\",Sched_Pay+Extra_Pay<Beg_Bal),Sched_Pay+Extra_Pay,IF(Pay_Num<>\"\",Beg_Bal,\"\"))","v":{"$error":"#VALUE!"}},"","",{"$f":"IF(AND(Pay_Num<>\"\",Sched_Pay+Extra_Pay<Beg_Bal),Beg_Bal-Princ,IF(Pay_Num<>\"\",0,\"\"))","v":{"$error":"#VALUE!"}},{"$f":"SUM($H$15:$H335)","v":0}]
[{"$f":"IF(Values_Entered,A335+1,\"\")","v":""},"",{"$f":"IF(Pay_Num<>\"\",I335,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"IF(Pay_Num<>\"\",Total_Pay-Int,\"\")","v":""},{"$f":"IF(Pay_Num<>\"\",Beg_Bal*Interest_Rate/Num_Pmt_Per_Year,\"\")","v":""},{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H336)","v":0}]
["","","",{"$f":"IF(Pay_Num<>\"\",Scheduled_Monthly_Payment,\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H337)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H338)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H339)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H340)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H341)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H342)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H343)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H344)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H345)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H346)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H347)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H348)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H349)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H350)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H351)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H352)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H353)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H354)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H355)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H356)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H357)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H358)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H359)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H360)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H361)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H362)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H363)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H364)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H365)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H366)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H367)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H368)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H369)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H370)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H371)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H372)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H373)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H374)","v":0}]

{"sheet":"2nd Loan Repayment","index":9,"n_rows":374,"n_cols":10,"rows_kept":374,"cut":false,"hidden":false,"merged":[[3,1,3,3],[3,5,3,7],[0,0,0,9]]}
["2nd Loan Repayment"]
["Bank:",{"$f":"Questionaire!F110","v":0}]
[]
[null,"Enter Values",null,null,null,"Loan Summary"]
[null,null,"Loan Amount",{"$f":"E5","v":0},{"$f":"Questionaire!$F$111","v":0},null,"Scheduled Payment",{"$f":"IF(Values_Entered,-PMT(Interest_Rate/Num_Pmt_Per_Year,Loan_Years*Num_Pmt_Per_Year,Loan_Amount),\"0\")","v":"0"}]
[null,null,"Annual Interest Rate",{"$f":"E6","v":0},{"$f":"Questionaire!$F$112","v":0},null,"Scheduled Number of Payments",{"$f":"IF(Values_Entered,Loan_Years*Num_Pmt_Per_Year,\"\")","v":""}]
[null,null,"Loan Period in Years",{"$f":"E7","v":0},{"$f":"Questionaire!$F$113","v":0},null,"Actual Number of Payments",{"$f":"IF(Values_Entered,Number_of_Payments,\"\")","v":""}]
[null,null,"Number of Payments Per Year",12,null,null,"Total Early Payments",{"$f":"IF(Values_Entered,SUMIF(Beg_Bal,\">0\",Extra_Pay),\"\")","v":""}]
[null,null,"Start Date of Loan",{"$f":"E9","v":"00:00:00"},{"$f":"Questionaire!$F$115","v":"00:00:00"},null,"Total Interest",{"$f":"IF(Values_Entered,SUMIF(Beg_Bal,\">0\",Int),\"\")","v":""}]
[null,null,"Optional Extra Payments",0]
[]
[]
["PmtNo.","Payment Date","Beginning Balance","Scheduled Payment","Extra Payment","Total Payment","Principal","Interest","Ending Balance","Cumulative Interest"]
[]
[{"$f":"IF(Values_Entered,1,\"\")","v":""},{"$f":"IF(Pay_Num<>\"\",DATE(YEAR(Loan_Start),MONTH(Loan_Start)+(Pay_Num)*12/Num_Pmt_Per_Year,DAY(Loan_Start)),\"\")","v":""},{"$f":"IF(Values_Entered,Loan_Amount,\"\")","v":""},{"$f":"IF(Pay_Num<>\"\",Scheduled_Monthly_Payment,\"\")","v":""},{"$f":"IF(AND(Pay_Num<>\"\",Sched_Pay+Scheduled_Extra_Payments<Beg_Bal),Scheduled_Extra_Payments,IF(AND(Pay_Num<>\"\",Beg_Bal-Sched_Pay>0),Beg_Bal-Sched_Pay,IF(Pay_Num<>\"\",0,\"\")))","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(Pay_Num<>\"\",Sched_Pay+Extra_Pay<Beg_Bal),Sched_Pay+Extra_Pay,IF(Pay_Num<>\"\",Beg_Bal,\"\"))","v":{"$error":"#VALUE!"}},{"$f":"IF(Pay_Num<>\"\",Total_Pay-Int,\"\")","v":""},{"$f":"IF(Pay_Num<>\"\",Beg_Bal*(Interest_Rate/Num_Pmt_Per_Year),\"\")","v":""},{"$f":"IF(AND(Pay_Num<>\"\",Sched_Pay+Extra_Pay<Beg_Bal),Beg_Bal-Princ,IF(Pay_Num<>\"\",0,\"\"))","v":{"$error":"#VALUE!"}},{"$f":"SUM($H$15:$H15)","v":0}]
[{"$f":"IF(Values_Entered,A15+1,\"\")","v":""},"",{"$f":"IF(Pay_Num<>\"\",I15,\"\")","v":""},{"$f":"IF(Pay_Num<>\"\",Scheduled_Monthly_Payment,\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"IF(Pay_Num<>\"\",Total_Pay-Int,\"\")","v":""},{"$f":"IF(Pay_Num<>\"\",Beg_Bal*Interest_Rate/Num_Pmt_Per_Year,\"\")","v":""},{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H16)","v":0}]
["","","",{"$f":"IF(Pay_Num<>\"\",Scheduled_Monthly_Payment,\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H17)","v":0}]
["","","",{"$f":"IF(Pay_Num<>\"\",Scheduled_Monthly_Payment,\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H18)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H19)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H20)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H21)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H22)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H23)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H24)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H25)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H26)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H27)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H28)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H29)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H30)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H31)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H32)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H33)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H34)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H35)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H36)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H37)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H38)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H39)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H40)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H41)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H42)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H43)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H44)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H45)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H46)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H47)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H48)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H49)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H50)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H51)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H52)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H53)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H54)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H55)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H56)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H57)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H58)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H59)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H60)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H61)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H62)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H63)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H64)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H65)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H66)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H67)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H68)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H69)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H70)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H71)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H72)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H73)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H74)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H75)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H76)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H77)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H78)","v":0}]
["",{"$f":"IF(Pay_Num<>\"\",DATE(YEAR(Loan_Start),MONTH(Loan_Start)+(Pay_Num)*12/Num_Pmt_Per_Year,DAY(Loan_Start)),\"\")","v":""},"","",{"$f":"IF(AND(Pay_Num<>\"\",Sched_Pay+Scheduled_Extra_Payments<Beg_Bal),Scheduled_Extra_Payments,IF(AND(Pay_Num<>\"\",Beg_Bal-Sched_Pay>0),Beg_Bal-Sched_Pay,IF(Pay_Num<>\"\",0,\"\")))","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(Pay_Num<>\"\",Sched_Pay+Extra_Pay<Beg_Bal),Sched_Pay+Extra_Pay,IF(Pay_Num<>\"\",Beg_Bal,\"\"))","v":{"$error":"#VALUE!"}},"","",{"$f":"IF(AND(Pay_Num<>\"\",Sched_Pay+Extra_Pay<Beg_Bal),Beg_Bal-Princ,IF(Pay_Num<>\"\",0,\"\"))","v":{"$error":"#VALUE!"}},{"$f":"SUM($H$15:$H79)","v":0}]
[{"$f":"IF(Values_Entered,A79+1,\"\")","v":""},"",{"$f":"IF(Pay_Num<>\"\",I79,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"IF(Pay_Num<>\"\",Total_Pay-Int,\"\")","v":""},{"$f":"IF(Pay_Num<>\"\",Beg_Bal*Interest_Rate/Num_Pmt_Per_Year,\"\")","v":""},{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H80)","v":0}]
["","","",{"$f":"IF(Pay_Num<>\"\",Scheduled_Monthly_Payment,\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H81)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H82)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H83)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H84)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H85)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H86)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H87)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H88)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H89)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H90)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H91)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H92)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H93)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H94)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H95)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H96)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H97)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H98)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H99)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H100)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H101)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H102)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H103)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H104)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H105)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H106)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H107)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H108)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H109)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H110)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H111)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H112)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H113)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H114)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H115)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H116)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H117)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H118)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H119)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H120)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H121)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H122)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H123)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H124)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H125)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H126)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H127)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H128)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H129)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H130)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H131)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H132)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H133)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H134)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H135)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H136)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H137)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H138)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H139)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H140)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H141)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H142)","v":0}]
["",{"$f":"IF(Pay_Num<>\"\",DATE(YEAR(Loan_Start),MONTH(Loan_Start)+(Pay_Num)*12/Num_Pmt_Per_Year,DAY(Loan_Start)),\"\")","v":""},"","",{"$f":"IF(AND(Pay_Num<>\"\",Sched_Pay+Scheduled_Extra_Payments<Beg_Bal),Scheduled_Extra_Payments,IF(AND(Pay_Num<>\"\",Beg_Bal-Sched_Pay>0),Beg_Bal-Sched_Pay,IF(Pay_Num<>\"\",0,\"\")))","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(Pay_Num<>\"\",Sched_Pay+Extra_Pay<Beg_Bal),Sched_Pay+Extra_Pay,IF(Pay_Num<>\"\",Beg_Bal,\"\"))","v":{"$error":"#VALUE!"}},"","",{"$f":"IF(AND(Pay_Num<>\"\",Sched_Pay+Extra_Pay<Beg_Bal),Beg_Bal-Princ,IF(Pay_Num<>\"\",0,\"\"))","v":{"$error":"#VALUE!"}},{"$f":"SUM($H$15:$H143)","v":0}]
[{"$f":"IF(Values_Entered,A143+1,\"\")","v":""},"",{"$f":"IF(Pay_Num<>\"\",I143,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"IF(Pay_Num<>\"\",Total_Pay-Int,\"\")","v":""},{"$f":"IF(Pay_Num<>\"\",Beg_Bal*Interest_Rate/Num_Pmt_Per_Year,\"\")","v":""},{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H144)","v":0}]
["","","",{"$f":"IF(Pay_Num<>\"\",Scheduled_Monthly_Payment,\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H145)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H146)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H147)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H148)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H149)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H150)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H151)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H152)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H153)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H154)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H155)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H156)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H157)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H158)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H159)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H160)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H161)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H162)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H163)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H164)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H165)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H166)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H167)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H168)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H169)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H170)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H171)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H172)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H173)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H174)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H175)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H176)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H177)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H178)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H179)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H180)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H181)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H182)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H183)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H184)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H185)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H186)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H187)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H188)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H189)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H190)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H191)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H192)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H193)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H194)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H195)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H196)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H197)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H198)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H199)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H200)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H201)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H202)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H203)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H204)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H205)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H206)","v":0}]
["",{"$f":"IF(Pay_Num<>\"\",DATE(YEAR(Loan_Start),MONTH(Loan_Start)+(Pay_Num)*12/Num_Pmt_Per_Year,DAY(Loan_Start)),\"\")","v":""},"","",{"$f":"IF(AND(Pay_Num<>\"\",Sched_Pay+Scheduled_Extra_Payments<Beg_Bal),Scheduled_Extra_Payments,IF(AND(Pay_Num<>\"\",Beg_Bal-Sched_Pay>0),Beg_Bal-Sched_Pay,IF(Pay_Num<>\"\",0,\"\")))","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(Pay_Num<>\"\",Sched_Pay+Extra_Pay<Beg_Bal),Sched_Pay+Extra_Pay,IF(Pay_Num<>\"\",Beg_Bal,\"\"))","v":{"$error":"#VALUE!"}},"","",{"$f":"IF(AND(Pay_Num<>\"\",Sched_Pay+Extra_Pay<Beg_Bal),Beg_Bal-Princ,IF(Pay_Num<>\"\",0,\"\"))","v":{"$error":"#VALUE!"}},{"$f":"SUM($H$15:$H207)","v":0}]
[{"$f":"IF(Values_Entered,A207+1,\"\")","v":""},"",{"$f":"IF(Pay_Num<>\"\",I207,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"IF(Pay_Num<>\"\",Total_Pay-Int,\"\")","v":""},{"$f":"IF(Pay_Num<>\"\",Beg_Bal*Interest_Rate/Num_Pmt_Per_Year,\"\")","v":""},{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H208)","v":0}]
["","","",{"$f":"IF(Pay_Num<>\"\",Scheduled_Monthly_Payment,\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H209)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H210)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H211)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H212)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H213)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H214)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H215)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H216)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H217)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H218)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H219)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H220)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H221)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H222)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H223)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H224)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H225)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H226)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H227)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H228)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H229)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H230)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H231)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H232)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H233)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H234)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H235)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H236)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H237)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H238)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H239)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H240)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H241)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H242)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H243)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H244)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H245)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H246)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H247)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H248)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H249)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H250)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H251)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H252)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H253)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H254)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H255)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H256)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H257)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H258)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H259)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H260)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H261)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H262)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H263)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H264)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H265)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H266)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H267)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H268)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H269)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H270)","v":0}]
["",{"$f":"IF(Pay_Num<>\"\",DATE(YEAR(Loan_Start),MONTH(Loan_Start)+(Pay_Num)*12/Num_Pmt_Per_Year,DAY(Loan_Start)),\"\")","v":""},"","",{"$f":"IF(AND(Pay_Num<>\"\",Sched_Pay+Scheduled_Extra_Payments<Beg_Bal),Scheduled_Extra_Payments,IF(AND(Pay_Num<>\"\",Beg_Bal-Sched_Pay>0),Beg_Bal-Sched_Pay,IF(Pay_Num<>\"\",0,\"\")))","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(Pay_Num<>\"\",Sched_Pay+Extra_Pay<Beg_Bal),Sched_Pay+Extra_Pay,IF(Pay_Num<>\"\",Beg_Bal,\"\"))","v":{"$error":"#VALUE!"}},"","",{"$f":"IF(AND(Pay_Num<>\"\",Sched_Pay+Extra_Pay<Beg_Bal),Beg_Bal-Princ,IF(Pay_Num<>\"\",0,\"\"))","v":{"$error":"#VALUE!"}},{"$f":"SUM($H$15:$H271)","v":0}]
[{"$f":"IF(Values_Entered,A271+1,\"\")","v":""},"",{"$f":"IF(Pay_Num<>\"\",I271,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"IF(Pay_Num<>\"\",Total_Pay-Int,\"\")","v":""},{"$f":"IF(Pay_Num<>\"\",Beg_Bal*Interest_Rate/Num_Pmt_Per_Year,\"\")","v":""},{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H272)","v":0}]
["","","",{"$f":"IF(Pay_Num<>\"\",Scheduled_Monthly_Payment,\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H273)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H274)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H275)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H276)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H277)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H278)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H279)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H280)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H281)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H282)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H283)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H284)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H285)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H286)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H287)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H288)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H289)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H290)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H291)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H292)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H293)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H294)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H295)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H296)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H297)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H298)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H299)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H300)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H301)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H302)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H303)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H304)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H305)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H306)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H307)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H308)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H309)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H310)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H311)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H312)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H313)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H314)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H315)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H316)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H317)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H318)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H319)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H320)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H321)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H322)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H323)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H324)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H325)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H326)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H327)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H328)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H329)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H330)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H331)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H332)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H333)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H334)","v":0}]
["",{"$f":"IF(Pay_Num<>\"\",DATE(YEAR(Loan_Start),MONTH(Loan_Start)+(Pay_Num)*12/Num_Pmt_Per_Year,DAY(Loan_Start)),\"\")","v":""},"","",{"$f":"IF(AND(Pay_Num<>\"\",Sched_Pay+Scheduled_Extra_Payments<Beg_Bal),Scheduled_Extra_Payments,IF(AND(Pay_Num<>\"\",Beg_Bal-Sched_Pay>0),Beg_Bal-Sched_Pay,IF(Pay_Num<>\"\",0,\"\")))","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(Pay_Num<>\"\",Sched_Pay+Extra_Pay<Beg_Bal),Sched_Pay+Extra_Pay,IF(Pay_Num<>\"\",Beg_Bal,\"\"))","v":{"$error":"#VALUE!"}},"","",{"$f":"IF(AND(Pay_Num<>\"\",Sched_Pay+Extra_Pay<Beg_Bal),Beg_Bal-Princ,IF(Pay_Num<>\"\",0,\"\"))","v":{"$error":"#VALUE!"}},{"$f":"SUM($H$15:$H335)","v":0}]
[{"$f":"IF(Values_Entered,A335+1,\"\")","v":""},"",{"$f":"IF(Pay_Num<>\"\",I335,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"IF(Pay_Num<>\"\",Total_Pay-Int,\"\")","v":""},{"$f":"IF(Pay_Num<>\"\",Beg_Bal*Interest_Rate/Num_Pmt_Per_Year,\"\")","v":""},{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H336)","v":0}]
["","","",{"$f":"IF(Pay_Num<>\"\",Scheduled_Monthly_Payment,\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H337)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H338)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H339)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H340)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H341)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H342)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H343)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H344)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H345)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H346)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H347)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H348)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H349)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H350)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H351)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H352)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H353)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H354)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H355)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H356)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H357)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H358)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H359)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H360)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H361)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H362)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H363)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H364)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H365)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H366)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H367)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H368)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H369)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H370)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H371)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H372)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H373)","v":0}]
["","","","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"","",{"$error":"#VALUE!"},{"$f":"SUM($H$15:$H374)","v":0}]