Course details
Financial modeling is used regularly by operating businesses to make a variety of decisions. This workshop is designed especially to provide financial professionals looking to build complex models for financial, real investments and development projects using Excel. Properties with multiple complex leases particularly benefit from the use of Excel spreadsheets to evaluate the effect of leases terminating and being renewed overtime. It can also be used to evaluate complex iterative scenarios with multiple options. The course material is covered comprehensively over two days with a combination of lectures and practice problems. The overall objective is to integrate financial concepts with accessible but powerful Excel tools to facilitate greater analytical accuracy and rapid investment analysis.
- Integrate financial concepts with accessible but powerful Excel tools to facilitate greater analytical accuracy and rapid investment analysis
- Construct flexible and reusable models which can be applied to a wide range of different investment scenarios
- Understand how to interpret the results of the excel models to analyze the risks and returns of the investment projects
Excel Functions And Tools
In addition to covering a wide range of finance topics, the course specifically covers the following Excel tools and functions.
COURSE OUTLINE
- Building Financial Models
- Financial Statement Modeling
- Investment Modeling
- Building Your Own Models
LEARNING OUTCOME
Through a combination of case studies, practical exercises and Excel based models you will learn how to adjust and apply the theoretical techniques used. Delegates are encouraged to ask questions and highlight areas of particular interest. The concepts taught are designed to be of practical benefit to attendees and are transferable to the workplace.
Updated on 08 November, 2015Course Location
About COMAT Training Services Pte Ltd
To be or not to be; this is the question which resides in us. All man of clay, our innate differences are subtle and few. The void spanning greatness hinges on existence of mean and will. COMAT holds an intrinsic belief that every inpidual has a potential to be realised. Betterment of society through advancement of its basic unit, empowerment through continuous learning – Upon these axioms were we founded, and today proudly uphold.
Love for the people around us, a desire for a better world, our passion is our profession. COMAT believes learning is a lifelong process and key to a meaningful existence. Spearheaded by a renowned team of highly experienced and motivated trainers, COMAT offers an extensive array of IT, safety and leadership & professional development courses, providing inpiduals with the means to excel.
While adhering to globally accepted quality standards, our intention goes beyond training and certification - COMAT provides a holistic experience, focusing on generation of inductive environments for stimulating philosophical thoughts. True learning lies in instillation of a sense of self-realisation, a will to become who they can be.
We pride ourselves on our innovations, our desire for continuous improvement, and the ability to perceive the needs and wants of each inpidual. Customized approaches for varying needs, we conjure solutions tailored to fit.
See all COMAT Training Services Pte Ltd courses- Accountant's Guide to Climate Change StudyHubSGD 33Duration: Upto 1 Hour
- Accredited Bookkeeping, Accounting and Sage One Alpha AcademySGD 34
SGD 537Duration: Upto 14 Hours
