Payback Period NPV Corellian Engineering Corporation Project Development Criteria YT 1300 VCX 100 Formulas Inwestment Awal Sales Est Payback - Investment Sales Rate of Payback Perid Payback period Rate of Return Acceptable -IFCANDDIES,D13--0.15). "Yes","No") -IRANDAFII SF130.15). "Yes","No") Payback period does not take into account the time value of money "Rate of Return is the inverse of the payback period Payback Period NPV Corellian Engineering Corporation Project Development Criteria Year 2 0 YT 1300 Required Rate (Given) Outflow Inflow Not NPV Year 2 VCX 100 Required Rate (Given) Outlow Inflow Net NPV Please use the following spreadsheet to complete this project. Project 1.2.xlsx la Deliverables: 1. Upload completed Excel spreadsheet here Project 1.2: Your team at Corellian Engineering has $1 billion to invest in new product development. This time, management has decided to invest in freighters with FTL Hyperdrives, so they have narrowed the selection down to two projects as described below. Your task is to calculate the Payback period and Rate of Return. Management will only accept a project if it has a payback period of fewer than 5 years AND the rate of return is at least 15%. YT-1300 www This freighter is capable of making the Kessel Run in less than 12 parsecs, in the right hands. It has multiple sensor-proof cargo holds, dual phase cannons, and inertial dampeners to cushion the 3,000 Gs suffered from ludicrously fast speeds. The financials are as follows: Initial Investment: $700,000,000 Estimated Annual Sales: $225,000,000 VCX-100 light freighter This has sleeping quarters and perhaps even a kitchen. It is also outfitted with a magnetic cargo clamp on its ventral plating, capable of holding several bulk containers. The cargo bay and main entrance ramp of the VCX-100 is located in the front of the freighter, making loading and unloading easier. The financials are as follows: Initial Investment: $400,000,000 Estimated Annual Sales: $110,000,000