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

{"sheet":"Growth, NW & ROA","index":0,"n_rows":18,"n_cols":13,"rows_kept":18,"cut":false,"hidden":false,"merged":[[17,0,18,7],[1,0,1,7]]}
[]
["Relationship Between Growth, Capital & ROA"]
[]
[null,null,null,null,null,null,"What If…","What If…"]
["Assets ($000s)",100000,null,null,null,null,"Growth%","ROA%"]
["Capital ($000s)",10000,null,null,null,null,0.05,0.01]
[]
[]
[null,"Growth","Assets","Net Inc",null,null,"Capital","ROA"]
[]
["Base",null,{"$f":"B5","v":100000},null,null,null,{"$f":"B6/C11","v":0.1}]
["Yr 1",{"$f":"G6","v":0.05},{"$f":"C11*(1+B12)","v":105000},{"$f":"((C11+C12)/2)*$H12","v":1025},null,null,{"$f":"M12/C12","v":0.105},{"$f":"H6","v":0.01},null,null,null,null,{"$f":"D12+B6","v":11025}]
["Yr 2",{"$f":"B12","v":0.05},{"$f":"C12*(1+$B13)","v":110250},{"$f":"((C12+C13)/2)*$H13","v":1076.25},null,null,{"$f":"M13/C13","v":0.10976190476190475},{"$f":"H12","v":0.01},null,null,null,null,{"$f":"D13+M12","v":12101.25}]
["Yr 3",{"$f":"B13","v":0.05},{"$f":"C13*(1+$B14)","v":115762.5},{"$f":"((C13+C14)/2)*$H14","v":1130.0625},null,null,{"$f":"M14/C14","v":0.11429705215419501},{"$f":"H13","v":0.01},null,null,null,null,{"$f":"D14+M13","v":13231.3125}]
["Yr 4",{"$f":"B14","v":0.05},{"$f":"C14*(1+$B15)","v":121550.625},{"$f":"((C14+C15)/2)*$H15","v":1186.565625},null,null,{"$f":"M15/C15","v":0.11861624014685239},{"$f":"H14","v":0.01},null,null,null,null,{"$f":"D15+M14","v":14417.878124999999}]
[]
[]
["Note:  Feel free to manually override growth and ROA percentages by individual year.  To reset all four years, input the desired ratios in cells G6:H6 and click the Set All 4 Years the Same button."]