Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Using the following information based on expected sales to forecast the monthly cash collections, accounts receivable balance, monthly cash disbursements, net cash flows, cash surplus

Using the following information based on expected sales to forecast the monthly cash collections, accounts receivable balance, monthly cash disbursements, net cash flows, cash surplus / deficit, and short term debt (if any) at the end of each month in the fourth quarter of 2016 (October December 2016). Do not allow your firm to have a cash balance below the minimum cash balance and only borrow what you need.

a. In September 2016 credit sales were $800,000.

b. The firms total credit sales in 2015 were $7,300,000. The firm's accounts receivable balance on December 31, 2014 was $100,000. The firm's accounts receivable balance on December 31, 2015 was $140,000.

c. Expected sales in October are $50,000, expected sales in November are $100,000, and expected sales in December are $400,000. All sales are made on credit.

d. Accounts payable are 60% of sales

e. Operating expenses are 10% of sales

f. The firm plans to purchase equipment in October costing $750,000

g. Beginning Cash Balance = $250,000

h. Minimum Cash Balance = $15,000

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

What is the firm's accounts receivable period?

What is the firm's total cash collections for the month of October 2016?

What is the firm's total cash collections for the month of November 2016?

What is the firm's total cash collections for the month of December 2016?

What is the firm's total cash disbursements for the month of October 2016?

What is the firm's total cash disbursements for the month of November 2016?

What is the firm's total cash disbursements for the month of December 2016?

What is the firm's short term debt at the end of October 2016?

What is the firm's short term debt at the end of November 2016?

What is the firm's short term debt at the end of December 2016?

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Software Reviews And Audits A How To Guide For Project Staff

Authors: Dr David Tuffley

1st Edition

1461130468, 978-1461130468

More Books

Students also viewed these Accounting questions