A company requires its services to make a cash budget for the quarter from March to...
A company requires its services to make a cash budget for the quarter from March to May, for which it provides information on the projected income and expenses.
|
March |
April |
May |
|||
|
Cash Inflows |
$430,000 |
$150,000 |
$350,000 |
||
|
Cash payments |
$380,000 |
$260,000 |
$255,000 |
- The company policy states to have a minimum of $20,000 and a maximum of $22,000 in cash at the end of each month. If the surplus exceeds the maximum amount, then it will go to marketable securities. Loan can be paid in full or in part payments.
- You are asked to prepare a monthly Forecasted cash flow statement, calculating how much the company will borrow in case of losses, or how much should be invested in marketable securities in the event of surpluses
- The beginning cash balance is $ 20,000
How much will you pay to Bank loans in May?
Homework Answers
SEE THE IMAGE. ANY DOUBTS,
FEEL FREE TO ASK. THUMBS UP PLEASE
Add Answer to:
A company requires its services to make a cash budget for the
quarter from March to...
Jul Kennison, Inc. has prepared its third quarter budget and provided the following data: Aug Sep Cash collections $49,...
Jul Kennison, Inc. has prepared its third quarter budget and provided the following data: Aug Sep Cash collections $49,000 $39,500 $47,100 Cash payments: Purchases of direct materials 28,000 21,800 17,000 Operating expenses 12,300 9,100 11,400 Capital expenditures 13,800 24,700 The cash balance on June 30 is projected to be $4,100. The company has to maintain a minimum cash balance of $5,000 and is authorized to borrow at the end of each month to make up any shortfalls. It may borrow...
I do not know how to find the beginning balance for the 3rd or 4th quarter.....
I do not know how to find the beginning balance for the 3rd or
4th quarter.. i keep getting it wrong. Also how do I find interest
for the 2nd quarter (blank spot where it is supposed to be).
Garden Depot is a retailer that is preparing its budget for the
upcoming fiscal year. Management has prepared the following summary
of its budgeted cash flows:
1st Quarter
2nd Quarter
3rd Quarter
4th Quarter
Total cash receipts
$
230,000
$
380,000...
The company’s beginning cash balance for the upcoming fiscal year will be $20,000. The company requires...
The company’s beginning cash balance for the upcoming fiscal
year will be $20,000. The company requires a minimum cash balance
of $10,000 and may borrow any amount needed from a local bank at a
quarterly interest rate of 3%. The company may borrow any amount at
the beginning of any quarter and may repay its loans, or any part
of its loans, at the end of any quarter. Interest payments are due
on any principal at the time it is...
Garden Depot is a retailer that is preparing its budget for the upcoming fiscal year. Management...
Garden Depot is a retailer that is preparing its budget for the upcoming fiscal year. Management has prepared the following summary of its budgeted cash flows: 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Total cash receipts $ 330,000 $ 450,000 $ 380,000 $ 400,000 Total cash disbursements $ 379,000 $ 349,000 $ 339,000 $ 359,000 The company’s beginning cash balance for the upcoming fiscal year will be $22,000. The company requires a minimum cash balance of $10,000 and may...
Below are the forecasted cash receipts and cash payments for Kaden Company for the first four...
Below are the forecasted cash receipts and cash payments for
Kaden Company for the first four months of the year.
Below are the forecasted cash receipts and cash payments for Kaden Company for the first four months of the year. ***.. January February March April Budgeted cash collections 100,000 75,000 75,000 146,000 127,000 67,000 120,000 Budgeted cash payments: Operating expenses Dividends Equipment purchase Total budgeted cash payments 92,000 20,000 40,000 152,000 127,000 67,000 120,000 On January 1, Kaden Company had...
Carols Chocolate company Carol's Chocolate Company has prepared its third quarter budget and provided the following...
Carols Chocolate company
Carol's Chocolate Company has prepared its third quarter budget and provided the following data: Jul Aug Sep Cash collections $49,000 $39,500 $47,200 Cash payments: Purchases of direct materials 30,000 21,900 18.000 Operating expenses 12.400 8400 1 1,400 Capital expenditures 13,400 24.200 The cash balance on June 30 is projected to be $4000. The company has to maintain a minimum cash balance of $5,000 and is authori borrow at the end of each month to make up any...
Garden Depot is a retailer that is preparing its budget for the upcoming fiscal year. Management...
Garden Depot is a retailer that is preparing its budget for the upcoming fiscal year. Management has prepared the following summary of its budgeted cash flows: 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Total cash receipts $ 350,000 $ 470,000 $ 400,000 $ 420,000 Total cash disbursements $ 393,000 $ 363,000 $ 353,000 $ 373,000 The company’s beginning cash balance for the upcoming fiscal year will be $20,000. The company requires a minimum cash balance of $10,000 and may...
Given the following information, construct the firm's cash budget for the given months and answer the questions. • All sales are for credit and collections occur after 30 days. • An $100,000 Treasury bill matures in March. • Monthly fixed disbursements ar
Given the following information, construct the firm's cash budget for the given months and answer the questions.All sales are for credit and collections occur after 30 days.A $100,000 Treasury bill matures in March.Monthly fixed disbursements are $25,000.Variable disbursements are 40 percent of sales and occur one month prior to sales. (Variable cash disbursements are given for April.)A tax payment of $30,000 is due in April.A payment of $50,000 is to be received in February.The initial cash is $20,000.The minimum required...
Garden Depot is a retailer that is preparing its budget for the upcoming fiscal year. Management has prepared the following summary of its budgeted cash flows:
Garden Depot is a retailer that is preparing its budget for the upcoming fiscal year. Management has prepared the following summary of its budgeted cash flows: The company's beginning cash balance for the upcoming fiscal year will be $20,000. The company requires a minimum cash balance of $10,000 and may borrow any amount needed from a local bank at a quarterly interest rate of 3%. The company may borrow any amount at the beginning of any quarter and may repay its...
question 36 Hutchinson, Inc. provides the following data taken from its third quarter budget: Jul Aug...
question 36
Hutchinson, Inc. provides the following data taken from its third quarter budget: Jul Aug Sep Cash collections $66,000 $42,000 $42,000 Cash payments: Purchases of direct materials 32,000 34,000 25,000 Operating expenses 11,000 20,000 22,000 Capital expenditures 0 34,000 6,000 The cash balance on June 30 is projected to be $13,000. Based on the above data, calculate the shortfall the company is projected to have at the end of August. O A. $34.000 OB. $21,000 OC. $36,000 OD. $10,000
Jul Kennison, Inc. has prepared its third quarter budget and provided the following data: Aug Sep Cash collections $49,000 $39,500 $47,100 Cash payments: Purchases of direct materials 28,000 21,800 17,000 Operating expenses 12,300 9,100 11,400 Capital expenditures 13,800 24,700 The cash balance on June 30 is projected to be $4,100. The company has to maintain a minimum cash balance of $5,000 and is authorized to borrow at the end of each month to make up any shortfalls. It may borrow...
I do not know how to find the beginning balance for the 3rd or
4th quarter.. i keep getting it wrong. Also how do I find interest
for the 2nd quarter (blank spot where it is supposed to be).
Garden Depot is a retailer that is preparing its budget for the
upcoming fiscal year. Management has prepared the following summary
of its budgeted cash flows:
1st Quarter
2nd Quarter
3rd Quarter
4th Quarter
Total cash receipts
$
230,000
$
380,000...
The company’s beginning cash balance for the upcoming fiscal
year will be $20,000. The company requires a minimum cash balance
of $10,000 and may borrow any amount needed from a local bank at a
quarterly interest rate of 3%. The company may borrow any amount at
the beginning of any quarter and may repay its loans, or any part
of its loans, at the end of any quarter. Interest payments are due
on any principal at the time it is...
Below are the forecasted cash receipts and cash payments for
Kaden Company for the first four months of the year.
Below are the forecasted cash receipts and cash payments for Kaden Company for the first four months of the year. ***.. January February March April Budgeted cash collections 100,000 75,000 75,000 146,000 127,000 67,000 120,000 Budgeted cash payments: Operating expenses Dividends Equipment purchase Total budgeted cash payments 92,000 20,000 40,000 152,000 127,000 67,000 120,000 On January 1, Kaden Company had...
Carols Chocolate company
Carol's Chocolate Company has prepared its third quarter budget and provided the following data: Jul Aug Sep Cash collections $49,000 $39,500 $47,200 Cash payments: Purchases of direct materials 30,000 21,900 18.000 Operating expenses 12.400 8400 1 1,400 Capital expenditures 13,400 24.200 The cash balance on June 30 is projected to be $4000. The company has to maintain a minimum cash balance of $5,000 and is authori borrow at the end of each month to make up any...
question 36
Hutchinson, Inc. provides the following data taken from its third quarter budget: Jul Aug Sep Cash collections $66,000 $42,000 $42,000 Cash payments: Purchases of direct materials 32,000 34,000 25,000 Operating expenses 11,000 20,000 22,000 Capital expenditures 0 34,000 6,000 The cash balance on June 30 is projected to be $13,000. Based on the above data, calculate the shortfall the company is projected to have at the end of August. O A. $34.000 OB. $21,000 OC. $36,000 OD. $10,000
Most questions answered within 3 hours.
-
Where is the error in this code sequence?
String s1 = "Hello";
String s2 = "ello";...
asked 11 months ago -
Financial data for Joel de Paris, Inc., for last year
follow:
Joel de Paris, Inc.
Balance...
asked 11 months ago -
Consider this reaction:
Al2(SO4)3 (aq)+ BaCl3
(aq) Al2Cl6 (aq)- +
3BaSO4(s) . What is the...
asked 11 months ago -
Suppose that Savneet is considering increasing her
recent random sample from 20 car rentals to 40...
asked 11 months ago -
Trucks arrive at an unloading terminal at an average rate of 120
per hour.
Trucks arrive...
asked 11 months ago -
Why are methanol and ethanol completely soluble in water while
octanol is not very little soluble....
asked 11 months ago -
A facilities manager at a university reads in a research report
that the mean amount of...
asked 11 months ago -
When the CuSO4 is rehydrated by adding water to the anhydrous
compound, is this an endothermic...
asked 11 months ago -
A ray of sunlight is passing from diamond into crown glass; the
angle of incidence is...
asked 11 months ago -
A block of mass 0.249 kg is placed on top of a light, vertical
spring of...
asked 11 months ago -
how do the kidneys compensate in the presences of acidosis
a) trigger hyperventilate
b) reserve acid...
asked 11 months ago -
Question 501 pts
The rental rate of capital to the firm increases. Which of the
following...
asked 11 months ago