Question

In: Finance

Finish the following Cash Budget CASH BUDGET JAN FEB MAR APRIL MAY JUNE JULY AUG SEPT...

Finish the following Cash Budget

CASH BUDGET
JAN FEB MAR APRIL MAY JUNE JULY AUG SEPT OCT NOV DEC
SALES 200,000 230,000 150000 210,000.00 220,000.00 170,000.00 160,000.00 150,000.00 180,000.00 210,000.00 220,000.00 210,000.00
COLLECTIONS:
No cash Sales
30 days 50%
60 days 50%
TOTAL CASH RECEIPTS
CASH DISBURSEMENTS
SUPPLIES 70%
PAYABLES/SUPPLIES paid next month(in 30 days)
SALARIES/OVER monthly 40000
INTEREST monthly 1000
DIVIDENDS monthly 1000
TAXES quarterly 1200
TOTAL DISBURSEMENT 42000 0 1200 0 0 0 0 0 0 0 0 0
NET CHANGE IN CASH
BEGINNING CASH 10000 0 0 0 0 0 0 0 0 0 0 0
FINANCING NEEDED 0 0 0 0 0 0 0 0 0 0 0 0
ENDING CASH
starting loan balance
CUMMULATIVE BORROWING 100,000

Solutions

Expert Solution

JAN FEB MAR APRIL MAY JUNE JULY AUG SEPT OCT NOV DEC
SALES 200,000 230,000 150000 210,000.00 220,000.00 170,000.00 160,000.00 150,000.00 180,000.00 210,000.00 220,000.00 210,000.00
COLLECTIONS:
30 days 50% 100000 115000 75000 105000 110000 85000 80000 75000 90000 105000
60 days 50% 100000 115000 75000 105000 110000 85000 80000 75000 90000 105000
TOTAL CASH RECEIPTS 100000 215000 190000 180000 215000 195000 165000 155000 165000 195000 105000
SUPPLIES 70%
SUPPLIES paid next month 140000 161000 105000 147000 154000 119000 112000 105000 126000 147000 154000
SALARIES monthly 40000 40000 40000 40000 40000 40000 40000 40000 40000 40000 40000 40000
INTEREST monthly 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000
DIVIDENDS monthly 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000
TAXES quarterly 1200 1200 1200 1200
TOTAL 42000 182000 204200 147000 189000 198000 161000 154000 148200 168000 189000 198200
NET CHANGE IN CASH (42000) (82000) 10800 43000 (9000) 17000 34000 11000 6800 (3000) 6000 (93200)
FINANCING NEEDED (32000) (114000) (103200) (60200) (69200) (52200) (18200) (7200) (400) (3400) 2600 (90600)
CUMMULATIVE BORROWING 100,000

Related Solutions

