The Chief Executive Officer of BigTech One, LLC makes the following statement in their Annual Report of 2022: We are living through a period of historic economic, societal, and geopolitical change. The world in 2022 looks nothing like the world in 2019. As I write this, inflation is at a 40-year high, supply chains are stretched, and the war in Ukraine is ongoing. At the same time, we are entering a technological era with the potential to power awesome advancements across every sector of our economy and society. As the worlds largest software company, this places us at a historic intersection of opportunity and responsibility to the world around us. BigTech One, LLC is a technology company whose mission is to empower every person and every organization on the planet to achieve more. They strive to create local opportunity, growth, and impact in every country around the world. Their platforms and tools help drive small business productivity, large business competitiveness, and public-sector efficiency. They also support new startups, improve educational and health outcomes, and empower human ingenuity. The company was founded in 2000, and they have developed software, services, devices, and solutions that deliver value to their customers. BigTech One, LLC generates revenue by offering a wide range of cloud-based and other services to people and businesses; licensing and supporting an array of software products; designing, manufacturing, and selling devices; and delivering relevant online advertising to a global audience. Our most significant expenses are related to compensating employees; designing, manufacturing, marketing, and selling our products and services; datacenter costs in support of our cloud-based services; and income taxes. After 2019, many companies have faced various market risks. BigTech One, LLC is also exposed to economic risk from foreign exchange rates, interest rates, credit risk, and equity prices. The financial statements below are given for the years 2022 and 2023. The company is trying to have a better understanding of their financial situation and they would like to project the next 3 fiscal years ahead. Use the following points to help BigTech One, LLC: 1. Please recreate all three financial statements using excel. Please make sure to have all formulas are visible. You should have each financial statement on a separate tab. (10pts) 2. Please compute a common-size statement on the Income statement and the balance sheet. (10pts) a. What can you conclude from the common-size statements 3. Project the income statement for the next 3 fiscal year: 2024, 2025, and 2026. (10pts) a. Please be mindful of the growth rate for the years provided 4. Compute the common size for all projected years for the income statement (5pts) 5. Use three categories of ratios (of your choice) calculate them and explain your findings (10pts) Microsoft alluded that the finance team will be looking for additional investors. Therefore, the board of directors hires an investment bank to help them value the company and help them find investors. You are the Financial Analyst assigned to this project; you will use the information below to help find the value of BigTech One, LLC: 1. Calculate Free Cash Flow for BigTech One, LLC: from 2022 to 2026 (5pts) 2. Use the information below to calculate the cost of equity (15pts) a. The T-bill for the 1-Year Treasury is 4.76% b. BigTech One, LLCs Beta is 0.93 c. The Return on the market is 2.03% 3. Use the information below to calculate the WACC (15pts) a. The cost of debt is 7% b. The capital structure is 54% equity and 46% debt c. The corporate tax rate is 21% 4. Finally, calculate the value of BigTech One, LLC and describe each step. (20pts) ______________________________________________________________________________ Please provide two files for this assignment: Word document Excel file Remember that you are to work with your group on this project. Only one member of your team needs to submit your work on Canvas. Please make sure to follow each step above to successfully complete your assignment. Income Statement Balance Sheet Cash Flow Statement