Purchase an asset every 5 years

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

How do I show a purchase every 5 years after the initial purchase of an
asset. For instance, I have an individual, age 40, who wants to buy an auto
at the age of 42 and then buy one every 5 years. I can get the first year of
purchase but not the subsequent purchase every 5 years to build a table.
i.e.
Data field:
Current age of person 40
Cost of auto $20,000
Start date from now (in years) 2
Replacement of auto (in years) 5

Table: Purchase
Age of auto
40 $0
41 $0
42 $20,000
43 $0
44 $0
45
initial formula: =IF(age=$current age$+$start date from now$,use cost,0)

I appreciate the help.
Thank you
 
With your first four parameters in cells B2 to B5, and your table data
starting in A10, put this formula in B10:

=IF(MOD(A10-B$2-B$4,B$5)=0,B$3,0)

and copy this down. A10 is the Age (variable), B2 is Current Age, B4
is Start Date, B3 is Auto Cost, B5 is Replacement Frequency.

Hope this helps.

Pete
 
Pete
It works great! Thank you, Cheers

Pete_UK said:
With your first four parameters in cells B2 to B5, and your table data
starting in A10, put this formula in B10:

=IF(MOD(A10-B$2-B$4,B$5)=0,B$3,0)

and copy this down. A10 is the Age (variable), B2 is Current Age, B4
is Start Date, B3 is Auto Cost, B5 is Replacement Frequency.

Hope this helps.

Pete
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hello happy new year to all, Text box input for year of purchase 0
Some kind of vlookup required? 4
date of birth age formula 8
Calculate age with an end date 3
Help with Formula 2
Date Formula 85 factor 7
need help finding most common number and so on 2
Calculate an "Age Group" from age in years 10

Back
Top