Notes

List<QuickBooksModel> quickBooksModelList = new();

decimal GAProjection = 0;
decimal SalesExpProjection = 0;
decimal ResearchExpProjection = 0;
decimal MarketingExpProjection = 0;
decimal CostTotalExpProjection = 0;
decimal EBITDAExpProjection = 0;
decimal TaxProjection = 0;
decimal CostTotalThirdPercent = 0;
decimal gmProjection = 0;
decimal revenueReal = 0;
decimal cogsReal = 0;
decimal gmReal = 0;
decimal otherIncomeProjection = 0;
decimal otherIncomeReal = 0;
decimal gaReal = 0;
decimal salesExpReal = 0;
decimal randDReal = 0;
decimal marketingExpensesReal = 0;
decimal totalExpReal = 0;
decimal costTotalReal = 0;
decimal EBITDAReal = 0;
decimal taxReal = 0;
decimal netIncomeReal = 0;
decimal CostTotalFourthPercent = 0;
decimal numberofConsultantsProjection = 0;
decimal hoursWorkedProjection = 0;
for (int i = 0; i < 15; i++)
{
QuickBooksModel quickBooksModel = new();
switch (i)
{
case 0:
quickBooksModel.Quickbooks = "Revenue";
quickBooksModel.Projection = projectionsExcelMasterModels?.TotalBill160Hras;
quickBooksModel.ThirdPercent = "100%";
var projectionIncomeExpensesRevenue = projectionIncomeExpensesHelperAsync.Where(x => x.IncomeExpensesNumber == "0").FirstOrDefault();
quickBooksModel.IncomeexpensesTableId = projectionIncomeExpensesRevenue?.Id;
revenueReal = Convert.ToDecimal(projectionIncomeExpensesRevenue?.RealData);
if (revenueReal != 0)
{
quickBooksModel.Real = $"${revenueReal.ToString(AppConstants.DefaultFiveDigits)}";
quickBooksModel.ForthPercent = "100%";
}
break;
case 1:
quickBooksModel.Quickbooks = "COGS";
quickBooksModel.Projection = projectionsExcelMasterModels?.TotalTotalCost;
if (!String.IsNullOrEmpty(projectionsExcelMasterModels?.TotalBill160Hras))
{
decimal COGSThirdPercent = (Convert.ToDecimal(projectionsExcelMasterModels?.TotalTotalCost?.Replace("$", "")) / Convert.ToDecimal(projectionsExcelMasterModels?.TotalBill160Hras?.Replace("$", ""))) * 100;
quickBooksModel.ThirdPercent = $"{COGSThirdPercent.ToString(AppConstants.DefaultTwoDigits)}%";
}
var projectionIncomeExpensesCOGS = projectionIncomeExpensesHelperAsync.Where(x => x.IncomeExpensesNumber == "1").FirstOrDefault();
quickBooksModel.IncomeexpensesTableId = projectionIncomeExpensesCOGS?.Id;
cogsReal = Convert.ToDecimal(projectionIncomeExpensesCOGS?.RealData);
if (cogsReal != 0)
{
quickBooksModel.Real = $"${cogsReal.ToString(AppConstants.DefaultFiveDigits)}";
if (revenueReal != 0)
{
decimal COGSFourthPercent = (cogsReal / revenueReal) * 100;
quickBooksModel.ForthPercent = $"{COGSFourthPercent.ToString(AppConstants.DefaultTwoDigits)}%";
}
}
break;
case 2:
quickBooksModel.Quickbooks = "GM";
gmProjection = Convert.ToDecimal(projectionsExcelMasterModels?.TotalBill160Hras?.Replace("$", "")) - Convert.ToDecimal(projectionsExcelMasterModels?.TotalTotalCost?.Replace("$", ""));
quickBooksModel.Projection = $"${gmProjection.ToString(AppConstants.DefaultFiveDigits)}";
decimal gmThirdPercent = (gmProjection / Convert.ToDecimal(projectionsExcelMasterModels?.TotalBill160Hras?.Replace("$", ""))) * 100;
quickBooksModel.ThirdPercent = $"{gmThirdPercent.ToString(AppConstants.DefaultTwoDigits)}%";
gmReal = revenueReal - cogsReal;
if (gmReal != 0)
{
quickBooksModel.Real = $"${gmReal.ToString(AppConstants.DefaultFiveDigits)}";
if (revenueReal != 0)
{
decimal GMFourthPercent = (gmReal / revenueReal) * 100;
quickBooksModel.ForthPercent = $"{GMFourthPercent.ToString(AppConstants.DefaultTwoDigits)}%";
}
}
break;
case 3:
quickBooksModel.Quickbooks = "G&A";
GAProjection = (Convert.ToDecimal(projectionsExcelMasterModels?.TotalBill160Hras?.Replace("$", "")) * 8) / 100;
quickBooksModel.Projection = $"${GAProjection.ToString(AppConstants.DefaultFiveDigits)}";
decimal GAThirdPercent = (GAProjection / Convert.ToDecimal(projectionsExcelMasterModels?.TotalBill160Hras?.Replace("$", ""))) * 100;
quickBooksModel.ThirdPercent = $"{GAThirdPercent.ToString(AppConstants.DefaultTwoDigits)}%";
var projectionIncomeExpensesGA = projectionIncomeExpensesHelperAsync.Where(x => x.IncomeExpensesNumber == "3").FirstOrDefault();
quickBooksModel.IncomeexpensesTableId = projectionIncomeExpensesGA?.Id;
gaReal = Convert.ToDecimal(projectionIncomeExpensesGA?.RealData);
if (gaReal != 0)
{
quickBooksModel.Real = $"${gaReal.ToString(AppConstants.DefaultFiveDigits)}";
if (revenueReal != 0)
{
decimal GAFourthPercent = (gaReal / revenueReal) * 100;
quickBooksModel.ForthPercent = $"{GAFourthPercent.ToString(AppConstants.DefaultTwoDigits)}%";
}
}
break;
case 4:
quickBooksModel.Quickbooks = "Sales Exp";
SalesExpProjection = (Convert.ToDecimal(projectionsExcelMasterModels?.TotalBill160Hras?.Replace("$", "")) * 5) / 100;
quickBooksModel.Projection = $"${SalesExpProjection.ToString(AppConstants.DefaultFiveDigits)}";
decimal SalesExpThirdPercent = (SalesExpProjection / Convert.ToDecimal(projectionsExcelMasterModels?.TotalBill160Hras?.Replace("$", ""))) * 100;
quickBooksModel.ThirdPercent = $"{SalesExpThirdPercent.ToString(AppConstants.DefaultTwoDigits)}%";
var projectionIncomeExpensesSalesExp = projectionIncomeExpensesHelperAsync.Where(x => x.IncomeExpensesNumber == "4").FirstOrDefault();
quickBooksModel.IncomeexpensesTableId = projectionIncomeExpensesSalesExp?.Id;
salesExpReal = Convert.ToDecimal(projectionIncomeExpensesSalesExp?.RealData);
if (salesExpReal != 0)
{
quickBooksModel.Real = $"${salesExpReal.ToString(AppConstants.DefaultFiveDigits)}";
if (revenueReal != 0)
{
decimal SalesExpFourthPercent = (salesExpReal / revenueReal) * 100;
quickBooksModel.ForthPercent = $"{SalesExpFourthPercent.ToString(AppConstants.DefaultTwoDigits)}%";
}
}
break;
case 5:
quickBooksModel.Quickbooks = "Research & Devolp Exp";
ResearchExpProjection = (Convert.ToDecimal(projectionsExcelMasterModels?.TotalBill160Hras?.Replace("$", "")) * 2) / 100;
quickBooksModel.Projection = $"${ResearchExpProjection.ToString(AppConstants.DefaultFiveDigits)}";
decimal ResearchExpThirdPercent = (ResearchExpProjection / Convert.ToDecimal(projectionsExcelMasterModels?.TotalBill160Hras?.Replace("$", ""))) * 100;
quickBooksModel.ThirdPercent = $"{ResearchExpThirdPercent.ToString(AppConstants.DefaultTwoDigits)}%";
var projectionIncomeExpensesRandD = projectionIncomeExpensesHelperAsync.Where(x => x.IncomeExpensesNumber == "5").FirstOrDefault();
quickBooksModel.IncomeexpensesTableId = projectionIncomeExpensesRandD?.Id;
randDReal = Convert.ToDecimal(projectionIncomeExpensesRandD?.RealData);
if (randDReal != 0)
{
quickBooksModel.Real = $"${randDReal.ToString(AppConstants.DefaultFiveDigits)}";
if (revenueReal != 0)
{
decimal RandDRealFourthPercent = (randDReal / revenueReal) * 100;
quickBooksModel.ForthPercent = $"{RandDRealFourthPercent.ToString(AppConstants.DefaultTwoDigits)}%";
}
}
break;
case 6:
quickBooksModel.Quickbooks = "Marketing Expenses";
MarketingExpProjection = (Convert.ToDecimal(projectionsExcelMasterModels?.TotalBill160Hras?.Replace("$", "")) * 2) / 100;
quickBooksModel.Projection = $"${MarketingExpProjection.ToString(AppConstants.DefaultFiveDigits)}";
decimal MarketingExpThirdPercent = (MarketingExpProjection / Convert.ToDecimal(projectionsExcelMasterModels?.TotalBill160Hras?.Replace("$", ""))) * 100;
quickBooksModel.ThirdPercent = $"{MarketingExpThirdPercent.ToString(AppConstants.DefaultTwoDigits)}%";
var projectionIncomeExpensesMarketingExpenses = projectionIncomeExpensesHelperAsync.Where(x => x.IncomeExpensesNumber == "6").FirstOrDefault();
quickBooksModel.IncomeexpensesTableId = projectionIncomeExpensesMarketingExpenses?.Id;
marketingExpensesReal = Convert.ToDecimal(projectionIncomeExpensesMarketingExpenses?.RealData);
if (marketingExpensesReal != 0)
{
quickBooksModel.Real = $"${marketingExpensesReal.ToString(AppConstants.DefaultFiveDigits)}";
if (revenueReal != 0)
{
decimal MarketingExpenseFourthPercent = (marketingExpensesReal / revenueReal) * 100;
quickBooksModel.ForthPercent = $"{MarketingExpenseFourthPercent.ToString(AppConstants.DefaultTwoDigits)}%";
}
}
break;
case 7:
quickBooksModel.Quickbooks = "Total Exp";
decimal totalExpProjection = GAProjection + SalesExpProjection + ResearchExpProjection + MarketingExpProjection;
quickBooksModel.Projection = $"${totalExpProjection.ToString(AppConstants.DefaultFiveDigits)}";
decimal TotalExpThirdPercent = (totalExpProjection / Convert.ToDecimal(projectionsExcelMasterModels?.TotalBill160Hras?.Replace("$", ""))) * 100;
quickBooksModel.ThirdPercent = $"{TotalExpThirdPercent.ToString(AppConstants.DefaultTwoDigits)}%";
totalExpReal = gaReal + salesExpReal + randDReal + marketingExpensesReal;
if (totalExpReal != 0)
{
quickBooksModel.Real = $"${totalExpReal.ToString(AppConstants.DefaultFiveDigits)}";
if (revenueReal != 0)
{
decimal TotalExpenseFourthPercent = (totalExpReal / revenueReal) * 100;
quickBooksModel.ForthPercent = $"{TotalExpenseFourthPercent.ToString(AppConstants.DefaultTwoDigits)}%";
}
}
break;
case 8:
quickBooksModel.Quickbooks = "Other income";
var projectionIncomeExpensesOtherincome = projectionIncomeExpensesHelperAsync.Where(x => x.IncomeExpensesNumber == "8").FirstOrDefault();
quickBooksModel.IncomeexpensesTableId = projectionIncomeExpensesOtherincome?.Id;
otherIncomeProjection = Convert.ToDecimal(projectionIncomeExpensesOtherincome?.ProjectionData);
if (otherIncomeProjection != 0)
{
quickBooksModel.Projection = $"${otherIncomeProjection.ToString(AppConstants.DefaultFiveDigits)}";
}
otherIncomeReal = Convert.ToDecimal(projectionIncomeExpensesOtherincome?.RealData);
if (otherIncomeReal != 0)
{
quickBooksModel.Real = $"${otherIncomeReal.ToString(AppConstants.DefaultFiveDigits)}";
}
break;
case 9:
quickBooksModel.Quickbooks = "Cost Total";
CostTotalExpProjection = Convert.ToDecimal(projectionsExcelMasterModels?.TotalTotalCost?.Replace("$", "")) + GAProjection + SalesExpProjection + ResearchExpProjection + MarketingExpProjection;
quickBooksModel.Projection = $"${CostTotalExpProjection.ToString(AppConstants.DefaultFiveDigits)}";
CostTotalThirdPercent = (CostTotalExpProjection / Convert.ToDecimal(projectionsExcelMasterModels?.TotalBill160Hras?.Replace("$", ""))) * 100;
quickBooksModel.ThirdPercent = $"{CostTotalThirdPercent.ToString(AppConstants.DefaultTwoDigits)}%";
costTotalReal = cogsReal + totalExpReal;
if (costTotalReal != 0)
{
quickBooksModel.Real = $"${costTotalReal.ToString(AppConstants.DefaultFiveDigits)}";
if (revenueReal != 0)
{
CostTotalFourthPercent = (costTotalReal / revenueReal) * 100;
quickBooksModel.ForthPercent = $"{CostTotalFourthPercent.ToString(AppConstants.DefaultTwoDigits)}%";
}
}
break;
case 10:
quickBooksModel.Quickbooks = "EBITDA";
EBITDAExpProjection = Convert.ToDecimal(projectionsExcelMasterModels?.TotalBill160Hras?.Replace("$", "")) - CostTotalExpProjection;
quickBooksModel.Projection = $"${EBITDAExpProjection.ToString(AppConstants.DefaultFiveDigits)}";
decimal EBITDAThirdPercent = (EBITDAExpProjection / Convert.ToDecimal(projectionsExcelMasterModels?.TotalBill160Hras?.Replace("$", ""))) * 100;
quickBooksModel.ThirdPercent = $"{EBITDAThirdPercent.ToString(AppConstants.DefaultTwoDigits)}%";
EBITDAReal = revenueReal - costTotalReal;
if (EBITDAReal != 0)
{
quickBooksModel.Real = $"${EBITDAReal.ToString(AppConstants.DefaultFiveDigits)}";
if (revenueReal != 0)
{
decimal EBITDAFourthPercent = (EBITDAReal / revenueReal) * 100;
quickBooksModel.ForthPercent = $"{EBITDAFourthPercent.ToString(AppConstants.DefaultTwoDigits)}%";
}
}
break;
case 11:
quickBooksModel.Quickbooks = "Tax ( 37% )";
TaxProjection = (EBITDAExpProjection * 37) / 100;
quickBooksModel.Projection = $"${TaxProjection.ToString(AppConstants.DefaultFiveDigits)}";
decimal TaxThirdPercent = (TaxProjection / Convert.ToDecimal(projectionsExcelMasterModels?.TotalBill160Hras?.Replace("$", ""))) * 100;
quickBooksModel.ThirdPercent = $"{TaxThirdPercent.ToString(AppConstants.DefaultTwoDigits)}%";
taxReal = (EBITDAReal * 37) / 100;
if (taxReal != 0)
{
quickBooksModel.Real = $"${taxReal.ToString(AppConstants.DefaultFiveDigits)}";
if (revenueReal != 0)
{
decimal TaxFourthPercent = (taxReal / revenueReal) * 100;
quickBooksModel.ForthPercent = $"{TaxFourthPercent.ToString(AppConstants.DefaultTwoDigits)}%";
}
}
break;
case 12:
quickBooksModel.Quickbooks = "Net Income After Tax";
decimal NetIncomeAfterTaxProjection = EBITDAExpProjection - TaxProjection;
quickBooksModel.Projection = $"${NetIncomeAfterTaxProjection.ToString(AppConstants.DefaultFiveDigits)}";
decimal NetIncomeAfterTaxThirdPercent = (NetIncomeAfterTaxProjection / Convert.ToDecimal(projectionsExcelMasterModels?.TotalBill160Hras?.Replace("$", ""))) * 100;
quickBooksModel.ThirdPercent = $"{NetIncomeAfterTaxThirdPercent.ToString(AppConstants.DefaultTwoDigits)}%";
netIncomeReal = EBITDAReal - taxReal;
if (netIncomeReal != 0)
{
quickBooksModel.Real = $"${netIncomeReal.ToString(AppConstants.DefaultFiveDigits)}";
if (revenueReal != 0)
{
decimal NetIncomeFourthPercent = (netIncomeReal / revenueReal) * 100;
quickBooksModel.ForthPercent = $"{NetIncomeFourthPercent.ToString(AppConstants.DefaultTwoDigits)}%";
}
}
break;
case 13:
quickBooksModel.Quickbooks = "Number of Consultants";
quickBooksModel.Projection = projectionsExcelMasterModels?.TotalNumberOfConsultants.ToString("##,##0");
var projectionIncomeExpensesNumberofConsultants = projectionIncomeExpensesHelperAsync.Where(x => x.IncomeExpensesNumber == "13").FirstOrDefault();
quickBooksModel.IncomeexpensesTableId = projectionIncomeExpensesNumberofConsultants?.Id;
numberofConsultantsProjection = Convert.ToDecimal(projectionIncomeExpensesNumberofConsultants?.RealData);
if (numberofConsultantsProjection != 0)
{
quickBooksModel.Real = $"{numberofConsultantsProjection.ToString()}";
}
break;
case 14:
quickBooksModel.Quickbooks = "Hours worked";
quickBooksModel.Projection = projectionsExcelMasterModels?.GrandTotalConsultantsCalculation.ToString("##,##0");
var projectionIncomeExpensesHoursWorked = projectionIncomeExpensesHelperAsync.Where(x => x.IncomeExpensesNumber == "14").FirstOrDefault();
quickBooksModel.IncomeexpensesTableId = projectionIncomeExpensesHoursWorked?.Id;
hoursWorkedProjection = Convert.ToDecimal(projectionIncomeExpensesHoursWorked?.RealData);
if (hoursWorkedProjection != 0)
{
quickBooksModel.Real = $"{hoursWorkedProjection.ToString(AppConstants.DefaultFiveDigits)}";
}
break;
}
quickBooksModelList.Add(quickBooksModel);

}
projectionsExcelMasterModels.QuickBooksModelList = quickBooksModelList;