Question

Copy the range C6:D6 to cell B13. Click cell C13, and then use Goal Seek to determine the projected amount of Endowment Investments in cell B13 if the value in C13 is 10%.

А B % of Total Projected Investments City of Orange Blossom Beach Investment Portfolio Projection for Next Fiscal Year Budget Projected Current Year Investments for Next Investments Fiscal Year 28,809,800 $ 32,956,740 8,120,500 6,754,950 13,786,400 22,712,600 4,007,520 6,874,325 11,694,500 13,987,550 $ 66,418,720 $ 83,286,165 5 ed Investments 6 wment 7 stment Reserves 8 ial 9 Agent Funds 39.57% 8.11% 27.27% 8.25% 16.79% 10 11 Goal: Increase Endowment Fund from 8% to 10% Amount 14

I need help how to do Copy the range C6:D6 to cell B13. Click cell C13, and then use Goal Seek to determine the projected amount of Endowment Investments in cell B13 if the value in C13 is 10%.

Answer 1

The following data is already given in Excel sheet. Using Goal Seek, we have to determine the projected amount of Endowment Investments in cell B13 if the value in C13 in Excel sheet given above is 10%.

The following table shows the Investment portfolio of City of Orange Blossom Beach.

City of Orange Blossom Beach
Investment Portfolio
Projection for Next Fiscal Year Budget
	Current Year Investments ($)	Projected Investments for Next Fiscal Year ($)	% of Total Projected Investments
Pooled Investments	$       28,809,800	$               32,956,740	39.57%
Endowment	$         8,120,500	$                 6,754,950	8.11%
Investment Reserves	$       13,786,400	$               22,712,600	27.27%
Special	$         4,007,520	$                 6,874,325	8.25%
Fiscal Agent Funds	$       11,694,500	$               13,987,550	16.79%
Total	$       66,418,720	$               83,286,165
Goal: Increase Endowment Fund from 8% to 10%
Goal Amount	$         8,328,617	10.00%

To determine the projected amount or goal amount in cell B13, we have to divide cell C6 by cell D6 i.e. $ 6,754,950 / 8.11% = $83,286,165. After that, take 10% (cell C13) of $83,286,165.

The final answer is $ 8,328,617.

Therefore, The projected amount of Endowment Investments in cell B13 is $ 8,328,617.