Home fx Review View Automate Assignment Calculate Now Insert Draw Page Layout Formulas Data ? A Q Define Name Trace Precedents Date & Lookup & Time Reference Math & More Trig Functions Name Manager Use in Formula Create from Selection Trace Dependents Remove Arrows Show Formulas Checking Window 160' Error Watch Calculation Calculate Sheet Options Insert AutoSum Recently Financial Logical Text Function Used Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off? Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. D28 fx A B 2 3 Monthly Interest Rate 4 5 Line of Credit Needed 6 7 8 6 C D E Comments Share Yes No Check for Updates F G H | J K L M N 0 P Q R S T U V Cash Flow Budget Worksheet 1.5% December Beginning Cash Balance January $5,000.00 February March April May June Cash Inflows (Income): Customer Payments Cash Sales Total Cash Inflows Cash Outflows (Expenses): Advertising Loan Interest Insurance Inventory Purchases Rent or Lease 13 10 11 12 1234 14 15 16 17 18 19 20 Office Supplies 21 Payroll 22 23 Utilities & Telephone 24 Total Expenses 25 26 Cash Flows (Net): 27 28 Shortfall/Surplus Cash $6000.00* 29 30 Loan Calculatations 31 32 Additional Cash Needed $0.00 45 35 B3 34 23 Cash Available to Retire Debt $6,000.00 Cash Used to Retire Debt Loan Balance** Ending Cash Balance $1,000.00 $0.00 36 $5,000.00 $35,000.00 $45,000.00 $53,000.00 $64,680.00 $76,540.00 $90,540.00 $52,000.00 $62,000.00 $73,500.00 $86,000.00 $100,600.00 $117,700.00 $87,000.00 $107,000.00 $126,500.00 $150,680.00 $177,140.00 $208,240.00 $20,000.00 $30,000.00 $35,000.00 $40,000.00 $50,000.00 $60,000.00 $4,500.00 $4,500.00 $4,500.00 $4,500.00 $4,500.00 $4,500.00 $46,000.00 $53,000.00 $54,500.00 $59,800.00 $71,900.00 $83,300.00 $3,200.00 $3,200.00 $3,200.00 $3,500.00 $4,000.00 $4,000.00 $11,000.00 $12,000.00 $13,500.00 $18,100.00 $17,700.00 $23,200.00 $12,000.00 $12,000.00 $12,000.00 $12,000.00 $12,000.00 $12,000.00 $2,700.00 $3,000.00 $3,100.00 $3,200.00 $3,500.00 $5,000.00 $99,400.00 $117,700.00 $125,800.00 $141,100.00 $163,600.00 $192,000.00 -$12,400.00 - $10,700.00 $700.00 $9,580.00 $13,540.00 $16,240.00 37 * Nata thara wasalaan halan Budget Cellular 1000 in Novomboru.h: Calls Data Co with the nnch cuuulus in Dacomber Thin Messages CashFlow + the hooinninecoch value in Complete the statement of cash flow for January through June by completing the tasks. As part of the process you will need to use a circular reference. You will need to set Excel to handle circular references. 1000