What is the cash budget for june, july and august

Assignment Help Accounting Basics
Reference no: EM133187586

Question - During the annual budget preparation Tobias Jeans Company created a cash budget for the summer months (June, July, August). The company has a line of credit at Bluth Bank. They can borrow up to $150,000 at an annual rate of interest of 10%. They can only borrow in increments of $1,000. So far for the year they have not had to borrow anything from the line of credit, so the outstanding balance on the loan will be zero on May 31. The company's cash balance on May 31, will be $80,000. If they do end up borrowing from the line of credit, they will pay the back as much as possible as soon as they can since interest is charged and must be paid monthly. They do have to maintain a minimum cash balance of $80,000 at the end of each month. If they are below that, they must borrow from the line of credit, but if they are above that they can repay any loan balance with excess cash. Expected monthly collection and disbursement patters are shown below:

*Collections: 45% of the current month's sales budget and 55% of the previous month's sales budget.

*Accounts Payable Disbursements: 30% of the current month's accounts payable budget and 70% of the previous month's accounts payable budget.

*All other disbursements occur in the month in which they are budgeted.

Budget Information

 

May

June

July

August

Sales

$100,000

$110,000

$115,000

$100,000

Accounts Payable

$20,000

$30,000

$40,000

$40,000

Payroll

$50,000

$60,000

$70,000

$50,000

Machine Rent

$5,000

$5,000

$5,000

$5,000

Other Disbursements

$20,000

$20,000

$15,000

$5,000

Depreciation

$6,000

$6,000

$6,000

$6,000

Required - What is the cash budget for June, July and August?

Reference no: EM133187586

Questions Cloud

What is the direct labor rate variance : The following information is provided for Dexter, Inc.: Standard direct labor wage rate: $10/hour. What is the direct labor rate variance
What is jaroni break-even point in sales dollars : Total sales for previous period were $60,000. Wages, materials, and variable manufacturing overhead totaled $10,200. What is Jaroni break-even point in Sales
How many orders would the company need to place this year : The cost of placing an order with its supplier is IDR3,000,000. How many orders would the company need to place this year
Contrast judgment with decision-making : Contrast "judgment" with "decision-making". Define "heuristic" and describe a heuristic that can affect judgments.
What is the cash budget for june, july and august : They can only borrow in increments of $1,000. What is the cash budget for June, July and August
Calculate the commission income for the year : Calculate the Commission Income for the year that will enter the Profit or Loss as an income for the year ended 31st December 2021
Provide a profile of australia economic growth rates : Provide a profile of Australia's economic growth rates, and financial systems. Compare and contrast the work of multilateral institutions in Australia
Prepare all relevant journal entries related to machinery : Assuming that MyBaby Bhd's policy is to present government grants as deferred income, prepare all relevant journal entries related to the machinery
Prepare chancellor international journal entries on june : Prepare Chancellor International's journal entries on June 1, June 30 (a balance sheet date) and July 15, 2019 related to this purchase

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