The components of a bond portfolio are listed below:

Bond Market value $(000$s$)$ Duration

$16434\mathrm{.}33$

$27785\mathrm{.}06$

$35604\mathrm{.}51$

$47553\mathrm{.}15$

The target portfolio dollar duration is $$100$K$.$ If you want to maintain the same proportions of the assets in the portfolio while rebalancing it to target duration, what will be dollar change in the size of the resulting portfolio?

$($Note that it can be negative or positive, depending on whether you need dollar duration to increase or decrease to reach the target.$)$

Correct Answer

$-382,394\mathrm{.}92$ margin of error $+/-1\%$

You need to scale the portfolio up or down until its dollar duration is equal to $100$k$.$Need the correct Excel Forumula that gets the ANSWER $-382,394\mathrm{.}92$