25 Jul Complete the Budget in a Service Company (Cash Budget) assignment.? ?Please use the template provided below. The document must have the complete budget and sho
Complete the Budget in a Service Company (Cash Budget) assignment. Please use the template provided below.
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.
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.
,
Sheet1
| Formulas included. Enter amounts in highlighted areas to complete the budget | ||||
| Edge Soccer Programs | ||||
| Cash Budget | ||||
| For the Two Months Ended February 28 | ||||
| January | February | Total | ||
| Beginning cash balance | $ – 0 | $ – 0 | ||
| Cash receipts from customers | $ – 0 | $ – 0 | ||
| Collection of note receivable | $ – 0 | |||
| Cash available | $ – 0 | $ – 0 | $ – 0 | |
| Cash payments: | ||||
| Equipment purchases | $ – 0 | |||
| Selling and administrative expenses | $ – 0 | |||
| Total cash payments | $ – 0 | $ – 0 | $ – 0 | |
| Ending cash balance before financing | $ – 0 | $ – 0 | $ – 0 | |
| Minimum cash balance desired | $ – 0 | $ – 0 | ||
| Projected cash excess (deficiency) | $ – 0 | $ – 0 | $ – 0 | |
| Financing: | ||||
| Borrowing | $ – 0 | |||
| Total effects of financing | $ – 0 | $ – 0 | $ – 0 | |
| Ending cash balance | $ – 0 | $ – 0 | $ – 0 | |
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.