Cash Outflows (Expenses): $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...

Transcribed Image Text:

Cash Outflows (Expenses): $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 3 Monthly Interest Plate 15% Line of Credit Needed 7 December 8 Beginning Cash Balance January $5,000.00 February March April May June 9 TO Cash Inflows (Income): 11 Customer Payments 12 Cash Sales 13 Total Cash Inflows 4 15 16 Advertising 17 Loan Interest 18 Insurance 19 Inventory Purchases 20 Office Supplies 21 Payroll 22 Rent or Lease 23 Utilities & Telephone 24 Total Expenses 25 Cash Flows (Net): 27 Shortfall/Surplus Cash $6000.00* 29 30 Loan Calculations 31 Additional Cash Needed 32 Cash Available to Retire Debt Cash Used to Retire Debt $0.00 $6,000.00 $1,000.00 $7,400.00 $10,700.00 $0.00 $0.00 $0.00 $700.00 $0.00 $9,580.00 $0.00 $0.00 $13,540.00 $16,240.00 CashFlow Data Cellular Budget $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,900.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 $7,400.00 $10,700.00 $700.00 $9,580.00 $13,540.00 $16,240.00 MyEducator Tasks 2.7 Calculate the cash used to retire debt for each of the six months. Since the company can't use more cash than is available to retire the debt, Cash Used to Retire Debt cannot exceed the Cash Available to Retire Debt. Likewise, the company can't use more money to retire debt than it has debt from the prior month to retire. a. Cash Used to Retire Debt will be equal to the Cash Available to Retire Debt if the cash available is less than the loan balance from the prior X Cash Outflows (Expenses): $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 3 Monthly Interest Plate 15% Line of Credit Needed 7 December 8 Beginning Cash Balance January $5,000.00 February March April May June 9 TO Cash Inflows (Income): 11 Customer Payments 12 Cash Sales 13 Total Cash Inflows 4 15 16 Advertising 17 Loan Interest 18 Insurance 19 Inventory Purchases 20 Office Supplies 21 Payroll 22 Rent or Lease 23 Utilities & Telephone 24 Total Expenses 25 Cash Flows (Net): 27 Shortfall/Surplus Cash $6000.00* 29 30 Loan Calculations 31 Additional Cash Needed 32 Cash Available to Retire Debt Cash Used to Retire Debt $0.00 $6,000.00 $1,000.00 $7,400.00 $10,700.00 $0.00 $0.00 $0.00 $700.00 $0.00 $9,580.00 $0.00 $0.00 $13,540.00 $16,240.00 CashFlow Data Cellular Budget $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,900.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 $7,400.00 $10,700.00 $700.00 $9,580.00 $13,540.00 $16,240.00 MyEducator Tasks 2.7 Calculate the cash used to retire debt for each of the six months. Since the company can't use more cash than is available to retire the debt, Cash Used to Retire Debt cannot exceed the Cash Available to Retire Debt. Likewise, the company can't use more money to retire debt than it has debt from the prior month to retire. a. Cash Used to Retire Debt will be equal to the Cash Available to Retire Debt if the cash available is less than the loan balance from the prior X