Question

Question 3 Digital Solutions Inc is preparing its cash collection summary for 2018. Digital ended 2017...

Question 3

Digital Solutions Inc is preparing its cash collection summary for 2018. Digital ended 2017 with cash of

$81 million, and managers need to keep a cash balance of at least $75 million for operations.

Collections from customers are expected to total $11,284 million during 2018, and payments for the cost of services should reach $6,166 million. Operating expense payments are budgeted at $2,543.

Homework Answers

Answer #1

Answer:

Cash budget is the following:

Particulars Amount Amount
Cash balance (beginning) $ 81
Add :Cash receipts
Collection from customer $ 11,284
Total $ 81+ $ 11,284 = $ 11,365 $ 11,365
Less :Cash payments
cash services $ 6,166
Operating expense $ 2,543
Total $ 6,166 + $ 2,543=$ 8,709 $ 8,709
Excess or (deficiency) cash availabe $ 11,365 - $ 8,709= $ 2,658 $ 2,658
Borrrow $ 0
Repayment $ 0

Total cash balance

$ 2,658
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Question 3 Digital Solutions Inc is preparing its cash collection summary for 2018. Digital ended 2017...
Question 3 Digital Solutions Inc is preparing its cash collection summary for 2018. Digital ended 2017 with cash of $81 million, and managers need to keep a cash balance of at least $75 million for operations.    Collections from customers are expected to total $11,284 million during 2018, and payments for the cost of services should reach $6,166 million. Operating expense payments are budgeted at $2,543.    During 2018, Digital expects to invest $1,825 million in new equipment and sell...
Digital Solutions Inc is preparing its cash collection summary for 2018. Digital ended 2017 with cash...
Digital Solutions Inc is preparing its cash collection summary for 2018. Digital ended 2017 with cash of $81 million, and managers need to keep a cash balance of at least $75 million for operations. Collections from customers are expected to total $11,284 million during 2018, and payments for the cost of services should reach $6,166 million. Operating expense payments are budgeted at $2,543. During 2018, Digital expects to invest $1,825 million in new equipment and sell older assets for $115...
Built-Tight is preparing its master budget for the quarter ended September 30, 2017. Budgeted sales and...
Built-Tight is preparing its master budget for the quarter ended September 30, 2017. Budgeted sales and cash payments for product costs for the quarter follow: July August September Budgeted sales $ 62,500 $ 78,500 $ 49,500 Budgeted cash payments for Direct materials 16,460 13,740 14,060 Direct labor 4,340 3,660 3,740 Factory overhead 20,500 17,100 17,500 Sales are 25% cash and 75% on credit. All credit sales are collected in the month following the sale. The June 30 balance sheet includes...
MONTGOMERY INC. Comparative Balance Sheets December 31, 2018 and 2017 2018 2017 Assets Cash $ 55,900...
MONTGOMERY INC. Comparative Balance Sheets December 31, 2018 and 2017 2018 2017 Assets Cash $ 55,900 $ 56,300 Accounts receivable, net 13,800 16,800 Inventory 123,700 97,100 Total current assets 193,400 170,200 Equipment 68,500 57,500 Accum. depreciation—Equipment (31,000 ) (21,200 ) Total assets $ 230,900 $ 206,500 Liabilities and Equity Accounts payable $ 33,000 $ 35,200 Salaries payable 600 800 Total current liabilities 33,600 36,000 Equity Common stock, no par value 165,900 153,100 Retained earnings 31,400 17,400 Total liabilities and equity...
Schedule of Cash Payments for a Service Company EastGate Physical Therapy Inc. is planning its cash...
Schedule of Cash Payments for a Service Company EastGate Physical Therapy Inc. is planning its cash payments for operations for the first quarter (January–March). The Accrued Expenses Payable balance on January 1 is $34,400. The budgeted expenses for the next three months are as follows: January February March Salaries $79,100 $96,300 $106,600 Utilities 6,500 7,200 8,600 Other operating expenses 60,900 66,400 73,100 Total $146,500 $169,900 $188,300 Other operating expenses include $4,300 of monthly depreciation expense and $1,000 of monthly insurance...
Built-Tight is preparing its master budget for the quarter ended September 30, 2017. Budgeted sales and...
Built-Tight is preparing its master budget for the quarter ended September 30, 2017. Budgeted sales and cash payments for product costs for the quarter follow: July August September Budgeted sales $ 60,000 $ 76,000 $ 52,000 Budgeted cash payments for Direct materials 16,960 14,240 14,560 Direct labor 4,840 4,160 4,240 Factory overhead 21,000 17,600 18,000 Sales are 30% cash and 70% on credit. All credit sales are collected in the month following the sale. The June 30 balance sheet includes...
1) Isaac Inc. began operations in January 2018. For certain of its property sales, Isaac recognizes...
1) Isaac Inc. began operations in January 2018. For certain of its property sales, Isaac recognizes income in the period of sale for financial reporting purposes. However, for income tax purposes, Isaac recognizes income when it collects cash from the buyer's installment payments. In 2018, Isaac had $600 million in sales of this type. Scheduled collections for these sales are as follows: 2018                                                 $ 60 million 2019                                                 120 million 2020                                                 120 million 2021                                                 150 million 2022                                                ...
EastGate Physical Therapy Inc. is planning its cash payments for operations for the first quarter (January–March)....
EastGate Physical Therapy Inc. is planning its cash payments for operations for the first quarter (January–March). The Accrued Expenses Payable balance on January 1 is $29,500. The budgeted expenses for the next three months are as follows: January February March Salaries $67,900 $82,600 $91,500 Utilities 5,600 6,200 7,400 Other operating expenses 51,600 56,200 61,900 Total $125,100 $145,000 $160,800 Other operating expenses include $3,700 of monthly depreciation expense and $800 of monthly insurance expense that was prepaid for the year on...
QS 12-19 Indirect: Preparing statement of cash flows LO P1, P2, P3 MONTGOMERY INC. Comparative Balance...
QS 12-19 Indirect: Preparing statement of cash flows LO P1, P2, P3 MONTGOMERY INC. Comparative Balance Sheets December 31, 2018 and 2017 2018 2017 Assets Cash $ 58,200 $ 58,100 Accounts receivable, net 18,300 22,300 Inventory 164,100 128,800 Total current assets 240,600 209,200 Equipment 90,900 76,200 Accum. depreciation—Equipment (41,000 ) (28,100 ) Total assets $ 290,500 $ 257,300 Liabilities and Equity Accounts payable $ 43,600 $ 46,600 Salaries payable 900 1,100 Total current liabilities 44,500 47,700 Equity Common stock, no...
EastGate Physical Therapy Inc. is planning its cash payments for operations for the first quarter (January–March)....
EastGate Physical Therapy Inc. is planning its cash payments for operations for the first quarter (January–March). The Accrued Expenses Payable balance on January 1 is $26,800. The budgeted expenses for the next three months are as follows: January February March Salaries $61,600 $75,000 $83,100 Utilities 5,100 5,600 6,700 Other operating expenses 46,800 51,000 56,200 Total $113,500 $131,600 $146,000 Other operating expenses include $3,400 of monthly depreciation expense and $800 of monthly insurance expense that was prepaid for the year on...