Home |
Search |
Today's Posts |
#1
|
|||
|
|||
compound interest formula
hello,
Ok, I have a material cost in cell A1 - todays date in A2, the date the material will be delivered in A3, and an inflation value in A4 (%per annum). I need a formula that will work out what the material will cost when the material is delivered. eg. costs £100 today at a rate of 5%per annum it will cost £105 next year and £110.25 in two years. All input values are in seperate cells and can vary. Also it will have to cope with fractions of a year. Any ideas? Ciara |
#2
|
|||
|
|||
Try this: Set A2 and A3 to "Date" format. A5 = A1*(1+A4)^((VALUE(A3)-VALUE(A2))/365) Hope it helps. Ciara Wrote: hello, Ok, I have a material cost in cell A1 - todays date in A2, the date the material will be delivered in A3, and an inflation value in A4 (%per annum). I need a formula that will work out what the material will cost when the material is delivered. eg. costs £100 today at a rate of 5%per annum it will cost £105 next year and £110.25 in two years. All input values are in seperate cells and can vary. Also it will have to cope with fractions of a year. Any ideas? Ciara -- Morrigan ------------------------------------------------------------------------ Morrigan's Profile: http://www.excelforum.com/member.php...fo&userid=7094 View this thread: http://www.excelforum.com/showthread...hreadid=377082 |
#3
|
|||
|
|||
say I want to do it between jan '04 and jan'05 - this counts as 1 year for me
but has 366 day - how can i account for a leap year? "Morrigan" wrote: Try this: Set A2 and A3 to "Date" format. A5 = A1*(1+A4)^((VALUE(A3)-VALUE(A2))/365) Hope it helps. Ciara Wrote: hello, Ok, I have a material cost in cell A1 - todays date in A2, the date the material will be delivered in A3, and an inflation value in A4 (%per annum). I need a formula that will work out what the material will cost when the material is delivered. eg. costs £100 today at a rate of 5%per annum it will cost £105 next year and £110.25 in two years. All input values are in seperate cells and can vary. Also it will have to cope with fractions of a year. Any ideas? Ciara -- Morrigan ------------------------------------------------------------------------ Morrigan's Profile: http://www.excelforum.com/member.php...fo&userid=7094 View this thread: http://www.excelforum.com/showthread...hreadid=377082 |
#4
|
|||
|
|||
Try the YearFrac worksheet function. You need to enable the analysis toolpak
Mangesh "Ciara" wrote in message ... say I want to do it between jan '04 and jan'05 - this counts as 1 year for me but has 366 day - how can i account for a leap year? "Morrigan" wrote: Try this: Set A2 and A3 to "Date" format. A5 = A1*(1+A4)^((VALUE(A3)-VALUE(A2))/365) Hope it helps. Ciara Wrote: hello, Ok, I have a material cost in cell A1 - todays date in A2, the date the material will be delivered in A3, and an inflation value in A4 (%per annum). I need a formula that will work out what the material will cost when the material is delivered. eg. costs £100 today at a rate of 5%per annum it will cost £105 next year and £110.25 in two years. All input values are in seperate cells and can vary. Also it will have to cope with fractions of a year. Any ideas? Ciara -- Morrigan ------------------------------------------------------------------------ Morrigan's Profile: http://www.excelforum.com/member.php...fo&userid=7094 View this thread: http://www.excelforum.com/showthread...hreadid=377082 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
a formula to find total compound amount after given number of yea. | Excel Worksheet Functions | |||
Interest formula on Personal Line | Excel Discussion (Misc queries) | |||
Cell shows formula and not the result of the formula. | Excel Worksheet Functions | |||
Are financial functions calculated based on compound interest? | Excel Worksheet Functions | |||
compound interest | Excel Worksheet Functions |