HANDS-ON
Financial Analysis and Modeling
X435.6 (1 semester unit in Business Administration)
A requirement in the Certificate Program in FinanceThis hands-on computer course provides students with the skills needed to apply the theories, concepts, and tools covered in Basic Corporate Finance and Intermediate Corporate Finance to the development of spreadsheet knowledge that can be used for effective financial analysis and financial decision making. Specific attention is devoted to developing spreadsheet skills for financial statement analysis and forecasting, stock and bond valuation, target capital structure estimation, and capital budgeting.
This course is primarily intended for students in the UC Berkeley Extension Certificate Program in Finance, but it is also ideal for students who want to expand their ability to use computer spreadsheets in financial management applications.
Prerequisites: Completion of Basic Corporate Finance X430.1, completion of or concurrent enrollment in Intermediate Corporate Finance X444.1, and basic proficiency with computer spreadsheets.
Note: The online course requires access to Microsoft Excel 2003 or later.
Click below for sections, start dates, locations, instructors,
and to enroll.
Online, Enroll anytime
CATHERINE PINKAS, M.B.A., PMP, is vice president of Synapsis Solutions, a curriculum development company specializing in systems training materials for companies including Apple Computer, Cisco Systems, Network Appliances, IBM, Compaq, and Informix. She has more than 15 years of experience in project management involving construction, information technology, business development, and events management.
- Online course: Internet access required
- Enroll anytime: You have 6 months to complete
- $525 (EDP 897132)
Enroll
Textbook(s) for this course:
Financial Analysis with Microsoft Excel
Author: Timothy R. Mayes and Todd M. Shank
Publisher: South-Western
Edition: 4th
Publication Year: 2006
ISBN: 0324407505
Sat. Aug. 9, San Francisco
MARTIN A. MEDEIROS, M.A., named Honored Instructor in 2005, is a professional economist and an instructor at College of Alameda and Holy Names College. Previously, he worked as an economist for Bank of America.Revised class schedule in red.
- 3 meetings
- Aug. 9-23: Sat., 9 am-2 pm
- San Francisco: Room 814, UC Berkeley Extension Downtown Center, 425 Market St., 8th Floor (enter on Fremont St.)
- $470 (EDP 304196)
Enroll
Textbook(s) for this course:
Note: Book Optional
Microsoft Excel: Data Analysis and Business Modeling
Author: Winston
Publisher: Microsoft Press
Edition: 1
Publication Year: 2004
ISBN: 0735619018
Textbook is optional.