filmov
tv
Topic 3 DQ 1: Creating Financial Formulas
Показать описание
Instructions: Open the tab labeled "Financial" and complete the tasks indicated there. Start by entering your name where indicated. Pay attention to the legend and note that the sheet is self-checking.
Excel Skills Learned
Upon completing the sheet, you should have an understanding of:
1. Entering more complicated future value formulas.
2. Reusing a formula for repeated calculations
Math Skills Learned
1. Computing future value of an investment under various schemes: single investment with simple interest, single investment with compounded interest, and periodic investments with compounded interest.
2. Computing total invested and interest earned.
Excel Skills Learned
Upon completing the sheet, you should have an understanding of:
1. Entering more complicated future value formulas.
2. Reusing a formula for repeated calculations
Math Skills Learned
1. Computing future value of an investment under various schemes: single investment with simple interest, single investment with compounded interest, and periodic investments with compounded interest.
2. Computing total invested and interest earned.
0:14:27
0:12:12
0:01:01
0:14:01
0:02:13
0:14:43
0:02:48
0:07:31
0:12:32
0:05:08
0:05:24
0:12:40
0:02:02
0:03:51
0:10:13
0:00:11
0:10:53
0:01:48
0:21:09
0:09:46
0:05:05
0:12:45
0:07:45
0:05:56