Thank you in advance !
( Required information [The following information applies to the questions displayed below.] These problems relate to the Integrated Analytics Case: Bene Petit. Select the appropriate eBook link to open the Case Overview, Case Background, and Part 5: Performance Evaluation and Analysis. For this problem, assume that Taylor is considering investing in one or more of the following projects: Project A: Expand the manufacturing facility to increase capacity by 20 percent. This investment is expected to cost $360,000 and generate net cash flow of $80,000 per year for the next eight years. Project B: Overhaul the company website to optimize the user experience and generate more traffic from online advertising. This project would cost $210,000 and is expected to generate an additional $100,000 in sales for the next 10 years. Assume that the contribution margin is 42 percent and that there would be no increase in fixed costs, including depreciation. Project C: Invest in solar panels and more fuel-efficient delivery vehicles to reduce operating expenses (e.g., electricity and fuel) and the company's carbon footprint. The initial investment in assets would be $360,000, which would be depreciated over five years. The investment is expected to increase net income by $18,000 per year, after the depreciation adjustment. (1) Required information Part 2 or 2 [The following information applies to the questions displayed below] These problems relate to the Integrated Analytics Case: Bene Petit. Select the appropriate eBook link to open the Case 3 Overview, Case Background, and Part 5: Performance Evaluation and Analysis. Compute the following ratios for 2023 and 2024 : Note: Round your answer to the nearest whole percentage, followed by 2 decimal places. For example 0.09423 would be entered as 9.42%. X Part+5a+(student+spreadsheet) xsx Profitability Ratios 2024 2023 Net Profit Margin Gross Profit Maroin Retum on investment (Average Assots) Fetum on investment (Average Equity) Fined Asset Furnover Liquildity and Solvency ratios 2024 2023 Current ratio Debt to Assets Debe to Tquity Times interesteamed