Sorry I know this is a longer problem but I really need help it's due tonight! Also this is the most clear I can get it.. thank you in advance!!

Cash budget-Advanced The actual sales and perches for Xenocom Inc., for September and October 2019 song with is forecasts and purchases for the period November 2019 through April 2020, follow Tho fem mam 20% of sales for cash and collects on 40% of its sales in each of the 2 months following the sale. One cash inflows are expected to be $12.000 in September and Art, S15.000 in January and March, and $27.000 in Foruary. The firm pays cash for 10% of its purchases. It pays for 50% of its purchases in the following month and for 40% of its purchase 2 months der Wages and sales amount to 20% of the preceding months sales. Runt of $20.000 per month must be paid intorst payments of $10.000 we due in January and Apl Aprincipal payment of $30 000 hodin April. The fim peta to pay cash dividend of 520,000 in January and April Tes 580.000 rue in April. The firm as intends to make a $25.000 cash purchase of find in December a. Assuming that the tem as a cash balance of $22.000 at the beginning of November, in the end of months Bances for each month November through April b. Assuming that the firmwishes to maintain a $15.000 minimum cash balance determine the required to financing or excess cash balance for each month November through c. the firm were regning a line of credit to cover reeded fnancing for the period November to April ware would this to have to be? Explain your we 2. Auning that the fresa cathos of $22.000 at the beginning of November in the demontable for each month November rough April Complete the November cah budget for Xence. He bow Round to the newest dolar) Od Now $30.000 250.000 170.000 Forecast Casa Colections month Lag 2 month S 120.000 110.000 100.000 Focach Churches Paymer Lago Lih 5 S 5 Cash budget-Advanced The actual sales and purchases for Xenocore, Inc., for September and October 2018, along with a forecast sales and purchases for the period November 2019 trough April 2020, follow The makes 20% of wie fer cash and collect on 40% of each of the 2 months torowing the wie Other cash info xeded to be $12.000 in September and Art, $15.000 in dry and Marth and 827 000 Ferty. The tempays et 10% of a purchases. It pays for boys of its purchases in the following month and for 80of its purchases 2 months later. Wages and salaries amount to 20% of the preceding monthie salon Rent of $20,000 per month most be paid. Interest payments of 10,000 res in Jaway and Aeri. Aprel payment of $30.000 s sode in April. The firm to pay cash videos of $20,000 in Jawy and Areas of 580.000 dus in heri. The formations to make a $25.000 cash purchase of find assets in December Aurring to the firm has estataron o $22.000 at the beginning of November, determine the end of months belonent for each month November through April b. Assuming that the form wahes to maintain a $15.000 minimum cash bolanos, determine the required total financing or excess ch bolo for each month November through April che frmwre requesting a line of credit to cover meded financing for the period November to April, how large would this into be? Explain your new Lago $ Lag 2 month 5 $ Rent 5 Internet payments 5 3 Dudende Tres Purchase of food 5 Totalcaldisbursements 5 Nel caso 5 Add: Beginning cash Ending 5 Complete the December cash budget toe Xenocor, Inc. below. Round to the road) Xenocore. In Oct Nov Dec Forecast $ 250,000 $ 170.000 $ 100.000 Cash Cash budget Advanced The actuales and purchase for Xenocore, Inc., for Schembet and Odober 2010, orgults forecasts and purchases for the period Neverter 2019 through Apri2020 follow The femme 20of sales for cash and collects on 40% of this sales in each of the 2 months following the sale Other cash flows are expected to be $12.000 in September and Roll $45.000 in January and Marchand $27.000 in February The firm pays cash for 10% of the purchases it pays for 50% dis purchases in the following month and for 40% of its purchase 2 months ages and are amount to 20% of the preceding more of $20.000 per month must be paid interest payment of $10,000 redu in January and Art A principal payment of 530.000 is due in April. The form expects to pay cih dividends of $20,000 in Jawy and April. Troes of 500.000 din Ari The firm in tend to make a $25.000 cash purchase of food in December Assuming that the firm has a cash balance of $22.000 at the beginning of November, determine the end of month as blancas for each month November throughout b. Asuing at the wishes to main a $15.000 cash balance, determine the required total ning or excels cash bare for each month November through April e the firmware and credit to covered facing for the period Now Allow lige would this new to be? Explain your an Comine the December cash budget for Monocore. Inc. brow Round to the nature dest) Xencore Oel Now Dee $20.000 170.000 100.000 Yolche Forech Cath 3 . 100005 3 150.000 5 100.000 5 Lagi Lago 5 1 5 $ Primer Cash budget-Advanced The cand purch for Xenocors, Inc. for September and October 2019, long with its formats and purchases for the period November 2010 through April 2020. folio The Form 20% les for cash and collects on 40% of its sales in each of the 2 months following the other cash infows are expected to be $12.000 in September and Roll. 515.000 in January and Marchand $27.000 in February. The firm pays cash for 10% of the purchases pays for sos alts purchases in the following month and for os. of is purchase 2 months later. Wees and are amount to 20% of the preceding month's sales Rurt of $20.000 per month must be paid her parents of S10,000 we dwin Jonway an April. A principal payment of $30.000 is due in April. The temporis to pay cash didends of $20.000 in January and For Tee of 500.000 are due in the firm as intends to make a 525.000 cash puthese of food 2. Assuming that the firm has a cash balance of 22.000 te beginning of November, determine the end or cash balances for each mont, November through April B. Assuming that the timwishes to maintain a $15.000 mm Cash belo, determine the required total francing or excess cash balance for each month November through Art. che frequesting and of credit to cover hoded nanong for the period November to Ari, how we would this line have to be? Explain your Lag 2 month Sad Rent 5 5 5 Dividende 5 5 5 Toch 5 Nutcash flow S AditBegge Eng Copiate the way can budget to Xerocor. c. below Road to the newest color Xenocore, the Nov Der Forecast $ 170.000 100.000 $ 10.000 Cash Cash budget--Advanced The actual sales and purchases for Xenocore, Inc., for September and October 2016. along with its forecast sales and purchases for the period November 2019 rough April 2006 follow The femaks 20of als for cash and collecta on 40af is in each of the 2 months following the sale other cash infows are expected to be $12.000 in September and Art. 515.000 denary and March, and 827 000 in February. The firm pays cantor 10% of a purchases. It pays for 50% of its purchases in the following month and for cool is purchases 2 months latet Wages and stars amount to 20% of the preceding nonto. Rart of $20,000 per month must be paid forest payments of $10,000 recue in January and Art A principal payment of $30.000 is de in April. The firm spects to pay cash dividends of $20,000 in January and Apr Tous of 80.000 are due in der The femalso words to make a $35.000 cash purchase of food assets in December Assuming that the femasach balance of $22.000 at the beginning of November demine the mothes for each mone, November throughout B. Ahat the fem wielomairtain a $15.000 minum blondeermine the regundo financing or ce belance for each month November through April che frequesting a line of credit to cover needed financing for the period November to Aprl how large would this name to be? Explain your arms Complete the way uh budt for Xos.com, Inc. below Round to the news cole) Xenocore, Inc. Now Dec For $ 170.000 100.000 10.000 Collection 5 3 Orch Rach 3 160.000 30.000 100.000 $ Lager 5 3 3 3 1 Cash budget-Advanced Teachers and purchase for Xenocore, Inc., for September and October 2010. Meng with its recent and purchased for the period over 200 through Apr 2020. The me 20% for cash and collects on 40% din ach of the 2 months to owing the other cashindows are expected to be $12.000 in September and Art, $15.000 in day and March, and $27.000 in Fonary. The firm pays cantor 10 purchases. It pays for 50% of its purchases in the following more and for 40% of its purchases 2 months Wages and sales amount to 20% of the preceding month's salos. Rent of $20.000 per month must be paid. Interest payments of $10,000 recue in January and Art A principal payment $30.000 Ari The time to pay cash dividinds of $20,000 in January and Agree of 80.000 dinarl The form oonds to make a $25.000 cash purchase of food a. Atturning the firm has a cash balance of $22.000 at the beginning of November, determine the end of months bancos forach mor, Novenstertrough All. b. Aming that the firm withes to maintain a $15.000 minimum belonon determine the required to runcing or esta balonce for each month November through April c. them were requesting and credit to cover needed financing for the period November to or how large would this in have to be? Explain your answer Lingo 5 Runt Principe Dividende 5 5 . Puchoff $ Toch disbursements 5 5 Aas Baging S ningco 5 Condiale e Februarych budget to Xanocom lebelow and to the newest dolar) Xenocore, Ine Dec Jan Feb Foreca 160.000 100.000 $ 10.000 Cash Collection Cash budget Advanced The actuales and purchase for Xenocore, Inc., for Sectomber and October 2013. along with its forecast sales and purchases for the period November 2016 tough April 2000, follow The te makes 20% of at sale for cash and collects on 40% of sale in each of the 2 months tobowing the sale. Other canh infows are expected to be $12.000 in September and Art, $15.000 in January and March, and $2.000 in February. The firm pays cash for 10% of tra purchase. It pay for 50 of its purchase in the following mom and tortor of its purchase 2 months in Wages and staries arourt to 20% of the preceding nort's Rest of $20.000 per month must be paid. Interest payments of $10,000 are de in January and Apr. A principal payment of $30.000 is also due in April. The firm spects to pay cas vidonds of $20,000 in January and Aprire of 500.000 are due in Aort. The form also intends to make a $25,000 cash purchase of food in December 2. Assuming that the form as a cash balance of $22.000 at the beginning of November, determine the end of month cash balances for each month, November through April b. Ansuring that the front whes to maintain a $15.000 minimum cash balance, determine the required total financing or exceed cash balance for each month November through April the firm were tre of credit to cover de Gracing for the period November to Arlow large would have to be? Explain your Complete the February cash budget for Xenocore, Inc. below and to the nearesto Xenocore, Ine Dec Jan Forecast $100.000 $100.000 5180.000 Cath Collection Lago Lag 2 5 Obernih 3 Tocho 5 Forecast Pach 5 100.000 00.000 H.000 5 1 5 $ Pc 3 Cash budget Advanced the actual sales and purchase for Xenocore Inc., for Salember and October 2010, long with its forecastles and purchases for the period November 2015 rough April 2020, tollow The firm mokes20% of sale for cash and collects on 40% of its sale in sach of the month following the sale. Other cash flows are expected to be $12.000 in September and Art. 515.000 in January and March, and $2.000 in February The firm pays call for 10% of a pocit pays form of the purchase in the following monard for 60% of its purchase 2 months later Wapes and salaries arourt to 20% of the preceding more Rest of $20.000 per month and interest payments of $10,000 are due in January and Agri A principal payment of $30.000 is also due in April. The firm pode to paycan dividends of $20.000 in January and Apres of $80.000 are due in fort. The female nonds to make a $25,000 cash purchase of food in December 2. Assuming that the fomos a cash balance of $22.000 at the beginning of November, determine the end of month cash balances for each month, November through Ael b. Ansuring that the front whes to maintain a $15.000 minimum cash Delaron determine the required total finanong or exceed cash balance for each month November through April c. the firmware engine of credit to covered financing for the period November to All how we would have to be? Explain your Last month Logo $ 3 Rent Interstate Pinoy Die 5 $ 5 3 Totalca debemos 5 Nel caso Adding Ending 1 Comme Massage for more wound to the Xenocore, the Jan Feb Mar 160.000 100.000 200.000 Cash Cash budget-Advanced the actual sales and purchases for Xenocore, Inc., for September and October 2010, along with its forecast sales and purchases for the period November 2010 Through April 2020. tollow The makes 20% of all sales for cash and collects on 40% of its sales in each of the 2 months following the other cash info are expected to be $12.000 in September and Art. $55.000 in denary and Mech and S27.000 in February. The tem pays cash for 10% of puts it pays for Sons of its purchase in the following more and for 60% of its purchases 2 months Wages and was amount to 20% of the preceding months Rent of $20.000 per month must be printerest payments $10,000 in 520.000 euro in fer. purchase of ist in December a. Asuing that the firm has a cash balance of $22.000 at the beginning of November determine the forth balans for each month November through ori. b. Assuming that the fem wishes to maintain a $15.000 cash balance, determine the required total financing or excess cash balance for each month November through April c. the firmwingine it tooded ring for the period November to All how large would then we be? Explain your Complete e Much cash budget for Xenocor, he below Round to the rest olla:) Xenocore. In Jan Feb Mar Forecast $ 140,000 $ 180,000 $200,000 3 5 Collections Log In Lag? O Totho Fosch Cash 3 5 . 110.000 $ 30.000 100.000 Lagi 1 1 s 1 1 Pro Cash budget-Advanced The actual sales and purchases for Xanecore, Inc., for Salember and Odober 2018, long with strecast sales and purchases for the period November 2019 trough Art 2020, follow The firm makes 2017 e for cash and cocon 40 och 2 months following the other cash info expected to be $12.000 in September and Art, $15.000 in dry and Marchand $27.000 in February The fiempre comfort purchases. It pays for 50% of its purchases in the following month and for 40% of its purchases 2 months later Wages and salaries amount to 20% of the preceding morta als Rent of $20.000 per month must be paid. Inforest payments of 10.000 e due in Jayed All Aprel ayer 30.000 Ari. The fixed to pay cash dividech 820,000 in dinary and Arts of $80.000 de in April. The fem here to make a s000 cash pe of food in December a Assuring that the firm has a cash batonca of $22.000 at the beging of November determine the woman can ons for each month November throun All b. Aming that the firm wishes to martina $15.000 mininunch blodetermine the required to wong or conch balans for each month November though April 2.The fem were requesting red credit to cover needed francling for the period November to All how large wiodid the inte have to be? Explain your wat S $ Principe . . Touchdows Male 31 Complete the forth budget to come. In town to the new Xenocore. In Feb Mar ADI Force Cocon $ 3 Lag Other Cashbudget-Advanced The acts and purchases for Xenocore, Inc., for Salember and October 2018, or with a forecast sales and purchases for the period November 2013 rough April 2020, follow The femaks 20% for cash and ca cn 40of neach of the 2 months following the Church now as expected to be $12.000 in September and Art. 15.000 in donary and March, and $27.000 in February. The tempera control of purchases. It pays for 50% of its purchases in the following month and for 40% of its purchases 2 months later. Wages and salaries amount to 20% of the preceding morti si Ront of $20.000 per month must be paid. Inforest payments of 10.000 are due in Jinay and Art A principayment of $30.000 on April. The fimpedia to pay cam dividends of $20.000 in January and Art Tee of $80.000 de Inforl The fomno merch to make a $25.000 cath purchase of food in December a. Assuring that the firmosa cash balance of 522,000 at the beginning of November determine the end of north casts for sach month November through April b. Assuming that the firm whes to maintain a $15.000 minimum cash belon determine the roured to financing or con cash balance for ench Month November through April c. The fimwer requesting and credit to cover rododening for the period November to for how large woteine to be plan your www Complete the cash budget for encore, in below (Round so the Xenocore. In Feb Mar Apr Preces $ 300,000 $200,000 250.000 Collections . 1 Lag? On . . 100.000 00.000 Cath + 1 Lag? Rent 1 5 . Cashbudget-Advanced The actuales and purchase for Xenocore, b.lor Sectomber and October 2010, along with its forecasts and purchases for the period November 2013 huhti2020. tolow The makers 20% da sales for cash and collects on some of its sales in each of the 2 months following the sale. Other cash info me expected to be $12.000 in September and Art. 515.000 in January and Marchand 527 000 in February. The form pays coch for 10% of a purchases pays for 50% of the purchases in the following month and for 40% of its purchases 2 months later and mount to 20% of the preceding months sales Rest of 20,000 per month must be paid to payments of Sto,000 e in January and Apel Arnicipal payment of $30.000 is also on in April. The firm pects to pay cash didends of $20.000 inway and for all of $80,000 are on April. The femalo intends to make a $25.000 cash purchase of food assets in December 2. Assuming that the form has a cash banon 522.000 at the beginning of November determine the end of month cash balances for each month, Nevenbergh Art b. Asing the fem wies to maintain a $15.000 minimum cashbac, determine the referencat balance for a month. November rough April c. The firmware requesting a line of credit to cover need financing for the period November to April, towane would leave to be? Explain your we 110.000 500.000 50.000 Cashouth Payment Lemon Lig 2 months . . . 5 De 3 5 5 5 Adeling cash Ering 1. Asuming the firmwishes to main a $15.000 minimum cash and the financing or exchance for each month Novembergh April Compiute the table below. Round to the rest of Cash budget-Advanced the actual sales and purchases for Xucocore, Inc. for Schember and October 2018, long with ts forecast sales and purchases for the period November 2019 through April 2020, toewThe firm makes 20% of sation for cash and collecta on 40% of the sales in each of the 2 months following the sale. Oher cash rows are expected to be 12.000 in September and Apr. 515.000 in January and March, and S27 000 in February. The form pays cash for 10% of the purthales pays for 50% of its purchases in the following month and 80% of its purchase 2 months ages and stories mount to 20% of the preceding montessorit of $20,000 per month must be paid interest payment of $10.000 wree in January and April. A principal payment of 530,000 as soon in April. The fim expects to pay Chades of $20,000 in January and Port Tas of $80.000 ale doe in April. The femalo tends to make a $25.000 can purchase of food assets in December Assuming that the fem has a cash baca 822.000 the beginning of November, determine the end of months bence for each month, November through Art b. Aming at the firm whes to maintain a $15.000 machine determine the required for ce cash balance for each month November thoughArt c. them were requesting a line of credit to cover needed financing for the period November to April, how large would this in awe to be? Explain your Prin payment Dividende $ . Photo Totalco dobro March Add Beginning cash 5 5 5 b. Asuming that the fim wishes to maintain a $15.000 men can balonon, cetermine the required to financing or excess can be mentor och month, November through Aert Complete the below and to the nero Xanco. In Dee Feb Mar Nov Jan 15.000 11.00 15.000 15.000 15.000 Me Regarding 6. The line of credit hoe betower the main borowing for the morm of cond to the Type the name of the month February