Help. I am brand new to Excel, but I need to quickly come up with a
formula to do the following. In any programming language it would be
a simple do while loop, or equivalent, but I can not find out how to
do it in Excel:

Input a Daily Amount, let's say $150 * or call it DA

Multiply it times 365 for a yearly amount

Input a Number of Years, let's say 5 * or call it Y

Multiply the Yearly Amount times the number of years to get a Total
Yearly Amount or call it YA

Input an inflation Rate, let's say 5%* or call it IR

Input a number of Years, let's say 20 * or call it NY

Take the Total Yearly Amount and multiply it by 100% plus the
inflation rate to get an inflated amount. or in a formula (YA x (100
+ IR))

repeat this last calculation once for each of the 20 years.r
In a typical progamming language this would look like this

Counter =1
do while Counter <= NY
YA = (YA x (100 + IR))
Counter = Counter + 1
enddo

I can not find out how to loop or repeat in Excel.

Thanks for any help
Best regards,

Al
http://www.affordablefloridainsurance.com
http://www.americanbestmortgages.com