Civic Intelligence

Ramti Devi Gupta Foundation

990PF • Fiscal year 2013 • EIN 38-3266008

Oct 01, 2012 to Sep 30, 2013 • Filed on Aug 02, 2014

Organization Profile
3366 Kenwood DrRochester, MI 48309
Siviq Scores

Precomputed percentiles for this filing year versus similar nonprofits in the same peer cohort.

Liabilities / Assets

59th percentile

0.00x

Higher debt load relative to assets than 59% of similar nonprofits.

2013 filings • <$500k nonprofits • Source year 2013

Liabilities / Revenue

62nd percentile

0.00x

Higher debt load relative to revenue than 62% of similar nonprofits.

2013 filings • <$500k nonprofits • Source year 2013

Net Margin

99th percentile

100%

Higher net margin than 99% of similar nonprofits.

2013 filings • <$500k nonprofits • Source year 2013

Top Officer Pay

75th percentile

$0

Higher top officer pay than 75% of similar nonprofits.

Top officer pay equals 0.0% of source-year revenue.

2013 filings • <$500k nonprofits • Source year 2013

Asset Growth

52nd percentile

1.6%

Faster asset growth than 52% of similar nonprofits.

2013 filings • <$500k nonprofits • Annualized from 2012 to 2013

Revenue Growth

Score unavailable

No value available

No earlier valid filing was available within the previous three public years.

Source year 2013

Balance Sheet
Liabilities / Assets59th percentile

Assets

Up

$29,846

Up $472 (+1.6%) from 2012

Net Assets

Up

$29,846

Up $472 (+1.6%) from 2012

Liabilities

Up

$1

Up $1 from 2012

Revenue And Expenses
Liabilities / Revenue62nd percentileNet Margin99th percentile

Revenue

$472

No earlier filing loaded for comparison.

Expenses

Flat

$0

Flat from 2012

Net Income

$472

No earlier filing loaded for comparison.

Historical Trend

Balance Sheet Trend

Asset Growth52nd percentile

The highlighted filing sits inside the broader history for assets, liabilities, and net assets.

$40K$30K$20K$10K$0Assets 2010: $32,642Liabilities 2010: $0Net Assets 2010: $32,6422010Assets 2011: $28,906Liabilities 2011: $0Net Assets 2011: $28,9062011Assets 2012: $29,374Liabilities 2012: $0Net Assets 2012: $29,3742012Assets 2013: $29,846Liabilities 2013: $1Net Assets 2013: $29,8462013Assets 2014: $29,846Liabilities 2014: $1Net Assets 2014: $29,8462014Assets 2015: $29,846Liabilities 2015: $1Net Assets 2015: $29,8462015Assets 2016: $29,846Liabilities 2016: $0Net Assets 2016: $29,8462016Assets 2017: $0Liabilities 2017: $0Net Assets 2017: $02017

Highlighted filing

2013

Assets$29,846
Liabilities$1
Net Assets$29,846
Open 2013 Filing

Operations Trend

Revenue GrowthScore unavailable

Revenue, expenses, and net income across loaded years, with this filing highlighted.

$4.0K$2.0K$0-$2.0K-$4.0KExpenses 2010: $02010Expenses 2011: $02011Expenses 2012: $02012Revenue 2013: $472Expenses 2013: $0Net Income 2013: $4722013Revenue 2014: $1Expenses 2014: $0Net Income 2014: $12014Revenue 2015: $1Expenses 2015: $0Net Income 2015: $12015Revenue 2016: $0Expenses 2016: $0Net Income 2016: $02016Revenue 2017: $0Expenses 2017: $3,622Net Income 2017: -$3,6222017

Highlighted filing

2013

Revenue$472
Expenses$0
Net Income$472
Open 2013 Filing
Jump To
Filing Snapshot
Filing Period
Oct 1, 2012 to Sep 30, 2013
Signed
Aug 2, 2014
Return Version
2012v2.1
Compensation and Service Providers
Top Officer Pay75th percentile

Employees

NameTitleFull / Part TimeBaseOtherTotal
SHIAM GUPTAPresident-$0--
RAMA GUPTASecretary-$0--
Filing and Contact Details

Filer

EIN
38-3266008
Raw XML Appendix191 raw XML fields

This appendix keeps the raw XML leaves available for debugging and edge-case review. The human report above is the primary experience.

