Question

In: Finance

The Alex Thomsen Company is planning to request a line of credit from its bank. The...

The Alex Thomsen Company is planning to request a line of credit from its bank. The following sales forecasts have been made for parts of 2017 and 2018:

May 2017 $150,000
June 150,000
July 300,000
August 450,000
September 600,000
October 300,000
November 300,000
December 75,000
January 2018 150,000

Collection estimates obtained from the credit and collection department are as follows: collected within the month of sale, 5 percent; collected the month following the sale, 80 percent; collected the second month following the sale, 15 percent. Payments for labor and raw materials are typically made during the month following the month in which these costs are incurred. Total labor and raw materials costs are estimated for each month as follows:

May 2017 $75,000
June 75,000
July 105,000
August 735,000
September 255,000
October 195,000
November 135,000
December 75,000

General and administrative salaries will amount to approximately $22,500 a month; lease payments under long-term lease contracts will be $7,500 a month; depreciation charges will be $30,000 a month; miscellaneous expenses will be $2,250 a month; income tax payments of $52,500 will be due in both September and December; and a progress payment of $150,000 on a new research laboratory must be paid in October. Cash on hand on July 1 will amount to $110,000 and a minimum cash balance of $75,000 will be maintained through-out the cash budget period.

A. Prepare a cash budget for the last six months of 2017 with an estimate of required financing (or excess funds).

Solutions

Expert Solution


Related Solutions

James Buchanan Orthotics and Prosthetics is planning to request a line of credit from its bank....
James Buchanan Orthotics and Prosthetics is planning to request a line of credit from its bank. The company has produced sales estimates, and these appear in the worksheet below. Collection estimates are as follows: 10 percent within the month of sale, 75 percent in the month following the sale, and 15 percent in the second month following the sale. Labor and supplies estimates also appear in the worksheet below. Payments for labor and supplies are typically made during the month...
James Buchanan Orthotics and Prosthetics is planning to request a line of credit from its bank....
James Buchanan Orthotics and Prosthetics is planning to request a line of credit from its bank. The company has produced sales estimates, and these appear in the worksheet below. Collection estimates are as follows: 10 percent within the month of sale, 75 percent in the month following the sale, and 15 percent in the second month following the sale. Labor and supplies estimates also appear in the worksheet below. Payments for labor and supplies are typically made during the month...
Helen Bowers, owner of Helen's Fashion Designs, is planning to request a line of credit from...
Helen Bowers, owner of Helen's Fashion Designs, is planning to request a line of credit from her bank. She has estimated the following sales forecasts for the firm for parts of 2015 and 2016: 2015: May $180,000 June 180,000 July 360,000 August 540,000 September 720,000 October 360,000 November 360,000 December 90,000 2016: January 180,000 Estimates regarding payments obtained from the credit department are as follows: collected within the month of sale, 10%; collected the month following the sale, 75%; collected...
assume Alex borrowed $280 on his personal line of credit credit. interest charge at a rate...
assume Alex borrowed $280 on his personal line of credit credit. interest charge at a rate of 13% but calculated on a daily basis Alex is required to pay a minimum of 5% of the remaining loan balance every month. what would be Alex's first monthly loan payment assume a 30 day month and a 365 days a year. round your answer to 2 decimal places
We have a line of credit with a local bank that our company uses for purchasing...
We have a line of credit with a local bank that our company uses for purchasing inventory. Suppose I use this credit source to buy a new motorcycle for my personal use without the bank's knowledge. Which of the following problems describes this situation? A. Securities fraud B. Tax evasion C. Adverse selection D. Moral hazard
CASH BUDGETING Helen Bowers, owner of Helen's Fashion Designs, is planning to request a line of...
CASH BUDGETING Helen Bowers, owner of Helen's Fashion Designs, is planning to request a line of credit from her bank. She has estimated the following sales forecasts for the firm for parts of 2016 and 2017: May 2016 $186,000 June 186,000 July 372,000 August 540,000 September 720,000 October 360,000 November 360,000 December 90,000 January 2017 180,000 Estimates regarding payments obtained from the credit department are as follows: collected within the month of sale, 10%; collected the month following the sale,...
CASH BUDGETING Helen Bowers, owner of Helen’s Fashion Designs, is planning to request a line of...
CASH BUDGETING Helen Bowers, owner of Helen’s Fashion Designs, is planning to request a line of credit from her bank. She has estimated the following sales forecasts for the firm for parts of 2019 and 2020: May 2019 $180,000 June 180,000 July 360,000 August 540,000 September 720,000 October 360,000 November 360,000 December 90,000 January 2020 180,000 Estimates regarding payments obtained from the credit department are as follows: collected within the month of sale, 10%; collected the month following the sale,...
CASH BUDGETING Helen Bowers, owner of Helen's Fashion Designs, is planning to request a line of...
CASH BUDGETING Helen Bowers, owner of Helen's Fashion Designs, is planning to request a line of credit from her bank. She has estimated the following sales forecasts for the firm for parts of 2016 and 2017: May 2016 $186,000 June 186,000 July 372,000 August 540,000 September 720,000 October 360,000 November 360,000 December 90,000 January 2017 180,000 Estimates regarding payments obtained from the credit department are as follows: collected within the month of sale, 10%; collected the month following the sale,...
Chapter 15 Problem 2 James Buchanan Orthotics and Prosthetics is planning to request a line of...
Chapter 15 Problem 2 James Buchanan Orthotics and Prosthetics is planning to request a line of credit from its bank. The company has produced sales estimates, and these appear in the worksheet below. Collection estimates are as follows: 10 percent within the month of sale, 75 percent in the month following the sale, and 15 percent in the second month following the sale. Labor and supplies estimates also appear in the worksheet below. Payments for labor and supplies are typically...
A firm has established a revolving line of credit for $900,000 with a bank at a...
A firm has established a revolving line of credit for $900,000 with a bank at a rate of prime plus 2%. There is an annual fee of 1/2% on any unused funds. Interest is discounted on loans. Prime was 5% when the agreement was made. Assume the firm decides to take down the line for $500,000 for 60 days when the prime is at 6%. What is the effective annual rate?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT