Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Auditing Leadership The Professional And Leadership Skills You Need

Authors: Brian D. Kush

1st Edition

0470450010, 9780470450017

More Books

Students also viewed these Accounting questions

Question

What is productivity measurement?

Answered: 1 week ago