Question: Previously correct Use below case to answer questions 1-8. The Itsar Products Company has made the following monthly estimates of cash receipts and cash disbursements

Previously correct

Use below case to answer questions 1-8. The Itsar Products Company has made the following monthly estimates of cash receipts and cash disbursements when preparing cash budgets for the next twelve months. Itsar Products has beginning cash on hand of $10,000 and wants to maintain this minimum cash level throughout the next year.

Cash Cash

Month Receipts Disbursements

January $100,000 $100,000

February $110,000 $90,000

March $80,000 $110,000

April $100,000 $150,000

May $120,000 $180,000

June $160,000 $180,000

July $200,000 $180,000

August $250,000 $180,000

September $250,000 $150,000

October $200,000 $110,000

November $140,000 $100,000

December $100,000 $100,000

Will Itsar Products have a cash need during the next year? Type in Yes/No

_______

Question 2 (0.125 points)

Retake question
Question 2 options:
If Itsar Products has a cash need, indicate the month when the need will begin?

Question 3 (0.125 points)

Retake question
Question 3 options:
What is the net amount of cash needed in the above month? No commas, no decimal places.

Question 4 (0.125 points)

Retake question
Question 4 options:
Determine the month when the maximum need will occur?

Question 5 (0.125 points)

Retake question
Question 5 options:
Determine the amount when the maximum need will occur

Question 6 (0.125 points)

Retake question
Question 6 options:
Which month of the next year the cumulative cash need (if any) can be repaid?

Question 7 (0.125 points)

Retake question
Question 7 options:
What is the cash surplus amount in the above month?

Question 8 (0.125 points)

Retake question
Question 8 options:
What is the cash need/surplus by the next year end? Use bracket for negative values, no commas, no decimal places

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!