Develop a cash budget with a spread sheet

Assignment Help Accounting Basics
Reference no: EM131905016

Question: Develop a Cash Budget with a spread sheet

Develop a cash budget

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

Revenue: Tuition fee: $1000, 00 paid monthly

Event income $50,000 by Thanksgiving

Foundation support $2000, 000 semiannually, May and November

Expense:

Salary and wages: $80,000 monthly

Rent and Insurance $1000, 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 the cash safety margin is $80,000. How much operating reserve or liquidity should the school have to embard on the preschool program.

Reference no: EM131905016

Questions Cloud

Explain what types of addiction were addressed : Explain what types of addiction were addressed and how the film's characters became addicted, if known.
Discuss the vision and mission of an organization : Choose a utility provider of one of the sixteen sectors from the DHS Critical Infrastructures webpage.
Demonstrate the importance and impact of chosen healthcare : Demonstrate the importance and impact of the chosen healthcare policy issue to nursing. How it can promote learning, discipline and a healthier life style.
What problems do you think the company might encounter : Do you think compensation should be linked to balanced scorecards? What problems do you think the company might encounter in trying to implement a balanced scor
Develop a cash budget with a spread sheet : Develop a Cash Budget with a spread sheet. Develop a cash budge based on the following information about the preschool.
Describe a heritage assessment on three families : Describe a heritage assessment on three families. One of these families should be from your own culture. Complete Heritage Assessment Tool for each of families.
What three factors would influence your evaluation : Discuss why there may or may not be ratios that would be more important in a service vs manufacturing environment and which rations would those be?
Compute asset turnover for the two most recent years : Select two competing companies, Dr. Pepper and Coca-Cola both must be American and publicly traded and locate annual reports for these two companies.
How much would the division gain or lose : How much would the division gain or lose if Division B to purchase the product from the outside company for $18.40 per unit

Reviews

Write a Review

Accounting Basics Questions & Answers

  How much control does fed have over this longer real rate

Hubbard argues that the Fed can control the Fed funds rate, but the interest rate that is important for the economy is a longer-term real rate of interest.   How much control does the Fed have over this longer real rate?

  Coures:- fundamental accounting principles

Coures:- Fundamental Accounting Principles: - Explain the goals and uses of special journals.

  Accounting problems

Accounting problems,  Draw a detailed timeline incorporating the dividends, calculate    the exact Payback Period  b)   the discounted Payback Period. the IRR,  the NPV, the Profitability Index.

  Write a report on internal controls

Write a report on Internal Controls

  Prepare the bank reconciliation for company

Prepare the bank reconciliation for company.

  Cost-benefit analysis

Create a cost-benefit analysis to evaluate the project

  Theory of interest

Theory of Interest: NPV, IRR, Nominal and Real, Amortization, Sinking Fund, TWRR, DWRR

  Liquidity and profitability

Distinguish between liquidity and profitability.

  What is the expected risk premium on the portfolio

Your Corp, Inc. has a corporate tax rate of 35%. Please calculate their after tax cost of debt expressed as a percentage. Your Corp, Inc. has several outstanding bond issues all of which require semiannual interest payments.

  Simple interest and compound interest

Simple Interest, Compound interest, discount rate, force of interest, AV, PV

  Capm and venture capital

CAPM and Venture 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