Prepare a cash budget for each of the months of july

Assignment Help Accounting Basics
Reference no: EM132802432

Built-Tight is preparing its master budget for the quarter ended September 30. Budgeted sales and cash payments for product costs for the quarter follow.

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 $15,000 in cash; $45,000 in accounts receivable; $4,500 in accounts payable; and a $5,000 balance in loans payable. A minimum cash balance of $15,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).

Problem 1: Prepare a cash budget for each of the months of July, August, and September. (Round amounts to the dollar.)

Attachment:- Cash budget.zip

Reference no: EM132802432

Questions Cloud

Explain FIVE objectives of the internal audit function : Hollibarn Ltd set up an internal audit department upon the advice of the external auditor. Explain FIVE objectives of the internal audit function
Determine the identity of metal : An unknown metal has a density of 12.3 g/cm3. If the atomic radius of that metal is 134pm and it crystallizes as a face-centered cubic cell, determine the ident
Explain fixed and flexible budgeting : Explain fixed and flexible budgeting. Provide an example of budgeting for three consecutive periods in which safety margin is included for flexibility
What is the final temperature of sample of silver : Suppose that you have 29.8 g of silver. Also, assume that this sample of silver is initially at 18 ocsilvero C. What is the final temperature of this sample of
Prepare a cash budget for each of the months of july : Prepare a cash budget for each of the months of July, August, and September. Built-Tight is preparing master budget for the quarter ended September
What is the specific heat capacity of substance a : If the specific heat capacity of substance B is 1.17 J/g·oC, what is the specific heat capacity of substance A?
What is their taxable income : Question - Bonnie and Clyde, married filing jointly, and both over 65 years of age, have no dependents. What is their taxable income for 2020
What is the mass of gold ring : What is the mass of gold ring? (Assume a density of 0.998 g/mL for water.)
Discuss the concepts of mean : Discuss the concepts of Mean, Median, Mode, and Standard Deviation, including when each should be used, and evaluate the differences of each

Reviews

Write a Review

Accounting Basics Questions & Answers

  Is peridot required to revise prior year financial statement

The Peridot Company purchased machinery on January 2, 2019, Is Peridot required to revise prior years' financial statements as a result of the change?

  Determine for Alpha Company dollar amount of Cafeteria costs

Alpha uses the direct method for service cost allocation. Use this information to determine for Alpha Company the dollar amount of its Cafeteria costs

  Determine the net present value

Horak Company accumulates the following data concerning a proposed capital investment: cash cost $219,620, Determine the net present value

  What are the estimated cash receipts

Estimated provision for bad debts in May for credit sales in May are $7,000. What are the estimated cash receipts from accounts receivable collections in May

  What is the total shareholders equity

An entity was organized on January 1, 2019. On that date, the entity issued 200,000 shares with P 10 par value at P15 per share. During the period January.

  Calculate plantwide overhead rate using machine hours on

b.1calculate plantwide overhead rate using machine hours on projected manufacturing costs for job no. 110. round your

  What is the target cost per unit

Projected sales are $286000 (or 65000 units) and desired profit is $39000. What is the target cost per unit

  Calculate ending inventory and cost of goods sold

Required - Calculate ending inventory and cost of goods sold for 2018 assuming the company uses FIFO with a periodic inventory system

  What is the initial cost of the silver mine

Smithson Mining operates a silver mine in Nevada. Acquisition, exploration, and development costs totaled $7.4 million

  Cash based income is converted to accrual-based net income

Dwyer Corporation purchases computer equipment from manufacturers and then sells them in retail stores. The company was founded in early 2016 by Martin Dwyer.

  How much revenue will saar recognize

Saar Associates sells two licenses to Kim & Company on September 1, 2018. How much revenue will Saar recognize in 2018 under this arrangement

  Record the year-end adjusting entry for estimated returns

Prepare the entry to record the year-end adjusting entry for estimated returns. Record the year-end adjusting entry for estimated returns

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