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 vendors are scheduled as: 70% in the quarter of the purchases from vendors and the balance of 30% in the following quarter.  Other expenses include: o Team and game expenses which are 30% of total revenues each quarter o Selling and promotional expenses which are 5% of total revenues each quarter o General and administrative expenses which are 7% of total revenues each quarter o Interest expense and taxes which are 6% of total revenues each quarter  The beginning cash balance is $120

Solutions

Expert Solution

Cash Budget:

ekkarill92 answered 4 months ago

Next > < Previous

Related Solutions

Analyze the Sales Budget your team has created. Based on the projected revenue numbers within the...

Analyze the Sales Budget your team has created. Based on the projected revenue numbers within the quarterly data given, determine approximately how many new airplanes will be needed to generate the necessary revenue on an annualized basis. The industry uses Passenger Seat Miles as a measure of revenue. Current data fm the industry shows revenue per Passenger Seat Mile is 16 cents. ExpressJet believes that their revenue will go up by one cent per month during the quarter. An average...

When researching information to complete the cash flow budget, what needs to be considered?

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...

For the Twitter IPO deal, the investment banking team used the forward multiples based on projected...

For the Twitter IPO deal, the investment banking team used the forward multiples based on projected NTM EBITDA or sales of comparable companies. Write a short answer on the pros and cons of using forward multiples.

For the Twitter IPO deal, the investment banking team used the forward multiples based on projected...

For the Twitter IPO deal, the investment banking team used the forward multiples based on projected NTM EBITDA or sales of comparable companies. Write a paragraph on the pros and cons of using forward multiples.

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%...

The urgent care manager must resubmit her budget based on 2018 projected visits. The 2018 budget...

The urgent care manager must resubmit her budget based on 2018 projected visits. The 2018 budget should be based on actual expenses and visits incurred during the first seven months of 2017. Cost standards (2017) and budget standards (2018) must be prepared for all variable costs (indicated by a V behind the object code description). All fixed costs (F) should be projected using the incremental budgeting methodology. Projected visits is 2018 is 52,560. Salary and fringe benefit (object codes 4000-4199)...

A. Complete a flexible budget for 20,000 units produced. Use the following information at a production...

A. Complete a flexible budget for 20,000 units produced. Use the following information at a production level of 15,000 units to complete the flexible budget: Budgeted units 15,000 Revenue $1,500,000 Expenses: Wages and Salaries ($200,000 + $10Q) $350,000 Utilities (variable) $300,000 Depreciation (fixed) $200,000 Total expenses $850,000 Net operating income $650,000 Q = units produced Budgeted units 20,000 Revenue Expenses: Wages and Salaries ($200,000 + $10Q) Utilities (variable) Depreciation (fixed) Total expenses Net operating income B. Calculate the activity variances...

Chelsea Clinic’s PROJECTED budget information for 2020 is listed below. Please use this information to answer...

Chelsea Clinic’s PROJECTED budget information for 2020 is listed below. Please use this information to answer the questions below. Chelsea Clinic Total FFS Visit Volume 90,000 visits Payer Mix: Blue Cross 40% Highmark 60% Reimbursment Rates Blue Cross $25 per visit Highmark $20 per visit Variable Costs Resource Inputs Labor 48,000 total hours Supplies 100,000 total units Resource Input Prices Labor $ 25.00 per hour Supplies $ 1.50 per unit Fixed Costs (overhead, plant and equipment) $ 500,000.00...

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...

Subjects