Instructions

You can complete this assignment on Excel by following the steps outlined in detail below. I have used the symbols [ ] to designate what you should enter into Excel. For example if you see [=E3*2] I want you to type in the equals sign followed by E3, *, and finishing with 2. Typically you will press enter when you are done filling in the information.

1A) Calculate the expected rate of return for Franchise A

1. First calculate the probable returns for each projected rate of return.
   1. In C4 write [=A4*B4].
   2. Drag the equation down to apply from C4 to C8
2. Next calculate the expected rate of return for the investment.
   1. In C9 write [=SUM(C4:C8)]