I need help with a question
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
–
–
$
$
$
$
$
$
–
$
–
$
$
–
–
Instructions (Budget in a service Company)
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.
Hint: The budget should start with the January beginning
balance and the February ending balance should also be the
ending balance for the two months combined column.
Essay Writing Service Features
Our Experience
No matter how complex your assignment is, we can find the right professional for your specific task. Achiever Papers is an essay writing company that hires only the smartest minds to help you with your projects. Our expertise allows us to provide students with high-quality academic writing, editing & proofreading services.
Free Features
Free revision policy
$10Free bibliography & reference
$8Free title page
$8Free formatting
$8How Our Dissertation Writing Service Works
First, you will need to complete an order form. It's not difficult but, if anything is unclear, you may always chat with us so that we can guide you through it. On the order form, you will need to include some basic information concerning your order: subject, topic, number of pages, etc. We also encourage our clients to upload any relevant information or sources that will help.
Complete the order form
Once we have all the information and instructions that we need, we select the most suitable writer for your assignment. While everything seems to be clear, the writer, who has complete knowledge of the subject, may need clarification from you. It is at that point that you would receive a call or email from us.
Writer’s assignment
As soon as the writer has finished, it will be delivered both to the website and to your email address so that you will not miss it. If your deadline is close at hand, we will place a call to you to make sure that you receive the paper on time.
Completing the order and download