Prepare a cash receipts budget

Assignment Help Accounting Basics
Reference no: EM131539466

Question: Kool-Ray is preparing its master budget for the quarter ended September 30. Budgeted sales and cash payments for merchandise for the next three months follow:

1708_August.png

Sales are 20% cash and 80% on credit. All credit sales are collected in the month following the sale. The June 30 balance sheet includes balances of $12,000 in cash; $45,000 in accounts receivable; $4,500 in accounts payable; and a $2,000 balance in loans payable. A minimum cash balance of $12,000 is required. Loans are obtained at the end of any month when a cash shortage occurs. Interest is 1% per month based on the beginning of the month loan balance and is paid at each month-end. If an excess balance of cash exists, loans are repaid at the end of the month. Operating expenses are paid in the month incurred and consist of sales commissions (10% of sales), office salaries ($4,000 per month), and rent ($6,500 per month).

(1) Prepare a cash receipts budget for July, August, and September.

(2) Prepare a cash budget for each of the months of July, August, and September. (Round all dollar amounts to the nearest whole dollar.)

Reference no: EM131539466

Questions Cloud

Compare the burden of your state with two neighboring states : Compare the burden of your state with two neighboring states. Analyze the impact of tax holidays of up to 10 days in your state.
Emotional intelligence blind spots : Common blind spots that might prevent someone from pursuing self-awareness are: blind ambition, unrealistic goals, relentless striving, drives others
Prepare a budgeted balance sheet for march : The cash budget for March shows an ending bank loan of $10,000 and an ending cash balance of $48,000.
Describe three concepts or skills you learned in the course : Describe three concepts or skills you learned in the course that you can apply in your current or future professional life.
Prepare a cash receipts budget : Kool-Ray is preparing its master budget for the quarter ended September 30. Budgeted sales and cash payments for merchandise for the next three months.
Compute the incremental income after taxes : Compute the incremental income after taxes. What will Johnson’s incremental return on sales be if these new credit customers are accepted?
The african american and the korean american community : The media, especially Los Angeles Times, played a major role in instigating tension between the African American community and the Korean American community.
Prepare a report for presentation include income statements : The Finance Director has asked you, as an external consultant, to prepare a report for presentation include forecast income statements
Calculate the operating expenses : Cambridge, Inc. is preparing its master budget for the quarter ended June 30. Budgeted sales and cash payments for merchandise for the next three months.

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