anyone know how to do it in excel

B D E F G H J K L 1 2 3 4 5 Biscuit Farms Inc. has the following data, and it follows the residual dividend model. Currently, it finances with 15% debt. Some Biscuit family members would like for the dividend payout ratio to be increased. If Biscuit increased its debt ratio to 70%, by how much could the dividend payout ratio be increased, holding other things constant? Fill in Cells F15:G16, 115:116, 116 6 7 8 9 10 11 12 13 14 15 16 17 18 Capital Budget Net Income % Debt now % Debt after change $3,000,000 $3,500,000 15% % Equity now 70% % Equity after change Dividend Payout ratio Payout ratio Difference