Sensitivity Analysis for Financial Projections

Projected Financial Details:

• Income Statement Projections:
  • Net Sales Forecast: $8,000,000
  • Projected Expenses: $5,000,000

• Sensitivity Analysis:
  • Scenario 1: 10% Increase in Sales
  • Scenario 2: 10% 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.