Following this, I need to prepare a cash budget with this data

CashHungry Company Cash Budget Given Information For the Month Ended November 30, 20XX Note: A printout of this slide will make it easier to follow the rest of these slides. New Mode Delay Options Some Company has asked you to prepare Select the ship mode Projected November transactions to be paid in November, (a) a schedule of expected cash collections from sales for November and unless otherwise noted: (b) a cash budget for November using the following information: Snipping Purchases of merchandise inventory 10,000 in a future up Operating expenses:ving to a Projected cash balance at October 31 6.000 e. Try imp Sales and office salaries 21.000 & Sketch Cash balance desired November 30 5.000 logo key Office utilities 4,000 Projected sales by month (collected 60% in the month of Insurance expense (taken from Prepaid Insurance) 2,500 sale, 20% in the month after sale, and 10% in the second Depreciation of building and equipment 15.000 month following the sale; with the remaining 10% Amortization of patent 5.000 uncollectible): Purchases of store equipment 20,000 August 45,000 September 50,000 October 60.000 The company has a line of credit at the bank which allows borrowing up November 40.000 to $100,000. Currently, the company has loans of $25,000 taken out two Projected November sale of excess equipment: years ago at 10% interest. Interest is due quarterly on March 31, June Original cost 10.000 30. September 30 and December 31. Accumulated depreciation 8,500 Book value 1,500 Cash expected to be received 2,000 Gam on sale expected 500 CashHungry Company Cash Budget For the Month Ended November 30, 20XX The form at right includes all of the items in the given problem information that might" go on the cash budget S 6.000 Your mission is to decide which items listed actually go on the cash budget and at what amounts The listed items that do not go on the cash budget should be removed The solution is not provided, but some check figures are: Cash available = 49,000 Cash disbursements = 55,000 Cash deficiency =(6,000) To get from the deficiency to the cash balance desired at November 30, 20XX requires financing of 11,000. Cash balance. November 1, 20XX Cash receipts: Cash collections from customers Sale of excess equipment Cash available Cash disbursements: Purchases of merchandise inventory Payment of sales and office salaries Payment of office utilities Payment of insurance Payment of depreciation of building and equipment Payment of amortization of patent Purchases of store equipment Payment of interest (could be in financing section) Total cash disbursements Cash excess (deficiency) Financing or (Investing) Cash balance. November 30, 20XX $ 5.000 You will learn the most by working the budget yourself without using the check figures until you are finished. Lesson 9b Cash Budget Problem Some Company Cash Budget Given Information For the Year Ended December 31, 2020 Some Comparty has asked you to prepare a cash budget for the year 2020 using the following information: Projected cash balance at January 1 50,000 Cash balance desired December 31 65,000 Projected sales by quarter (collected 70% in the quarter of sale and 20% in the quarter after sale, with the remaining 10% uncollectible): Accounts recievable from 4th quarter 2019 (of which 20,000 is collectible and 10,000 is uncollectible) 30,000 Sales Quarter 1 145,000 Sales Quarter 2 250,000 Sales Quarter 3 160,000 Sales Quarter 4 240,000 Projected 2020 sale of excess land Original cost Accumulated depreciation Book value 40,000 Cash expected to be received 75.000 Gain on sale expected 35,000 Expected federal income tax refind from 2020 correction of error on 2018 tax return 14,000 Projected 2020 transactions, to be paid in 2020, unless otherwise noted Purchases of merchandise inventory 410.000 Operating expenses: Sales and office salaries 121,000 Office utilities 9,000 Insurance expense (taken from Prepaid Insurance) 6,500 Depreciation of building and equipment 55,000 Amortization of copyright 15,000 Purchases of office equipment 20,000 40,000 Cash dividend (dedared in December 2020: to be paid in January 2021 28,000 Currently, the company has loans of $250,000 taken out two years ago at 10% interest Interest is due quarterly on March 31, June 30. September 30 and December CashHungry Company Cash Budget Given Information For the Month Ended November 30, 20XX Note: A printout of this slide will make it easier to follow the rest of these slides. New Mode Delay Options Some Company has asked you to prepare Select the ship mode Projected November transactions to be paid in November, (a) a schedule of expected cash collections from sales for November and unless otherwise noted: (b) a cash budget for November using the following information: Snipping Purchases of merchandise inventory 10,000 in a future up Operating expenses:ving to a Projected cash balance at October 31 6.000 e. Try imp Sales and office salaries 21.000 & Sketch Cash balance desired November 30 5.000 logo key Office utilities 4,000 Projected sales by month (collected 60% in the month of Insurance expense (taken from Prepaid Insurance) 2,500 sale, 20% in the month after sale, and 10% in the second Depreciation of building and equipment 15.000 month following the sale; with the remaining 10% Amortization of patent 5.000 uncollectible): Purchases of store equipment 20,000 August 45,000 September 50,000 October 60.000 The company has a line of credit at the bank which allows borrowing up November 40.000 to $100,000. Currently, the company has loans of $25,000 taken out two Projected November sale of excess equipment: years ago at 10% interest. Interest is due quarterly on March 31, June Original cost 10.000 30. September 30 and December 31. Accumulated depreciation 8,500 Book value 1,500 Cash expected to be received 2,000 Gam on sale expected 500 CashHungry Company Cash Budget For the Month Ended November 30, 20XX The form at right includes all of the items in the given problem information that might" go on the cash budget S 6.000 Your mission is to decide which items listed actually go on the cash budget and at what amounts The listed items that do not go on the cash budget should be removed The solution is not provided, but some check figures are: Cash available = 49,000 Cash disbursements = 55,000 Cash deficiency =(6,000) To get from the deficiency to the cash balance desired at November 30, 20XX requires financing of 11,000. Cash balance. November 1, 20XX Cash receipts: Cash collections from customers Sale of excess equipment Cash available Cash disbursements: Purchases of merchandise inventory Payment of sales and office salaries Payment of office utilities Payment of insurance Payment of depreciation of building and equipment Payment of amortization of patent Purchases of store equipment Payment of interest (could be in financing section) Total cash disbursements Cash excess (deficiency) Financing or (Investing) Cash balance. November 30, 20XX $ 5.000 You will learn the most by working the budget yourself without using the check figures until you are finished. Lesson 9b Cash Budget Problem Some Company Cash Budget Given Information For the Year Ended December 31, 2020 Some Comparty has asked you to prepare a cash budget for the year 2020 using the following information: Projected cash balance at January 1 50,000 Cash balance desired December 31 65,000 Projected sales by quarter (collected 70% in the quarter of sale and 20% in the quarter after sale, with the remaining 10% uncollectible): Accounts recievable from 4th quarter 2019 (of which 20,000 is collectible and 10,000 is uncollectible) 30,000 Sales Quarter 1 145,000 Sales Quarter 2 250,000 Sales Quarter 3 160,000 Sales Quarter 4 240,000 Projected 2020 sale of excess land Original cost Accumulated depreciation Book value 40,000 Cash expected to be received 75.000 Gain on sale expected 35,000 Expected federal income tax refind from 2020 correction of error on 2018 tax return 14,000 Projected 2020 transactions, to be paid in 2020, unless otherwise noted Purchases of merchandise inventory 410.000 Operating expenses: Sales and office salaries 121,000 Office utilities 9,000 Insurance expense (taken from Prepaid Insurance) 6,500 Depreciation of building and equipment 55,000 Amortization of copyright 15,000 Purchases of office equipment 20,000 40,000 Cash dividend (dedared in December 2020: to be paid in January 2021 28,000 Currently, the company has loans of $250,000 taken out two years ago at 10% interest Interest is due quarterly on March 31, June 30. September 30 and December