Please show step by step. Thank you.

FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In Calibri 11 A IB w Paste % Alignment Number Conditional Format as Cell Formatting Table Styles Styles Cells Editing Clipboard Font A1 fac A B 00 B G L M D EF 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. 3 4 5 6 $ $ 7 00 8 D 10 $ $ 11 12 Sales Costs Cash Accounts receivable Inventory Net plant and equipment Accounts payable Notes payable Long-term debt Common stock Retained earnings Dividends Net income 0 0 0 0 0 0 0 0 0 0 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 13 $ 14 15 16 $ $ $ 17 18 19 20 Increase in sales Tax rate 15% 21% 21 22 23 Sheet1 + FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In Calibri 11 AA % Paste BI U > % Alignment Number Conditional Format as Cell Formatting Table Styles Styles Cells Editing Clipboard Font 2