Introduction to financial modelling : how to Excel at being a lazy (that means efficient!) modeller / by Liam Bastick
By: Bastick, Liam.Publisher: Melbourne, VIC : SumProduct, 2018Description: 327 p. : ill. ; electronic resource.ISBN: 9781615470662.Subject(s): Excel | Financial modelling | Spreadsheets | Business planningOnline resources: Download as an eBook
|Item type||Home library||Call number||URL||Status||Notes||Date due||Barcode||Item reserves|
|EBook||International||ProQuest eBook (Browse shelf)||Link to resource||eBook||Available as an ebook here|
Key Excel functions -- Key Excel functionalities -- Best practice methodology -- Layout tips -- Time series analysis -- Error checks -- Model template example -- Financial statement theory -- Control accounts -- Example model build -- Self review -- Ratio analysis.
Looks at the common Excel functions and functionalities necessary for financial modelling. Steps you through how to establish best practice in financial modelling through four key concepts, consistency, robustness, flexibility and transparency. Provides examples and case studies.