Develop a cash budget based on the following information about a preschool: Revenue Tuition fee: $100,000...

Develop a cash budget based on the following information about a preschool:

Revenue
Tuition fee: $100,000 paid monthly
Event income: $50,000 by Thanksgiving
Foundation support: $200,000 semiannually, May and November

Expense
Salary and wages: $80,000 monthly
Rent and insurance: $100,000 in January
Supply and food: $10,000 monthly
Administration and fundraising: $10,000 monthly

Assume the board of directors does not allow for short-term borrowing and that the cash safety margin is $80,000. How much operating reserve or liquidity should the school have to embark on the preschool program?

Solutions

Expert Solution

Based on the given data, pls find below workings:

It could be observed that at any point of time, the highest negative balance is -ve $ 100000; Over this, the Board of Directors have stipulated that the cash safety margin need to be $ 80000, since there is no short-term borrowing facility; Hence, based on the below workings, it is required to maintian operating reserve of $ 180000, for the school before embarking on the PreShcool program.

jeff jeffy answered 1 year ago

Next > < Previous

Related Solutions

1. Please use the following information to develop a cash budget for January and February: January...

1. Please use the following information to develop a cash budget for January and February: January February Beginning balance of cash $ 25,000 ? Cash collections from customers 150,000 200,000 Cash payments 205,000 110,000 Minimum cash balance at end of each month $20,000 Money is assumed to be borrowed at the beginning of any month when it is needed and paid back at the end of any month when it can be paid back. Interest is paid in the month...

Complete a cash budget for The Stars basketball team based on the following information.  Projected...

Complete a cash budget for The Stars basketball team based on the following information.  Projected Total Revenues: Q1=$800, Q2=$900, Q3=$950, Q4=$1000, 1 st quarter next yr. = $1000  Accounts Receivable (beginning) are equal to $450  50% of Revenues are cash sales  The rest of the revenues (50%) are collected in the following quarter  Beginning accounts payable are equal to $250  Purchases from vendors each quarter are 50% of next quarter sales  Payments to...

Which of the following is not a form of price? : Rent Tuition Fee Fare Rate...

Which of the following is not a form of price? : Rent Tuition Fee Fare Rate Toll Premium Royalties Bribe Dues Salary Commission Wage Tax Please put a Y or an N next to the following above, THANK YOU!! :)

Develop a revenue management (maximizing) model based on the information given in the scenario. How many...

Develop a revenue management (maximizing) model based on the information given in the scenario. How many seats should be allocated to each of the 16 itineraries to maximize revenue? What is the (maximum) expected revenue to be earned per day for all 16 flights? Assume operating costs for each of the legs is as follows: Leg 1 = $20,250 Leg 2 = $19,750 Leg 3 = $20,500 Leg 4 = $19,500 What is the expected operating income for each of...

Develop a Chase Strategy and a Level Strategy based on the following information. • The Level...

Develop a Chase Strategy and a Level Strategy based on the following information. • The Level Strategy requires the use of a constant workforce equal to the minimum requirement based on the expected demand (Note: Any needed capacity can be fulfilled with overtime.) • Chase strategy should use ‘hiring and firing’ actions to balance the capacity. Twenty-three workers worked during February. Illustrate and explain which is the best plan. March April May June Beginning Inventory 600 300 250 200 Demand...

Use the following information to prepare a cash budget for December. The cash balance on December...

Use the following information to prepare a cash budget for December. The cash balance on December 1 is $53,400. Actual sales for October and November and expected sales for December are as follows: October November December Cash sales $ 77,000 $ 81,200 $ 87,800 Sales on account $ 435,000 $ 538,000 $ 644,000 Sales on account are collected over a three-month period as follows: 20% collected in the month of sale, 60% collected in the month following sale, and 18%...

a Using the information provided, construct a monthly cash budget for October through December 2014. Based...

a Using the information provided, construct a monthly cash budget for October through December 2014. Based on your analysis, will Noble enjoy a surfeit of cash, or require external financing? b Construct a pro forma income statement for the first fiscal quarter of 2015 and a pro forma balance sheet as of December 31, 2014. What is your estimated external financine needed for December 31? c Does the December 31, 2014, estimated external financing equal your cash surplus (deficit) for...

Use the following information to develop a spreadsheet model that will calculate the free cash flows...

Use the following information to develop a spreadsheet model that will calculate the free cash flows and the value of the equity for the company. Cost of capital 12% Most recent year’s sales $1000 Nonoperating assets $100 Interest-bearing debt $250 Operating profit margin 12% Working capital/sales 35% Fixed assets/sales 20% Noninterest-bearing Current liabilities/sales 10% Tax rate 40% Forecasted sales growth Years 1␣2 12% Years 3␣5 8% 6␣N 4%

The Fortunate Co. is preparing a cash budget for the 2nd quarter. The following information is...

The Fortunate Co. is preparing a cash budget for the 2nd quarter. The following information is available: Projected cash sales: $10,000 each month Projected credit sales: $ 8,000 each month One half of the credit sales are collected in the month of sale, and the remainder collected in the following month (there are no uncollectible accounts). Accounts receivable on April 1st were $3,000. Operating expenses (paid in cash): $20,000 for April, and $13,000 for each of the following two months....

Based on the following data, prepare a cash budget (in proper form with labels) for July...

Based on the following data, prepare a cash budget (in proper form with labels) for July and August. Forecast sales May $12,000 June $15,000 July $16,000 August $12,000 Cash sales are 30% of total sales. Credit sales are collected as follows: 60% one month after the sale and 40% 2 months after the sale Accounts payable are paid 100% 2 months after the purchase Expected A/P May $4,500 June $6,500 July $7,000 August $8,000 In addition to purchases, there are...

Subjects