I want to make the following computation in the example cells below;
Highlight the three cells where I entered my formula; Drag down until
300,000 equals zero (or near zero).

a1=300,000-(49*150*1.05^0)
a2=a2-(49*150*1.05^1)
a3=a2-(49*150*1.05^2)

The problem i am having is showing a series of exponential increases. I
need 1.05 (which is 5%) to increase each year. Please advise. Sirsoto