Copy of Lab5_Ex3 print parameters in formula and data , print capital growth in formula

# Copy of Lab5_Ex3 print parameters in formula and data , print capital growth in formula

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. The investment parameters - interest rate, investment period, and maturity date can be easily

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: changed to see the effect on the final value of the investment. Lab 5 Exercise 3 Raafia Siddiqui 211098936 Parameters Initial Capital: \$30,000 Investment Dat 1/31/1999 Maturity Date: 1/31/2009 Interest Rate: 8.00% (per annum) Interest Period: 0.5 (years) Term: 10 (years) Number of Peri 20 Lab 5 Exercise 3 Raafia Siddiqui 211098936 Capital Growth (formula view) 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 Lab 5 Exercise 3 Raafia Siddiqui 211098936 Capital Growth (formula view)...
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 print parameters in formula and data , print capital growth in formula

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

View Full Document
Ask a homework question - tutors are online