Path#Value
InvestmentsCorpStockSchedule/InvestmentsCorpStock/EOYBookValue029846
InvestmentsCorpStockSchedule/InvestmentsCorpStock/EOYFMV027205
InvestmentsCorpStockSchedule/InvestmentsCorpStock/NameOfStock0STOCKS
IRS990PF/AnalysisIncomeProducingActy/DividendsAndIntFromSecPartVII/ExclusionCode014
IRS990PF/AnalysisOfRevenueAndExpenses/AdjustedNetIncome0472
IRS990PF/AnalysisOfRevenueAndExpenses/ContriGiftsPaidDsbrsChrtblPrps00
IRS990PF/AnalysisOfRevenueAndExpenses/ContriGiftsPaidRevAndExpnss00
IRS990PF/AnalysisOfRevenueAndExpenses/DividendsAdjNetIncm0472
IRS990PF/AnalysisOfRevenueAndExpenses/DividendsNetInvstIncm0472
IRS990PF/AnalysisOfRevenueAndExpenses/DividendsRevAndExpnss0472
IRS990PF/AnalysisOfRevenueAndExpenses/ExcessOfRevenueOverExpenses0472
IRS990PF/AnalysisOfRevenueAndExpenses/NetInvestmentIncome0472
IRS990PF/AnalysisOfRevenueAndExpenses/NotRequiredToAttachScheduleB0X
IRS990PF/AnalysisOfRevenueAndExpenses/TotalAdjustedNetIncome0472
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesDsbrsChrtblPrps00
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesNetInvstIncm00
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesRevAndExpnss00
IRS990PF/AnalysisOfRevenueAndExpenses/TotalNetInvestmentIncome0472
IRS990PF/AnalysisOfRevenueAndExpenses/TotalRevenueAndExpenses0472
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesDsbrsChrtblPrps00
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesNetInvstIncm00
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesRevAndExpnss00
IRS990PF/BalanceSheets/InvestmentsCorpStockBOY029374
IRS990PF/BalanceSheets/InvestmentsCorpStockEOY029846
IRS990PF/BalanceSheets/InvestmentsCorpStockEOYFMV027205
IRS990PF/BalanceSheets/OrgThatFollowSFAS1170X
IRS990PF/BalanceSheets/TotalAssetsBOY029374
IRS990PF/BalanceSheets/TotalAssetsEOY029846
IRS990PF/BalanceSheets/TotalAssetsEOYFMV027205
IRS990PF/BalanceSheets/TotalLiabilitiesBOY00
IRS990PF/BalanceSheets/TotalLiabilitiesEOY00
IRS990PF/BalanceSheets/TotalLiabilitiesNetAssetsBOY029374
IRS990PF/BalanceSheets/TotalLiabilitiesNetAssetsEOY029846
IRS990PF/BalanceSheets/TotalNetAssetsBOY029374
IRS990PF/BalanceSheets/TotalNetAssetsEOY029846
IRS990PF/BalanceSheets/UnrestrictedBOY029374
IRS990PF/BalanceSheets/UnrestrictedEOY029846
IRS990PF/ChangesInNetAssetsFundBalances/ExcessOfRevenueOverExpenses0472
IRS990PF/ChangesInNetAssetsFundBalances/Subtotal029846
IRS990PF/ChangesInNetAssetsFundBalances/TotalNetAssetsFundBalancesBOY029374
IRS990PF/ChangesInNetAssetsFundBalances/TotalNetAssetsFundBalancesEOY029846
IRS990PF/DistributableAmount/DistributableAmountAsAdjusted01449
IRS990PF/DistributableAmount/DistributableAmountBeforeAdj01449
IRS990PF/DistributableAmount/DistributableAmountBeforeDed01449
IRS990PF/DistributableAmount/MinimumInvestmentReturn01458
IRS990PF/DistributableAmount/TaxBasedOnInvestmentIncome09
IRS990PF/DistributableAmount/TotalTax09
IRS990PF/ExciseTaxBasedOnInvestmentIncm/InvestmentIncomeExciseTax09
IRS990PF/ExciseTaxBasedOnInvestmentIncm/SubtitleATax00
IRS990PF/ExciseTaxBasedOnInvestmentIncm/Subtotal09
IRS990PF/ExciseTaxBasedOnInvestmentIncm/TaxBasedOnInvestmentIncome09
IRS990PF/ExciseTaxBasedOnInvestmentIncm/TaxDue09
IRS990PF/ExciseTaxBasedOnInvestmentIncm/TaxUnderSection51100
IRS990PF/ExemptPF0X
IRS990PF/FMVAssetsEOY027205
IRS990PF/MethodOfAccountingCash0X
IRS990PF/MinimumInvestmentReturn/AcquisitionIndebtedness00
IRS990PF/MinimumInvestmentReturn/AdjTotalFMVOfUnusedAssets029610
IRS990PF/MinimumInvestmentReturn/AvgMonthlyCashBalances00
IRS990PF/MinimumInvestmentReturn/AvgMonthlyFMVOfSecurities029610
IRS990PF/MinimumInvestmentReturn/CashDeemedCharitable0444
IRS990PF/MinimumInvestmentReturn/FMVAllOtherNoncharitableAssets00
IRS990PF/MinimumInvestmentReturn/MinimumInvestmentReturn01458
IRS990PF/MinimumInvestmentReturn/NetNoncharitableAssets029166
IRS990PF/MinimumInvestmentReturn/TotalFMVOfUnusedAssets029610
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/CompOfHighestPaidEmplNONE0NONE
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/AvgHoursPerWkDevotedToPosition01.00
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/AvgHoursPerWkDevotedToPosition10.00
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/Compensation00
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/Compensation10
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/ContriToEmplBenefitPlansEtc00
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/ContriToEmplBenefitPlansEtc10
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/ExpenseAccountOtherAllowances00
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/ExpenseAccountOtherAllowances10
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/PersonName0SHIAM GUPTA
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/PersonName1RAMA GUPTA
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/Title0PRESIDENT
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/Title1SECRETARY
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/USAddress/AddressLine103366 KENWOOD DR
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/USAddress/AddressLine113366 KENWOOD DR
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/USAddress/City0ROCHESTER HILLS
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/USAddress/City1ROCHESTER
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/USAddress/State0MI
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/USAddress/State1MI
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/USAddress/ZIPCode048309
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/USAddress/ZIPCode148309
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/TotNumberOfOthEmplPaidOver50k00
IRS990PF/PrivateOperatingFoundations/LessorAdjNetIncmMinInvstReturn/CurrentYear0472
IRS990PF/PrivateOperatingFoundations/LessorAdjNetIncmMinInvstReturn/Total0472
IRS990PF/PrivateOperatingFoundations/Percent85OfLessor/CurrentYear0401
IRS990PF/PrivateOperatingFoundations/Percent85OfLessor/Total0401
IRS990PF/PrivateOperatingFoundations/QualifyingDistributions/Total00
IRS990PF/PrivateOperatingFoundations/TwoThirdsMinInvstReturn/CurrentYear0972
IRS990PF/PrivateOperatingFoundations/TwoThirdsMinInvstReturn/Total0972
IRS990PF/QlfyUndSect4940eForReducedTax/AdjNonchrtblAssetsAndOnePct00
IRS990PF/QlfyUndSect4940eForReducedTax/AdjustedNoncharitableAssets00
IRS990PF/QualifyingDistributions/ExpensesAndContributions00
IRS990PF/StatementsRegardingActivities/ActivitiesNotPrevReported0false
IRS990PF/StatementsRegardingActivities/ApplicableInsuranceContract0false
IRS990PF/StatementsRegardingActivities/AtLeast5000InAssets0true
IRS990PF/StatementsRegardingActivities/BooksInCareOfPersonName0SHIAM GUPTA
IRS990PF/StatementsRegardingActivities/BooksInCareOfPhoneNumber02488725769
IRS990PF/StatementsRegardingActivities/BooksInCareOfUSAddress/AddressLine103366 KENWOOD DR
IRS990PF/StatementsRegardingActivities/BooksInCareOfUSAddress/City0ROCHESTER HILLS
IRS990PF/StatementsRegardingActivities/BooksInCareOfUSAddress/State0MI
IRS990PF/StatementsRegardingActivities/BooksInCareOfUSAddress/ZIPCode048309
IRS990PF/StatementsRegardingActivities/ChangesToArticlesOrBylaws0false
IRS990PF/StatementsRegardingActivities/ComplyWithPublicInspectionRqr0true
IRS990PF/StatementsRegardingActivities/ForeignBank0false
IRS990PF/StatementsRegardingActivities/Form1120POLFiled0false
IRS990PF/StatementsRegardingActivities/Form990PFFiledWithAG0false
IRS990PF/StatementsRegardingActivities/InterestInControlledEntity0false
IRS990PF/StatementsRegardingActivities/LegislativePoliticalActivities0false
IRS990PF/StatementsRegardingActivities/MoreThan100Spent0false
IRS990PF/StatementsRegardingActivities/NewSubstantialContributors0false
IRS990PF/StatementsRegardingActivities/PrivateOperatingFoundation0true
IRS990PF/StatementsRegardingActivities/TerminationEtc0false
IRS990PF/StatementsRegardingActivities/UnrelatedBusIncomeOver10000false
IRS990PF/StatementsRegardingActy4720/BorrowOrLendWithDsqflyPerson0false
IRS990PF/StatementsRegardingActy4720/BusinessHoldings0false
IRS990PF/StatementsRegardingActy4720/FurnishedGoodsWithDsqflyPerson0false
IRS990PF/StatementsRegardingActy4720/GrantsToIndividuals0false
IRS990PF/StatementsRegardingActy4720/GrantsToOrganizations0false
IRS990PF/StatementsRegardingActy4720/InfluenceElection0false
IRS990PF/StatementsRegardingActy4720/InfluenceLegislation0false
IRS990PF/StatementsRegardingActy4720/JeopardyInvestments0false
IRS990PF/StatementsRegardingActy4720/NoncharitablePurpose0false
IRS990PF/StatementsRegardingActy4720/PayCompensationToDsqflyPerson0false
IRS990PF/StatementsRegardingActy4720/PaymentToGovernmentOffical0false
IRS990PF/StatementsRegardingActy4720/PayPremiumsPrsnlBnftContract0false
IRS990PF/StatementsRegardingActy4720/ProhibitedTaxShelterTransactn0false
IRS990PF/StatementsRegardingActy4720/RcvFundsToPayPrsnlBnftContract0false
IRS990PF/StatementsRegardingActy4720/SaleOrExchangeWithDsqflyPerson0false
IRS990PF/StatementsRegardingActy4720/TransferAssetsToDsqflyPerson0false
IRS990PF/StatementsRegardingActy4720/UncorrectedJeopardyInvestments0false
IRS990PF/StatementsRegardingActy4720/UncorrectedPriorActs0false
IRS990PF/StatementsRegardingActy4720/UndistributedIncomePriorYears0false
IRS990PF/StatementsRegardingActy4720/UndistrIncome4942a2NotApplied0false
IRS990PF/SummaryOfDirectCharitableActy/Description10dpfErr
IRS990PF/SummaryOfDirectCharitableActy/Expenses100
IRS990PF/SupplementaryInformation/AppicationSubmissionInfo/FormAndInfoAndMaterials0JUST AN APPLICATION WITH YOUR CREDENTIALS
IRS990PF/SupplementaryInformation/AppicationSubmissionInfo/RecipientName0SHIAM GUPTA
IRS990PF/SupplementaryInformation/AppicationSubmissionInfo/RecipientPhoneNumber02483409228
IRS990PF/SupplementaryInformation/AppicationSubmissionInfo/RecipientUSAddress/AddressLine103366 KENWOOD DR
IRS990PF/SupplementaryInformation/AppicationSubmissionInfo/RecipientUSAddress/City0ROCHESTER
IRS990PF/SupplementaryInformation/AppicationSubmissionInfo/RecipientUSAddress/State0MI
IRS990PF/SupplementaryInformation/AppicationSubmissionInfo/RecipientUSAddress/ZIPCode048309
IRS990PF/SupplementaryInformation/AppicationSubmissionInfo/RestrictionsOnAwards0NONE
IRS990PF/SupplementaryInformation/AppicationSubmissionInfo/SubmissionDeadlines0None
IRS990PF/SupplementaryInformation/ContributingManager0NONE
IRS990PF/SupplementaryInformation/ShareholderManager0NONE
IRS990PF/TrnsfrTrRlnWithNoncharitableEO/LoansOrLoanGuarantees0false
IRS990PF/TrnsfrTrRlnWithNoncharitableEO/PerformanceOfServicesEtc0false
IRS990PF/TrnsfrTrRlnWithNoncharitableEO/PurchaseAssetsNoncharitableEO0false
IRS990PF/TrnsfrTrRlnWithNoncharitableEO/ReimbursementArrangements0false
IRS990PF/TrnsfrTrRlnWithNoncharitableEO/RelationshipsNoncharitableEOs0false
IRS990PF/TrnsfrTrRlnWithNoncharitableEO/RentalOfFacilitiesEtc0false
IRS990PF/TrnsfrTrRlnWithNoncharitableEO/SalesOrExchangesOfAssets0false
IRS990PF/TrnsfrTrRlnWithNoncharitableEO/SharingOfFacilitiesEtc0false
IRS990PF/TrnsfrTrRlnWithNoncharitableEO/TrnsfrOfCashToNoncharitableEO0false
IRS990PF/TrnsfrTrRlnWithNoncharitableEO/TrnsfrOthAssetsNoncharitableEO0false
IRS990PF/UndistributedIncome/DistributableAmountAsAdjusted01449
IRS990PF/UndistributedIncome/UndistributedIncomeCY01449
ReturnHeader/BuildTS02015-12-30 17:16:21Z
ReturnHeader/Filer/EIN0383266008
ReturnHeader/Filer/Name/BusinessNameLine10RAMTI DEVI GUPTA FOUNDATION
ReturnHeader/Filer/NameControl0RAMT
ReturnHeader/Filer/USAddress/AddressLine103366 KENWOOD DR
ReturnHeader/Filer/USAddress/City0ROCHESTER
ReturnHeader/Filer/USAddress/State0MI
ReturnHeader/Filer/USAddress/ZIPCode048309
ReturnHeader/Officer/AuthorizeThirdParty0false
ReturnHeader/Officer/DateSigned02014-08-02
ReturnHeader/Officer/Name0SHIAM GUPTA
ReturnHeader/Officer/Phone02488725769
ReturnHeader/Officer/Title0PRESIDENT
ReturnHeader/Preparer/DatePrepared02014-08-13
ReturnHeader/PreparerFirm/EIN0383136796
ReturnHeader/PreparerFirm/PreparerFirmBusinessName/BusinessNameLine10ANIL SAKHUJA & ASSOCIATES PC
ReturnHeader/PreparerFirm/PreparerFirmUSAddress/AddressLine1016619 RONNIE LANE
ReturnHeader/PreparerFirm/PreparerFirmUSAddress/City0LIVONIA
ReturnHeader/PreparerFirm/PreparerFirmUSAddress/State0MI
ReturnHeader/PreparerFirm/PreparerFirmUSAddress/ZIPCode048154
ReturnHeader/Preparer/Name0ANIL SAKHUJA CPA
ReturnHeader/Preparer/Phone07349539526
ReturnHeader/Preparer/SelfEmployed0X
ReturnHeader/ReturnType0990PF
ReturnHeader/TaxPeriodBeginDate02012-10-01
ReturnHeader/TaxPeriodEndDate02013-09-30
ReturnHeader/TaxYear02012
ReturnHeader/Timestamp02014-08-13T11:23:16-04:00

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Displayed year

2013 • Form 990PFDetailed filing. Detailed filing data is available for this year.

Open filing
Assets
$29,846
Liabilities
$1
Net assets
$29,846
Revenue
$472
Expenses
$0
Net income
$472
Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2017Detailed filing. Detailed filing data is available for this year.$0.00$0.00$0.00$0.00$3.62$3.62
2016Detailed filing. Detailed filing data is available for this year.$29.8$0.00$29.8$0.00$0.00$0.00
2015Detailed filing. Detailed filing data is available for this year.$29.8$0.00$29.8$0.00$0.00$0.00
2014Detailed filing. Detailed filing data is available for this year.$29.8$0.00$29.8$0.00$0.00$0.00
2013Detailed filing. Detailed filing data is available for this year.$29.8$0.00$29.8$0.47$0.00$0.47
2012Detailed filing. Detailed filing data is available for this year.$29.4$0.00$29.4$0.00
2011Detailed filing. Detailed filing data is available for this year.$28.9$0.00$28.9$0.00
2010Detailed filing. Detailed filing data is available for this year.$32.6$0.00$32.6$0.00