Our organization operates an educational platform, charging 500 rupees per customer for a course, inclusive of 18% GST. Over the period of one year, we have engaged 20,000 customers. However, please note that we experience a refund rate of 4%, meaning that 4% of our customers request and receive refunds for their course fees. On the expenditure side, we have spent a total of 15,00,000 rupees on salaries and 20,00,000 rupees on server and other expenses, inclusive of GST at 28%. Further, 80% of our total revenue is generated through our partners, and as per our agreement, we provide them with a 50% share of this partner-generated revenue. Your task, considering the full input tax credit of GST, is to: Determine the total revenue, net of GST, and account for the 4% refund rate. Classify and calculate total expenses, net of GST. Classify them as follows: Employee Compensation (Salaries) Information Technology (Server and other expenses) Account for the revenue shared with partners, noting that this applies to only 80% of the total revenue. Finally, calculate the profit by subtracting the total net expenses (including the partner share) from the total net revenue. Please provide your answers with detailed calculations and explanations in an excel sheet. This task is designed to test your understanding of financial operations, tax implications, profit calculations, expense classification in financial statements, and handling of refunds in revenue calculations.