Please show all values AND formulas in excel.

Problem 3: Plastics Recycling Business Case (20 Points) While I was running my plastics recycling business, I needed to raise $500,000 for some immediate upgrades. Since this is new to me and my credit rating was not excellent at that point, I decided to approach a local venture capitalist rather than a local bank. I offered the venture capitalist to pay $100,000 at the end of cach year for 10 years starting received the money. I soon realized that the venture capitalist normally does not use his money and he makes deals with the local banks. Since his credit rating is excellent, he has persuaded the bank to loan him $300,000 for which he will pay $50,000 at the end of each year for 10 years starting from Year 1 from the issuance of the loan. It means the venture capitalist used $200,000 of his money to help me with the $500,000 loan. The venture capitalist charges the 18% interest rate on my loan. The bank charges the 10% interest rate on the loan to the venture capitalist. from Year 1 afterI Part 1: Venture Capitalist (VC) (a) Create the Cash Flow 1 for VC, who lends S500,000 to me. (b) Calculate the NPV for the Cash Flow 1 (c) Create the Cash Flow 2 for VC, who borrows $300,000 from the bank. (d) Calculate the NPV for the Cash Flow 2. (e) Calculate the final NPV for VC (f) Explain whether this investment is a good deal for VC using the (e) result. If yes, why? If no, why not? Part 2: Bank (a) Create the Cash Flow for the bank. (b) Calculate the NPV Explain whether this investment is a good deal for the Bank using the (b) result. If yes, why? If no, why not? (c) Part 3: Me (a) Create the Cash Flow for moe. (b) Calculate the NPV (c) Explain whether this investment is a good deal for me using the (b) result. If yes, why? If no, why not