Answered: Projected Cash Receipts,Romaris…

Managerial Accounting

15th Edition

ISBN:9781337912020

Author:Carl Warren, Ph.d. Cma William B. Tayler

Publisher:Carl Warren, Ph.d. Cma William B. Tayler

Chapter8: Budgeting

Section: Chapter Questions

Problem 18E

See similar textbooks

Related questions

Concept explainers

Question

please answer within 30 minutes. Projected Cash Receipts,Romaris Brothers Inc. needs a cash receipts schedule for the months of April, May, and June. Actual Sales: February = $500,000, March = $500,000. Forecast Sales: April =$560,000, May= $610,000, June= $650,000, July= $650,000, Assuming that sales are the only source of cash inflows and that 30% of them are for cash and the remainder are collected evenly over the following 2 months. Prepare a schedule of projected cash receipts for April, May and June. Projected Cash Disbursements Romaris Brothers Inc. needs a cash disbursement schedule for the months of April, May, and June. The following information was collected from financial records: Purchases: Purchases are calculated as 50% of the next month’s sales, 15% of purchases are made in cash, 60% of purchases are paid for 1 month after purchase, and the remaining 25% of purchases are paid for 2 months after purchase. Rent: The firm pays rent of $9,000 per month. Wages and salaries: Base wage and salary costs are fixed at $8,500 per month plus a variable cost of 5.5% of the current month’s sales. Taxes: A tax payment of $45,600 is due in June. Fixed asset outlays: New equipment costing $61,000 will be bought and paid for in May. Principal payments: $35,000 due in June. Interest payments: $3,000 due in June. Cash dividends: $9,500 will be paid in April. Prepare a schedule of projected cash disbursements for April, May and June. Net Cash Flows Prepare a schedule to compute de Net Cash Flows for April, May and June of Romaris Brothers Inc. In the preparation of a quarterly cash budget, the following revenue and cost information have been compiled. The firm collects 60 percent of sales for cash and 40 percent of its sales one month later. Interest income of $50,000 on marketable securities will be received in December. The firm pays cash for 40 percent of its purchases. The firm pays for 60 percent of its purchases the following month. Salaries and wages amount to 15 percent of the preceding month's sales. Sales commissions amount to 2 percent of the preceding month's sales. Lease payments of $100,000 must be made each month. A principal and interest payment on an outstanding loan is due in December of $150,000. The firm pays dividends of $50,000 at the end of the quarter. Fixed assets costing $600,000 will be purchased in December. Depreciation expense each month of $45,000. The firm has a beginning cash balance in October of $100,000 and maintains a minimum cash balance of $200,000. Prepare and evaluate a cash budget for the months of October, November, and December based on the information shown above.

Definition Definition Estimate of an organization's cash flow for a future period. A cash budget forecasts future cash receipts and payments from various sources for a fiscal year. A cash budget can be created once a month or once a week to determine the organization's cash position and ensure its performance in relation to the budget. It aids in determining whether the company has enough cash and cash equivalents to meet its operational needs in the future.

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 3 steps with 2 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.

Similar questions