Please answer this question and use excel if you can. Provide all work and excel file used to find the correct answers.

Imagine you are the GP of a Private Equity firm. You have invested $250,000 each in 30 deals. 30% of these deals are expected to be write-offs (you did not make anything on these, you lost all your money). 50% of the deals are expected to make a return of only 5% each. 10% of the deals are expected to make a return of only 10% each. On the remaining 10%, you quadruple your money. What is the return on your total investment portfolio?