Solar Inc has successfully produce solar panels for 5 years and would like to expand into batteries. They have two options to get into the battery production 0ption 1:Joint Venture In this option the company teams up with another party (Alternative Inc) to develop and produce batteries. Alternative Inc has already completed the required research. Solar Inc will be required to invest $10,000,000 into the joint venture. The business agreement with the other party lays out ajoint project with a time limit of 5 years- Solar Inc had to pay $100,000 for consultant fees to obtain the right business partner. Option 2: Buy the intellectual property and produce batteries themselves This option would require Solar Inc to produce the battery from a factory premise they currently own and are presently leasing. The lease agreement has a remaining term of 10 years at an annual rental of $100,000. Solar Inc would be required to pay $50,000 compensation up front to the tenant for breaking the agreement early. Purchase of the intellectual property together with the factory set up would cost $20,000,000 and they need to borrow 50% from the bank with an interest of 5% per year, interest-only loan. New experts will be hired to run this operation. Marks B. Calculate the net cash flows of Option 2 only, you can use the table below to fill in your answer: (4 marks) Time Net Cash Flow Workings Year 0 Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 Year 8 Year 9 Year 10C. The following is the calculation for NPV for both options, calculate EAA for each option and make a recommendation for Solar Inc. on which investment should be selected? {3 marks) Cost of capital "m m 3'13) 9 Marks A. Calculate the ARR for option 2 only, you can use the following table format to ll your answer: {3 marks] \" The following information is for both options: Solar Inc Solar Inc Budgeted Income Budgeted Income Statement Statement Option 1 Option 2 Year 1-5 Year 1 Year 2-10 Revenue Sales $6,000,000 $4,000,000 $10,000,000 Total revenue $6,000,000 $4,000,000 $10,000,000 Expenses Wages $200,000 $450,000 $700,000 Depreciation $2,000,000 $2,000,000 $2,000,000 Marketing expenses $50,000 $200,000 $100,000 Interest expense $50,000 $50,000 Production cost $1,000,000 $3,000,000 $3,000,000 Consultant Fees $100,000 Rent $75,000 lease breaking compensation $50,000 Total expenses $3,425,000 $5,750,000 $5,850,000 Profit (Loss) $2,575,000 -$1,750,000 $4,150,000 With the cost of capital of 12%