Stock Valuation using Excel

¥17,999
Course Code: FOI201-WS
Semester: Fall Day: Sat Time: 10:00-16:30 Hours: 6 Sessions: 1 End Date: 2021/12/4 Elective certificate: Accounting and Finance Medium of Instruction: English Location: Tokyo

Registration Closed - Add to Wishlist

Course Description

Valuing stocks is a complicated process that may need both art and science skills. In this workshop, students learn this process, using excel worksheet. Students bring their interested stock, and value the stock based on DCF (Discounted Cash Flow) model, and DDM (Dividend Discount) model. By knowing the stock’s theoretical (or intrinsic) value, students may determine whether the stock is over- or under-valued at its current market price.

Textbook

No required textbook (Recommended; Bodie, Kane & Marcus. “Investments,” 10th Ed. McGraw Hill)

Instructor

Toshiki Onozuka

Instructor Biography

Toshiki Onozuka's work experience ranges from a 27 year career in diverse accounting and finance roles in ExxonMobil (1977 to 2004) to working as a controller for Walt Disney Japan (2005 to 2012), including a three year supervisory responsibility for the accounting function in Walt Disney Korea. In addition to management-related tasks, he has accumulated a wealth of experience in a diversity of accounting and finance-related jobs while working for Controller's, Treasurer's, Strategic Planning and the SAP Project team. Toshiki has been teaching accounting courses at Temple University Japan Campus since the year 2000. Between 2013 and 2014, he was invited as visiting professor to give lectures on International Financial Reporting Standards and other accounting courses at Tashkent Financial Institute in Uzbekistan, where he is also currently honorary professor. He holds a MBA from Foster School of Business at the University of Washington, and a CPA from the Washington State Board of Accountancy.