{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Table of Contents","Exercise","Chart3","Instructions"],"not_rendered":{"charts":2,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"Chart3","index":2,"reason":"not_a_worksheet"}],"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":"Table of Contents","index":0,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"Sheet Tab","Description","Author"]
[null,1,"Table of Contents"]
[null,2,"Exercise"]
[null,3,"Chart3"]
[null,4,"Instructions"]
[]
[null," File Name: ",null,"C:\\A Files\\Courses\\Course Materials\\1 Templates and Exercises Corporate Model\\Exercises\\Exercise 1 - Cash Flow Plug.xls"]
[]
[null," Colour Codes "]
[]
[null," Date ",null,"2009-03-10"]

{"sheet":"Exercise","index":1,"n_rows":63,"n_cols":10,"rows_kept":63,"cut":false,"hidden":false,"merged":[]}
["Table of Contents"]
[]
[null,null,"Existing Balance Sheet"]
[null,null,null,"Fixed Assets",1000]
[null,null,null,"Surplus Cash",200,null,"Sensitivity Factor",null,{"$f":"I7/100","v":1}]
[null,null,null,"Total Assets",{"$f":"E4+E5","v":1200}]
[null,null,null,"Over Drafts",500,null,null,null,100]
[null,null,null,"Equity",{"$f":"E6-E7","v":700}]
[null,null,null,"Total Liab and Cap",{"$f":"E7+E8","v":1200},null,"Interest Expense Rate",null,0.1]
[null,null,null,null,null,null,"Interest Income Rate",null,0.05]
[null,null,null,"Check",{"$f":"E6=E9","v":true}]
[]
[null,null,"Operating Inputs"]
[null,null,null,"Base EBITDA",null,-200,100,500,700,800]
[]
[null,null,"Profit and Loss/Cash Flow"]
[null,null,null,"Applied EBITDA"]
[null,null,null,"Less: Interest Expense"]
[null,null,null,"Add: Interest Income"]
[null,null,null,"Net Income"]
[]
[null,null,null,"Cash Flow = Net Income"]
[]
[null,null,"Surplus Cash less Over Drafts"]
[null,null,null,"Opening Balance"]
[null,null,null,"Add: Cash Flow"]
[null,null,null,"Closing Balance"]
[]
[null,null,null,"Surplus Cash"]
[null,null,null,"Interest Income Rate"]
[null,null,null,"Interest Income  "]
[]
[null,null,null,"Overdrafts"]
[null,null,null,"Interest Expense Rate"]
[null,null,null,"Interest Expense  "]
[]
[null,null,null,"Equity Balance"]
[null,null,null,"Opening Balance"]
[null,null,null,"Add: Net Income"]
[null,null,null,"Closing Balance"]
[]
[null,null,"Projected Balance Sheet"]
[null,null,null,"Fixed Assets"]
[null,null,null,"Surplus Cash"]
[null,null,null,"Total Assets"]
[]
[null,null,null,"Over Drafts"]
[null,null,null,"Equity"]
[null,null,null,"Total Liab and Cap"]
[]
[null,null,null,"Difference"]
[null,null,null,"Check "]
[]
[null,null,null,"Overall Check"]
[]
[]
[null,null,"Graph Data"]
[null,null,null,null,null,2008,{"$f":"F58+1","v":2009},{"$f":"G58+1","v":2010},{"$f":"H58+1","v":2011},{"$f":"I58+1","v":2012}]
[null,null,null,null,"Cash Balance",{"$f":"F44","v":0},{"$f":"G44","v":0},{"$f":"H44","v":0},{"$f":"I44","v":0},{"$f":"J44","v":0}]
[null,null,null,null,"Overdrafts",{"$f":"F47","v":0},{"$f":"G47","v":0},{"$f":"H47","v":0},{"$f":"I47","v":0},{"$f":"J47","v":0}]
[]
[]
[null,null,null,null,null,"Sensitivity Factor",null,{"$f":"Sensitivity","v":1}]

{"sheet":"Instructions","index":3,"n_rows":28,"n_cols":4,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
["Table of Contents"]
[]
[]
[]
[]
[]
[]
[null,null,null,"Use the F11 Key for the graph"]
[]
[null,null,null,"The first balance of the net cash bucket is the cash less debt (it can be negative)"]
[]
[null,null,null,"Changes in the cash flow bucket come from the last line in the cash flow statement"]
[]
[null,null,null,"Use the MAX function to Compute the Surplus cash"]
[]
[null,null,null,"Take the first year surplus cash from the balance sheet"]
[]
[null,null,null,"Use the MAX function with a negative sign to compute short-term debt"]
[]
[null,null,null,"Take the first year debt from the balance sheet"]
[]
[null,null,null,"Balance the balance sheet with and equity account"]
[]
[null,null,null,"The model has no dividends and the equity balance increases by income"]
[]
[null,null,null,"Check the difference between assets and liabilities and use a TRUE/FALSE test"]
[]
[null,null,null,"The TRUE/FALSE is simply Difference = 0"]