Module Details

Module Code: MRKT7023
Title: Finance and IT for Marketers
Long Title: Finance and IT for Marketers
NFQ Level: Intermediate
Valid From: Semester 2 - 2020/21 ( January 2021 )
Duration: 1 Semester
Credits: 5
Field of Study: 3420 - Marketing & Advertising
Module Delivered in: 1 programme(s)
Module Description: Excel based application of financial concepts (e.g. budgeting, financial performance ratios and investment appraisal) to practically evaluate the financial planning process.
 
Learning Outcomes
On successful completion of this module the learner will be able to:
# Learning Outcome Description
LO1 Calculate projections and evaluate the outcomes using the various investment appraisal methods
LO2 Assemble figures to produce an accurate cashflow forecast for an organisation using spreadsheets
LO3 Calculate the costings, break even analysis, return on marketing investment and mark up using spreadsheets
LO4 Evaluate the government agencies which promote industrial development and provide assistance to start up and established companies
LO5 Appraise the forms of finance for a company given its financial requirements including the utilisation of KPIs
Dependencies
Module Recommendations

This is prior learning (or a practical skill) that is strongly recommended before enrolment in this module. You may enrol in this module if you have not acquired the recommended learning but you will have considerable difficulty in passing (i.e. achieving the learning outcomes of) the module. While the prior learning is expressed as named MTU module(s) it also allows for learning (in another module or modules) which is equivalent to the learning specified in the named module(s).
Incompatible Modules
These are modules which have learning outcomes that are too similar to the learning outcomes of this module. You may not earn additional credit for the same learning and therefore you may not enrol in this module if you have successfully completed any modules in the incompatible list.
No incompatible modules listed
Co-requisite Modules
No Co-requisite modules listed
Requirements

This is prior learning (or a practical skill) that is mandatory before enrolment in this module is allowed. You may not enrol on this module if you have not acquired the learning specified in this section.
No requirements listed
 
Indicative Content
Investment Appraisal
Appraisal of capital expenditure - payback; average rate of return; net present value; internal rate of return. All calculations performed using a spreadsheet package.
Budgeting and Financial Forecasting
The role of budgeting and forecasting; preparation of cashflow statements and projected final accounts using if statements in a spreadsheet package.
Sources of Finance
Types of finance - short, medium and long term; evaluation of cost of finance; state aid - LEO and Enterprise Ireland supports.
Interpretation of Accounts
Customer lifetime value; CLV calculation; ratio analysis; break even; mark up; return on marketing investment. All calculations performed using a spreadsheet package and comparisons made with historical figures and/or future projections.
Module Content & Assessment
Assessment Breakdown%
Coursework100.00%

Assessments

Coursework
Assessment Type Written Report % of Total Mark 50
Timing Week 7 Learning Outcomes 3,4,5
Assessment Description
Prepare a financial analysis and presentation on your chosen company in groups
Assessment Type Practical/Skills Evaluation % of Total Mark 50
Timing Week 13 Learning Outcomes 1,2,3
Assessment Description
Lab based evaluation using Microsoft Excel that requires the student to prepare financial accounts and projections, interpret results, and apply theoretical knowledge
No End of Module Formal Examination
Reassessment Requirement
Coursework Only
This module is reassessed solely on the basis of re-submitted coursework. There is no repeat written examination.

The University reserves the right to alter the nature and timings of assessment

 

Module Workload

Workload: Full Time
Workload Type Contact Type Workload Description Frequency Average Weekly Learner Workload Hours
Lecture Contact Class based learning Every Week 2.00 2
Lab Contact Lab based instruction Every Week 1.00 1
Independent & Directed Learning (Non-contact) Non Contact Independent learning Every Week 4.00 4
Total Hours 7.00
Total Weekly Learner Workload 7.00
Total Weekly Contact Hours 3.00
Workload: Part Time
Workload Type Contact Type Workload Description Frequency Average Weekly Learner Workload Hours
Lecture Contact Class based learning Every Week 1.00 1
Lab Contact Lab based instruction Every Week 1.00 1
Independent & Directed Learning (Non-contact) Non Contact Independent Learning Every Week 5.00 5
Total Hours 7.00
Total Weekly Learner Workload 7.00
Total Weekly Contact Hours 2.00
 
Module Resources
Recommended Book Resources
  • Peter Atrill. (2018), Managment Accounting for Decision Makers, 9. Pearson UK, E-Book - Online Access, [ISBN: 9781292204604].
  • Alan Dillon. (2014), Step by Step Spreadsheets, 3. Gill & Macmillian, [ISBN: 9780717160440].
  • Eugene F. Brigham, Michael C. Ehrhardt. (2016), Financial Management: Theory & Practice, EMEA Ed. Cengage Learning, [ISBN: 9781473729605].
Supplementary Book Resources
  • Atrill, P. & McLaney, E.. (2016), Accounting and Finance for Non Specialists, 10. Pearson, E Book - Online Access, [ISBN: 9781292135601].
This module does not have any article/paper resources
Other Resources
 
Module Delivered in
Programme Code Programme Semester Delivery
CR_BMRKT_8 Bachelor of Business (Honours) in Marketing 4 Mandatory