DO THIS IN EXCEL ONLY AND SHOW THE FORMULAS. IF COMPLETE I WILL UPVOTE THANK YOU Cash Budget ActivityCash ReceiptsLess: Cash DisbursementsNet: Cash FlowAdd: Beginning CashEnding Cash BalanceLess:Minimum Cash BalanceExcess Cash/Balance Required Total FinancingJan2,000,000.00850,000.00650,000.00500,000.00Feb2,500,000.001,600,000.001,800,000.00500,000.00MarApr2,200,000.00 1,500,000.00950,000.00 1,800,000.002,700,000.00500,000.003,950,000.00500,000.00Using Excel spreadsheets, compute for the Net Cash Flow, Ending Cash Balance and Excess/Balance RequiredFor January, February, March and April.

Cash budget is the statement which is prepared to forecast the future cash receipts and payments of…

Cash Budget Activity Cash Receipts Less: Cash Disbursements Net: Cash Flow Add: Beginning Cash Ending Cash Balance Less:Minimum Cash Balance Excess Cash/Balance Required Total Financing Jan 2,000,000.00 850,000.00 650,000.00 500,000.00 Feb Mar 2,500,000.00 2,200,000.00 1,600,000.00 950,000.00 1,800,000.00 2,700,000.00 3,950,000.00 500,000.00 Apr 1,500,000.00 1,800,000.00 500,000.00 500,000.00 Using Excel spreadsheets, compute for the Net Cash Flow, Ending Cash Balance and Excess/Balance Required For January, February, March and April.

