What would I enter in for the calculations in each excel cell? I keep getting zero for answers and i know its not right. (first picture p.202 with bulleted list - that is what is given to make calculations but I don't understand how to do them correctly)

what are the equations i use to get the answers?

202 Case 9 . Percentage invested in Stocks and Bonds--This value is the sum of amounts invested in stock and bond funds versus the total invested in all kinds of funds. Note that precious metals farba are not included in stock funds. Revenue earned The revenue earned for a type of fund is a function of the amount invested in it and its average rate of return Administrative Costs-The administrative cost for a type of fund is a function of the amount invested in it and its average administrative expense rate. Risk Points-The risk points for a type of fund is a function of the amount invested in it and ina assigned risk factor. Total Risk Points to Total amount Invested - This total is the average risk factor for the fund funds. It is the total risk points for all types of funds divided by the total amount invested in all types of funds. . Income Statement Section The statement shown in Figure 9-8 is the projected net annual income on the amounts invested in the fundo funds. An explanation of the line items follows Figure 9-8. 47 Income Statement 48 Total Revenue 49 Total Administrative Costs 50 Net Income Before Tax Source: Microsoft product screenshots used with permission from Microsoft Corporation FIGURE 9-8 Income Statement section Total Revenue-This amount is the sum of the revenues earned, as shown in the Calculations section Total Administrative Costs-This amount is the sum of administrative costs, as shown in the Calculations section. Net Income Before Tax-This amount is the difference between Total Revenue and Total Administrative Costs. . SO Microsoft product screenshots used with permiso Me Corpo GURE 96 Constants section Second product screenshots used with permission from Microsoft Corporation GURE 97 Calculations section Total Amount Invested-Amounts invested are shown in the changing cells. able to me chroef Rund The Fundus sounds Metal unde runds runde recious Metals Body Nu Metals funds . mutual fund. . Cash available to invest --You have $100 million to invest. Minimum investment in each type of fund. You must invest at least $10 million in each type of Expected Rates of Return - The expected average rate of return is different for each kind of fund. For example, the rate is 8 percent for funds that invest in industrial company common stock Administrative Cost Rate-The expected average expense rate is different for each kind of fund. For example, the rate is eight-tenths of one percent for funds that invest in industrial company Risk Factor- The expected average risk factor is different for each kind of fund. For example, the factor is 3 for funds that invest in industrial company common stocks . common stocks . Calculations Section Your spreadsheet should calculate the amounts shown in Figure 9-7. These values will be wed later in the soome statement or as constraints. Calculated values may be based on the values of the changing cells, the stunts, and other calculations. An explanation of the line items follows Figure 9-7. Percentage invested in Stocks and Bonds Bond funds Precious Metals funds & Cut DE Copy Calibri - 111 Paste BIU A-EESE Format Painter Clipboard Font Alignm B31 =B3 B12 A B 25 REIT funds 4 $4 100% $0 $0 $0 $0 26 27 Calculations 28 Total Amount Invested 29 Percentage invested in Stocks and Bonds 30 Revenue earned: 31 Stock funds 32 Bond funds 33 Precious Metals funds 34 REIT funds 35 Administrative Costs: 36 Stock funds 37 Bond funds 38 Precious Metals funds 39 REIT funds 40 Risk Points: 41 Stock funds 42 Bond funds 43 Precious Metals funds 44 REIT funds 45 Total Risk Points to Total amount invested 46 Funds Original Ready Scroll Lock $ol SO $0 SO 3 1 5 4 3.25 18 O O 202 Case 9 . Percentage invested in Stocks and Bonds--This value is the sum of amounts invested in stock and bond funds versus the total invested in all kinds of funds. Note that precious metals farba are not included in stock funds. Revenue earned The revenue earned for a type of fund is a function of the amount invested in it and its average rate of return Administrative Costs-The administrative cost for a type of fund is a function of the amount invested in it and its average administrative expense rate. Risk Points-The risk points for a type of fund is a function of the amount invested in it and ina assigned risk factor. Total Risk Points to Total amount Invested - This total is the average risk factor for the fund funds. It is the total risk points for all types of funds divided by the total amount invested in all types of funds. . Income Statement Section The statement shown in Figure 9-8 is the projected net annual income on the amounts invested in the fundo funds. An explanation of the line items follows Figure 9-8. 47 Income Statement 48 Total Revenue 49 Total Administrative Costs 50 Net Income Before Tax Source: Microsoft product screenshots used with permission from Microsoft Corporation FIGURE 9-8 Income Statement section Total Revenue-This amount is the sum of the revenues earned, as shown in the Calculations section Total Administrative Costs-This amount is the sum of administrative costs, as shown in the Calculations section. Net Income Before Tax-This amount is the difference between Total Revenue and Total Administrative Costs. . SO Microsoft product screenshots used with permiso Me Corpo GURE 96 Constants section Second product screenshots used with permission from Microsoft Corporation GURE 97 Calculations section Total Amount Invested-Amounts invested are shown in the changing cells. able to me chroef Rund The Fundus sounds Metal unde runds runde recious Metals Body Nu Metals funds . mutual fund. . Cash available to invest --You have $100 million to invest. Minimum investment in each type of fund. You must invest at least $10 million in each type of Expected Rates of Return - The expected average rate of return is different for each kind of fund. For example, the rate is 8 percent for funds that invest in industrial company common stock Administrative Cost Rate-The expected average expense rate is different for each kind of fund. For example, the rate is eight-tenths of one percent for funds that invest in industrial company Risk Factor- The expected average risk factor is different for each kind of fund. For example, the factor is 3 for funds that invest in industrial company common stocks . common stocks . Calculations Section Your spreadsheet should calculate the amounts shown in Figure 9-7. These values will be wed later in the soome statement or as constraints. Calculated values may be based on the values of the changing cells, the stunts, and other calculations. An explanation of the line items follows Figure 9-7. Percentage invested in Stocks and Bonds Bond funds Precious Metals funds & Cut DE Copy Calibri - 111 Paste BIU A-EESE Format Painter Clipboard Font Alignm B31 =B3 B12 A B 25 REIT funds 4 $4 100% $0 $0 $0 $0 26 27 Calculations 28 Total Amount Invested 29 Percentage invested in Stocks and Bonds 30 Revenue earned: 31 Stock funds 32 Bond funds 33 Precious Metals funds 34 REIT funds 35 Administrative Costs: 36 Stock funds 37 Bond funds 38 Precious Metals funds 39 REIT funds 40 Risk Points: 41 Stock funds 42 Bond funds 43 Precious Metals funds 44 REIT funds 45 Total Risk Points to Total amount invested 46 Funds Original Ready Scroll Lock $ol SO $0 SO 3 1 5 4 3.25 18 O O