Complete the following problems from chapter 3 in the textbook: P3-3: Income statement preparation On December 31 2015 Cathy Chen a self-employed certified public accountant (CPA) completed her first full year in business. During the year she billed$360 000 for her accounting services. She had two employees a bookkeeper and a clerical assistant. In addition to her monthly salary of $8 000 Ms. Chen paid annual salaries of $48 000 and $36 000 to the bookkeeper and the clerical assistant respectively.Employment taxes and benefit costs for Ms. Chen and her employees totaled $34 600 for the year. Expenses for office supplies including postage totaled $10 400 for the year. In addition Ms. Chen spent $17 000 during the year on tax-deductible travel andentertainment associated with client visits and new business development. Lease payments for the office space rented (a taxdeductible expense) were $2 700 per month. Depreciation expense on the office furniture and fixtures was $15 600 for the year. Duringthe year Ms. Chen paid interest of $15 000 on the $120 000 borrowed to start the business. She paid an average tax rate of 30% during 2015. a. Prepare an income statement for Cathy Chen CPA for the year ended December 31 2015. • b. Evaluate her 2015 financialperformance. P3-6: Balance sheet preparation Use the appropriate items from the following list to prepare in good form Mellark’s Baked Goods balance sheet atDecember 31 2015. P3-10: Statement of retained earnings Hayes Enterprises began 2015 with a retainedearnings balance of $928 000. During 2015 the firm earned $377 000 after taxes. From this amount preferred stockholders were paid $47 000 in dividends. At year-end 2015 the firm’s retained earnings totaled $1 048 000. The firm had 140 000 shares of commonstock outstanding during 2015. a. Prepare a statement of retained earnings for the year ended December 31 2015 for Hayes Enterprises. (Note: Be sure to calculate and include the amount of cash dividends paid in 2015.) b. Calculate the firm’s 2015 earningsper share (EPS). c. How large a per-share cash dividend did the firm pay on common stock during 2015? P3-16: Accounts receivable management An evaluation of the books of Blair Supply which follows gives the end-of-year accounts receivable balance whichis believed to consist of amounts originating in the months indicated. The company had annual sales of $2.4 million. The firm extends 30-day credit terms. a. Use the year-end total to evaluate the firm’s collection system. b. If 70% of the firm’s sales occurbetween July and December would this information • affect the validity of your conclusion in part a? Explain. • P3-18: Debt analysis Springfield Bank is evaluating Creek Enterprises which has requested a $4 000 000 loan to assess the firm’s financial leverageand financial risk. On the basis of the debt ratios for Creek along with the industry averages (see the top of the next page) and Creek’s recent financial statements (following) evaluate and • recommend appropriate action on the loan request. • Part II:P3-20: Common-size statement analysis A common-size income statement for Creek Enterprises’ 2014 operations follows. Using the firm’s 2015 income statement presented in Problem 3–18 develop the 2015 common-size income statement and compare it with • the 2014statement. Which areas require further analysis and investigation? • P3-21: The relationship between financial leverage and profitability Pelican Paper Inc. and Timberland Forest Inc. are rivals in the manufacture of craft papers. Some financial statementvalues for each company follow. Use them in a ratio analysis that • compares the firms’ financial leverage and profitability. • • Follow these instructions for completing and submitting your assignment: 1. Do all work in Excel. Do not submit Word files or*.pdf files. 2. Submit a single spreadsheet file for this assignment. Do not submit multiple files. 3. Place each problem on a separate spreadsheet tab. 4. Label all inputs and outputs and highlight your final answer. 5. Follow the directions in “Guidelinesfor Developing Spreadsheets.” You are not required to submit this assignment to Turnitin.
