**Question description:**

*This user has given permission to use the problem statement for this blog.*

I need 2 formulas:
1. salvage value? where initial cost item is in column C, effective life of 10 yrs is in column D, diminishing value 20% is in column E, Salvage Value ? is in column F.
2. then need formula for WDV to be located in column G.

Solved by V. D. in 40 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

Excelchat Expert
23/10/2017 - 04:20

Hi there, Thanks for choosing Got It Pro-Excel! How may I help you today?

Excelchat Expert
23/10/2017 - 04:22

You need Salvage Value correct?

User
23/10/2017 - 04:22

Yes . I just need the correct inputs for excel.

Excelchat Expert
23/10/2017 - 04:22

Sure

Excelchat Expert
23/10/2017 - 04:23

As per my understanding, the formula for Salvage value is given as:

User
23/10/2017 - 04:23

Would you like me to plug in some values on the sheet opposite

Excelchat Expert
23/10/2017 - 04:24

Salvage value =InitialCost*[(1-%diminishing)^years]

Excelchat Expert
23/10/2017 - 04:24

I can put in the formula

Excelchat Expert
23/10/2017 - 04:24

and then you can play with the values

User
23/10/2017 - 04:24

This will be part A.

User
23/10/2017 - 04:24

Then l will need part B which is the WDV

Excelchat Expert
23/10/2017 - 04:25

The formula for Salvage value is in Column F

Excelchat Expert
23/10/2017 - 04:25

=C2*((1-E2)^D2)

Excelchat Expert
23/10/2017 - 04:25

Can you give me the full form of WDV?

Excelchat Expert
23/10/2017 - 04:26

as in what does WDV stand for?

Excelchat Expert
23/10/2017 - 04:28

Does it stand for Written Down Value?

Excelchat Expert
23/10/2017 - 04:29

Salvage value =InitialCost*[(1-%diminishing)^years]

User
23/10/2017 - 04:29

This is what l am after

Excelchat Expert
23/10/2017 - 04:30

I have found a formula for WDV

Excelchat Expert
23/10/2017 - 04:30

but it needs 2 more inputs

User
23/10/2017 - 04:30

hmm..It shouldnt

Excelchat Expert
23/10/2017 - 04:30

Date of purchase and Calculation date

User
23/10/2017 - 04:31

assume 30.06. for each financial period

User
23/10/2017 - 04:31

annual

User
23/10/2017 - 04:34

ahhh...can we assume for the exercise the wdv is after 5 years

Excelchat Expert
23/10/2017 - 04:35

Ok Hold on

Excelchat Expert
23/10/2017 - 04:36

So I have entered the formula

User
23/10/2017 - 04:36

wow

Excelchat Expert
23/10/2017 - 04:36

That takes in the 2 dates mentioned

User
23/10/2017 - 04:36

thats a big formula

Excelchat Expert
23/10/2017 - 04:36

you can change those dates

Excelchat Expert
23/10/2017 - 04:36

if you like to consider the period you want

Excelchat Expert
23/10/2017 - 04:36

I will explain the formula

Excelchat Expert
23/10/2017 - 04:36

=C5*((1-E5)^((DATEDIF(I5, H5, "D")+1)/365))

Excelchat Expert
23/10/2017 - 04:37

The datedif part calculates the number of days between 2 dates

Excelchat Expert
23/10/2017 - 04:37

The formula is as follows:

Excelchat Expert
23/10/2017 - 04:37

WDV as on Date = Cost price x (1- Dep Rate%) ^ (Date of WDV Calculation - Date of Purchase + 1)/365

Excelchat Expert
23/10/2017 - 04:38

So you can put in the dates you want in the 2 columns after Col G

User
23/10/2017 - 04:39

Perfect

User
23/10/2017 - 04:39

That helps me alot

User
23/10/2017 - 04:39

much appreciated

Excelchat Expert
23/10/2017 - 04:39

Great

Excelchat Expert
23/10/2017 - 04:40

Do you need any clarification on any formula

Excelchat Expert
23/10/2017 - 04:40

?

User
23/10/2017 - 04:40

so can l copy and paste this formula

Excelchat Expert
23/10/2017 - 04:40

Copy paste where?

User
23/10/2017 - 04:43

1 more minute and then we are all good

Excelchat Expert
23/10/2017 - 04:43

no problem

User
23/10/2017 - 04:46

I cant find the up arrow symbol

User
23/10/2017 - 04:46

Just before D5

Excelchat Expert
23/10/2017 - 04:46

It will be above the number 6

Excelchat Expert
23/10/2017 - 04:46

press shift + 6

User
23/10/2017 - 04:46

ahh yes

User
23/10/2017 - 04:46

thankyou

User
23/10/2017 - 04:46

I feel like a goose

User
23/10/2017 - 04:47

So will this formula stay on the page for a few minutes

Excelchat Expert
23/10/2017 - 04:47

i think so

Excelchat Expert
23/10/2017 - 04:47

but if you maintain the columns as it is

Excelchat Expert
23/10/2017 - 04:47

then you can copy this formula in any sheet

Excelchat Expert
23/10/2017 - 04:47

for salvage value

Excelchat Expert
23/10/2017 - 04:48

=C5*((1-E5)^D5)

Excelchat Expert
23/10/2017 - 04:48

and for WDV

Excelchat Expert
23/10/2017 - 04:48

=C5*((1-E5)^((DATEDIF(I5, H5, "D")+1)/365))

User
23/10/2017 - 04:56

It works

User
23/10/2017 - 04:56

Cool

Excelchat Expert
23/10/2017 - 04:57

great

User
23/10/2017 - 04:57

Whats your name

Excelchat Expert
23/10/2017 - 04:57

Jeet

User
23/10/2017 - 04:57

Thanks Jeet

Excelchat Expert
23/10/2017 - 04:57

No problem

Excelchat Expert
23/10/2017 - 04:57

Thanks for using Got It Pro-Excel! Have a good day

User
23/10/2017 - 04:57

Hey l might call upon you again

User
23/10/2017 - 04:57

How do l get in touch again

Excelchat Expert
23/10/2017 - 04:58

You post another question in the same way

User
23/10/2017 - 04:58

Very Cool

Excelchat Expert
23/10/2017 - 04:58

and one of the experts will get in touch

User
23/10/2017 - 04:58

Thankyou

User
23/10/2017 - 04:58

Have a nice day

Excelchat Expert
23/10/2017 - 04:58

My pleasure

**This is the output file from the real Excelchat help session:**

*This is an example of the expert help you can get. It contains no private user information.*