EXCEL 4-6 Application Capstone Project IN THIS PROJECT This project relates to Front Range Action Sports, which is one of the country's largest retailers of sports gear and outdoor recreation merchandise. The company has large retail stores in Colorado, Washington, Oregon, Idaho, California, and New Mexico, in addition to a growing online business. Major merchandise categories include fishing, camping, rock climbing, winter sports, action sports, water sports, team sports, racquet sports, fitness, golf, apparel, and footwear. In this project, you will apply skills you practiced from the objectives in Excel Chapters 4 through 6. You will develop two workbooks for Frank Osei, the Vice President of Finance. You will create a loan payment table and an organization chart for the new Idaho Store, develop a phone order form for the newest lines of apparel, create a chart displaying skier attendance, and standardize an expense report template to ensure accurate data entry for winter carnival expenses. Your completed worksheets will look similar to Figure 2.1. PROJECT FILES For Project Cap2, you will need the You will save your workbooks as: following files: Lastname_Firstname_Cap2_Expense_Template eCap2_Expense_Report Lastname_Firstname_Cap2_Financial_Report eCap2_Financial_Report eCap2_Erica eCap2_Kate eCap2_Laura eCap2_Sean eCap2_Tyler PROJECT RESULTS FIGURE 2.1 Project Cap2 Financial Report