I'm coding an investment calculator in Microsoft Visual Studio 2003.
I need to show an initial investment of 200, with an expected annual rate of 8%, for six years, on the form.

How do I calculate on my asp page so that the form will generate the following calculation:

Year 1 $216
Year 2 $233.28
Year 3 $251.9424
Year 4 $272.097792
Year 5 $293.86561536
Year 6 $317.3748645888

Thanks so much. My email is activexcode@hotmail.com.

dim strYearAmt,i,iniAmt,yrAmt,arrAmt
iniAmt=200
yrAmt=iniAmt
for i=1 to 6
  yrAmt=round((((yrAmt * 8)/100)+yrAmt),i)
  strYearAmt=strYearAmt & yrAmt & ","
next

arrAmt=split(strYearAmt,",")

'generate the form

strFORM="<form name='frm1' action='mypage.asp' method='post'>"
for j=0 to ubound(arrAmt)-1
  strFORM=strFORM & "<input type='text' name='txtYr' value='" & arrAmt(j) & "'>Year" & j+1 & "<br>"
next

response.write strFORM

I just displayed the values in 6 text boxes for 6 years.

------------
Rajani

Sorry. I should've been clearer. I created an investment calculator in asp, designed to post as a form on the web. When it posts to the web, the user should be able to:

1)Put in ANY amount in the initial investment box (say, 200 as an example)

2)Put in ANY expected annual rate of return (say, 8% as an example)

3)Put in ANY number of years (say, 6 as an example)

Once they press the CALCULATE the FUTURE VALUE button, they should see a two-column table, underneath the form, which shows a running total:

Year 1 $216
Year 2 $233.28
Year 3 $251.9424
Year 4 $272.097792
Year 5 $293.86561536
Year 6 $317.3748645888

Here's my original code. It seems okay, except I can't get it to calculate from Year 1 on, as described above. And I'm having trouble creating the tw-column table. How do I incorporate your calcs into my current code? Please correct my syntax where necessary. Thanks for your help! :-}
__________________________________________________ ____
<%

DIM counter, initialinvestment, annualrateofreturn, numberofyears, investmentvalue

initialinvestment = request.form ("initial investment")
response.write ("Initial investment is:" & initialinvestment & "<br/>")

annualrateofreturn = request.form ("annual rate of return")
response.write ("Annual rate of return is:" & annualrateofreturn & "<br/>")
numberofyears = request.form ("number of years")
response.write ("Number of years:" & numberofyears & "<br/>")

investmentvalue = initialinvestment*(1 + annualrateofreturn)

for counter = 1 to numberofyears
    response.write(counter&" " & "<br/>")
    investmentvalue = initialinvestment*(1 + annualrateofreturn)
    response.write (investmentvalue&" " &"<br/>")
next

%>
    <form method = "post" action= "InvestmentCalc.asp">
    <h3>Investment Calculator</h3>
    <b>Initial Investment:</b
    <input type= "text" name= "initial investment" value='<%= initialinvestment%>'/><br/>

    <b>Expected Annual Rate of Return %:</b>
    <input type="text" name="annual rate of return" size = "10" maxlength = "10" value="<%= annualrateofreturn%>"/><br/>

    <b>Number of Years:</b>
    <input type="text" name="number of years" size = "3" maxlength = "3" value="<% =numberofyears%>"/></p>

<input type="submit" value="Calculate the Future Value"/></p>

  </form>

</body>

</html>

Hi Activexcode,

Rajani has given the you the entire "working" code. There shouldn't much of diffucilty in incorporating that in your code. hmmm!

You got to comment this line and add the following line in blue next to the commented lines. Also replace your FOR...NEXT loop code with this one. The lines in GREEN above are the culprits in your code.

Hope that explains.

Also I am not sure why /> has been used in all the places where TAGs are used. Is that ASP.Net code, where the controls need to be closed with "/>"? I haven't seen that in use for classic ASP.

Cheers!

_________________________
- Vijay G
Strive for Perfection

Yes. Asp.net.

I would suggest you better submit that on an ASP.NET forum here in this site. This is a Classic ASP forum.

_________________________
- Vijay G
Strive for Perfection