Co. is interested to hire you as financial analyst. Your role is to prepare break-even and leverage analysis for Kyiv-Moscow Co. The following information are provided by the Kyiv-Moscow Co :

• The company sold their products up to 233,333 units in FY2021, with price per unit of $25.
• The sales are expected to growth with 20% rate for upcoming years.
• The company has target EBIT of $1,500,000, while percentage of variable cost to sales is 55%. The corporate tax is 35%
• Total amount for fixed costs $400,000, and interest expense $100,000.
• The company paid preferred dividends of $100,000
• The company issued 1,000,000 common stocks

Answer the following questions:

1. What is the operating break-even point (in units) and the operating break-even point (in $)? What is the number of units to meet the EBIT target? Shows the excel sheet calculations

2. Find the degree of operating leverage (DOL), degree of financial leverage (DFL), and degree of total leverage (DTL) for FY2021 and FY2022. Show the excel sheet calculations

3. Prepare the forecasted income statements for FY2023, FY2024, FY2025 and find the degree of operating leverage (DOL), degree of financial leverage (DFL), and degree of total leverage (DTL) for FY2023, FY2024, FY2025. Show the excel sheet calculations

4. Prepare the graph of leverage analysis and briefly explain your view about leverage position of Kyiv-Moscow Co.