How much operating reserve or liquidity should the school

Assignment Help Financial Accounting
Reference no: EM132483645

Question 1: Use Excel to develop a monthly cash-flow budget for a preschool based on the information below. Assume that the board of directors does not allow for short-term borrowing. How much operating reserve or liquidity should the school have to embark on the preschool program? In what month will the end-of-the-month balance turn positive? In addition to answering these questions based on your cash-flow budget, please copy-paste or attach your Excel cash-based budget table to receive full credit for your work.

Revenues

Tuition fees: $100,000 paid monthly

Event income: $50,000 by Thanksgiving

Foundation support: $200,000 semiannually, May and November

Expenses

Salary and wages: $80,000 monthly

Rent and maintenance: $100,000 in January

Supply and food: $10,000 monthly

Administration and fundraising: $10,000 monthly

Reference no: EM132483645

Questions Cloud

Weight is a factor in winning football games : The following data represent weights (pounds) of a random sample of professional football players on the following teams.
Determine december amount of earnings per share : The Common Stock account for Baltimore Corporation on January 1, 2018 was $52,500. Determine December amount of Earnings per Share
Calculate amount debited or credited to retained earnings : Baltimore Corporation authorized a 10% stock dividend when the market value was $20 per share. Calculate amount debited or credited to retained earnings
Average annual profit of small businesses : Look at your answers for the two previous questions (about the small business revenue). Why are your answers to the previous two questions different?
How much operating reserve or liquidity should the school : How much operating reserve or liquidity should the school have to embark on the preschool program? In what month will the end-of-the-month balance
Data contains the number of friends on facebook : The following data contains the number of friends on Facebook for an SRS of 20 Facebook users from a large university.
What is the minimum number of people she must survey : Assuming the standard deviation is 4.1 people, what is the minimum number of people she must survey?
Confidence interval to estimate the population mean : The sample mean is 4.5 meals per week with a sample standard deviation of 2.1. Construct a 99% confidence interval to estimate the population mean.
Confidence interval to estimate proportion of all us adults : Construct a 95% confidence interval to estimate the proportion of all U.S. adults who get a physical

Reviews

Write a Review

Financial Accounting Questions & Answers

  Problem regarding the bullock gold mining

Seth Bullock, the owner of Bullock Gold Mining, is evaluating a new gold mine in South Dakota. Dan Dority, the company's geologist, has just finished his analysis of the mine site.

  Which of the following is a current liability

Which of the following is a current liability and Which of the following is true about accounts payable

  Role of international accounting

The role of international accounting toward promotion of generally accepted accounting principle

  Calculate depreciation under the units of production method

Calculate the depreciation under the straight line method, calculate the depreciation under the double declining method and calculate the depreciation under the units of production method

  Determine the profit margin ratio and the gross profit rate

Fill in the missing amounts and calculate the profit margin ratio and the gross profit rate for each company

  Locate?financial statements for a company of choice

Question 1: Locate?financial statements for a company of your?choice and?review the cash flow statement.

  Adjusting entries and preparing an adjusted trial balance

Recording Adjusting Entries and Preparing an Adjusted Trial Balance [LO 4-2, 4-3] [The following information applies to the questions displayed below.] North Star prepared the following unadjusted trial balance at the end of its second year of operat..

  Q1 which is not reported as an operating activity on a cash

q1. which is not reported as an operating activity on a cash flow statement prepared using the indirect method?a.

  Inexperienced employee punctured several containers

New equipment was purchased by Hunter Corp. at a list price of 914,000, with credit terms of 2/10, n/30. Payment was made within the discount period and included 9,800 sales tax in addition to the net purchase price. During installation, an inexperie..

  Determine new account balances after each transaction

Enter amount of each transaction on individual items of the accounting equation. Do not determine new account balances after each transaction. Prepare Balance Sheet for May 31. Prepare statement of retained earnings for May.

  Preferred stock

Wade's outstanding stock consists of 40,000 shares of 7.5% cumulative and participating preferred stock with a $10 par value and also 100,000 shares of common stock with a $1 par value. During its first four years of operations, the corporation decla..

  Capital budgeting is integral part of strategic planning

Capital budgeting is an integral part of the strategic planning and budgeting process of most firms. Explain and provide a numerical example of the use of the internal rate-of-return method and the Net Present Value (NPV) method of analyzing capital ..

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd