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

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

View Full Document Right Arrow Icon
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
Background image of page 1

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

View Full DocumentRight Arrow Icon
Background image of page 2
Background image of page 3

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

View Full DocumentRight Arrow Icon
Background image of page 4
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

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 Right Arrow Icon
Ask a homework question - tutors are online