Question: please help with excel step-by-step (detailed) much appreciated **IMPORTANT** PLEASE MAKE SURE TO USE EXCEL WITH FORMULAS CompUSA Corp.'s projected net income is $180 million,
please help with excel step-by-step (detailed) much appreciated **IMPORTANT** PLEASE MAKE SURE TO USE EXCEL WITH FORMULAS
CompUSA Corp.'s projected net income is $180 million, its current target capital structure is 25% debt and 75% equity, and its current target dividend payout ratio is 35%. CompUSA has more positive NPV projects than it can finance without issuing new stock, but its board of directors decided that it cannot issue any new shares in the foreseeable future. The CFO now wants to determine how the maximum capital budget would be affected by changes in capital structure policy and/or the target dividend payout policy. Compared to the current policy, how much increase could the total capital budget be if the target payout ratio is lowered to 25% and the target proportion of debt is raised to 48% debt and 52% equity at the same time, net income is held constant?
PLEASE HELP WITH EXCEL STEP-BY-STEP (IN FULL detail) much appreciated **IMPORTANT** I WANT TO LEARN
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
