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 Option 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 a joint 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. The following information is for both options: Solar Inc Budgeted Income Statement Solar Inc Budgeted Income Statement Option 1 Year 1-5 Option 2 Year 1 Year 2-10 Revenue Sales Total revenue $6,000,000 $6,000,000 $4,000,000 $4,000,000 $10,000,000 $10,000,000 $200,000 $2,000,000 $50,000 $450,000 $2,000,000 $200,000 $50,000 $3,000,000 $700,000 $2,000,000 $100,000 $50,000 $3,000,000 Expenses Wages Depreciation Marketing expenses Interest expense Production cost Consultant Fees Rent lease breaking compensation Total expenses Profit (Loss) $1,000,000 $100,000 $75,000 $3,425,000 $2,575,000 $50,000 $5,750,000 -$1,750,000 $5,850,000 $4,150,000 With the cost of capital of 12% (3 A. Calculate the ARR for option 2 only, you can use the following table format to fill your answer: marks) Items Workings Investment (O/bal) Investment (C/bal) Average investment Average profit ARR B. Calculate the net cash flows of Option 2 only, you can use the table below to fill in your answer: marks) Net Cash Flow Workings Time Year 0 Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 Year 8 Year 9 Year 10 C. 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) Option 2 12% Cost of capital Period NPV Option 1 12% 5 years $6,852,328 10 years $9,193,146 ? ? EAA Recommendation