{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Template"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":1,"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":"Template","index":0,"n_rows":66,"n_cols":7,"rows_kept":66,"cut":false,"hidden":false,"merged":[[0,0,0,6]]}
["CHAPTER 5 TEMPLATE--JUST TO SAVE YOU SOME TYPING"]
["Sales growth"]
["Current assets/Sales"]
["Current liabilities/Sales"]
["Net fixed assets/Sales"]
["Costs of goods sold/Sales"]
["Depreciation rate"]
["Interest rate on debt"]
["Interest paid on cash & marketable securities"]
["Tax rate"]
["Dividend payout ratio"]
[]
["Year",0,1,2,3,4,5]
["Income statement"]
["Sales"]
["Costs of goods sold"]
["Interest payments on debt"]
["Interest earned on cash & marketable securities"]
["Depreciation"]
["Profit before tax"]
["Taxes"]
["Profit after tax"]
["Dividends"]
["Retained earnings"]
[]
["Balance sheet",0,1,2,3,4,5]
["Cash and marketable securities"]
["Current assets"]
["Fixed assets"]
["     Fixed assets at cost"]
["     Accumulated depreciation"]
["     Net fixed assets"]
["Total assets"]
[]
["Current liabilities"]
["Debt"]
["Stock"]
["Accumulated retained earnings"]
["Total liabilities and equity"]
[]
[]
["Year",0,1,2,3,4,5]
["Free Cash Flow"]
["PAT"]
["Add back depreciation"]
["Minus NWC"]
["    Minus increase in CA"]
["    Add back increase in CL"]
["Subtract CAPEX"]
["Add back net interest after taxes"]
["Free Cash Flow"]
[]
[]
["WACC"]
["Long-term FCF growth"]
[]
["Year",0,1,2,3,4,5]
["FCF"]
["Terminal value"]
["Total"]
[]
["Enterprise value:  \nPV of FCFs and terminal value"]
["Add back initial cash"]
["Asset value"]
["Subtract year 0 debt"]
["Imputed equity value"]