Scheduled Dates: 04 – 15 Mar 2024 | 03 – 14 Jun 2024 | 02 – 13 Sep 2024 | 02 – 13 Dec 2024

Duration: 2 Weeks

Preamble

This course introduces the student to Computerized Financial Management Applications used by Managers and Supervisors in the daily operational decision-making process. Students will apply their Financial Accounting knowledge by learning how to use Computerized Accounting systems to generate Financial data. The student will also learn how to import Financial data from a Computerized Accounting System into a spreadsheet software program to facilitate the analysis of Financial data. Students will be introduced to Trend Analysis,Financial Statement Ratio Analysis and the preparation of Budget Forecasts utilizing the spreadsheet software capabilities.

Target Group

This course provides training for computerized accounting specialists, who use their skills to perform a variety of accounting applications aided by computer technology.

Course Outline

• Basic financial concepts (Manual Vs Computerized)
• Systems set up  e.g. IFMIS
• Computerized environments: general, payroll, sales, receivables, payables, purchases, and financial statement analysis.
• Guiding factors for selecting FMIS
• Attributes of a well designed FMIS
• Requirements for introduction of FMIS
• Why FMIS fail/Preconditions
• Modules in a typical FMIS (Core/non-core modules)
• Requirements for introduction of FMIS
• Software to record financial information – Spreadsheet, Dbases, acct prog.
• Advantages & disadvantages
• Transactions - sales; purchases, cash transactions; income; expenditure etc
• Abstracting information from computerized accounting systems.
• Type of information e.g. expenses; income; assets; liabilities
• Formats: view; print; export data, eg to spreadsheet, PowerPoint, Word; save (native, comma separated variable (csv), hypertext mark-up language (html))
• Analyzing financial information from software applications
• Present & communicate financial information for decision making
• Interested parties/Consumers of financial information
• Overview of Finance and Computer applications
• MS EXCEL Environment, basic functions
• Analyzing Cash Flows Using Excel Tables and Pivot Tables
• Time value of money in Excel
• Analyzing Financial Statements: Profit. liquidity, activity & lev. ratios
• Calculating the Effect of Interest Rates on Loan Repayment
• Asset Valuation Models: CAPM Model, Analyzing Bond Investments
• Financial simulations
• Considering financial alternatives under various assumptions
• Computer application in financial planning and strategies
• Portfolio Risk and Return: Markowitz Theory: Risk and Return
• Financial modeling

REGISTRATION

To register, kindly fill the Seminar Registration Form and send it to us through:
Email:This email address is being protected from spambots. You need JavaScript enabled to view it. , This email address is being protected from spambots. You need JavaScript enabled to view it.

 TERMS AND CONDITIONS OF PAYMENT

1. Fees Payment - All fees are payable strictly in advance 2 working days before the course starting date.
2. Cancellation Fee - Cancelletion of any participant 5 working days before the start day of a course will incur a 20% cancellation fee.
   We regret that no cancellations will be accepted within 2 working days of a course, but substitutions may be made.