This computer-based course provides students with the skills to conduct financial analysis using Microsoft Excel. After a review of financial statements, students create spreadsheet models to analyze income statements, balance sheets and cash budgets. Time-value of money calculations, ratio analysis, financial forecasting and break-even analysis are automated through the design and development of spreadsheet models.
Applicants must be a graduate of a college or university diploma or degree program or possess equivalent work-related experience and training.
What You Need
What You Need
Most college level courses require textbooks; textbooks are not included in the course fees. It is the student’s responsibility to purchase any required textbooks.
Textbooks are available at the Campus Shop for in class, Contact North, and iLearn/D2L courses. The Campus Shop does not carry most OntarioLearn textbooks. OntarioLearn textbooks can be purchased at www.textnet.ca.
Learning outcomes represent culminating demonstrations of learning and achievement. In addition, learning outcomes are interrelated and cannot be viewed in isolation of one another. As such, they should be viewed as a comprehensive whole. They describe performances that demonstrate that significant integrated learning by graduates of the program has been achieved.
Program Vocational Learning Outcomes
- Interpret and record business transactions, and prepare basic financial statements.
- Integrate knowledge of capital investments, credit planning, and finance into relevant aspects of work.
- Utilize the concepts and business applications of computer information systems.
- Adhere to the concepts of organizational behaviour, and apply decision-making and problem solving techniques in formulating business policy.
- Apply the concepts of human resource management and organizational behaviour to establish and maintain effective working relationships.
- Analyze a marketing situation and develop appropriate advertising recommendations and sales promotion strategies.
- Compare and contrast various pricing strategies and their effects on sales and profits.
- Prepare and deliver a sales presentation.
- Utilize effective oral and written communications in all aspects of work completed.
- Apply effective interpersonal skills.
- Articulate various economic principles and their relationship to business.
- Complete all work according to relevant and accepted business ethics and within the scope of corporate responsibility.