My Account

Home Solutions 3) Write the formula in the box below that you used in the cell that gives the Total as being 100% (cell C8)

We write, we donâ€™t plagiarise! Every answer is different no matter how many orders we get for the same assignment. Your answer will be 100% plagiarism-free, custom written, unique and different from every other student.

I agree to receive phone calls from you at night in case of emergency

Please share your assignment brief and supporting material (if any) via email here at: [email protected] after completing this order process.

The primary theme of the paper is 3) Write the formula in the box below that you used in the cell that gives the Total as being 100% (cell C8) in which you are required to emphasize its aspects in detail. The cost of the paper starts from $129 and it has been purchased and rated 4.9 points on the scale of 5 points by the students. To gain deeper insights into the paper and achieve fresh information, kindly contact our support.

Required:

1) Using excel, and the data provided on the previous page, open a new spreadsheet in excel and replicate the spreadsheet below where you will see the format we require. Show the asset allocation, returns and weighted returns for both the BCG Balanced fund and the BCG Growth fund. (Save the spreadsheet for submission.)

2) Create a pie chart for each fund showing the asset allocation of each fund.

3) Write the formula in the box below that you used in the cell that gives the Total as being 100% (cell C8)

4) Write the formula in the box below that you used in the cell that gives the weighted return for Cash in the BCG Balanced Fund (cell E2)

5) Write the formula in the box below that you used in the cell that gives the Total weighted return for the BCG Growth Fund (cell E22)

6) When looking at a cell reference, how do you know if the cell is a “relative” cell reference in excel or an ‘’absolute” cell reference in excel? Remember, you can google or youtube this, in addition to the notes we have provided in Appendix 5 if you need additional help.

7) Provide an example of when you might use a relative cell reference in excel. Remember, you can google or youtube this, in addition to the notes we have provided if you need additional help.

8) Provide an example of when you might use an absolute cell reference in excel. Remember, you can google or youtube this, in addition to the notes we have provided if you need additional help.

9) Explain what is meant by a weighted return.

10) Ensure you submit your excel spreadsheet including the pie chart when you submit your assignment.

Check Out Our Original Reviews