hi Problem Management of Ice Cold is contemplating the purchase of a new ice cream truck. The company plans to establish new routes for each of the trucks near the beaches in Southern California where the weather is pleasant year-round. Considerable research has been performed on estimated demand in consideration of expected larger demand during the summer and weekends. The cash flows of the van models differ due to the freezer capacity and customer windows. specifications. The company's minimum required rate of return is 10%. Details of the purchase price of the vans given below: Step Van Models GMC Utilimaster Freightliner GMC Morgan Olson Initial investment $ 62,756 48,135 54,257 79,730 Instructions: There are multiple parts to this problem. Use Excel to perform the following: PART 1: Complete the table as outlined in the worksheet "Summary". All requirements are listed as letters A through J on that worksheet. The table must be computed using Excel formulas; no numbers are to be entered! +

Management of lce Cold is contemplating the purchase of a new ice cream truck. The company plans to establish new routes for each of the trucks near the beaches in Southern Callfornia where the weather is pleasant year-round. Considerable research has been performed on estimated demand in consideration of expected larger demand during the summer and weekends. The cash flows of the van models differ due to the freezer capacity and customer windows. specifications. The company's minimum required rate of return is 10\%. Details of the purchase price of the vans is given below: Instructions: There are multiple parts to this problem. Use Excel to perform the following: PART 1: Complete the table as outlined in the worksheet "Summary". All requirements are listed as letters A through J on that worksheet. The table must be computed using Excel formulas; no numbers are to be entered