Data Review View Automate Assignment le Define Name Trace Precedents Calculate Now Use in Formula Trace Dependents Date & Time Lookup & Math & Reference Trig More Functions Name Manager Create from Selection Show Error Watch Remove Arrows Formulas Checking Window Calculation Options Calculate Sheet Home Insert Draw Page Layout Formulas fx ? A 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. K25 fx Comments Share Yes No Check for Updates C D E F G H | J K L M N P Q R S T U V W X Y Z AA AB AC A B 1 2 Cash Flow Budget Worksheet 3 Monthly Interest Rate 1.5% 4 56 Line of Credit Needed 7 December January February March April May June 8 Beginning Cash Balance $5,000.00 9 10 Cash Inflows (Income): 11 Customer Payments 12 Cash Sales 13 Total Cash Inflows 14 15 16 17 Loan Interest 18 Insurance 19 Inventory Purchases 20 Office Supplies 21 Payroll 22 Rent or Lease 23 Utilities & Telephone 24 Total Expenses 25 26 Cash Flows (Net): Cash Outflows (Expenses): Advertising $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 27 28 Shortfall/Surplus Cash $6000.00* -$7,400.00 -$5,700.00 $5,700.00 $14,580.00 $18,540.00 $21,240.00 29 30 Loan Calculatations 31 Additional Cash Needed 32 Cash Available to Retire Debt $0.00 $6,000.00 $7,400.00 $5,700.00 $0.00 $0.00 $0.00 $0.00 33 Cash Used to Retire Debt $1,000.00 34 Loan Balance** $0.00 35 36 Ending Cash Balance $5,000.00 37 38 39 40 *Note: there was a loan balance of $1000 in November which was paid to $0 with the cash surplus in December. This is why the beginning cash value in January is $1000 less than the ending cash in December. ** A loan taken out in any given month cannot be paid off in that month. The earliest a loan will be paid off will be the next month. 41 42 43 44 45 46 47 Budget Ready Cellular Accessibility: Investigate Calls Data Messages CashFlow + 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. A + 80%