Formulas to calculate cost of Capital

[HowardC]

I need assist to do the following per the attached workbook

1) I need to calculate the cumulative cash flow using the AND function as a logical alternative

2) I have calculated the payback period, but need help to calculate the payback using an alternative method using a nested if function for cell C93:J93


Your assistance will be most appreciated

Regards

Howard

[franciz]

[quote name='HowardC' post='774443' date='10-May-2009 01:03']I need assist to do the following per the attached workbook

1) I need to calculate the cumulative cash flow using the AND function as a logical alternative

2) I have calculated the payback period, but need help to calculate the payback using an alternative method using a nested if function for cell C93:J93


Your assistance will be most appreciated

Regards

Howard[/quote]

It is unclear on what you want to do
would you stated what are the criterias?

[HowardC]

[quote name='franciz' post='774457' date='09-May-2009 19:25']It is unclear on what you want to do
would you stated what are the criterias?[/quote]

With regard to my point 1 , the formula in C93:J93, must produce the same result as in C92:J92, except the AND Function must be used, see Message when you click in cell C93

With regard to my point 2, the formula in C97, must produce the same result as C95, the only difference to the formula, is that the IF function must be used

It would be appreciated if you could kindly assist me

Regards

Howard

[StuartR]

[quote name='HowardC' post='774459' date='09-May-2009 19:59']With regard to my point 1 , the formula in C93:J93, must produce the same result as in C92:J92, except the AND Function must be used, see Message when you click in cell C93

With regard to my point 2, the formula in C97, must produce the same result as C95, the only difference to the formula, is that the IF function must be used[/quote]
What strange requirements! Is this an attempt to get someone to do your homework for you?

[Jezza]

Howard

These are questions based from this book or something similar.

These questions are specifically about financial management and whilst Loungers are happy to answer functional questions about AND statements you can't expect us to be all financial experts.

However, if you were to pose a question without reference to Christopher Buzzard and Mike Ehrhardt's work we maybe able to help you

[HowardC]

[quote name='Jezza' post='774485' date='09-May-2009 23:40']Howard

These are questions based from this book or something similar.

These questions are specifically about financial management and whilst Loungers are happy to answer functional questions about AND statements you can't expect us to be all financial experts.

However, if you were to pose a question without reference to Christopher Buzzard and Mike Ehrhardt's work we maybe able to help you[/quote]


Attached please find amended spreadsheet. I have managed to solve the logical test using the AND function C20:J20 . have used the Index function in cell C24:J24, but would like this changed to an IF Nested Function . It would be appreciated if you could assist

Regards

Howard