Cash Budget - The following information applies to Company A: Jan. Feb. Mar. Apr. Miscellanous cash...
Cash Budget - The following information applies to Company A: Jan. Feb. Mar. Apr. Miscellanous cash payments $25,000 $30,000 $22,000 $32,000 Nov. Dec. Jan. Feb. Mar. Apr. Sales $200,000 $325,000 $250,000 $240,000 $260,000 $270,000 Assume Company A collects 20% of its sales in the month of the sale, 50% the next month, 25% the following month, and 5% is never collected. Dec. Jan. Feb. Mar. Apr. Purchases $210,000 $150,000 $170,000 $180,000 $190,000 Assume Company A makes cash payments of 40%...
AVERAGE EMPLOYMENT LEVELS FOR SEAT OF KNOWLEDGE    jan feb mar apr may jun jul aug...
AVERAGE EMPLOYMENT LEVELS FOR SEAT OF KNOWLEDGE    jan feb mar apr may jun jul aug sep oct nov dec machine/fabricating 47 47 50 49 51 51 52 51 51 50 52 53 shipping/recieving 24 23 25 25 25 23 24 24 24 24 24 24 welding 30 31 34 34 33 32 32 33 33 38 43 43 paint/assembly 26 30 30 30 29 36 34 33 36 37 36 35 TURNOVER Date            Department Reason 04/12                Machining/Fabricating               Other...
Jan 523.9 Feb 510.23 March 545.65 April 514.23 May 550.71 June 505.34 July 525.34 August 600...
Jan 523.9 Feb 510.23 March 545.65 April 514.23 May 550.71 June 505.34 July 525.34 August 600 Sept. 569.42 October 500.2 Novem. 533.12 December 507.11 What percentage of your bills are within two standard deviations of the mean?
​Tuscarora, Inc., a merchandising​ company, has the following budgeted​ figures: Jan Feb Mar April Sales ​$57,300...
​Tuscarora, Inc., a merchandising​ company, has the following budgeted​ figures: Jan Feb Mar April Sales ​$57,300 ​$60,000 ​$83,000 ​$98,000 Cost of goods sold ​50% of sales Required ending inventory ​$10,000 +​ 30% of next​ month's sales Inventory on hand on Jan 1 ​$30,000 Calculate the budgeted purchases for the month of January. A. ​$28,000 B. ​$26,650 C. ​$650 D. ​$56,650
Tuscarora, Inc., a merchandising​ company, has the following budgeted​ figures: Jan Feb Mar April Sales $54,000.00...
Tuscarora, Inc., a merchandising​ company, has the following budgeted​ figures: Jan Feb Mar April Sales $54,000.00 $69,000.00 $86,000.00 $95,000.00 Cost of goods sold 50​% of sales Required ending inventory $10,000.00 ​+ 20​% of next​ month's sales Inventory on hand on Jan 1 $27,500.00 Calculate the budgeted purchases for the month of January. A. $50,800.00 B. $23,300.00 C. $3,200.00 D. $23,800.00 Nyree Company is preparing its budget for the third quarter. The cash balance on June 30 was $32,000.00. Additional budgeted...
Using basic Python 2. Given the following dictionary: speed ={'jan':47, 'feb':52, 'march':47, 'April':44, 'May':52, 'June':53, 'july':54,...
Using basic Python 2. Given the following dictionary: speed ={'jan':47, 'feb':52, 'march':47, 'April':44, 'May':52, 'June':53, 'july':54, 'Aug':44, 'Sept':54} Get all values from the dictionary and add it to a new list called speedList, but don’t add duplicates values to the new list. Your code should print out: speedList [47, 52, 44, 53, 54] 3. Given the following list of numbers: numberList = [10, 20, 33, 46, 55, 61, 70, 88, 95] First iterate the list and print only those numbers,...
Dynamic Futon forecasts the following purchases from suppliers: Jan. Feb. Mar. Apr. May Jun. Value of...
Dynamic Futon forecasts the following purchases from suppliers: Jan. Feb. Mar. Apr. May Jun. Value of goods ($ millions) 32 28 25 22 20 20 a. Forty percent of goods are supplied cash-on-delivery. The remainder are paid with an average delay of one month. If Dynamic Futon starts the year with payables of $22 million, what is the forecasted level of payables for each month? (Do not round intermediate calculations. Enter your answers in millions rounded to 1 decimal place.)...
Zira Co. reports the following production budget for the next four months. April May June July...
Zira Co. reports the following production budget for the next four months. April May June July Production (units) 654 695 687 667 Each finished unit requires five pounds of raw materials and the company wants to end each month with raw materials inventory equal to 30% of next month’s production needs. Beginning raw materials inventory for April was 981 pounds. Assume direct materials cost $3 per pound. Prepare a direct materials budget for April, May, and June. (Round your intermediate...
Cash Budget Problem: Francesca’s Fragrances, Inc. Prepare Cash Budget for April, May, June 2019 Follow the...
Cash Budget Problem: Francesca’s Fragrances, Inc. Prepare Cash Budget for April, May, June 2019 Follow the following to prepare the budget: 1.         Real Sales 2019:         January                        - $200,000                                                 February                      - $400,000                                                 March                          - $350,000             Projected for 2019:     April                            - $500,000                                                 May                             - $400,000                                                 June                             - $450,000             Sales Payment History:           10% cash                                                             30% Accts. Rec. – collected n/30 days                                                             60% Accts. Rec. – collected...
Cash Disbursements Budget - Company A reports the following purchases and payments information: Dec. Jan. Feb....
Cash Disbursements Budget - Company A reports the following purchases and payments information: Dec. Jan. Feb. Mar. Apr. Purchases . . . $210,000 $150,000 $170,000 $180,000 $190,000 (a) Assume Company A makes cash payments of 40% of its purchases in the month of the purchase and pays the remaining 60% the following month. Compute the company's cash payments for each month from January through April. (Include formulas used to solve problem). Cash Disbursements Budget - Company B reports the following...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT