Connect Saved ? 5 Calculating EFN- Excel FORMULAS REVIEW VIEW Sign In INSERT DATA HOME PAGE LAYOUT X Cibri 11 -A A Cells Editing BIU. SA % Alignment Number Conditional Format as Cell Formatting Table Styles" Styles Font oard v G K HIJ L E F D M Information from the financial statements of the Heir Jordan Corporation are shown below. Prepare the pro forma financial statements and calculate EFN, assuming a 15 percent increase in sales, no new external debt or equity financing, and a constant payout ratio. + Sales Costs Cash Accounts receivable Inventory Net plant and equipment Accounts payable Notes payable Long-term debt Common stock Retained earnings Dividends Net income G.GOGO 46,000 37,600 2,950 4,100 6,400 41,300 2,400 5,400 28,000 15,000 3,950 2,880 6,552 $ $ Saved ? Calculating EFN- Excel FORMULAS DATA REVIEW VIEW LE HOME INSERT PAGE LAYOUT Calibri -111 A Cells Editing . BIU E- te Alignment Number Conditional Format as Cell Formatting Table Styles Styles board Font : X fix HI G J L K E F AB D Increase in sales Tax rate 15% 21% Complete the following analysis. Do not hard code values in your calculations. Payout ratio Pro forma income statement Sales Costs Taxable income Taxes Net income Dividends Addition to retained earnings Balance Sheet Assets Liabilities and Owners' equil Ch 04 - Fall 2020 MGMT 3100 x Connect how to find the interest growth x + Vext/map/index.html?_con=con&external_browser=0&launchurl=https%253A%252F%252Fims.mheducation.com% Connect Saved X Colung ErN-EXO FORMULAS DATA REVIEW VIEW Sign in HOME INSERT PAGE LAYOUT Calibri - 11 -AA Cells Editing BIU- A. Alignment Number Conditional Format as Cell Formatting Table Styles Styles Font X fax K L M D B Current assets Cash Accounts receivable Inventory Total EF G Current liabilities Accounts payable Notes payable Total Long-term debt Fixed assets Net plant and equipment Owners' equity Common stock Retained earnings Total Total liabilities and owners' equity Total assets External financing needed