{"text_format":"2","workbook":"xls","n_sheets":7,"sheets":["Valuation","Key Value Drivers","Financial Statements","Restated Financial Statements","Ratios","Working","NPV & IRR"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":0,"comments":5,"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","formulas":"cached_only"}

{"sheet":"Valuation","index":0,"n_rows":45,"n_cols":11,"rows_kept":45,"cut":false,"hidden":true,"merged":[[25,1,25,7],[23,10,75,15],[1,10,21,15],[44,1,45,9],[0,10,0,15],[22,10,22,15],[43,1,43,9],[1,1,1,7],[2,1,2,7],[3,1,3,7],[23,1,23,7],[24,1,24,7]],"flags":["formulas_cached_only"]}
[{"$nulls":10},"Documentation"]
[null,"Scott Corporation",{"$nulls":8},"This is an area where we can put documentation.                                                                                                                     "]
[null,"DCF VALUATION"]
[null,"Years ended 30 June"]
[null,null,"2009A","2010F","2011F","2012F","2013F","2014F"]
[null,null,"$'000","$'000","$'000","$'000","$'000","$'000"]
[]
[null,"Free cash flow (FCF)",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Discount factor",null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,"Discounted FCF",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"PV of FCF",{"$error":"#DIV/0!"}]
[null,"Continuing Value",{"$error":"#VALUE!"}]
[null,"Enterprise value",{"$error":"#DIV/0!"}]
[]
[]
[]
[null,"OI t+1 ",{"$error":"#VALUE!"}]
[null,"g","Enter g"]
[null,"RINOA",{"$error":"#DIV/0!"}]
[null,"Economic Profit t+1",{"$error":"#VALUE!"}]
[]
[]
[{"$nulls":10},"Notes Area"]
[null,"Scott Corporation",{"$nulls":8},"This area is designed as a space to write notes to yourself.  Hopefully this will save you the hassle of attempting to find the pen and paper that is somewhere in the bottom of your bag."]
[null,"ECONOMIC PROFIT VALUATION"]
[null,"Years ended 30 June"]
[null,null,"2009A","2010F","2011F","2012F","2013F","2014F"]
[null,null,"$'000","$'000","$'000","$'000","$'000","$'000"]
[]
[null,"Economic profit",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Discount factor",null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,"PV of economic profit",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Continuing value",{"$error":"#VALUE!"}]
[null,"NOA"," "]
[null,"Enterprise value",{"$error":"#DIV/0!"}]
{"$rows_empty":8}
[null,"Working Area"]
[null,"This is a place where you can copy and paste formulas, play with calculations and generally have fun whilst being able to see the data you are currently working on."]

{"sheet":"Key Value Drivers","index":1,"n_rows":26,"n_cols":16,"rows_kept":26,"cut":false,"hidden":true,"merged":[[24,15,24,20],[24,1,24,14],[25,1,26,14],[25,15,77,20],[0,15,0,20],[1,15,23,20],[1,1,1,13],[2,1,2,13],[3,1,3,13]],"flags":["formulas_cached_only"]}
[{"$nulls":15},"Documentation"]
[null,"Scott Corporation",{"$nulls":13},"The blue text represents hardwired calculation that should drop out upon entering appropriate data.                                                                                  "]
[null,"KEY VALUE DRIVERS"]
[null,"Years ended 30 June"]
[null,null,null,"2005A","2006A","2007A","2008A","2009A","2010F","2011F","2012F","2013F","2014F","2015F"]
[]
[null,"Sales growth (%)"]
[null,"PM (%)"]
[null,"ATO (times)",{"$nulls":11},0]
[]
[null,null,null,"$'000","$'000","$'000","$'000","$'000","$'000","$'000","$'000","$'000","$'000","$'000"]
[]
[null,"Sales",null,null,0,0,0,0,0,0,0,0,0]
[null,"OI",null,0,0,0,0,0,0,0,0,0,0,{"$error":"#VALUE!"}]
[null,"NOA",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"FCF",null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#VALUE!"}]
[null,"Economic Profit",null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#VALUE!"}]
[null,"RNOA",null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":5}," "]
[null,"WACC","Enter WACC",{"$nulls":6}," "," "," "]
[null,"g","Enter g"]
[]
[]
[]
[null,"Working Area",{"$nulls":13},"Notes Area"]
[null,"This is a place where you can copy and paste formulas, play with calculations and generally have fun whilst being able to see the data you are currently working on.",{"$nulls":13},"This area is designed as a space to write notes to yourself.  Hopefully this will save you the hassle of attempting to find the pen and paper that is somewhere in the bottom of your bag.  "]

{"sheet":"Financial Statements","index":2,"n_rows":148,"n_cols":9,"rows_kept":148,"cut":false,"hidden":false,"merged":[[24,1,24,6],[26,1,26,6],[68,1,68,6],[69,1,69,6],[25,1,25,6],[0,8,0,13],[23,8,23,13],[147,1,148,7],[24,8,179,13],[146,1,146,7],[1,8,22,13],[1,1,1,6],[2,1,2,6],[3,1,3,6],[70,1,70,6]],"flags":["formulas_cached_only"]}
[{"$nulls":8},"Documentation"]
[null,"RPM Global",{"$nulls":6},"This is an area where we can put documentation.                      "]
[null,"Statements of Movements in Equity"]
[null,"2019-06-30"]
[null,null,null,2018,2017,2016,2015]
[null,null,null,"$'000","$'000","$'000","$'000"]
[]
[null,"Balance",null,61800,43654,54919,40034]
[null,"Profit for the year",null,244,44,-9263,-6757]
[null,"Other comprehensive income",null,-155,-757,-69,42]
[null,"Total comprehensive income ",null,89,-713,-9332,-6715]
[null,"Transactions with owners in their capacity as owners"]
[null,"Contributions of equity, net of transactions costs",null,2533,18127,-2846,21216]
[null,"Employee share options",null,877,732,913,384]
[null,null,null,3410,18859,-1933,21600]
[null,"Balance at 30 June",null,65299,61800,43654,54919]
{"$rows_empty":7}
[{"$nulls":8},"Notes Area"]
[null,"RPM Global",{"$nulls":6},"This area is designed as a space to write notes to yourself.  Hopefully this will save you the hassle of attempting to find the pen and paper that is somewhere in the bottom of your bag.                                                         "]
[null,"Balance Sheets"]
[null,"as at 30 June"]
[null,null,null,2018,2017,2016,2015]
[null,null,null,"$'000","$'000","$'000","$'000"]
[null,"ASSETS"]
[null,"Current Assets",null,23319,20278,18142,22557]
[null,"Cash and cash equivalents",null,21388,24814,12648,17449]
[null,"Work in progress",null,3133,1784,1471,1148]
[null,"Current tax recievable",null,328,285,239,105]
[null,"Other assets",null,1213,1607,1658,1658]
[null,"Total Current assets",null,49381,48768,34158,42917]
[null,"Non- Current Assets"]
[null,"Trade and other recievables",null,233,215,283,351]
[null,"Investments accounted for using the equity method",null,null,null,26,26]
[null,"Property, plant and equipment",null,1876,2096,2137,2564]
[null,"Deferred tax assets",null,9145,9195,8656,8639]
[null,"Intangible assets",null,37140,33985,17499,22257]
[null,"Total non-current assets",null,48394,45491,28601,33837]
[null,"Total Assets",null,97775,9425,62759,76745]
[null,"LIABILITIES"]
[null,"Current liabilities"]
[null,"Trade and other payables",null,7521,8588,5210,8003]
[null,"Provisions",null,4650,3546,3049,3113]
[null,"Current Tax payables",null,129,608,183,73]
[null,"Other liabilities",null,16486,14620,8480,8508]
[null,"Total Current Liabilities",null,28786,27362,16922,19697]
[null,"Non-Current Liabilities"]
[null,"Provisions",null,1416,1545,1691,1953]
[null,"Deferred tax liabilities",null,16,30,17,"-"]
[null,"Other liabilities ",null,2258,3521,475,185]
[null,"Total non-current liabilities",null,3690,5096,2183,2138]
[null,"Total Liabilities",null,32476,32458,19105,21835]
[null,"Net Assets",null,65299,61800,43654,54919]
[null,"Equity"]
[null,"Contribution equity",null,87708,85175,67048,69894]
[null,"Reserves",null,-2284,-2995,-3013,-3857]
[null,"Retained earnings",null,-20125,-20380,-20381,-11118]
[null,"Total Equity",null,65299,61800,43654,54919]
[]
[]
[]
[]
[]
[null,"RPM Global"]
[null,"Income Statements"]
[null,43646]
[null,null,null,2018,2017,2016,2015]
[null,null,null,"$'000","$'000","$'000","$'000"]
[null,"Services",null,39158,32315,30026,36428]
[null,"Licence Sales",null,13605,23268,11752,15944]
[null,"Software maintenance ",null,19606,17264,15010,13701]
[null,"Licence subscription",null,778,547]
[null,"Other Reveue",null,557,1297,338,1558]
[null,"Revenue ",null,73704,74791,57126,67631]
[null,"Rechargeable expenses",null,-6136,-8016,-4476,-5612]
[null,"Net Revenue",null,67568,66775,52650,62019]
[]
[null,"Expenses"]
[null,"Amortisation",null,-2659,-1982,-931,-1060]
[null,"Depreciation",null,-739,-831,-948,-3080]
[null,"Employee benefits expense",null,-46921,-43516,-42546,-44287]
[null,"Commisions and incentives",null,-3960,-5165]
[null,"Other employee costs",null,-775,-672,-726,-772]
[null,"Office expenses",null,-2632,-3120,-3033,-3146]
[null,"Professional services",null,-1396,-1763,-1596,-1318]
[null,"Professional services - Russion litigation",null,-273,"-","-"]
[null,"Rent",null,-3418,-3621,-3886,-5948]
[null,"Reconstruction costs",{"$nulls":4},-2469]
[null,"Impairment of Goodwill",null,null,null,-4055,-3211]
[null,"Acquisition recorganisation costs",null,"-",-465]
[null,"Redundancy costs",null,"-",-766,-361]
[null,"Travel expenses",null,-2537,-2658,-2166,-2112]
[null,"Other expenses",null,-1560,-1679,-1920,-1835]
[null,null,null,-66870,-66238,-62168,-69238]
[]
[null,"Profit/(Loss) before finance costs and income tax",null,698,538,-9518,-7219]
[null,"Finance income",null,272,269,335,523]
[null,"Finance cost",null,-32,-24,-38,-173]
[null,"Fair value adjustments",null,-314,-24]
[null,"Net Finance costs",null,-74,245,297,350]
[]
[null,"Profit/(Loss) before income tax",null,624,783,-9221,-6869]
[null,"Income tax benefit/(expense)",null,-380,-739,-42,112]
[null,"Profit/(Loss) after income tax",null,244,44,-9263,-6757]
[]
[null,"Profit/(loss)",null,244,44,-9263,-6757]
[null,"Other comprehensive income"]
[null,"Items that will not be classified subsequently to profit or loss:"]
[null,"Re-Measuremtns fo retirement beneift obligations",null,11,-43]
[null,"Items that may be classifed subsequently to profit or loss:"]
[null,"Foreign curreny translation differences",null,-166,-714,-69,42]
[null,"Other comprehensive income/(loss), net of tax",null,-155,-757,-69,42]
[null,"Total comprehensive income",null,89,-713,-9332,-6715]
[]
[null,"Earings per share"]
[null,"Basic earnings per share (cents)",null,0.11,0.02,-5.3,-3.9]
[null,"Diluted earnings per share (cents)",null,0.11,0.02,-5.3,-3.9]
{"$rows_empty":24}
[null,"Basic earnings per share (cents)"]
[null,"This is a place where you can copy and paste formulas, play with calculations and generally have fun whilst being able to see the data you are currently working on."]

{"sheet":"Restated Financial Statements","index":3,"n_rows":121,"n_cols":16,"rows_kept":121,"cut":false,"hidden":false,"merged":[[115,10,115,12],[116,10,116,12],[117,10,117,12],[35,10,35,12],[36,10,36,12],[43,10,43,12],[111,10,111,12],[112,10,112,12],[113,10,113,12],[114,10,114,12],[109,10,109,12],[110,10,110,12],[105,10,105,12],[106,10,106,12],[107,10,107,12],[108,10,108,12],[101,10,101,12],[102,10,102,12],[103,10,103,12],[104,10,104,12],[97,10,97,12],[98,10,98,12],[99,10,99,12],[100,10,100,12],[93,10,93,12],[94,10,94,12],[95,10,95,12],[96,10,96,12],[87,10,87,12],[90,10,90,12],[91,10,91,12],[92,10,92,12],[83,10,83,12],[84,10,84,12],[85,10,85,12],[86,10,86,12],[77,10,77,12],[78,10,78,12],[79,10,79,12],[80,10,80,12],[81,10,81,12],[82,10,82,12],[88,1,88,2],[88,10,88,12],[59,10,59,12],[61,10,61,12],[62,10,62,12],[72,10,72,12],[73,10,73,12],[74,10,74,12],[75,10,75,12],[76,10,76,12],[56,10,56,12],[57,10,57,12],[58,10,58,12],[52,10,52,12],[53,10,53,12],[54,10,54,12],[55,10,55,12],[47,10,47,12],[50,10,50,12],[51,10,51,12],[49,10,49,12],[42,10,42,12],[44,10,44,12],[45,10,45,12],[41,10,41,12],[32,10,32,12],[33,10,33,12],[34,10,34,12],[37,10,37,12],[46,10,46,12],[25,1,25,12],[23,15,150,20],[26,1,26,12],[27,1,27,12],[65,1,65,12],[66,1,66,12],[67,1,67,12],[38,10,38,12],[39,10,39,12],[40,10,40,12],[22,15,22,20],[1,1,1,12],[2,1,2,12],[3,1,3,12],[0,15,0,20],[1,15,21,20]],"flags":["formulas_cached_only"]}
[{"$nulls":15},"Documentation"]
[null,"RPM Global",{"$nulls":13},"This is an area where we can put documentation.                                                                                                                                                                    "]
[null,"Restated Statements of Movements in Equity "]
[null,43646]
[null,null,null,2004,2005,2006,2007,2008,2009,2018,2017,2016,2015]
[null,null,null,"$'000","$'000","$'000","$'000","$'000","$'000","$'000","$'000","$'000","$'000"]
[]
[null,"Balance bgin year",{"$nulls":7},61800]
[]
[{"$nulls":10}," "]
{"$rows_empty":12}
[{"$nulls":15},"Notes Area"]
[{"$nulls":15},"This area is designed as a space to write notes to yourself.  Hopefully this will save you the hassle of attempting to find the pen and paper that is somewhere in the bottom of your bag.                                                                     "]
[]
[null,"RPM Global"]
[null,"Restated Statements of Financial Position"]
[null,"2019-06-30"]
[null,null,null,2004,2005,2006,2007,2008,2009,2018,2017,2016,2015]
[null,null,null,"$'000","$'000","$'000","$'000","$'000","$'000","$'000","$'000","$'000","$'000"]
{"$rows_empty":30}
[{"$nulls":9}," "]
[]
[]
[null," "]
[]
[null,"RPM Global"]
[null,"Restated Statements of Financial Performance consiated income"]
[null,43646]
[null,null,null,2004,2005,2006,2007,2008,2009,2018,2017,2016,2015]
[null,null,null,"$'000","$'000","$'000","$'000","$'000","$'000","$'000","$'000","$'000","$'000"]
[]
[{"$nulls":9}," "," ",null," "]
[]
[]
[{"$nulls":10}," "]
{"$rows_empty":44}
[null,"Working Area"]
[null,"This is a place where you can copy and paste formulas, play with calculations and generally have fun whilst being able to see the data you are currently working on."]

{"sheet":"Ratios","index":4,"n_rows":54,"n_cols":10,"rows_kept":54,"cut":false,"hidden":false,"merged":[[18,9,18,14],[19,9,140,14],[52,1,52,8],[53,1,54,8],[0,9,0,14],[1,1,1,6],[2,1,2,6],[3,1,3,6],[1,9,17,14]],"flags":["formulas_cached_only"]}
[{"$nulls":9},"Documentation"]
[null,"RPM Global",{"$nulls":7},"This is an area where we can put documentation.                                                                                                                                                                 "]
[null,"RATIOS"]
[null,43646]
[null,null,null,2018,2017,2016,2015]
[null,"Profitability Ratios"]
[null,"Gross Profit Margin","Gross profit/sales",null,null,null,0.19260000000000002]
[null,"Net Profit Margin","Net profit after tax/sales"," "]
[null,"Return on Assets","Net profit after tax/total assets",null,null,null," "]
[]
[null,"Efficiency (or Asset Management) Ratios"]
[null,"Inventory Turnover Ratio","Cost of goods sold/ending inventory",null,null,null,1.892]
[null,"Days of Inventory","Inventory/av.daily cost of goods sold"]
[null,"Total Asset Turnover Ratio","Sales/total assets",null," ",null," "]
[null,"Current Asset Turnover Ratio","Sales/current assets"]
[null,"Average Collection Period (Days Receivable)","Accounts receivable/av.daily credit sales"]
[null,null," "]
[null,"Liquidity Ratios"," "]
[null,"Current Ratio","Current assets/current liabilities"," "," ",null," ",null,null,"Notes Area"]
[null,"Quick Ratio 1","(Current assets - inventory - prepayments)/current liabilities",null,null,null,0.009,null,null,"This area is designed as a space to write notes to yourself.  Hopefully this will save you the hassle of attempting to find the pen and paper that is somewhere in the bottom of your bag.                                                         "]
[null,"Quick Ratio 2","(Current assets - inventory - prepayments - receivables)/current liabilities"]
[]
[null,"Financial Structure Ratios"]
[null,"Debt/Equity Ratio","Debt/equity"," ",null,null," "]
[null,"Equity Ratio","Equity/total assets",null,null,null," "]
[null,"Times Interest Earned","Earnings before interest & tax/interest"]
[]
[null,"Market Ratios"]
[null,"Earnings per Share (EPS)","Net profit after tax/nos of issued ordinary shares"," ",null,null," "]
[null,"Dividends per Share (DPS)","Dividends/number of issued ordinary shares"]
[null,"Dividend Yield Ratio","Dividends per share/market price per share"]
[null,"Price Earnings Ratio","Market price per share/earnings per share"," ",null,null," "]
[null,"Net Asset Backing per Share Ratio","Net assets (owners equity)/number of shares issued"]
[null,"Market/Book Ratio","Market price per share/net asset backing per share",null,null,null,0.052]
[]
[null,"Ratios Based on Reformulated Financial Statements"]
[null,"Dividend Payout Ratio","Dividends/comprehensive income",null,null,null," "]
[null,"Return on Equity (ROE)","Comprehensive Income/shareholders' equity",null,null,null," "]
[null,"Return on Net Operating Assets (RNOA)","Operating income after tax (OI)/net operating assets (NOA)"]
[null,"Net Borrowing Cost (NBC)","Net fin. expenses after tax/net financial obligations"]
[null,"Profit Margin (PM)","Operating income after tax (OI)/sales"]
[null,"Operating Liability Leverage (OLLEV)","Av.operating liabilities/av.net operating assets"]
[null,"Financial Leverage (FLEV)","Av.net financial obligations/av.shareholders' equity"]
[null,"Return on Operating Assets (ROOA)","(OI after tax + implicit interest after tax)/av.operating assets"]
[null,"Operating Liability Leverage Spread (OLSPREAD)","ROOA - short-term borrowing rate (after tax)"]
[null,"Asset Turnover (ATO)","Sales/net operating assets (NOA)"," ",null,null," "]
[null,"Growth in Sales","Change in sales/prior period's sales"]
[null,"Growth in Operating Income","Change in OI after tax/prior period's OI after tax"]
[null,"Growth in Net Operating Assets","Change in NOA/opening NOA"]
[null,"Growth in Shareholders' Equity","Change in shareholders' equity/opening shareholders' equity"]
[null,"Economic profit ","(RNOA - cost of capital) x net operating assets (NOA)"," "," "]
[]
[null,"Working Area"]
[null,"This is a place where you can copy and paste formulas, play with calculations and generally have fun whilst being able to see the data you are currently working on."]

{"sheet":"Working","index":5,"n_rows":2,"n_cols":15,"rows_kept":2,"cut":false,"hidden":true,"merged":[[0,14,0,19],[1,14,53,19],[0,1,0,13],[1,1,2,13]],"flags":["formulas_cached_only"]}
[null,"Working Area",{"$nulls":12},"Notes Area"]
[null,"This is a place where you can copy and paste forumlas, play with calculations and generally have fun without messing up your other worksheets.",{"$nulls":12},"This area is designed as a space to write notes to yourself.  Hopefully this will save you the hassle of attempting to find the pen and paper that is somewhere in the bottom of your bag.  "]

{"sheet":"NPV & IRR","index":6,"n_rows":34,"n_cols":12,"rows_kept":34,"cut":false,"hidden":false,"merged":[[4,0,4,11],[21,0,21,11]],"flags":["formulas_cached_only"]}
["EXAMPLE FOR WESFARMERS"]
[]
["ALL FIGURES ARE EXPRESSED IN MILLIONS AUD"]
[]
["OPTION 1: BUNNINGS"]
[]
["Time period",0,1,2,3,4,5,6,7,8,9,10]
["Cashflow",-77,-4,5,15,20,20,20,25,25,10,13]
["NPV",5.878440358998489]
[]
["IRR",0.11370810842533685]
[]
["Time period",0,1,2,3,4,5,6,7,8,9,10]
["Cashflow",-77,-4,5,15,20,20,20,25,25,10,13]
["Cumulative Cashflow",-77,-81,-76,-61,-41,-21,-1,24,49,59,72]
[]
["Payback Period","6 years",14.6,"days"]
[null,null,0.48,"months"]
[null,null,0.04,"years"]
[]
[]
["OPTION 2: COLES"]
[]
["Time period",0,1,2,3,4,5,6,7,8,9,10]
["Cashflow",-135,-5,-1,10,15,15,20,20,20,25,13.5]
["NPV",-66.609667704572]
[]
["IRR",-0.0026354083980250076]
[]
["Time period",0,1,2,3,4,5,6,7,8,9,10]
["Cashflow",-135,-5,-1,10,15,15,20,20,20,25,13.5]
["Cumulative Cashflow",-135,-140,-141,-131,-116,-101,-81,-61,-41,-16,-2.5]
[]
["Payback Period","Investment is never paid back within 10 years"]