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.