Concept explainers
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?
Want to see the full answer?
Check out a sample textbook solutionChapter 14 Solutions
SURVEY OF ACCOUNTING 360DAY CONNECT CAR
- 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
- Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage LearningFinancial & Managerial AccountingAccountingISBN:9781285866307Author:Carl Warren, James M. Reeve, Jonathan DuchacPublisher:Cengage LearningCornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage Learning