Challenging Business Problems with Detailed Answers

Kelly Pitney began her consulting business, Kelly Consulting, on April 1, 2016. The accounting cycle for Kelly Consulting for April, including financial statements, was illustrated in this chapter. During May, Kelly Consulting entered into the following transactions:May 3. Received cash from clients as an advance payment for services to be provided and recorded it as unearned fees, $4,500.5. Received cash from clients on account, $2,450.9. Paid cash for a newspaper advertisement, $225.13. Paid Office Station Co. for part of the debt incurred on April 5, $640.15. Recorded services provided on account for the period May 115, $9,180.16. Paid part-time receptionist for two weeks' salary including the amount owed on April 30, $750.17. Recorded cash from cash clients for fees earned during the period May 116, $8,360.Record the following transactions on Page 6 of the journal:20. Purchased supplies on account, $735.21. Recorded services provided on account for the period May 1620, $4,820.25. Recorded cash from cash clients for fees earned for the period May 1723, $7,900.27. Received cash from clients on account, $9,520.28. Paid part-time receptionist for two weeks' salary, $750.30. Paid telephone bill for May, $260.31. Paid electricity bill for May, $810.31. Recorded cash from cash clients for fees earned for the period May 2631, $3,300.31. Recorded services provided on account for the remainder of May, $2,650.31. Kelly withdrew $10,500 for personal use.Instructions:Enter the unadjusted trial balance on an end-of-period spreadsheet (work sheet) and complete the spreadsheet using the following adjustment data. Insurance expired during May is $275. Supplies on hand on May 31 are $715. Depreciation of office equipment for May is $330. Accrued receptionist salary on May 31 is $325. Rent expired during May is $1,600. Unearned fees on May 31 are $3,210. If an amount box does not require an entry, leave it blank or enter "0". Kelly Consulting End-of-Period Spreadsheet (Work Sheet) For the Month Ended May 31, 20Y8: Unadjusted Adjustments Adjusted Income Balance Trial Balance Trial Balance Statement Sheet Account Title Debit Credit Debit Credit Debit Credit Debit Credit Debit Credit Cash Accounts Receivable Supplies Prepaid Rent Prepaid Insurance Office Equipment Accum. Depreciation Accounts Payable Salaries Payable Unearned Fees Common Stock Retained Earnings Dividends Fees Earned Salary Expense Rent Expense Supplies Expense Depreciation Expense Insurance Expense Miscellaneous Expense Net income
Delsing Canning Company is considering an expansion of its facilities. Its current income statement is as follows:Sales $ 6,200,000Variable costs (50% of sales) 3,100,000Fixed costs 1,920,000Earnings before interest and taxes (EBIT) $ 1,180,000Interest (10% cost) 440,000Earnings before taxes (EBT) $ 740,000Tax (30%) 222,000Earnings after taxes (EAT) $ 518,000Shares of common stock 320,000Earnings per share $ 1.62The company is currently financed with 50 percent debt and 50 percent equity (common stock, par value of $10). In order to expand the facilities, Mr. Delsing estimates a need for $3.2 million in additional financing. His investment banker has laid out three plans for him to consider:Sell $3.2 million of debt at 14 percent.Sell $3.2 million of common stock at $20 per share.Sell $1.60 million of debt at 13 percent and $1.60 million of common stock at $25 per share.Variable costs are expected to stay at 50 percent of sales, while fixed expenses will increase to $2,420,000 per year. Delsing is not sure how much this expansion will add to sales, but he estimates that sales will rise by $1.60 million per year for the next five years.Delsing is interested in a thorough analysis of his expansion plans and methods of financing.He would like you to analyze the following:Required:a. The break-even point for operating expenses before and after expansion (in sales dollars). (Enter your answers in dollars not in millions, i.e, $1,234,567.)b. The degree of operating leverage before and after expansion. Assume sales of $6.2 million before expansion and $7.2 million after expansion. Use the formula: DOL = (S TVC) / (S TVC FC). (Round your answers to 2 decimal places.)c-1. The degree of financial leverage before expansion. (Round your answers to 2 decimal places.)c-2. The degree of financial leverage for all three methods after expansion. Assume sales of $7.2 million for this question. (Round your answers to 2 decimal places.)d. Compute EPS under all three methods of financing the expansion at $7.2 million in sales (first year) and $10.1 million in sales (last year). (Round your answers to 2 decimal places.)