We're Open
+44 7340 9595 39
+44 20 3239 6980

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



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

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.)

 

  • Ensure that formulae are used in the excel spreadsheet to find the ‘Total’ asset allocation of 100% .
  • Use formulae in the excel spreadsheet to calculate the weighted returns for each funds.
  • Use formulae in the excel spreadsheet to calculate the total weighted return for each fund.

 

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

  • Include a legend showing which asset class each colour represents
  • Include data labels on the pie charts to show the actual percentages allocated to each asset class
  • Include a title for 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.


Price: £ 129

100% Plagiarism Free & Custom Written, Tailored to your instructions

Details

  • Title: 3) Write the formula in the box below that you used in the cell that gives the Total as being 100% (cell C8)
  • Price: £ 129
  • Post Date: 2018-11-06T11:10:44+00:00
  • Category: Assignment Requirements
  • No Plagiarism Guarantee
  • 100% Custom Written

Customer Reviews

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

A masterpiece of assignment by , written on 2020-03-12

CIPD assignment is not my cup of tea. That’s the reason I sought out this place suggested by my friend. I would say that the writers of this site are really admiring. I was assigned the best CIPD writer that solved all my issues. He explained to me the difficult topics so well that now I am able to talk on those topics eloquently. I owe my writer a huge thanks and praise! And yes, I would recommend other students as well to come to instaresearch.co.uk for the top CIPD assignment help.
Reviews: 5

A masterpiece of assignment by , written on 2020-03-12

I have been taking help from Insta Research since 2015 and believe me, this place is incredible in giving the best help in assignments and essays. I also ask them to run plagiarism in my essays that I have written, and they always gave me accurate results. I am literally blessed to have a strong bonding with this site so that in any need of urgency, I contact them and find them always beside me. Thank you!

Write your Feedback

Your email address will not be published. Required fields are marked *