Question: HELP ASAP PLEASE and explain what you are doing in excel Sticking 2U manufactures of syringes used for injections. In late February, they began to

HELP ASAP PLEASE and explain what you are doing in excel

Sticking 2U manufactures of syringes used for injections. In late February, they began to revise their cash budget once news of the COVID-19 vaccination began to circulate. In addition to their regular expenses, they will need to rent additional space to manufacture their syringes. They will pay for extraordinary rental expenses in May ($30,000) and June ($30,000).

March April May June
Total cash receipts from all sales $200,000 $500,000 $550,000 $400,000
Cash disbursements for ordinary purchases and expenses $390,000 $520,000 $530,000 $390,000
Extraordinary Expenses for building Rental $30,000 $30,000

The companys cash balance on February 28, 2021, is expected to be $13,750. The company requires a minimum cash balance of $10,000 and may borrow any amount needed from a local bank at a monthly interest rate of 12%. Because of the potential crisis, the company has an unlimited line of credit. The company must borrow any amount at the beginning of any month and may repay its loans, or any part of its loans, at the end of any month. The company must borrow in multiples of $1,000. Interest payments are due on any principal at the time it is repaid. For simplicity, assume that interest is not compounded.

Prepare a CASH BUDGET for March, April, May, and June (you only need to prepare the cash budget including the financing section.) Upload your Cash Budget IN GOOD FORM (30 POINTS) - If you do not start with a blank spreadsheet, you will receive a Zero.

Indicate the ending cash balance on June 30 in the space below.

Indicate the ending loan balance on June 30 in the space below. (10 POINTS)

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 Accounting Questions!