ME179 - Solving Financial Problems with the HP 12C and Excel
Includes a Live Web Event on 02/22/2023 at 1:00 PM (EST)
Wednesday, February 22, 2023
1:00 p.m. - 3:00 p.m. Eastern
The webinar provides and introduction to the capabilities of the HP 12C and Excel spreadsheet for performing financial calculations. It will examine the functionality of the HP 12C financial calculator and Excel spreadsheet for solving financial problems. Multiple examples will be presented for solving present value and future value problems along with the present value and future value of an annuity. The preprogrammed functionality of the HP 12C and Excel spreadsheet will be discussed to illustrate how common financial problems can more easily be solved. The solution of a leasing problem will also be presented.
MTS Appraisers looking to increase their knowledge concerning use of the HP 12C financial calculator and Excel spreadsheet to solve financial problems.
General Webinar Information
Important login information will be e-mailed to registrants prior to the webinar. In addition, this presentation will not be recorded or made available post-webinar for purchase via the ASA Marketplace
To ensure the best ASA webinar experience, be sure to download the Zoom app on your device before the webinar begins.
Continuing Education (CE) Information
This webinar will award 2.0 CE hours.
If you are a designated member of the American Society of Appraisers, CE credit will automatically be entered into your record ONLY if you participate in the live webinar. Please allow approximately 2 weeks post-webinar for ASA to notify participants via email regarding a certificate of completion.
Richard Ellsworth, ASA, IA
Rick Ellsworth is MTS Education Chairman and currently an instructor for the Principles of Valuation course, ME 204. Rick is designated as an Accredited Senior Appraiser (ASA) in the Business Valuation, Machinery & Technical Specialties, and Appraisal Review & Management disciplines of ASA. He also holds the Society's specialty designation in Intangible Asset valuation. In addition, Rick is also a licensed Professional Engineer (PE), Chartered Financial Analyst (CFA) and Certified Cost Professional (CCP). He has Masters in Business Administration and Bachelor of Science in Civil Engineering degrees from Lehigh University.
Upon completion of this webinar, attendees will be able to:
1) Introduce the functionality of the HP 12C calculator and Excel spreadsheet.
2) Recognize situations where financial functions of the calculator and spreadsheet can be used to solve financial problems.
3) Examine various methods for solving present value, future value and annuity problems.
4) Demonstrate the applicability for leasing problems.
2) HP 12C Financial Calculator
3) Present Value
4) Future Value
5) Present Value of an Annuity
6) Solving Lease Transaction Financial Problems