Merpe & Canter $. % Conditional Format Fermingas Table Styles Cell insert Dale E17 * fx -PRODUCT(0.015*C34) D O Cash Flow Budget Worksheet Monthly interest Rate 1.3% Line of Great Needed $18.212.89 December Beginning Cash Balance January $5,000.00 February 50.00 March $0.00 April 50.00 May $0.00 $4 9 10 11 12 Cash Inflows (income): Customer Payments Cash Sales Total Cash Intlows $35.00000 545.000.00 $5300000 SA GOBO 576,540.00 500.540.00 552.000.00 562.00000 $23.50000 56.000.00 5100 500.00 5117,100.00 $87,000.00 5107,000.00 $126.500.00 5150.600.00 5177,140.00 570R240.00 14 15 16 17 18 19 20 21 22 23 24 25 26 27 SASA Cash Outflows (Expenses): Advertising Loan interest Insurance trventory Purchases Office Supplies Payroll Rent or Lease Uuties & Telephone Total Expenses $20,000.00 500.000.00 $35,000.00 40,000.00 $50,000.00 $60,000.00 $112.05 50.00 $112.65 $273.15 $2645 $124 78 $4.500.00 SL 500.00 $4.500.00 $4,500.00 54.500.00 $4.500.00 546,000.00 $53.000.00 $S450000 SS 9.00.00 $71.900.00 583 30000 53.200.00 $3,200.00 $3,200.00 $9.500,00 $4.000.00 $4.000.00 511,000.00 $17,000.00 $13,500.00 $1,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 53.000.00 53.100.00 $3,200.00 $3.500.00 $5,000.00 599,512) 5117,700.00 $125.91265 5541.173.19 5163.6438 5192,124.78 Cash Flows (Net): -512512.69510,700 00 558731 5910581 $53275 62 516. 115.22 Shortfall/Surplus Cash 56000.00 $7,51269 510,700 00 558731 59.106.31 $13.275.62 $21072 27 30 31 32 Loan Calculations Additional Cash Needed Cash Available to Retire Debt Cash Used to retire Debt Loan Balance $0.00 $6.000.00 51.000.00 $0.00 57,512.09 $0.00 50.00 $7,512.69 $10,700.00 $0.00 $0.00 558731 $0.00 $587.31 518, 217.69 $17.695 18 $0.00 $9,306 81 59,30681 $1,31857 50.00 $0.00 $12275 62 $21.072.77 58 31557 $0.00 $0.00 $0.00 34 5 Data Cellular Budget + Cash Flow Calculate Rrary Task 11 0.5/3 points Calculate the loan interest for each month. [-0.5] The value in cell E17 is not correct [-0.5] The value in cell F17 is not correct [-0.5] The value in cell G17 is not correct [-0.5] The value in cell H17 is not correct [-0.5] The value in cell 117 is not correct 212 points