For this assignment, you and your group will create a capital plan. Your plan will take into consideration all of the information you know about Universal Parts Company. Additionally, you will make and document any assumptions necessary to plan for UPCs capital needs. The director of finance has provided you with the following information:

• UPC will need $100 million in the next 10 years to sustain its growth and remain competitive in its market.
• UPCs desired capital structure is 30% debt and 70% equity.
• UPC will sell its fleet of trucks within the next 12 months. Instead, the company plans to lease trucks for shipping products to customers.

In Excel