Balance in loans payable, The June 30 balance sheet

Balance in loans payable

Assignment Help Financial Accounting

Reference no: EM13919823

Built-Tight is preparing its master budget for the quarter ended September 30, 2015. 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).
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 amounts to the dollar.)

Reference no: EM13919823

Questions Cloud

Unscrupulous lender-what is the effective interest rate : Imagine you are discussing a loan with a somewhat unscrupulous lender. You want to borrow $20,000 for one year. The interest rate is 12.5 percent. You and the lender agree that the interest on the loan will be 0.125 × $20,000 = $2,500. So the lender ..

The following selected financial information is available : The following selected financial information is available for Best, Inc. Amounts are in millions of dollars.

What is the value of the unlevered firm and tax shield : Merger Valuation with Change in Capital Structure Hastings Corporation is interested in acquiring Vandell Corporation. Vandell has 1 million shares outstanding and a target capital structure consisting of 30% debt; its beta is 1.50. What is the value..

Burden of proof in employment discrimination : HR legal environments are constantly changing. The court case that set the standard to place the burden of proof in employment discrimination on the company was:

Balance in loans payable : 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.

Operating cash flow and value of the property : Consider a commercial property that costs $1 million (90% building, 10% land) with the CAP rate of 10%. Assume that the operating cash flow and value of the property both grow at a rate of 5% per year. Suppose 80% of the property value is financed wi..

Identify major historical developments in world cultures : Explain how key social, cultural, and artistic contributions contribute to historical changes.Explain the importance of situating a society's cultural and artistic expressions within a historical context.

Estimate the project overall cost : Describe at least three (3) key milestones and /or deliverables for your project. Describe a high-level timeline that includes key tasks and deadlines. Estimate the project's overall cost and any key staffing and non-staffing resources needed.

Equipment to produce specialized aluminum products : ALUM, Inc. uses high-tech equipment to produce specialized aluminum products for its customers. Each one of these machines costs $1,520,000 to purchase plus an additional $48,000 a year to operate. The machines have a five-year life after which they ..

User Account

All Pages