This practice exercise explores simple cash budgets. Create a spreadsheet file that contains a simple monthly cash budget for the next year for the business described in the following scenario:
Assume you are thinking about starting a business and would like to forecast your cash needs for the next six months. You expect sales to be approximately $30,000 per month for the first 12 months and your purchases to support sales will be approximately 60% of sales. You anticipate about 20% of your sales will be cash and 80% collected the following month. Your supplier has agreed to extend credit for 70 days at no cost (i.e. you will pay your bills on a two month lag). Your monthly expenses for rent, wages, utilities, and so forth will be approximately $3,500 per month. Identify which of these are fixed costs and which ones are variable costs. You have deposited $15,000 in a checking account to begin your operations and would like to maintain a minimum balance of $5,000 in that account.
After building the cash budget, use it to address the following:
Explain the purpose of creating budgets and how your budget will help the business remain capitalized
Will you need additional funds at some point? Justify your answer.
How would you raise capital in the future?
Using the cash budget and answers to the above questions, create a 3-page APA-formatted paper explaining how to use the cash budget to finance the business illustrated in the scenario. Make sure to include the cash budget in an appendix.
Step 1
Cash budget: Cash budgeting can be defined as a budget prepare to estimate the relevant cash collection and expenses. Cash budget is very crucial for decision making process.
Step 2
Cash budget:
1month |
2nd month |
3month |
4month |
5month |
6month |
|
Opening cash balance |
$5,000 |
$2,500 |
$29,000 |
$25,500 |
$22,000 |
$18,500 |
Cash sales |
6,000 |
6,000 |
6000 |
6000 |
6000 |
6000 |
Collection of credit sales |
24,000 |
24,000 |
24,000 |
24,000 |
24,000 |
|
Less : due to supplier |
30,000 |
30,000 |
30,000 |
30,000 |
||
Less: monthly expenses |
$3,500 |
$3,500 |
$3500 |
$3500 |
$3500 |
$3500 |
Closing cash balance |
$2500 |
29,000 |
25,500 |
$22,000 |
$18,500 |
$15,000 |
Minimum balance in account for $5000 is assumed as cash .
The purpose of creating budgets are:
Budget will help the business to remain capitalized in following ways:
For six months of period ,no additional fund is required because expenses are covered from available cash balance.
The additional capital can be introduced by way of bank loan or advance raised from bank to introduce additional capital.
Rate the help you received.Thank you!!
This practice exercise explores simple cash budgets. Create a spreadsheet file that contains a simple monthly...
Step 1 Read the scenario. Assume you are thinking about starting a business and would like to forecast your cash needs for the next six months. You expect sales to be approximately $30,000 per month for the first 12 months and your purchases to support sales will be approximately 60% of sales. You anticipate about 20% of your sales will be cash and 80% collected the following month. Your supplier has agreed to extend credit for 70 days at no...
Multiple cash budgets—Scenario analysis Brownstein, Inc., expects sales of $100,000 during each of the next 3 months. It will make monthly purchases of $62,000 during this time. Wages and salaries are $19,000 per month plus 4% of sales. Brownstein expects to make a tax payment of $22,000 in the next month and a $13,000 purchase of fixed assets in the second month and to receive $7,000 in cash from the sale of an asset in the third month. All sales...
For this assignment you will utilize the excel template to create cash budgets using the example presented in the Chapter 16 PowerPoint. Your assignment will consist of the following: 1) You will create a sheet that prepares the monthly cash budget using the data below as well as the other data provided in the spreadsheet. (44.25 pts) May-16 Jun-16 Jul-16 Aug-16 Sep-16 Oct-16 Nov-16 Dec-16 Jan-17 Feb-17 Mar-17 Apr-17 May-17 Anticipated level of sales $15,000 $20,000 $30,000 $50,000 $40,000 $20,000...
Problem 7-8A Pronghorn Corp prepares monthly cash budgets. Here are relevant data from operating budgets for 2017. Sales Purchases January $360,300 121,200 84,500 70,000 79,900 February $400,300 131,200 81,700 73,400 87,900 Salaries Administrative expenses Selling expenses All sales and purchases are on account. Budgeted collections and disbursement data are given below. All other expenses are paid in the month incurred except for administrative expenses, which include $1,200 of depreciation per month. Other data. 1. Collections from customers: January $332,300; February...
Multiple cash budgets- Scenario analysis Brownstein, Inc, expects sakes of $99000 during each plus 4% of sales Brownstein of the next 3 months It will make montily purchases of $62,000 during this time. Wages and salaries are $20,000 per month receive $7,000 in cash from the sale of an asset in the third month Al expects to make a tax payment of $21,000 in the next month and a $11,000 purchase of fixed assets in the second month and to...
Multiple cash budgets Scenario analysis Brownstein, Inc., expects sales of $101,000 during each of the next 3 months. It will make monthly purchases of $58,000 during this time. Wages and salaries are $20,000 per month plus 6% of sales. Brownstein expects to make a tax payment of $16,000 in the next month and a $10,000 purchase of fixed assets in the second month and to receive $8,000 in cash from the sale of an asset in the third month. All...
Multiple cash budgets-Scenario analysis Brownstein, Inc, expects sales of $99,000 during each of the next 3 monthes. It will make monthly purchases of $62 000 hring this time Wages and salaries are S20 000 per month phr 4% of sal str stein expects to make a tax yment of S21,000 n te next month and a S11,000 purchase of fixed assets in the second month and to receive $7,000 in cash from the sale of an asset in the third...
part b prepare the cash budget Bee Gee Company prepares monthly cash budgets. Below is a set of relevant data extracted from existing reports, and the subsidiary budgets for the two months of September and October 2020. Sales Purchases Wages Manufacturing overhead Administration expenses Sale of equipment Cash paid for new IT equipment September RM 3,140,000 1,620,000 514,000 216,000 390,000 October RM 4,120,000 2,160,000 552,000 234,000 390,000 82,000 165,000 All sales are on credit. Collections from debtors normally have the...
Colter Company prepares monthly cash budgets. Relevant data from operating budgets for 2017 are as follows: February January Sales $370,800 $412,000 Direct materials purchases 123,600 128,750 Direct labor 92,700 103,000 Manufacturing overhead 77,250 72,100 Selling and administrative expenses 81,370 87,550 All sales are on account. Collections are expected to be 50% in the month of sale, 30% in the first month following the sale, and 20% in the second month following the sale. Sixty percent (60%) of direct materials purchases...
Question 4 Crane Company prepares monthly cash budgets. Relevant data from operating budgets for 2020 are as follows. Sales Direct materials purchases Direct labor Manufacturing overhead Selling and administrative expenses January $446,400 148,800 111,600 86,800 97,960 February $496,000 155,000 124,000 93,000 105,400 All sales are on account. Collections are expected to be 50% in the month of sale, 30% in the first month following the sale, and 20% in the second month following the sale. Sixty percent (60%) of direct...