Business Mathematics and Excel (5op)

Arviointiasteikko

H-5

Sisällön jaksotus

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.

Tavoitteet

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.

Sisältö

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

Oppimateriaalit

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

Opetusmenetelmät

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

Tenttien ajankohdat ja uusintamahdollisuudet

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

Opiskelijan ajankäyttö ja kuormitus

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

Arviointimenetelmät ja arvioinnin perusteet

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.

Hylätty (0)

Less than 50 % of points ( < 25 points)

Arviointikriteerit, tyydyttävä (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.

Arviointikriteerit, hyvä (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.

Arviointikriteerit, kiitettävä (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.