Hands-on financial modeling with Microsoft Excel 2019 : build practical models for forecasting, valuation, trading and growth analysis using Excel 2019 / by Shmuel Oluwa
By: Oluwa, Shmuel.Publisher: Birmingham, U.K. : Packt Publishing, 2019Description: iv, 268 p. : ill. ; electronic resource.ISBN: 9781789534627.Subject(s): Financial modelling | Data | Excel | SpreadsheetsOnline 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|
FINANCIAL MODELING - OVERVIEW : Introduction to financial modeling and Excel -- Steps for building a financial model. THE USE OF EXCEL - FEATURES AND FUNCTIONS FOR FINANCIAL MODELING: Formulas and functions - completing modeling tasks with a single formula -- Applying the referencing framework in Excel. BUILDING AN INTEGRATED FINANCIAL MODEL: Understanding the project and building assumptions -- Asset and debt schedules -- Cash flow statement -- Ratio analysis -- Valuation -- Model testing for reasonableness and accuracy.
Examines financial modelling using Excel's financial functions and pivot tables. Discusses how to perform valuations, identify growth drivers, and prepare various models for income and cash flow statements and balance sheets.