Sensitivity Analysis for Financial Projections

Projected Financial Details:

• Income Statement Projections:
  • Net Sales Forecast: $6,000,000
  • Projected Expenses: $4,000,000

• Sensitivity Analysis:
  • Scenario 1: 20% Increase in Sales
  • Scenario 2: 20% Decrease in Sales

Requirements:

• Prepare a forecasted income statement.
• Conduct a sensitivity analysis for the given scenarios.
• Calculate the impact on net profit for each scenario.
• Present the projections and sensitivity analysis in a detailed table format.
• Discuss the strategic decisions based on the sensitivity analysis.
• Evaluate the risks and opportunities presented by the sensitivity analysis.