I’ve been working on a spreadsheet to help evaluate IP deals.
http://www.tekserv.com.au/bruce/IP1.zip
or
http://www.tekserv.com.au/bruce/IP1.xlsI’m a visual sort of guy and struggle to deal with Net Present Value and Internal Rate of Return as abstractions, so have represented them graphically.
I’d be interested in any feedback regarding the usefulness of this graphical simulator.
At the moment, the simulator cannot reflect realistic cyclic changes in rates and CPI adn growth, but I may develop that.
BTW, the input worksheet looks complicated, and I’ll clean that up in time.
Cheers
BruceBruce
Mooloolaba, QldCrikey! thats a whopper of a spreadsheet!
I’ve downloaded it and will have a play with it to see if I can make sense of it.Nice Excell skills though!
More stuff on the voigtstr at http://users.bigpond.net.au/voigtstr
I look forward to having a play with it.
hi thefirstbruce
not had a play yet but will have a look and send you my modified sheethere to help
Thx Gross.
Any input appreciated.
I am still editing for errors. Though I don’t expect to find too many more. Tonight I revised calculation of NPV. And have cross checked and it seems to be right now.Some of the stamp duty values are out of date for some of the states. NSW and Qld are ok though.
There’s a few accounting issues I could do with advice on. i.e. the consistent application of inflation to future values, esp when used in IRR and NPV calcs. And a realistic choice for the discount rate in NPV, that considers the illiquid nature of property, future risk of negative events, and inflation’s effect on future dollar value.
I have seen one formula for NPV discount rate:
Discount Rate = Cost of Capital.
The formula for the (Nominal) Discount Rate
= (1 + Inflation Rate) * (1 + Real Discount Rate) – 1Bruce
Mooloolaba, QldP.S.
http://www.tekserv.com.au/bruce/Graph.gif
this is what the graphs should look like if they aren’t rendering properly on your version of Excel.Bruce
Mooloolaba, QldI have now updated the spreadsheet’s simulator.
It looks like this:
http://www.tekserv.com.au/bruce/IP.gifBruce
Mooloolaba, QldThat is a beauty Bruce!! Thanks,
PeterThanks, this is the latest GUI.
Have ironed out some more bugs, and checked the accuracy of some calculations, such as NPV and IRR.
http://www.tekserv.com.au/bruce/IP1.gifBruce
Mooloolaba, Qld
You must be logged in to reply to this topic. If you don't have an account, you can register here.
