Business Mathematics and Excel (5 cr)

Evaluation scale

H-5

Content scheduling

Course Topics:
1. Applying Excel in Financial Mathematics Calculations
1.1. Functions, graphs, goal-seeking methods, and matrices.
2. Percentage-Based Financial Applications
2.1. Value-added tax (VAT), taxation, inflation, indices, and profit margins.
3. Fundamentals of Interest Calculations
3.1. Review of interest rate calculations and their significance in financial planning.
4. Loan Calculations
4.1.Amortization schedules and the computation of the effective annual interest rate.
5. Investment Evaluation Methods
5.1. Assessing investment opportunities based on financial metrics.
6. Profitability and Cost Optimization
6.1. Identifying cost-efficient solutions and maximizing business profitability.
7. Demand and Supply Functions and Equilibrium Analysis
7.1. Understanding market dynamics and determining equilibrium points.

Objective

After studying the course the students understand the time value of money and is able to compare different investment alternatives. The student can estimate the profitability of an investment. He/she can optimize costs or profitability with Excel. He/she is able to use Excel in various problems of financial mathematics.

Content

Revision of Excel basics
Processing large datasets
Applying Excel for financial mathematics
Value added tax, inflation, indexes
Financing calculations
Investments
Matrix calculation
Profitability and cost optimization

Materials

Its- Learning Platform material
Material to be distributed in class

Supporting material:

Bronson, G., Bronson, R., & Kieff, M. (2021). Mathematics for Business (7th ed.). Mercury Learning & Information. (e-book finna)
Ummer, E. K. (2011). Basic mathematics for economics, business, and finance. Routledge. https://doi.org/10.4324/9780203817322 (e-book finna)
Business Math for Dummies by Mary Jane Sterling and Benjamin Schultz (can be found as a e-book in the library of Turku UAS)
Own information search

Teaching methods

• Practical hands-on exercises using Excel.
• Real-world financial case studies.
• Interactive demonstrations and guided tutorials.

Exam schedules

Final Exam Week 47
Retest 1 Week 50
Retest 2 in January, will be informed later

Student workload

Supporting videos 20 h
Contact Lessons 20 h
Excercises 35 h
Independent working 55 h
Final Exam 4 h

Evaluation methods and criteria

Exercises Approved/Failed
A Failed Exercise/not returned Exercise equals one minus point

Final Exam 50 points


Bonus of Attendance

Attendance time Bonuspoints

10 times gives 5 bonuspoints
9 times gives 4 bonuspoints
8 times gives 3 bonuspoints
7 times gives 2 bonuspoints
6 times gives 1 bonuspoints
5 times gives 0 points
4 times gives -1 points
3 times gives -2 spoints
2 times gives-3 points
1 times gives -4 points
0 times gives - 5 points

The use of artificial intelligence varies depending on the learning tasks. Instructions on its use are provided in the course, task-specific.

Failed (0)

Less than 50 % of points ( < 25 points)

Assessment criteria, satisfactory (1-2)

The student has received the required number of points for the grade
Grade 1 60%
Grad 2, 70 %

The final exam score can be increased by active participation in class.

Assessment criteria, good (3-4)

The student has received the required number of points for the grade
Grade 3, 70 %
Grade 4, 80 %

The final exam score can be increased by active participation in class.

Assessment criteria, excellent (5)

The student has shown activity, received the required number of points for the grade; at least 90 % of total points (>= 45 points)
The final exam score can be increased by active participation in class.