Copy of Lab5_Ex3

# Copy of Lab5_Ex3 - The investment parameters - interest...

This preview shows pages 1–4. Sign up to view the full content.

Comments - Investment Growth Model This example starts with "raw data" in the Parameters worksheet, consisting of an amount of money (initial capital) and the investment and maturity dates. The other data in the Parameters worksheet include the interest rate (per annum), the period after which interest is paid (as a fraction of a year) and the number of years of the investment (to be calculated from the investment and maturity dates). Apart from illustrating the use of various functions that operate on dates this model also further demonstrates recurrence relations. The CapitalGrowth worksheet calculates the amount of the investment as it is compounded by the addition of interest for each period.

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: The investment parameters - interest rate, investment period, and maturity date can be easily changed to see the effect on the final value of the investment. Initial Capital: \$30,000 Investment Date: 1/31/1999 Maturity Date: 1/31/2009 Interest Rate: 8.00% (per annum) Interest Period: 0.5 (years) Term: 10 (years) Number of Periods: 20 Compound Capital Growth Period Capital \$30,000.00 1 \$31,200.00 2 \$32,448.00 3 \$33,745.92 4 \$35,095.76 5 \$36,499.59 6 \$37,959.57 7 \$39,477.95 8 \$41,057.07 9 \$42,699.35 10 \$44,407.33 11 \$46,183.62 12 \$48,030.97 13 \$49,952.21 14 \$51,950.29 15 \$54,028.31 16 \$56,189.44 17 \$58,437.01 18 \$60,774.50 19 \$63,205.48 20 \$65,733.69...
View Full Document

## This note was uploaded on 12/15/2010 for the course CSE CSE 1520 taught by Professor Paul during the Spring '09 term at York University.

### Page1 / 4

Copy of Lab5_Ex3 - The investment parameters - interest...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online