Instructions
The document must have the complete budget and show the entire process along with an explanation.
Add a brief explanation of the budget just like what you should do if you were in a meeting with senior management and you were the accountant who was tasked with presenting the budget. Put that explanation on the page below the budget that you have prepared.
Budget in Service Company (Cash Budget)
Edge Soccer Program (Edge) began the year with a cash balance of $10,500. The budget
forecasts that collections from customers owed to the company will be $11,000 in January and
$15,200 in February. The soccer program is also supposed to receive $8,500 in January on a note
receivable from a soccer club that owes Edge for training.
Edge plans to purchase soccer equipment in January and February with cash. The
budgeted amounts of the purchases are $15,600 in January and $14,800 in February. Operating
costs for the business is $2900 per month.
Edge must maintain a minimum cash balance of $10,000 in their bank account at all
times. If the amount in the bank account falls below $10,000, then bank extends credit to Edge
immediately in multiples of $1000. Edge pays back any amounts borrowed each quarter in
payments of $2000 plus 4% interest. The first payment occurs three (3) months after the bank
has extended edge credit.
Requirement
Prepare a cash budget for January and February.
Formulas included. Enter amounts in highlighted areas to complete the budget
Edge Soccer Programs
Cash Budget
For the Two Months Ended February 28
January
Beginning cash balance
Cash receipts from customers
Collection of note receivable
Cash available
Cash payments:
Equipment purchases
Selling and administrative expenses
Total cash payments
Ending cash balance before financing
Minimum cash balance desired
Projected cash excess (deficiency)
Financing:
Borrowing
Total effects of financing
Ending cash balance
$
–
$
$
–
$
–
$
$
–
o complete the budget
grams
et
ed February 28
$
$
February
–
$
$
$
$
$
$
$
–
$
$
$
$
Total
–
–
$
$
$
$
$
$
–
$
–
$
$
–
–
Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.
Read moreEach paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.
Read moreThanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.
Read moreYour email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.
Read moreBy sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.
Read more