Cash Budget Activity Cash Receipts Less: Cash Disbursements Net: Cash Flow Add: Beginning Cash Ending Cash Balance Less:Minimum Cash Balance Excess Cash/Balance Required Total Financing Jan 2,000,000.00 850,000.00 650,000.00 500,000.00 Feb Mar 2,500,000.00 2,200,000.00 1,600,000.00 950,000.00 1,800,000.00 2,700,000.00 3,950,000.00 500,000.00 Apr 1,500,000.00 1,800,000.00 500,000.00 500,000.00 Using Excel spreadsheets, compute for the Net Cash Flow, Ending Cash Balance and Excess/Balance Required For January, February, March and April.

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Data Year 2 Quarter Year 3 Quarter 1 2 3 4 1 2 Budgeted unit sales 40,000 60,000 100,000 50,000 70,000 80,000 • Selling price per unit • Accounts receivable, beginning balance • Sales collected in the quarter sales are made • Sales collected in the quarter after sales are made • Desired ending finished goods inventory is • Finished goods inventory, beginning • Raw materials required to produce one unit • Desired ending inventory of raw materials is • Raw materials inventory, beginning • Raw material costs • Raw materials purchases are paid and • Accounts payable for raw materials, beginning balance $12 per unit $65,000 75% 25% 30% of the budgeted unit sales of the next quarter 12,000 units 5 pounds 10% of the next quarter's production needs 23,000 pounds $0.80 per pound 60% in the quarter the purchases are made 40% in the quarter following purchase $81,500 •Direct labor cost per hour •Direct labor hour per unit $15 per hour 0.2 hour per unit $2 per hour $60,000 •Variable MOH rate…
Hello - Where does the opening balance of cash come from (how is it derived) in Step 3. Preparing a Cash Budget? (see included picture. THANK YOU!! pz
f. PROBLEM 8-29 Completing a Master Budget LOB-2, LOB-4, LOB-7, LOB-B, LOB-9, LOB-10 The following data relate to the operations of Shilow Company, a wholesale distributor of con- sumer goods: g. h. b. Actual and budgeted sales data: a. The gross margin is 25% of sales. c. d. e. One-half of a month's inventory purchases is paid for in the month of purchase; the other half is paid for in the following month. The accounts payable at March 31 are the result of March purchases of inventory. Monthly expenses are as follows: commissions, 12% of sales; rent, $2,500 per month; other expenses (excluding depreciation), 6% of sales. Assume that these expenses are paid monthly. Depreciation is $900 per month (includes depreciation on new assets). Equipment costing $1.500 will be purchased for cash in April. Management would like to maintain a minimum cash balance of at least $4,000 at the end of each month. The company has an agreement with a local bank that allows the company to borrow in…
23. Which of the following would be included as a cash disbursement on a cash budget? A. Fixed asset purchases B. Depreciation C. Borrowings from a bank D. Both A & C 12
Which is the correct answer? The following information was reported in a cash budget: Beginning cash balance $280,000 Cash payments 494,000 Cash receipts 370,000 Minimum cash balance desired 200,000 How much cash will the company have to borrow in order to meet its required needs? a. $64,000 b. $124,000 c. $0 d. $44,000
a. Beginning cash balance on June 1, P85,300. b. Cash receipts from sales, P519,500. Budgeted cash disbursements for purchases, P274,500. C. d. Budgeted cash disbursements for salaries, P96,300. e. Other budgeted cash expenses, P58,300. f. Cash repayment of bank loan, P33,300. g. Budgeted depreciation expense, P35,300. Use the above information to determine the ending cash balance to be reported on the month ended June 30 cash budget.
Q5 Short term budget is prepared for: Liquidity Working Capital Management All of the above To exercise control over day to day expenditure
7 In preparing a cash budget, what use is made of the number: cost of goods sold as a percentage of sales? Used to convert cost of goods sold numbers into inventory cost numbers to forecast cash collected from customers Used to convert loan borrowing amounts into loan repayment amounts to establish loan schedules Used to convert sales numbers into inventory cost numbers to forecast cash collected from customers O Used to convert sales numbers into inventory cost numbers to forecast cash paid for inventory purchases
are available for the months April through June, during which the loan will be used: a. On April 1, the start of the loan period, the cash balance will be $26,800. Accounts receivable on April 1 will total $193,200, of which $165,600 will be collected during April and $22,080 will be collected during May. The remainder will be uncollectible. b. Past experience shows that 30% of a month's sales are collected in the month of sale, 60% in the month following sale, and 8% in the second month following sale. The other 2% is bad debts that are never collected. Budgeted sales and expenses for the three- month period follow: Sales (all on account) Merchandise purchases Payroll Lease payments Advertising Equipment purchases Depreciation April $360,000 $ 275,000 $32,000 $ 38,400 $ 73,000 $0 $ 15,400 Required 1 Required 2 May $ 582,000 $ 227,000 $ 32,000 $ 38,400 $ 73,000 $0 $ 15,400 c. Merchandise purchases are paid in full during the month following purchase. Accounts payable for merchandise…
Reflection: Write your answer on a separate sheet of paper. Make your own monthly personal cash budget using the General Form of the Cash Budget below. You can itemize your sources of cash and your expenses. CASH BUDGET Week Week Week Week Total 1 2 3 4 Cash Receipts (itemized) XXX Less-Cash Disbursement XXX (itemized) Net Cash Flow XXX Add-Beginning Cash Ending Cash XXX XXX Required Ending Cash Balance XXX Required Total Financing Excess Cash Balance XXX
Which is not a section of the cash budget?A. cash receiptsB. cash disbursementsC. allowance for uncollectible accountsD. financing needs
PREPARE CASH BUDGET FOR YEAR 2021 Use the format if necessary as a guide: Cash Balance, January 1, 2021 Add: Collection from Customers Total Cash Available Less: Disbursements Payments for Material Purchases Direct Labor Factory Overhead Selling and Administrative Expenses Equipment purchase Tax Expenses Dividends Total Disbursements Excess (deficiency) of cash available over disbursements Investing: Long-term Investment Increments Interest Receivable Total Cash used in Investing Financing: Borowwings Repayments Interest Paid Total Financing Cash Balance, Ending