im sorry i know this is extremely long but please please help!! it will be so appreciated
Cashbudget-Advanced The act as an oudos to correfox September and October 2010 org with some and purchase for the period omer 2016 Art 2020, to the moon sain borcash and collecte des hote2 months following the other couhinfoware meted babe 12.000 in Sloterd, 315.000 Jenwyn Mac, 27.000 in For The time comfort of ex parche pay for purchases in the flowing month and for of such 2 months Wages and sale amount to 20% of the preceding more Rent 20.000 per month of 90.000 and on Apple of 530,000 is not the formed to pay cash dividends of $20.000 inwandproof 80.000 dinThe follade to make a 5.000 in Dec a. Aurthermosa cash balanced $22.000 at the beginning of November demetendo months balance for each oth November through on Assing that the form wished to run 315.000 manner the required totalinong or excess canh balance teach movember through eft om were in all redit to cover needed francing for the period November to low wodi in velo Explan you www. As care of 22.000 at the timing of becomiendo en cash bales for each Cung het onder ch but to Xtrecere, he wound to the to Xenocore.ie Sept Out 1 210.000 250.000 170.000 Dobec Lago Tag 2 OG Total cathos Forecast Puristuses . 5 3 5 120.000 10.000 $ Laat Lag 2 month and we 3 $ 3 de payment 2. Anoting that we truri cu balance of $22.000 begering of November, Stone the end of on.canh balances for each month, Newmber throughout Complete me bercah budget to Xardcore he below (Hound to the newest ) Xenocore, le Sept Force $ 210.000 5 250.000 170.000 Oct Now $ 5 5 5 $ 120.000 150.000 120 600 5 $ Collections Lagimon Lam Och The Focal Purch Cath purchase Payments Lago Lag 2 month Sales and wages Re It payments Preciowym Divideo Times Pares offres Tuan Notch $ 5 S 5 $ 5 $ $ $ Cash budoet - Advanced The actual sales and marches for Xenonom inn for Septembne and October 2010 alone with its for sales and outches for the period November HE Taxes $ Purchases of fixed assets $ Total cash disbursements $ Net cash flow $ Add Beginning cash $ Ending cash $ Complete the December cash budget for Xenocoro, Inc below (Round to the nearest Collar) Xenocore, Inc. Oct Nov 250,000 $ 170,000 $ $ Dec 160,000 s s s $ 140.000 $ $ 150,000 $ 100.000 Forecast sales Cash salos Collections Lag 1 month Lag 2 month Other cash receipts Total cash receipts Forecast Purchases Cash purchases Payments Lag 1 month Lag 2 month Salaries and wages Rent Interest payments Principal payments $ s s $ $ $ $ $ $ $ $ Rent Interest payments $ Principal payments Dividends Taxes Purchases of fixed assets $ Total cash disbursements Net cash flow $ Add: Beginning cash $ Ending cash Complete the January cash budget for Xenocore, Inc. below: (Round to the nearest dollar.) $ $ Xenocore, Inc. Nov Dec Jan 170,000 $ 160,000 $ 140,000 $ $ $ $ $ Forecast sales Cash sales Collections Lag 1 month Lag 2 month Other cash receipts Total cash receipts Forecast Purchases Cash purchases Payments Lag 1 month 1 month $ A 140,000 $ 80,000 100,000 $ $ $ $ Lag 1 month Lag 2 month $ Salaries and wages $ Rent Interest payments Principal payments Dividends $ Taxes Purchases of fixed assets $ Total cash disbursements Net cash flow Add: Beginning cash Ending cash $ Complete the February cash budget for Xenocore, Inc. below: (Round to the nearest dollar.) $ $ $ $ $ $ $ Xenocore, Inc. Dec Jan 160,000 $ 140,000 $ Feb 180,000 $ $ Forecast sales Cash sales Collections Lag 1 month Lag 2 month Other cash receipts Total cash receipts Forecast Purchases $ $ $ $ $ 100,000 $ 80,000 $ 110,000 och nichsene $ $ s 100,000 $ 110,000 80,000 $ $ $ Other cash receipts Total cash receipts Forecast Purchases Cash purchases Payments Lag 1 month Lag 2 month Salaries and wages Rent $ $ $ $ $ $ $ $ Interest payments Principal payments Dividends Taxes Purchases of fixed assets Total cash disbursements $ S $ S Net cash flow co Add: Beginning cash Ending cash Complete the March cash budget for Xenocore, Inc. below: (Round to the nearest dollar.) Xenocore, Inc. Jan Mar Forecast sales $ 140,000 $ 180,000 $ 200,000 Cash sales Collections Lag 1 month Feb Complete the March cash budget for Xenocore, Inc. below: (Round to the nearest dollar.) Xenocore, Inc. Jan Feb Mar 140,000 $ 180,000 $ 200,000 $ $ $ $ $ $ $ 80,000 $ $ 110,000 $ $ 100,000 w $ Forecast sales Cash sales Collections Lag 1 month Lag 2 month Other cash receipts Total cash receipts Forecast Purchases Cash purchases) Payments Lag 1 month Lag 2 month Salaries and wages Rent Interest payments Principal payments Dividends Taxes Purchases of fixed assets Total cash disbursements Net cash flow Add: Beginning cash $ $ $ $ $ $ $ $ $ un S $ $ A Feb Total cash disbursements Net cash flow Add: Beginning cash Ending cash $ Complete the April cash budget for Xenocore, Inc. below: (Round to the nearest dollar.) Xenocore, Inc. Mar Apr Forecast sales 180,000 $ 200,000 $ 250,000 Cash sales $ Collections Lag 1 month $ Lag 2 month Other cash receipts Total cash receipts Forecast Purchases 110,000 $ 100,000 $ 90,000 Cash purchases $ Payments Lag 1 month Lag 2 month Salaries and wages Rent Interest payments Principal payments Dividends $ $ $ A $ $ $ Tauer Complete the April cash budget for Xenocore, Inc. below: (Round to the nearest dollar.) Xenocore, Inc. Feb Mar 180,000 $ 200,000 $ $ 250,000 $ $ S $ S $ 110,000 $ 100,000 $ 90,000 $ Forecast sales Cash sales Collections Lag 1 month Lag 2 month Other cash receipts Total cash receipts Forecast Purchases Cash purchases Payments Lag 1 month Lag 2 month Salaries and wages Rent Interest payments Principal payments Dividends Taxes Purchases of fixed assets Total cash disbursements Net cash flow $ $ $ S s $ $ $ $ $ s > 5 Dividends Tawe 5 Purchases of food ascots 5 Tutash 5 Notchtow $ Mod Begeing cash Ending $ 1. Auming the firm with to maintain a $15.000 minimum balance to the cred Holaninong or exchance for each month November Touch Al Complete the table below found to the rest doar Xenocore. In Dec Feb Mar Apr Ending 5 5 5 5 5 umum cash balance 15.000 15.000 15.000 15.000 15.000 15.000 Recured lotal financing $ $ S Excess cash bace c. The ine of credit should be at least to cover the maximum borrowing ronds for the month of Rourd to the west doilar Type the tut name of the month og Fey) NON Cashbudget-Advanced The act as an oudos to correfox September and October 2010 org with some and purchase for the period omer 2016 Art 2020, to the moon sain borcash and collecte des hote2 months following the other couhinfoware meted babe 12.000 in Sloterd, 315.000 Jenwyn Mac, 27.000 in For The time comfort of ex parche pay for purchases in the flowing month and for of such 2 months Wages and sale amount to 20% of the preceding more Rent 20.000 per month of 90.000 and on Apple of 530,000 is not the formed to pay cash dividends of $20.000 inwandproof 80.000 dinThe follade to make a 5.000 in Dec a. Aurthermosa cash balanced $22.000 at the beginning of November demetendo months balance for each oth November through on Assing that the form wished to run 315.000 manner the required totalinong or excess canh balance teach movember through eft om were in all redit to cover needed francing for the period November to low wodi in velo Explan you www. As care of 22.000 at the timing of becomiendo en cash bales for each Cung het onder ch but to Xtrecere, he wound to the to Xenocore.ie Sept Out 1 210.000 250.000 170.000 Dobec Lago Tag 2 OG Total cathos Forecast Puristuses . 5 3 5 120.000 10.000 $ Laat Lag 2 month and we 3 $ 3 de payment 2. Anoting that we truri cu balance of $22.000 begering of November, Stone the end of on.canh balances for each month, Newmber throughout Complete me bercah budget to Xardcore he below (Hound to the newest ) Xenocore, le Sept Force $ 210.000 5 250.000 170.000 Oct Now $ 5 5 5 $ 120.000 150.000 120 600 5 $ Collections Lagimon Lam Och The Focal Purch Cath purchase Payments Lago Lag 2 month Sales and wages Re It payments Preciowym Divideo Times Pares offres Tuan Notch $ 5 S 5 $ 5 $ $ $ Cash budoet - Advanced The actual sales and marches for Xenonom inn for Septembne and October 2010 alone with its for sales and outches for the period November HE Taxes $ Purchases of fixed assets $ Total cash disbursements $ Net cash flow $ Add Beginning cash $ Ending cash $ Complete the December cash budget for Xenocoro, Inc below (Round to the nearest Collar) Xenocore, Inc. Oct Nov 250,000 $ 170,000 $ $ Dec 160,000 s s s $ 140.000 $ $ 150,000 $ 100.000 Forecast sales Cash salos Collections Lag 1 month Lag 2 month Other cash receipts Total cash receipts Forecast Purchases Cash purchases Payments Lag 1 month Lag 2 month Salaries and wages Rent Interest payments Principal payments $ s s $ $ $ $ $ $ $ $ Rent Interest payments $ Principal payments Dividends Taxes Purchases of fixed assets $ Total cash disbursements Net cash flow $ Add: Beginning cash $ Ending cash Complete the January cash budget for Xenocore, Inc. below: (Round to the nearest dollar.) $ $ Xenocore, Inc. Nov Dec Jan 170,000 $ 160,000 $ 140,000 $ $ $ $ $ Forecast sales Cash sales Collections Lag 1 month Lag 2 month Other cash receipts Total cash receipts Forecast Purchases Cash purchases Payments Lag 1 month 1 month $ A 140,000 $ 80,000 100,000 $ $ $ $ Lag 1 month Lag 2 month $ Salaries and wages $ Rent Interest payments Principal payments Dividends $ Taxes Purchases of fixed assets $ Total cash disbursements Net cash flow Add: Beginning cash Ending cash $ Complete the February cash budget for Xenocore, Inc. below: (Round to the nearest dollar.) $ $ $ $ $ $ $ Xenocore, Inc. Dec Jan 160,000 $ 140,000 $ Feb 180,000 $ $ Forecast sales Cash sales Collections Lag 1 month Lag 2 month Other cash receipts Total cash receipts Forecast Purchases $ $ $ $ $ 100,000 $ 80,000 $ 110,000 och nichsene $ $ s 100,000 $ 110,000 80,000 $ $ $ Other cash receipts Total cash receipts Forecast Purchases Cash purchases Payments Lag 1 month Lag 2 month Salaries and wages Rent $ $ $ $ $ $ $ $ Interest payments Principal payments Dividends Taxes Purchases of fixed assets Total cash disbursements $ S $ S Net cash flow co Add: Beginning cash Ending cash Complete the March cash budget for Xenocore, Inc. below: (Round to the nearest dollar.) Xenocore, Inc. Jan Mar Forecast sales $ 140,000 $ 180,000 $ 200,000 Cash sales Collections Lag 1 month Feb Complete the March cash budget for Xenocore, Inc. below: (Round to the nearest dollar.) Xenocore, Inc. Jan Feb Mar 140,000 $ 180,000 $ 200,000 $ $ $ $ $ $ $ 80,000 $ $ 110,000 $ $ 100,000 w $ Forecast sales Cash sales Collections Lag 1 month Lag 2 month Other cash receipts Total cash receipts Forecast Purchases Cash purchases) Payments Lag 1 month Lag 2 month Salaries and wages Rent Interest payments Principal payments Dividends Taxes Purchases of fixed assets Total cash disbursements Net cash flow Add: Beginning cash $ $ $ $ $ $ $ $ $ un S $ $ A Feb Total cash disbursements Net cash flow Add: Beginning cash Ending cash $ Complete the April cash budget for Xenocore, Inc. below: (Round to the nearest dollar.) Xenocore, Inc. Mar Apr Forecast sales 180,000 $ 200,000 $ 250,000 Cash sales $ Collections Lag 1 month $ Lag 2 month Other cash receipts Total cash receipts Forecast Purchases 110,000 $ 100,000 $ 90,000 Cash purchases $ Payments Lag 1 month Lag 2 month Salaries and wages Rent Interest payments Principal payments Dividends $ $ $ A $ $ $ Tauer Complete the April cash budget for Xenocore, Inc. below: (Round to the nearest dollar.) Xenocore, Inc. Feb Mar 180,000 $ 200,000 $ $ 250,000 $ $ S $ S $ 110,000 $ 100,000 $ 90,000 $ Forecast sales Cash sales Collections Lag 1 month Lag 2 month Other cash receipts Total cash receipts Forecast Purchases Cash purchases Payments Lag 1 month Lag 2 month Salaries and wages Rent Interest payments Principal payments Dividends Taxes Purchases of fixed assets Total cash disbursements Net cash flow $ $ $ S s $ $ $ $ $ s > 5 Dividends Tawe 5 Purchases of food ascots 5 Tutash 5 Notchtow $ Mod Begeing cash Ending $ 1. Auming the firm with to maintain a $15.000 minimum balance to the cred Holaninong or exchance for each month November Touch Al Complete the table below found to the rest doar Xenocore. In Dec Feb Mar Apr Ending 5 5 5 5 5 umum cash balance 15.000 15.000 15.000 15.000 15.000 15.000 Recured lotal financing $ $ S Excess cash bace c. The ine of credit should be at least to cover the maximum borrowing ronds for the month of Rourd to the west doilar Type the tut name of the month og Fey) NON
