Thread: Assets
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Frances C[_2_] Frances C[_2_] is offline
external usenet poster
 
Posts: 31
Default Assets

I need a formula that can be use for different kind of asset calculations for
example

a 401k that has a value of $10,000.00 and is multiply by interest rate of
2% and I need to subtract $1000.00 for cost to sell (sometimes that cost to
sell is also presented as 10% instead of $1000.00)

I also have a real estate with a value of $200,000.00 to be mutiply by
interest rate of 0% and to subtract a cost to sell of $150,000.00

Another one is a Saving accont a value of $500.00 and is mutiply by interest
rate of 3% with $0.00 cost to sell

I have try some formulas, I really need one that can work with all the
problems.

a1=value b1=interest rate c1=cost to sell d1=where the formula goes
(answer)

Thanks