Applicable VLO's for This Week's Case Study 2. Integrate knowledge of capital investments, credit planning, and finance into relevant aspects of work Brief Introduction to This Week's Case Study Jessica, the general manager of ADVANCED GREEN TECHNOLOGIES is planning an expansion for the ADVANCED GREEN TECHNOLOGIES store. Jessica was debating this decision for a longtime, but when demand outstripped supply at his store, she decided to expand the business. Expanding the business requires a thorough analysis, which she plans to carry out this week. This Week's Detailed Case Study Information ADVANCED GREEN TECHNOLOGIES Company is a successful business venture. It is expected that sales at the ADVANCED GREEN TECHNOLOGIES will increase substantially in the coming 5 years. Right now, the company occasionally runs out of inventory. To meet the increase in demand Jessica is planning an expansion. Jessica has two locations in mind each location has a unique value proposition. Jessica gathered a lot of data, to make sure she is taking the right decision. First, she went out, and calculated the rent rates at each location. The rent is a running expense, it is not volatile, but it increases in-line with inflation. Next, Jessica analyzed the neighborhood demographics, this is an essential step which will enable forecasting future sales. The neighborhood demographics proved to be very similar. Both neighborhoods have a lot of middle-class working families, which is the target market for ADVANCED GREEN TECHNOLOGIES Company. Moreover, Jessica also made sure to visit the local city council, in order to obtain more information on the required permits. The permit is essential, since zoning requirements could restrict certain business activities. After obtaining the information for each location, Jessica started thinking about capital investments. She researched the appropriate equipment which will be used in each store. She also went out and talked to a couple contractors and obtained quotes for his suggested design and store layout. She was satisfied with pricing. Finally, Jessica went to his financial manager and they together analyzed the required working capital financing for each location. The financial manager, used pro-forma financial statements to forecast the expected sales figure, cost of goods sold, and operating expenses. Also, the financial manager, made sure to calculate the "Weighted Average Cost of Capital", the stores will be financed via a mix of equity and debt. The financial manager summarized the key cash flows (presented in the tables below), and she's eager to know the expected profitability for each project; NPV, IRR, and Payback Period. It's expected that each store will require major renovations after 10 years, and thus the project life is limited to 10 years. Option A: 5800 Yonge St. N Year Expected Cash flow Comment WIL PROJECT CASE STUDY ORIENTATION Week 2 0 2019 -$ 3,000,000.00 Includes Working Capital 1 2020 $ 306,000.00 2 2021 $ 120,000.00 3 2022 $ 240,000.00 4 2023 $ 360,000.00 5 2024 $ 540,000.00 6 2025 $ 660,000.00 7 2026 $ 187,200.00 8 2027 $ 840,000.00 9 2028 $ 936,000.00 10 2029 $ 1,200,000.00 Includes Salvage Value Cost of Capital: 12% Option B: 1136 Avenue Rd. N Year Expected Cash flow Comment 0 2019 -$ 4,800,000.00 Includes Working Capital 1 2020 $ 489,600.00 2 2021 $ 960,000.00 3 2022 $ 384,000.00 4 2023 $ 1,152,000.00 5 2024 $ 864,000.00 6 2025 $ 1,056,000.00 7 2026 $ 299,520.00 8 2027 $ 600,000.00 9 2028 $ 960,000.00 10 2029 $ 1,920,000.00 Includes Salvage Value Cost of Capital: 12% Your task is to analyze the above capital projects, and reach a capital decision based on (IRR, NPV, and Payback). In order to finance this project, the company has three options: Line of Credit Secured Loan Corporate Credit Card Which option should be selected and why