show in Excel

Ring Technology has a capital budget of $850,000, it wants to maintain a target capital structure of 35% debt and 65% equity, and it also wants to pay a dividend of $400,000. If the company follows the residual dividend model, how much net income must it earn to meet its capital budgeting requirements and pay the dividend, all while keeping its capital structure in balance? Capital budget debt pct equity pct equity contribution dividends Net Income