Using the following information based on expected sales to forecast the monthly cash collections, accounts receivable...

Using the following information based on expected sales to forecast the monthly cash collections, accounts receivable balance, monthly cash disbursements, net cash flows, and cash surplus / deficit at the end of each month in the third quarter of 2018 (July - September 2018). Do not allow your firm to have a cash balance below the minimum cash balance and only borrow what you need.

a. In June 2018 credit sales were $50,000.

b. The firm’s total sales in 2017 were $1,825,000. The firm's accounts receivable balance on December 31, 2016 was $45,000. The firm's accounts receivable balance on December 31, 2017 was $75,000.

c. Accounts payable are 50% of sales

d. Operating expenses are 15% of sales

e. The firm plans to purchase equipment in July costing $250,000.

f. Beginning Cash Balance = $25,000

g. Minimum Cash Balance = $5,000

h. Assume there is an annual interest rate of 18% on short term debt and that the firm starts with no short term borrowing.

i. Sales are expected to be $60,000 for July 2018, $400,000 for August 2018, and $100,000 for September 2018.

For this question i need to know: (explanations would be nice, sorry for posting more than one question, but they all go hand in hand)

Firm's Accounts Receivable Turnover
Firm's Accounts Receivable Period
Firm's accounts receivable balance at the beginning of July 2018
Firm's total cash collections for the month of July 2018?
Firm's total cash collections for the month of August 2018?
Firm's total cash collections for the month of September 2018?
Firm's total cash disbursements for the month of July 2018?
Firm's total cash disbursements for the month of August 2018?
?Firm's total cash dispursements for the month of September 2018?
Firm's short term debt at the end of July 2018?
?Firm's short term debt at the end of August 2018?
Firm's short term debt at the end of September 2018?

Solutions

Expert Solution

jeff jeffy answered 1 year ago

Next > < Previous

Related Solutions

cash collections of accounts receivable will increase and decrease _ 1) accounts payable , accounts...

cash collections of accounts receivable will increase ____ and decrease _____ 1) accounts payable , accounts receivable 2) accounts receivable, accounts payable 3) cash, accounts receivable 4) cast, accounts payable when developring cost functions , which of the following is false 1) the cost funtion must be believable 2) the cost function does not have to be reliable 3) personal observations of cost and activities provide the best evidence of a plausible relationship between a cost and its cost driver...

If ending accounts receivable exceeds the beginning accounts receivable: A. cash collections during-the period exceed the...

If ending accounts receivable exceeds the beginning accounts receivable: A. cash collections during-the period exceed the amount of revenue earned. B. net Income for the period is less than the amount of cash basis income. C. no cash was collected during the period. D. cash collections during the year are less than the amount of revenue earned.

The following information is available for Quality Book Sales' sales on account and accounts receivable: Accounts...

The following information is available for Quality Book Sales' sales on account and accounts receivable: Accounts receivable balance, January 1, Year 2 $ 125,900 Allowance for doubtful accounts, January 1, Year 2 3,520 Sales on account, Year 2 812,740 Collection on accounts receivable, Year 2 844,776 After several collection attempts, Quality Book Sales's wrote off $2,520 of accounts that could not be collected. Quality Book Sales estimates that 1.25 percent of sales on account will be uncollectible. Required a. Compute...

The following information is available for Quality Book Sales’ sales on account and accounts receivable: Accounts...

The following information is available for Quality Book Sales’ sales on account and accounts receivable: Accounts receivable balance, January 1, 2016 $ 79,500 Allowance for doubtful accounts, January 1, 2016 4,910 Sales on account, 2016 560,000 Collection on accounts receivable, 2016 566,000 After several collection attempts, Quality Book Sales wrote off $2,960 of accounts that could not be collected. Quality Book Sales estimates that 5 percent of the ending accounts receivable balance will be uncollectible. Required: a. Compute the following...

Schedule of Cash Collections on Accounts Receivable and Cash Budget Roybal Inc. sells all of its...

Schedule of Cash Collections on Accounts Receivable and Cash Budget Roybal Inc. sells all of its product on account. Roybal has the following accounts receivable payment experience: Percent paid in the month of sale 20 Percent paid in the month after the sale 55 Percent paid in the second month after the sale 23 To encourage payment in the month of sale, Roybal gives a 2% cash discount. Roybal's anticipated sales for the next few months are as follows: April...

Schedule of Cash Collections of Accounts Receivable OfficeMart Inc. has "cash and carry" customers and credit...

Schedule of Cash Collections of Accounts Receivable OfficeMart Inc. has "cash and carry" customers and credit customers. OfficeMart estimates that 30% of monthly sales are to cash customers, while the remaining sales are to credit customers. Of the credit customers, 25% pay their accounts in the month of sale, while the remaining 75% pay their accounts in the month following the month of sale. Projected sales for the next three months are as follows: October $121,000 November 151,000 December 221,000...

Schedule of Cash Collections of Accounts Receivable OfficeMart Inc. has "cash and carry" customers and credit...

Schedule of Cash Collections of Accounts Receivable OfficeMart Inc. has "cash and carry" customers and credit customers. OfficeMart estimates that 25% of monthly sales are to cash customers, while the remaining sales are to credit customers. Of the credit customers, 30% pay their accounts in the month of sale, while the remaining 70% pay their accounts in the month following the month of sale. Projected sales for the next three months are as follows: October $58,000 November 65,000 December 72,000...

Schedule of Cash Collections of Accounts Receivable OfficeMart Inc. has "cash and carry" customers and credit...

Schedule of Cash Collections of Accounts Receivable OfficeMart Inc. has "cash and carry" customers and credit customers. OfficeMart estimates that 20% of monthly sales are to cash customers, while the remaining sales are to credit customers. Of the credit customers, 25% pay their accounts in the month of sale, while the remaining 75% pay their accounts in the month following the month of sale. Projected sales for the next three months are as follows: October $115,000 November 144,000 December 210,000...

Schedule of Cash Collections of Accounts Receivable OfficeMart Inc. has "cash and carry" customers and credit...

Schedule of Cash Collections of Accounts Receivable OfficeMart Inc. has "cash and carry" customers and credit customers. OfficeMart estimates that 25% of monthly sales are to cash customers, while the remaining sales are to credit customers. Of the credit customers, 20% pay their accounts in the month of sale, while the remaining 80% pay their accounts in the month following the month of sale. Projected sales for the next three months are as follows: October $118,000 November 148,000 December 216,000...

Schedule of Cash Collections of Accounts Receivable OfficeMart Inc. has "cash and carry" customers and credit...

Schedule of Cash Collections of Accounts Receivable OfficeMart Inc. has "cash and carry" customers and credit customers. OfficeMart estimates that 25% of monthly sales are to cash customers, while the remaining sales are to credit customers. Of the credit customers, 25% pay their accounts in the month of sale, while the remaining 75% pay their accounts in the month following the month of sale. Projected sales for the next three months are as follows: October $124,000 November 155,000 December 227,000...

Subjects