Calculate Total Revenue including Yearly Price Increases w/MS Acce

[cpfrangi]

If a rate is say...$10 per month per unit; # Units is 100; Yearly Increase=8%
and Term of Contract is 5 Years...how do I put a formula in a query that
gives me the total revenue over the life of the contract. I did this in
Excel and the total revenue comes out to $70,399.21 over the 5-Year period.

I have to figure this out for about 200 properties...all with different
rates, units, percentages, and contract term.

This is the formula I used in Excel to come up with the $70,399.21
C16=Total Yrly Revenue ($10*100*12) D16=% Increase
=(C16*(1+D16)^4)+(C16*(1+D16)^3)+(C16*(1+D16)^2)+(C16*(1+D16)^1)+(C16*(1+D16)^0)

H E L P !!!! Thank you all....

 

[Jeff Boyce]

If Excel gives you an easy way to do this, why are you trying to do it in
Access?

If you have data in Access but need/want to do (easy) financial calculations
on it, consider exporting the data from Access to Excel, which is designed
to do just that kind of thing.

Or am I missing something?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[cpfrangi]

I have a database of customers in private communities. Each community has
different contract terms. I print out a report listing each community's rate
per unit per month, #units in the community, yrly % rate increase, and the
resulting revenue for the year (based on the first year's rate). Now they
want the total revenue through the end of the contract (taking into account
the annual rate increases)... which can sometimes be 15 years. How do you
use excel to print a report in access? Also..some communities have a 5-yr
contract, while some have 10-or 15-yr contracts.