Urgent need asap

I have step 1-4 completed. I need 5-12 added for my group project to be completed.

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 UPC’s 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.
• UPC’s 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.

Individual Portion:

Using course materials and the library, identify 4 sections (or stages) in designing a capital plan for UPC. For instance, you may pick 4 sections in the capital planning cycle. Your group should share the sections in the planning cycle such that the group will cover all of the sections in the cycle.

Sections in a capital plan may include the following:

1.      Analysis of project impact and risks

2.      Appropriations

3.      Ranking of project options and scenarios

4.      Project filtering and accept or reject decisions

5.      Analysis of capital sources and funding

6.      Allocation of funds among independent or mutually exclusive projects

7.      Review and approval of capital plan

8.       Capital budget reviews, monitoring, and reporting

Group Portion:

I need a complete capital planning cycle for UPC. There need to be an Excel worksheets showing calculations and a Word document for my discussions.

Additionally, include a PowerPoint Presentation of your capital planning cycle.