Survey Of Accounting
5th Edition
ISBN: 9781259631122
Author: Edmonds, Thomas P.
Publisher: Mcgraw-hill Education,
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 14, Problem 14E
Exercise 7-14A Determining amount to borrow and pro forma statement balances
Lois Bragg owns a small restaurant in Boston. Ms. Bragg provided her accountant with the following summary information regarding expectations for the month of June. The balance in accounts receivable as of May 31 is $40,000. Budgeted cash and credit sales for June are $100,000 and $250,000, respectively. Credit sales are made through Visa and MasterCard and are collected rapidly. Eighty percent of credit sales is collected in the month of sale, and the remainder is collected in the following month. Ms. Bragg’s suppliers do not extend credit. Consequently, she pays suppliers on the last day of the month. Cash payments for June arc expected to be $330,000. Ms. Bragg has a line of credit that enables the restaurant to borrow funds on demand; however, they must be borrowed on the last day of the month. Interest is paid in cash also on the last day of the month. Ms. Bragg desires to maintain a $15,000 cash balance before the interest payment. Her annual interest rate is 9 percent.
Required
- a. Compute the amount of funds Ms. Bragg needs to borrow for June.
- b. Determine the amount of interest expense the restaurant will report on the June pro forma income statement.
- c. What amount will the restaurant report as interest expense on the July pro forma income statement?
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Problem 13-61 (Algo) Comprehensive Budget Plan (LO 13-4, 5, 6)
Brighton, Inc., manufactures kitchen tiles. The company recently expanded, and the controller believes that it will need to borrow cash to continue operations. It began negotiating for a one-month bank loan of $500,000 starting May 1. The bank would charge interest at the rate of 1.00 percent per month and require the company to repay interest and principal on May 31. In considering the loan, the bank requested a projected income statement and cash budget for May.
The following information is available:
The company budgeted sales at 600,000 units per month in April, June, and July and at 450,000 units in May. The selling price is $4 per unit.
The inventory of finished goods on April 1 was 150,000 units. The finished goods inventory at the end of each month equals 25 percent of sales anticipated for the following month. There is no work in process.
The inventory of raw materials on April 1 was 56,250 pounds. At the end…
Chapter 14 Solutions
Survey Of Accounting
Ch. 14 - Prob. 1QCh. 14 - Prob. 2QCh. 14 - 3.What are the three levels of planning? Explain...Ch. 14 - 4.What is the primary factor that distinguishes...Ch. 14 - 5.What is the advantage of using a perpetual...Ch. 14 - Prob. 6QCh. 14 - Prob. 7QCh. 14 - 8. Ken Shilov, manager of the marketing...Ch. 14 - Prob. 9QCh. 14 - 10.What is the normal starting point in developing...
Ch. 14 - 11. How does the level of inventory affect the...Ch. 14 - 12.What are the components of the cash budget?...Ch. 14 - 13.The primary reason for preparing a cash budget...Ch. 14 - 14.What information does the pro forma income...Ch. 14 - 15.How does the pro forma statement of cash flows...Ch. 14 - Exercise 7-1A Budget responsibility Teresa...Ch. 14 - Exercise 7-2A Preparing a sales budget Parliament...Ch. 14 - Prob. 3ECh. 14 - Exercise 7-4A Preparing sales budgets with...Ch. 14 - Exercise 7-5A Determining cash receipts from...Ch. 14 - Exercise 7-6A Using judgment in making a sales...Ch. 14 - Exercise 7-7A Preparing an inventory purchases...Ch. 14 - Exercise 7-8A Preparing a schedule of cash...Ch. 14 - Exercise 7-9A Determining the amount of expected...Ch. 14 - Exercise 7-10A Preparing inventory purchases...Ch. 14 - Exercise 7-11A Preparing a schedule of cash...Ch. 14 - Prob. 12ECh. 14 - Exercise 7-13A Preparing a cash budget The...Ch. 14 - Exercise 7-14A Determining amount to borrow and...Ch. 14 - Prob. 15ECh. 14 - Problem 7-16A Behavioral impact of budgeting...Ch. 14 - Prob. 17PCh. 14 - Problem 7-18A Preparing an inventory purchases...Ch. 14 - Prob. 19PCh. 14 - Problem 7-21A Preparing a cash budget Fayette...Ch. 14 - Prob. 21PCh. 14 - Problem 7-22A Preparing budgets with multiple...Ch. 14 - Problem 7-23A Preparing a master budget for retail...Ch. 14 - ATC 7-1 Business Applications Case Preparing and...Ch. 14 - ATC7-2 Group Assignment Master budget and pro...Ch. 14 - ATC 7-4 Writing Assignment Continuous budgeting...Ch. 14 - Ethical Dilemma Bad budget system or unethical...
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
- Exercise 4-54 Operating Cycle and Current Receivables a. Dither and Sly are attorneys-at-law who specialize in federal income tax law. The): complete their typical case in 6 months or less and collect from the typical client within 1 additional month. b. Johnstons Market specializes in fresh meat and fish. All merchandise must be sold within one week of purchase. Almost all sales are for cash and any receivables are generally paid by the end of the following month. c. Mortondos is a womens clothing store specializing in high-style merchandise. Merchandise spends an average of 7 months on the rack following purchase. Most sales are on credit and the typical customer pays within 1 month of sale. d. Trees Inc. grows Christmas trees and sells them to various Christmas tree lots. Most sales are for cash. It takes 6 years to grow a tree. Required: For each of the businesses described above, indicate the length of the operating cycle.arrow_forwardRefer to Exercise 8.24. Del Spencers purchases clothing evenly throughout the month. All purchases are on account. On the first of every month, Jana Spencer, Dels wife, pays for all of the previous months purchases. Terms are 2/10, n/30 (i.e., a 2 percent discount can be taken if the bill is paid within 10 days; otherwise, the entire amount is due within 30 days). The forecast purchases for the months of May through September are as follows: Required: 1. Prepare a cash disbursements schedule for the months of August and September. (Round all cash amounts to the nearest dollar.) 2. Now, suppose that Del wants to see what difference it would make to have someone pay for any purchases that have been made three times per month, on the 1st, the 11th, and the 21st. Prepare a cash disbursements schedule for the months of July and August assuming this new payment schedule. (Round all cash amounts to the nearest dollar.) 3. Suppose that Jana (who works full-time as a school teacher and is the mother of two small children) does not have time to make payments on two extra days per month and that a temporary employee is hired on the 11th and 21st at 20 per hour, for four hours each of those two days. Is this a good decision? Explain. Del Spencer is the owner and founder of Del Spencers Mens Clothing Store. Del Spencers has its own house charge accounts and has found from past experience that 10 percent of its sales are for cash. The remaining 90 percent are on credit. An aging schedule for accounts receivable reveals the following pattern: 15 percent of credit sales are paid in the month of sale. 65 percent of credit sales are paid in the first month following the sale. 14 percent of credit sales are paid in the second month following the sale. 6 percent of credit sales are never collected. Credit sales that have not been paid until the second month following the sale are considered overdue and are subject to a 3 percent late charge. Del Spencers has developed the following sales forecast: Required: Prepare a schedule of cash receipts for August and September.arrow_forwardBudgeted income statement and balance sheet As a preliminary to requesting budget estimates of sales, costs, and expenses for the fiscal year beginning January 1, 2017, the following tentative trial balance as of December 31, 2016, is prepared by the Accounting Department of Regina Soap Co.: Cash............................................................. 85,000 Accounts Receivable............................................... 125,600 Finished Goods................................................... 69,300 Work in Process................................................... 32,500 Materials......................................................... 48,900 Prepaid Expenses................................................. 2,600 Plant and Equipment.............................................. 325,000 Accumulated Depreciation Plant and Equipment.................. 156,200 Accounts Payable................................................. 62,000 Common Stock, 10 par........................................... 180,000 Retained Earnings................................................. 290,700 688,900 688,900 Factory output and sales for 2017 are expected to total 200,000 units of product, which are to be sold at 5.00 per unit. The quantities and costs of the inventories at December 31, 2017, are expected to remain unchanged from the balances at The beginning of the year. Budget estimates of manufacturing costs and operating expenses for the year are summarized as follows: Estimated Costs and Expenses Cost of goods manufactured and sold: Fixed (Total for Year) Direct materials................................................ 1.10 Direct labor.................................................... 0.65 Factory overhead: Depreciation of plant and equipment.......................... 40,000 Other factory overhead....................................... 12,000 0.40 Selling expenses: Sales salaries and commissions.................................. 46,000 0.45 Advertising.................................................... 64,000 Miscellaneous selling expense.................................. 6,000 0.25 Administrative expenses: Office and officers salaries...................................... 72,400 0.12 Supplies....................................................... 5,000 0.10 Miscellaneous administrative expense........................... 4,000 0.05 Balances, of accounts receivable, prepaid expenses, and accounts payable at the end of the year are not expected to differ significantly from the beginning balances. Federal income tax of 30,000 on 2017 taxable income will be paid during 2017. Regular quarterly cash dividends of 0.15 per share are expected to be declared and paid in March, June, September, and December on 18,000 shares of common stock outstanding. It is anticipated that fixed assets will be purchased for 75,000 cash in May. Instructions 1. Prepare a budgeted income statement for 2017. 2. Prepare a budgeted balance sheet as of December 31, 2017, with supporting calculations.arrow_forward
Recommended textbooks for you
Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage Learning
Financial & Managerial AccountingAccountingISBN:9781285866307Author:Carl Warren, James M. Reeve, Jonathan DuchacPublisher:Cengage Learning
Cornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage Learning
Cornerstones of Cost Management (Cornerstones Ser...
Accounting
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Cengage Learning
Financial & Managerial Accounting
Accounting
ISBN:9781285866307
Author:Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:Cengage Learning
Cornerstones of Financial Accounting
Accounting
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Cengage Learning
The management of receivables Introduction - ACCA Financial Management (FM); Author: OpenTuition;https://www.youtube.com/watch?v=tLmePnbC3ZQ;License: Standard YouTube License, CC-BY