Financial Planning & Forecasting Seminar 2018-2


DCF successfully conducted its 3-day Financial Planning and Forecasting public seminar held on November 24, December 1 & 8, 2018 at the Cesar E.A. Virata School of Business, UP Diliman, Quezon City.


Dr. Arthur Cayanan handled Day 1. He discussed the important building blocks needed for Financial Planning and Forecasting – Macroeconomics with actual Philippine historical data, Industry Analysis including some of the common tools used and Strategic Planning.


Financial statement analysis, another building block, was discussed by Ms. Pamela S. Lloren-Alcantara on Day 2. She explained the process of financial forecasting using the financial statement method as well as the steps to prepare a cash budget. Topics were reinforced with several exercises.


Day 3 was held at the computer laboratory where Professor Diogenes Dy gave participants hands-on experience in Financial Modeling using MS Excel. They did forecasting of income statements, balance sheets and cash flow statements, as well as discounted cash flow valuation.

There were 18 participants and some of the feedback were as follows:

“Thank you! The wealth of knowledge and experience of the professor gave a really valuable perspective to the session.”

“The professor has a lot of useful insights. He’s also a lively lecturer/speaker.”

“The professor provided a lot of concrete examples. He tried to answer all queries of the class.”

“I like the ‘OC’-ness and tips/shortcuts of the speaker.”

“I appreciate the tips on data sources and Excel shortcuts. I also liked the explanations on why items are included/not included, and are given a particular forecasting treatment. The formulas from the previous session were also explained well. Thanks!”

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s