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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started