The beginning cash balance is $18,000. Sales are forecasted at $860,000 of which 80% will be on account. Seventy percent of credit sales are expected to be collected in the year of sale. Cash expenditures for the year are forecasted at $475,000. Accounts Receivable from previous accounting periods totaling $11,300 will be collected in the current year. The company is required to make a $14,000 loan payment and an annual interest payment on the last day of every year. The loan balance as of the beginning of the year is $95,000, and the annual interest rate is 8%.

The beginning cash balance is $18,000. Sales are forecasted at $860,000 of which 80% will be on account. Seventy percent of credit sales are expected to be collected in the year of sale. Cash expenditures for the year are forecasted at $475,000. Accounts Receivable from previous accounting periods totaling $11,300 will be collected in the current year. The company is required to make a $14,000 loan payment and an annual interest payment on the last day of every year. The loan balance as of the beginning of the year is $95,000, and the annual interest rate is 8%.

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

ABC Company is considering to establish a line of credit with a local bank to make up for the cash deficit for the next three months. The company expects a 60% chance for a $273,446 deficit and a 40% chance for no deficit at all. The line of credit charges 0.52% of interest rate per month on the amount borrowed plus a commitment fee of $2,500 for a quarter. It also requires a 9% compensation balance for outstanding loans. The company can reinvest any excess cash at an annual rate of 8%. What will the expected cost of establishing a line of credit be? Round your answer to the nearest dollar. (Hint: Refer to a numerical example in short-term financing choices.) Group of answer choices $5,313 $5,321 $5,304 $5,309 $5,317
Assume that sales and expenses forecasts for months April, May, June, and July are as follows. month, 60% are paid in the next month, and 20% are paid in the second month after. All expenses in a month are paid in the same month. There is a $20,000,000 minimum required cash balance at the end of each month, and any shortage from this minimum requirement will be covered by obtaining a loan. Any excess over $20,000,000 will be used to reduce or pay off cumulative loan. Initial cash balance in June is $6,000,000 and there is no cumulative loan at this time. Monthly prorated tax rate is 2%, and monthly interest rate on cumulative loan is 1%. Requirements: Prepare cash budget proforma for months June and July and interpret the result in detail.
69) Western Company expects the following credit sales for the first five months of the year: January, $43,000; February, $58,000; March, $48,000; April, $54,000, May $58,000. Experience has shown that payment for the credit sales is received as follows: 60% in the month of sale, 25% in the first month after sale, 10% in the second month after sale, and the remainder is uncollectible. How much cash can Western Company expect to collect in March as a result of credit sales (current and past)? A) $28,800. B) $42,600. C) $48,000. D) $47,600. E) $41,100.
the second quarter of 2021: Credit sales Credit purchases Cash disbursements Wages, taxes, and expenses Interest Equipment purchases Beginning cash balance Cash receipts Cash collections from credit sales Total cash available Cash disbursements The company predicts that 5 percent of its credit sales will never be collected, 30 percent of its sales will be collected in the month of the sale, and the remaining 65 percent will be collected in the following month. Credit purchases will be paid in the month following the purchase. Purchases Wages, taxes, and expenses Interest In March 2021, credit sales were $190,000 and credit purchases were $130,000. Using this information, complete the following cash budget: (Do not round intermediate calculations. Leave no cells blank - be certain to enter "0" wherever required.) Equipment purchases April May June $320,000 $300,000 $360,000 128,000 151,000 176,000 Total cash disbursements 44,000 11,000 80,000 Ending cash balance 11,500 11,000 150,000 $…
Munoz Pointers Corporation expects to begin operations on January 1, year 1; it will operate as a specialty sales company that sells laser pointers over the Internet. Munoz expects sales in January year 1 to total $270,000 and to increase 15 percent per month in February and March. All sales are on account. Munoz expects to collect 69 percent of accounts receivable in the month of sale, 24 percent in the month following the sale, and 7 percent in the second month following the sale. Required a. Prepare a sales budget for the first quarter of year 1. b. Determine the amount of sales revenue Munoz will report on the year 1 first quarterly pro forma income statement. c. Prepare a cash receipts schedule for the first quarter of year 1. d. Determine the amount of accounts receivable as of March 31, year 1. Complete this question by entering your answers in the tabs below. Required A Required B Required C Required D Determine the amount of accounts receivable as of March 31, year 1. (Do not…
The following budgeted statement of profit or loss has been prepared for Tata Ltd. for the four months January to April 2020 March April Gh¢ 60,000 50,000 70,000 60,000 Jan Feb Gh¢ Gh¢ Gh¢ Sales Cost of production (Increase)/decrease in stock 50,000 55,000 32,500 50,000 (5,000) (17,500) 20,000 (5,000) Cost of sales 45,000 37,500 52,500 45,000 Gross profit Adm & selling ov/hd 15,000 12,500 17,500 15,000 (8,000) (7,500) (8,500) (8,000) Net profit before interest 7,000 5,000 9,000 7,000 Additional Information: 40% of the production cost relates to direct materials. Materials are bought in the month prior to the month in which they are used. 2. Purchases are paid for one month after purchase. 1. 3. 30% of the production cost relates to direct labour which is paid for when it is used. 4. The remainder of the production cost is production overhead. 5. Gh¢5,000 per month is a fixed cost which includes Gh¢3,000 depreciation. Fixed production overhead costs are paid for when incurred. 6. The…
Neon Inc.’s forecast sales for July is $72,000. It has $15,000 in accounts receivable at the end of June. 30% of its total sales are expected to be cash sales. Of the remaining 70%, 80% are expected to be collected in the month of the sale and the remaining 20% in the month following the sale. Determine the amount of accounts receivable at the end of July. Group of answer choices $79,200 $61,920 $10,080 $40,320
Graham Potato Company has projected sales of $12,000 in September, $15,000 in October, $22,000 in November, and $18,000 in December. Of the company's sales, 30 percent are paid for by cash and 70 percent are sold on credit. Experience shows that 40 percent of accounts receivable are paid in the month after the sale, while the remaining 60 percent are paid two months after. Determine collections for November and December. Also assume Graham's cash payments for November and December are $18,500 and $11,000, respectively. The beginning cash balance in November is $5,000, which is the desired minimum balance. a. Prepare a cash receipts schedule for November and December. Graham Potato Company Cash Receipts Schedule Sales Credit sales Cash sales One month after sale Two months after sale Total cash receipts September October November December
Avery Company projects the following sales for the first three months of the year: $13,500 in January; $15,900 in February; and $15,800 in March. The company expects 80% of the sales to be cash and the remainder on account. Sales on account are collected 50% in the month of the sale and 50% in the following month. The Accounts Receivable account has a zero balance on January 1. Round to the nearest dollar. Prepare a schedule of cash receipts for Avery for January, February, and March. What is the balance in Accounts Receivable on March 31?
The Martin Company expects its total sales in the first quarter of 2024 will be $200,000 . Martin estimates that , in each subsequent quarter , total sales will increase by 10 % of the sales in the immediately preceding quarter . Martin estimates that 60 % of each quarter's sales will be on account , and 40 % will be for cash . Of the amount on account , 75% will be collected in the same quarter the sale occurred , and 25 % will be collected in the following quarter . Assume Martin will have no accounts receivable at the beginning of 2024. The balance in the Accounts Receivable account at the end of the third quarter is expected to be: $42,000 $ 30,000 $36,300 $ 60,000 $108,900
Millen’s managers have made the following additional assumptions and estimates: Estimated sales for July and August are $310,000 and $330,000, respectively. Each month’s sales are 20% cash sales and 80% credit sales. Each month’s credit sales are collected 30% in the month of sale and 70% in the month following the sale. All of the accounts receivable at June 30 will be collected in July. Each month’s ending inventory must equal 20% of the cost of next month’s sales. The cost of goods sold is 60% of sales. The company pays for 40% of its merchandise purchases in the month of the purchase and the remaining 60% in the month following the purchase. All of the accounts payable at June 30 will be paid in July. Monthly selling and administrative expenses are always $70,000. Each month $10,000 of this total amount is depreciation expense and the remaining $60,000 relates to expenses that are paid in the month they are incurred. The company does not plan to buy or sell any plant and equipment…
Brandeis, Inc has a 45-day accounts payable period. The firm has expected quarterly sales of $2,400, $2,800, $3,600, and $4,200, respectively, for the next calendar year. The cost of goods sold for a quarter is equal to 70% of the next quarter sales. The firm has a beginning payables balance of $1,200 as of quarter one. What is the amount of the projected cash disbursements for accounts payable for quarter 3 of the next year? Each quarter has 90 days. Multiple Choice $3,900 $2,730 $2,240 $2,870 $3,060