Normal view MARC view ISBD view

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
Contents:
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.
Summary: 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.
Item type Home library Call number URL Status Notes Date due Barcode Item reserves
EBook EBook International
ProQuest eBook (Browse shelf) Link to resource eBook Available as an ebook here
Total reserves: 0

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.

© 2017 Chartered Accountants Australia and New Zealand ABN 50 084 642 571 (CA ANZ).
Formed in Australia. Members of CA ANZ are not liable for the debts and liabilities of CA ANZ

Powered by Koha

Powered by Koha