Business Mathematics and ExcelLaajuus (5 cr)
Course unit code: TE00CK13
General information
- Credits
- 5 cr
- Teaching language
- Finnish
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
courseUnit.toTranslate
boolean
courseUnit.languageValidated
boolean
courseUnit.toContentValidation
boolean
courseUnit.contentValidated
boolean
courseUnit.learningUnitId
22308
courseUnit.code
TE00CK13
courseUnit.name
Business Mathematics and Excel
courseUnit.type
COURSE_UNIT
courseUnit.state
ACTIVE
Credits
5
courseUnit.minCredits
5
courseUnit.maxCredits
5
courseUnit.levelId
22308
courseUnit.learningUnitGroupCode
22308
courseUnit.educationPay
boolean
courseUnit.minOptionalityCredits
5
courseUnit.maxOptionalityCredits
5
courseUnit.modifiedBy
22288
courseUnit.organization
peppi
courseUnit.learningUnitId
22308
courseUnit.thesisBelongs
boolean