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.

  

During 2018, Digital expects to invest $1,825 million in new equipment and sell older assets for $115 million. Debt payments scheduled for 2018 will total $597 million. The company forecasts net income of $890 million for 2018 and plans to pay dividends of $338 million.

Prepare Digital Solutions cash balance for 2018. Will the cash receipts and payments leave Digital with the desired ending cash

balance of $75 million, or will the company need additional financing? If it does, how much will it need?

Hint: cash collections - cash payments = ending cash - desired balance = financing (if needed)

Homework Answers

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
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...
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.
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...
Lipton Auto​ Parts, a​ family-owned auto parts​ store, began January with $ 10 comma 600 cash....
Lipton Auto​ Parts, a​ family-owned auto parts​ store, began January with $ 10 comma 600 cash. Management forecasts that collections from credit customers will be $ 11 comma 800 in January and $ 14 comma 500 in February. The store is scheduled to receive $ 6 comma 000 cash on a business note receivable in January. Projected cash payments include inventory purchases ​($ 13 comma 900 in January and $ 13 comma 100 in February​) and selling and administrative expenses...
SweeneySweeney Health Center provides a variety of medical services. The company is preparing its cash budget...
SweeneySweeney Health Center provides a variety of medical services. The company is preparing its cash budget for the upcoming third quarter. The following transactions are expected to​ occur: a. Cash collections from services in​ July, August, and​ September, are projected to be $94,000​, $158,000​, and $127,000 respectively. b. Cash payments for the upcoming third quarter are projected to be $149,000 in​ July, $103,000 in​ August, and $131,000 in September. c. The cash balance as of the first day of the...
BentfieldBentfield Health Center provides a variety of medical services. The company is preparing its cash budget...
BentfieldBentfield Health Center provides a variety of medical services. The company is preparing its cash budget for the upcoming third quarter. The following transactions are expected to occur: LOADING... (Click the icon to view the expected transactions.) Requirement Prepare a combined cash budget for BentfieldBentfield Health Center for the third quarter, with a column for each month and for the quarter total. (If a box is not used in the table leave the box empty; do not enter a zero....
Texas Rex expects the following Cash Receipts in each quarter:                      Q1           &n
Texas Rex expects the following Cash Receipts in each quarter:                      Q1                     Q2                          Q3                          Q4                                               $10,600           $11,850                 $14,775                 $19,625 Texas Rex believes the amount of cash needed for payments on account for raw materials each quarter is:                      Q1                     Q2                          Q3                          Q4                                               $4,594              $5,039                   $6,219                   $6,819 The Cash Budget is critically important to the survival of businesses. It tells management how much cash is available, and shortfalls of cash need to be anticipated and handled through expense reductions...
I ONLY NEED THE INVENTORY PURCHASES BUDGET (C) AND THE CASH BUDGET (G). Hint - not...
I ONLY NEED THE INVENTORY PURCHASES BUDGET (C) AND THE CASH BUDGET (G). Hint - not all the numbers in the two charts just get added across. I'm assuming that is to find the total-qtr. number. Please help! Admire is a retail company that sells specialized gardening products. The company is considering opening a new store on October 1, Year1. As budget coordinator, you have been asked to prepare a master budget for the first 3 months of the company’s...
Webster Corporation is preparing its cash budget for April. The March 31 cash balance is $37,800....
Webster Corporation is preparing its cash budget for April. The March 31 cash balance is $37,800. Cash receipts are expected to be $648,000 and cash payments for purchases are expected to be $612,000. Other cash expenses expected are $27,700 selling and $34,200 general and administrative. The company desires a minimum cash balance at the end of each month of $37,000. If necessary, the company borrows enough cash to meet the minimum using a short-term note. The amount Webster must borrow...
REQUIREMENTS:   1)    Sales Budget   2)    Production Budget Budgets should be for the individual three (3) months of the...
REQUIREMENTS:   1)    Sales Budget   2)    Production Budget Budgets should be for the individual three (3) months of the first quarter of 2019. Include a quarterly total column on the right side. Each budget/requirement should be in a separate tab within one spreadsheet. All pages should be in portrait format using the same font. Use proper rounding and show two (2) decimal places of accuracy on dollar amounts. Round up and show whole amounts on all other figures. (Hint) Excel provides functions for...