This assignment Must be completed using Excel (please show formulas too – cant just have the values showing)

There are three independent assignments. Save the file and submit it here. (photos for each of the problems is attached here) 

• Location Selection on Page 420 #39;
• Portafolio Allocation on page 419 #36 and
• Markdown Price Model on page 415 #18