need formulas please!

Sve Book! Excel Home insert Page Layout Formulas Rese Help RODUCT NOTICE There was problem checking the device' license tutus. Please in the Microsoft account the deceactivated with SIGN IN TO OFRCE look your home credential e out of date. Please sign to we can only your subcription Sign in Sign in Cash Flow Budget Worksheet Monthly interest Rate 1.5% Line of Credit Needed December February March April May January $5.000.00 June Beginning Cash Balance 1 Cash Inflows (income): Customer Payments Cash Sales Total Cash In $15.000.00 $52,000.00 $45.000.00 551,000.00 $72,500.00 S640000 $85,000.00 $76,500.00 $100.600.00 590540.00 $217,200.00 13 14 15 16 $20,000.00 $30,000.00 300.00 S00.000.00 390.000,00 36 Cash Outflows (Expenses): vertising count ince inventory Purchase Office Suces 9450000 5.000.00 39.200.00 1,000,00 00:00 $52.000.00 53,200.00 $12.000.00 54.100.00 55,500.00 $200,00 $12.500,00 500.00 $55,000.00 53.500.00 St. 10000 5410000 37100.00 $4.000,00 17,00 20 11 54500.00 $8,000 $4.000.00 22200.00 Type here to ach O hop 2 3 96 5 6 & 7 00 9 Seve Book Excel OR HI Sign In Home Insert Dage Layout Formalas Data Review View Help PRODUCT NON CE The problem checking the device center in with Mr 305 court this date witvad with SIGN IN TO OFCE kike your stod detine out of date, Plese sig inte en veily your action Sign in Cash Inflows (Income) Customer Payments Cash Set total cash flows 535,000.00 $52.000.00 $45,000.00 562.000.00 553.000.00 $78,500.00 $64,600.00 586,000.00 $76.540.00 $100,600.00 $90.500,00 $117.700.00 $20,000.00 510,000.00 SM5,000.00 $40.000.00 $50,000.00 1 Cash Outflows (Expenses): Advertis Loan interest race invertory Purchase Office Suplies Payroll Pontor Le Telephone utal Expenses 54500.00 $46,000.00 $3,200.00 $11,000.00 $13,000.00 $2.700.00 $4500,00 $3.000.00 $200.00 $12.000.00 $12,000.00 5000.00 $ 500.00 $54500.00 $1,200.00 313.500.00 $12.000.00 $100.00 $4,500.00 55,000.00 $3.500.00 10 100.00 $12.000.00 39.2000 54500.00 $71,900.00 $4,000.00 $17,700.00 $12,000.00 $3,500.00 $4.500.00 $83.300.00 $4.000.00 $2,200.00 $12,000.00 $5.000.00 -24 Cash Flows (Net): 26 21 Shortfall/Surplus Cash Sco DO Loan Calculations Cashow DRE o PI LP Tree to search Po $ 2 3 5 6 7 8 9 0 W E R T >save Book 1 - Excel Home Insert Page Layout Formulas Data Review Hela PRODUCT NOTO Thenata problem chieding this device center Morten in with the Microsoft Saccount the stated with SIGN IN TO OFROE Itlook your home credentis et of dute lesson in convenity your con Sign In Cash Flows (Net): Shortfall/Surplus Cash $6000.00 1 Loan Calculations Additional Cash Neded Cash Ale to retire Debt Cash vied to Retre Debt Loan Balance $0.00 3400000 51.000.00 30.00 Ending Cash Balance $5,000.00 23 Note: there was no tance of 1000 in November which waspadto so with the cathrin Domber This is why the beping cash value in is olen than the ength in December Alontent in month bead that month. The leader will be the next month Cash p Type here ween o ii 0 10 4 %6 5 3 4 6 & 7 8 9 0 W E R T Huy w ho MyEducator Manth Bay Mapy Used Uwag Summary May Marth Mb lar Complete the slow for janar the show complete the part of the peo 10 reference O C 5 B 9 0 V Q W E R Y U P than Layout Tomate NINO Candy Costcode Plan Op Oy A May Total options Mas MO wowote olen? Uw Talat es o serie M Total TE May Hot wa D C o 10 9 44 E R T Y 1 O P 7 s D F G H J K 4 7 V B N M . 7 to