Docstoc

Cash Gap

Document Sample
Cash Gap Powered By Docstoc
					Cash Gap Days Worksheet
Annual Sales Gross Margin

Place Mouse here for instructions
$

Annual 25,000,000 11%

Daily $ 68,493

Cost of goods(Material, labor, subcontractors)

$

22,250,000

$

60,959

Month Ending Balance Inventory Cost in Excess Accounts Receivable Billings in excess Accounts Payable CASH GAP DAYS Average Cost per day Cash Gap Days Amount of Money that needs to be borrowed $ $ $ $ $ $

Month One 500,000 1,000,000 3,500,000 1,000,000 2,300,000

Gap Days 8 16 51 $

Month Two 650,000

Gap Days 11 20 55 $ $ $

Month Three 850,000 1,750,000 3,900,000 250,000 1,900,000

Gap Days 14 29 57 $ $ $

Three Month Average 666,667 1,316,667 3,716,667 583,333 2,100,000 11 22 54 (9) (34) 44 $ 60,959 43.83 2,672,000

$ 1,200,000 $ 3,750,000 500,000

(15) $

(7) $ (34) $ 43

(4) $ (31) $ 65

(38) $ 2,100,000 23

23 1,425,000

43 $ 2,642,500 $

65 3,948,500 $

Borrowing rate Borrowing Cost per day

8.5%

8.5%

8.5%

8.5%

$

332

$

615

$

920

$

622

www.cfo-togo.com call for password if you need it

Before Changing days you must run a macro; Hold Ctrl + p, col. E = F, if you did it right

Month Ending Balance Inventory Cost in Excess Accounts Receivable Billings in excess Accounts Payable CASH GAP DAYS

Average Thousands $ 667 $ $ $ $ 1,317 3,717 583 2,100

+ + + -

11 22 54 9 34 44

11 22 54 9 34 44

www.cfo-togo.com call for password if you need it

There are some rounding issue involved with this spreadsheet none are material, it has to do with the way the days round.

Average Cost per day Cash Gap Days

$

60,959 44

Amount of Money that needs to be borrowed Borrowing rate Revised Borrowing cost per day
Actual Borrowing cost per day Annualized Savings

$ 2,672,000

$ $ $

8.5% 622 622 -


				
DOCUMENT INFO
Shared By:
Categories:
Stats:
views:303
posted:1/3/2008
language:English
pages:4
Jeff Sperry Jeff Sperry
About