Excel
Durga-prasad_01
Anika-DSMSimpleExcelExercise.xlsxQuestion 1
| Widget List Price: | $ 54,002.00 | |||
| Customer ABC | # of Units Purchased | Purchase Price | ||
| 1 | List Price | |||
| 3 | 12% Discount | |||
| 2 | 16% Discount | |||
| QUESTION: | Assume that our company sells widgets. The list price for a single widget is $54,002. Since becoming a customer, Customer ABC has purchased a total of 6 units at the price points listed above. Based on this information, calculate and provide answers for the questions below. (Please show your forumlas) | |||
| (a) | What's the Total Price Paid? | |||
| (b) | What's the Average Price Paid? | |||
| (c) | What's the Weighted Average Discount? |
Question 2
| Allocation | Expected Rate of Return | ||
| Investment A | 25% | 5% | |
| Investment B | 25% | 6% | |
| Investment C | 50% | 2% | |
| QUESTION: | Mr. Sumo is considering investing across three assets at the allocation perecentages listed above. What is the expected rate of return for the above portfolio? Please show your work/formulas in this sheet. | ||
