Stocking up on inventory in February, April, June, and September. The annual cash budget indicates that my MONTHLY NET CASH for the year will be the following:

JAN$5,000.00; FEB-$30,000.00; MAR$20,000.00; APRIL -$35,000.00; MAY$25,000.00; JUNE-$10,000.00; JULY$25,000.00; AUG$25,000.00; SEPT-$30,000.00; OCT$15,000.00; NOV$15,000.00; DEC$25,000.00

1. How do I use an Excel spreadsheet to show a cash flow summary and external financing summary with beginning year cash balance of $50,000.00 and a minimum cash balance desired must be $50,000.00 every month? Does the company need outside financing? What is the minimum line of credit to request from a lender? And am I a good candidate for a line of credit? Why am I a good candidate for a line of credit?

E g . : A; LUmtSJP Stu Temp'ateiedxted , mew \ sert Draw Page Laywjut meulas Data Renew men HE'p :3 TEH me whatynu wanttn d AD 52:; ' (airbri ~11 . A' A' E E E *2 EB '.".'\\apTexY Ganalal [:1 Normal Bed EEIEE EEK i: Egr'm ' 9'? ,0 P315 {mempaim B I Q _ _ .5) A. , : : : ._. Magsfsnm $ % , (33 H Fiix'algqngal thglaeta: Gnnd NELnral |n:EII Dads Farina \\' mesh are? gran: Cllpbuard r. Funt 5 Alignment Number Styles new; Edmng a. K34 ' K J I; v A I B I c I D I E I F I a I H I \\ I J | K | L I M I N I o I P I Q I F - JANUARY FEBRUARY MARCH APRIL Mmr JUNE JULY AUGUSI SEPTEMBER DCIDBER NOVEMBER DECEMBER GIVEN: MONTHLY NET CASH GAIN OR LOSS 5 5,000 5 [30,0003 5 20,000 5 [35,000) 5 25,000 5 [10,000) 5 25,000 5 25,000 5 [30,000) 5 15,000 5 15,000 5 25,000 CASH FLOW SUMMARY , Cash balance at 50.311 of month . Nel cash gam (1055) duting month , Cash bal, at end of month (befme nzndng) , hnimum msh balance deied s, Sulplus ash (019mm ash (Line 3 7 Line 4) EXTERNAL FINANCING SUMMARY 6. External nancing balance , 51211 of menth New nancing qu'd (negative of Line 5) (if decil!) Financing repayments (if smp1nsr) 7. E, 9, Ext Enandng balance end of mmlth 10.Cash bal. 31 end of 1110 JAN UARV DECEM BER glg''EIWE'gW'W RWI'g WW5 IEIIQHa FFIWSHEWI\" \"W\"? L Enter