ROI and Payback Calculation for Expansion Projects

Calculate the ROI and financial viability of a [EXPANSION TYPE: new location/new product line/new market] project for [COMPANY NAME] in the [INDUSTRY] sector.\\\\\\\\n\\\\\\\\n**Investment data:**\\\\\\\\n- Initial investment: R$ [AMOUNT]\\\\\\\\n- Working capital investment: R$ [AMOUNT]\\\\\\\\n- Estimated monthly revenue: R$ [AMOUNT]\\\\\\\\n- Monthly fixed costs of new operation: R$ [AMOUNT]\\\\\\\\n- Variable costs: [PERCENTAGE]% of revenue\\\\\\\\n- Ramp-up period: [MONTHS] months to full revenue\\\\\\\\n\\\\\\\\n**Perform the following calculations:**\\\\\\\\n\\\\\\\\n1) **Simple ROI:**\\\\\\\\n- Formula: (Annual Net Profit / Total Investment) × 100\\\\\\\\n- ROI in Year 1, Year 2, and Year 3\\\\\\\\n\\\\\\\\n2) **Simple and discounted payback:**\\\\\\\\n- Month-by-month breakdown of when investment is recovered\\\\\\\\n- Discount rate: [RATE]% per year (opportunity cost)\\\\\\\\n- Present results in a table\\\\\\\\n\\\\\\\\n3) **Net Present Value (NPV):**\\\\\\\\n- 5-year projected cash flow\\\\\\\\n- Discount rate: WACC of [RATE]%\\\\\\\\n- Decision criteria: NPV > 0 → viable\\\\\\\\n\\\\\\\\n4) **IRR (Internal Rate of Return):**\\\\\\\\n- Calculate project IRR\\\\\\\\n- Compare to cost of capital\\\\\\\\n- Compare to risk-free rate plus risk premium\\\\\\\\n\\\\\\\\n5) **Sensitivity analysis:**\\\\\\\\n- Scenario if revenue is 20% lower\\\\\\\\n- Scenario if costs increase by 15%\\\\\\\\n- Scenario if ramp-up takes twice as long\\\\\\\\n- Break-even point in each scenario\\\\\\\\n\\\\\\\\nPresent results in table format and include a final recommendation (invest/do not invest/defer). Format for presentation to [BANK/INVESTORS/PARTNERS].