formula for forward cover

[JV0710]

Book1
	A	B	C	D	E	F	G	H	I
1	Sorryaboutthepreviouspostfolks,IjusttriedtheHTMLmakerforthefirsttime...
2	Iwouldappreciateanyhelponthisquery
3
4	Seebelow:
5
6		Example
7		A	B	C	D	E	F	G	H
8	1		December	January	February	March	April	May	June
9	2	MonthlyPayment		200	350	300	300	350	400
10	3
11	4	Moneyavailableatendofmonth	1000
12	5
13	6	CoverinMonths	3.5
14
15		Question:
16		InB6-Ineedaformulatoworkoutthatthe"moneyavailable"willlastonly3.5Months??
17			(January,February,MarchandhalfofApril)
18
19	Thanks
20
21	Joe
Sheet1

 

[JV0710]

[No message]

 

[JV0710]

[No message]

 

[njimack]

Isn't this a duplicate of the post I answered yesterday?

 

[JV0710]

Hi Neil - yes it is, My apologies . . . My Assistant was at my desk and "Re-sent".

I have posted comments on your answer this morning, on the previous post - Once again I apologise