Civic Intelligence

Guan Foundation

990PF • Fiscal year 2017 • EIN 82-3392969

Jan 01, 2017 to Dec 31, 2017 • Filed on Aug 24, 2018

400 Cheyenne LnCedar Park, TX 78613

(415) 606-0197

Siviq Scores

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

Liabilities / Assets

35th percentile

0.00x

Tied with the lowest-debt nonprofits in its peer group.

2017 filings • $500k-$1M nonprofits • Source year 2017

Liabilities / Revenue

35th percentile

0.00x

Tied with the lowest-debt nonprofits in its peer group.

2017 filings • $500k-$1M nonprofits • Source year 2017

Net Margin

100th percentile

100%

Higher net margin than 100% of similar nonprofits.

2017 filings • $500k-$1M nonprofits • Source year 2017

Top Officer Pay

54th percentile

$0

Higher top officer pay than 54% of similar nonprofits.

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

2017 filings • $500k-$1M nonprofits • Source year 2017

Asset Growth

Score unavailable

No value available

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

Source year 2017

Revenue Growth

Score unavailable

No value available

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

Source year 2017

Assets

$53,550

No earlier filing loaded for comparison.

Net Assets

$53,550

No earlier filing loaded for comparison.

Liabilities

$0

No earlier filing loaded for comparison.

Revenue

$576,558

No earlier filing loaded for comparison.

Expenses

$0

No earlier filing loaded for comparison.

Net Income

$576,558

No earlier filing loaded for comparison.

Historical Trend

Balance Sheet Trend

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

$1.5M$1.0M$500K$0Assets 2017: $53,550Liabilities 2017: $0Net Assets 2017: $53,5502017Assets 2018: $548,787Liabilities 2018: $0Net Assets 2018: $548,7872018Assets 2019: $651,494Liabilities 2019: $0Net Assets 2019: $651,4942019Assets 2020: $1,374,711Liabilities 2020: $0Net Assets 2020: $1,374,7112020Assets 2021: $1,417,686Liabilities 2021: $0Net Assets 2021: $1,417,6862021Assets 2022: $1,362,628Liabilities 2022: $0Net Assets 2022: $1,362,6282022Assets 2023: $1,355,841Liabilities 2023: $12023Assets 2024: $1,303,106Liabilities 2024: $0Net Assets 2024: $1,303,1062024

Highlighted filing

2017

Assets$53,550
Liabilities$0
Net Assets$53,550

Operations Trend

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

$1.0M$500K$0-$500KRevenue 2017: $576,558Expenses 2017: $0Net Income 2017: $576,5582017Revenue 2018: $63,000Expenses 2018: $27,955Net Income 2018: $35,0452018Revenue 2019: $134,780Expenses 2019: $70,454Net Income 2019: $64,3262019Revenue 2020: $754,535Expenses 2020: $59,054Net Income 2020: $695,4812020Revenue 2021: $126,602Expenses 2021: $84,917Net Income 2021: $41,6852021Revenue 2022: $35,761Expenses 2022: $89,819Net Income 2022: -$54,0582022Revenue 2023: $86,496Expenses 2023: $93,283Net Income 2023: -$6,7872023Revenue 2024: $8,588Expenses 2024: $770Net Income 2024: $7,8182024

Highlighted filing

2017

Revenue$576,558
Expenses$0
Net Income$576,558
Jump To
Filing Snapshot
Filing Period
Jan 1, 2017 to Dec 31, 2017
Signed
Aug 24, 2018
Return Version
2017v2.2
Compensation and Service Providers

Employees

NameTitleFull / Part TimeBaseOtherTotal
ZHIXIN GUANTrustee-$0--
Filing and Contact Details

Filer

Filer Name
Guan Foundation
EIN
82-3392969
Address
400 CHEYENNE LN, CEDAR PARK, TX 78613

Signing Officer

Name
Zhixin Guan
Title
Trustee
Phone
4156060197
Signed
2018-08-24
Discuss with paid preparer
Yes

Preparer

Firm
Saicedar LLC dba Mytaxfiler
Address
13276 Research Blvd Ste 202, Austin, TX 78750
Preparer
Guru Chandrahas Reddy Dorsala
Phone
5129817991
Raw XML Appendix186 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
IRS990PF/AnalysisOfRevenueAndExpenses/AdjustedNetIncomeAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/ContriPaidDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/ContriPaidRevAndExpnssAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/ContriRcvdRevAndExpnssAmt0576558
IRS990PF/AnalysisOfRevenueAndExpenses/ExcessRevenueOverExpensesAmt0576558
IRS990PF/AnalysisOfRevenueAndExpenses/NetInvestmentIncomeAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesRevAndExpnssAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotalNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotalRevAndExpnssAmt0576558
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesRevAndExpnssAmt00
IRS990PF/ChgInNetAssetsFundBalancesGrp/ExcessRevenueOverExpensesAmt0576558
IRS990PF/ChgInNetAssetsFundBalancesGrp/SubtotalAmt0576558
IRS990PF/ChgInNetAssetsFundBalancesGrp/TotNetAstOrFundBalancesEOYAmt0576558
IRS990PF/DistributableAmountGrp/DistributableAsAdjustedAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/InvestmentIncomeExciseTaxAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/SubtitleATaxAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TaxBasedOnInvestmentIncomeAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TaxUnderSection511Amt00
IRS990PF/FMVAssetsEOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/CashEOYAmt053550
IRS990PF/Form990PFBalanceSheetsGrp/OrganizationFollowsSFAS117Ind0X
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsBOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsEOYAmt053550
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsEOYFMVAmt00
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesBOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesEOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesNetAstBOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesNetAstEOYAmt053550
IRS990PF/Form990PFBalanceSheetsGrp/TotNetAstOrFundBalancesBOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/TotNetAstOrFundBalancesEOYAmt053550
IRS990PF/Form990PFBalanceSheetsGrp/UnrestrictedEOYAmt053550
IRS990PF/InitialReturnInd0X
IRS990PF/MethodOfAccountingCashInd0X
IRS990PF/MinimumInvestmentReturnGrp/AcquisitionIndebtednessAmt00
IRS990PF/MinimumInvestmentReturnGrp/AdjustedTotalFMVOfUnusedAstAmt00
IRS990PF/MinimumInvestmentReturnGrp/AverageMonthlyCashBalancesAmt00
IRS990PF/MinimumInvestmentReturnGrp/AverageMonthlyFMVOfSecAmt00
IRS990PF/MinimumInvestmentReturnGrp/CashDeemedCharitableAmt00
IRS990PF/MinimumInvestmentReturnGrp/FMVAllOtherNoncharitableAstAmt00
IRS990PF/MinimumInvestmentReturnGrp/MinimumInvestmentReturnAmt00
IRS990PF/MinimumInvestmentReturnGrp/NetVlNoncharitableAssetsAmt00
IRS990PF/MinimumInvestmentReturnGrp/TotalFMVOfUnusedAssetsAmt00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/CompOfHghstPdCntrctOrNONETxt0NONE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/CompOfHghstPdEmplOrNONETxt0NONE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/AverageHrsPerWkDevotedToPosRt00.00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/CompensationAmt00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/EmployeeBenefitProgramAmt00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/ExpenseAccountOtherAllwncAmt00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/PersonNm0ZHIXIN GUAN
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/TitleTxt0TRUSTEE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/AddressLine1Txt0400 CHEYENNE LN
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/CityNm0CEDAR PARK
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/StateAbbreviationCd0TX
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/ZIPCd078613
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OtherEmployeePaidOver50kCnt00
IRS990PF/Organization501c3ExemptPFInd0X
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjNetVlNoncharitableAssetsAmt00
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjNonchrtblNetInvstIncmPctAmt00
IRS990PF/QualifyingDistriPartXIIGrp/ExpensesAndContributionsAmt00
IRS990PF/StatementsRegardingActy4720Grp/BrrwOrLendDisqualifiedPrsnInd0false
IRS990PF/StatementsRegardingActy4720Grp/BusinessHoldingsInd0false
IRS990PF/StatementsRegardingActy4720Grp/FurnGoodsDisqualifiedPrsnInd0false
IRS990PF/StatementsRegardingActy4720Grp/GrantsToIndividualsInd0false
IRS990PF/StatementsRegardingActy4720Grp/GrantsToOrganizationsInd0false
IRS990PF/StatementsRegardingActy4720Grp/InfluenceElectionInd0false
IRS990PF/StatementsRegardingActy4720Grp/InfluenceLegislationInd0false
IRS990PF/StatementsRegardingActy4720Grp/JeopardyInvestmentsInd0false
IRS990PF/StatementsRegardingActy4720Grp/NoncharitablePurposeInd0false
IRS990PF/StatementsRegardingActy4720Grp/PayCompDisqualifiedPrsnInd0false
IRS990PF/StatementsRegardingActy4720Grp/PaymentToGovernmentOfficialInd0false
IRS990PF/StatementsRegardingActy4720Grp/PayPremiumsPrsnlBnftCntrctInd0false
IRS990PF/StatementsRegardingActy4720Grp/ProhibitedTaxShelterTransInd0false
IRS990PF/StatementsRegardingActy4720Grp/RcvFndsToPayPrsnlBnftCntrctInd0false
IRS990PF/StatementsRegardingActy4720Grp/SaleOrExchDisqualifiedPrsnInd0false
IRS990PF/StatementsRegardingActy4720Grp/TransferAstDisqualifiedPrsnInd0false
IRS990PF/StatementsRegardingActy4720Grp/UncorrectedPriorActsInd0false
IRS990PF/StatementsRegardingActy4720Grp/UncorrectedPYJeopardyInvstInd0false
IRS990PF/StatementsRegardingActy4720Grp/UndistributedIncomePYInd0false
IRS990PF/StatementsRegardingActy4720Grp/UndistrIncmSect4942a2NotAppInd0false
IRS990PF/StatementsRegardingActyGrp/ActivitiesNotPreviouslyRptInd0false
IRS990PF/StatementsRegardingActyGrp/AtLeast5000InAssetsInd0true
IRS990PF/StatementsRegardingActyGrp/ChangesToArticlesOrBylawsInd0false
IRS990PF/StatementsRegardingActyGrp/ComplyWithPublicInspRqrInd0true
IRS990PF/StatementsRegardingActyGrp/DonorAdvisedFundInd0false
IRS990PF/StatementsRegardingActyGrp/ForeignAccountsQuestionInd0false
IRS990PF/StatementsRegardingActyGrp/Form1120POLFiledInd0false
IRS990PF/StatementsRegardingActyGrp/Form990PFFiledWithAttyGenInd0false
IRS990PF/StatementsRegardingActyGrp/IndividualWithBooksNm0ZHIXIN GUAN
IRS990PF/StatementsRegardingActyGrp/LegislativePoliticalActyInd0false
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/AddressLine1Txt0400 CHEYENNE LN
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/CityNm0CEDAR PARK
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/StateAbbreviationCd0TX
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/ZIPCd078613
IRS990PF/StatementsRegardingActyGrp/MoreThan100SpentInd0false
IRS990PF/StatementsRegardingActyGrp/NewSubstantialContributorsInd0false
IRS990PF/StatementsRegardingActyGrp/OrganizationDissolvedEtcInd0false
IRS990PF/StatementsRegardingActyGrp/OrgReportOrRegisterStateCd0TX
IRS990PF/StatementsRegardingActyGrp/OwnControlledEntityInd0false
IRS990PF/StatementsRegardingActyGrp/PhoneNum04156060197
IRS990PF/StatementsRegardingActyGrp/PrivateOperatingFoundationInd0false
IRS990PF/StatementsRegardingActyGrp/Section508eRqrSatisfiedInd0false
IRS990PF/StatementsRegardingActyGrp/UnrelatedBusIncmOverLimitInd0false
IRS990PF/SupplementaryInformationGrp/OnlyContriToPreselectedInd0X
IRS990PF/SupplementaryInformationGrp/TotalGrantOrContriApprvFutAmt00
IRS990PF/SupplementaryInformationGrp/TotalGrantOrContriPdDurYrAmt00
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/LoansOrLoanGuaranteesInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/PerformanceOfServicesEtcInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/PurchaseOfAssetsNonchrtblEOInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/ReimbursementArrangementsInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/RelationshipsNonchrtblEOInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/RentalOfFacilitiesOthAssetsInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/SalesOrExchangesOfAssetsInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/SharingOfFacilitiesEtcInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/TrnsfrOfCashToNonchrtblEOInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/TrnsfrOtherAssetNonchrtblEOInd0false
IRS990PF/UndistributedIncomeGrp/DistributableAsAdjustedAmt00
IRS990PF/UndistributedIncomeGrp/UndistributedIncomeCYAmt00
IRS990ScheduleB/ContributorInformationGrp/ContributorNum01
IRS990ScheduleB/ContributorInformationGrp/ContributorNum12
IRS990ScheduleB/ContributorInformationGrp/ContributorNum23
IRS990ScheduleB/ContributorInformationGrp/ContributorPersonNm0GUAN FM TR
IRS990ScheduleB/ContributorInformationGrp/ContributorPersonNm1ZHIXIN GUAN
IRS990ScheduleB/ContributorInformationGrp/ContributorPersonNm2ZHIXIN GUAN
IRS990ScheduleB/ContributorInformationGrp/ContributorUSAddress/AddressLine1Txt0400 CHEYENNE LN
IRS990ScheduleB/ContributorInformationGrp/ContributorUSAddress/AddressLine1Txt1400 CHEYENNE LN
IRS990ScheduleB/ContributorInformationGrp/ContributorUSAddress/AddressLine1Txt2400 CHEYENNE LN
IRS990ScheduleB/ContributorInformationGrp/ContributorUSAddress/CityNm0CEDAR PARK
IRS990ScheduleB/ContributorInformationGrp/ContributorUSAddress/CityNm1CEDAR PARK
IRS990ScheduleB/ContributorInformationGrp/ContributorUSAddress/CityNm2CEDAR PARK
IRS990ScheduleB/ContributorInformationGrp/ContributorUSAddress/StateAbbreviationCd0TX
IRS990ScheduleB/ContributorInformationGrp/ContributorUSAddress/StateAbbreviationCd1TX
IRS990ScheduleB/ContributorInformationGrp/ContributorUSAddress/StateAbbreviationCd2TX
IRS990ScheduleB/ContributorInformationGrp/ContributorUSAddress/ZIPCd078613
IRS990ScheduleB/ContributorInformationGrp/ContributorUSAddress/ZIPCd178613
IRS990ScheduleB/ContributorInformationGrp/ContributorUSAddress/ZIPCd278613
IRS990ScheduleB/ContributorInformationGrp/NoncashContributionInd0X
IRS990ScheduleB/ContributorInformationGrp/PersonContributionInd0X
IRS990ScheduleB/ContributorInformationGrp/PersonContributionInd1X
IRS990ScheduleB/ContributorInformationGrp/TotalContributionsAmt017508
IRS990ScheduleB/ContributorInformationGrp/TotalContributionsAmt136050
IRS990ScheduleB/ContributorInformationGrp/TotalContributionsAmt2523000
IRS990ScheduleB/GeneralRuleInd0X
IRS990ScheduleB/NonCashPropertyContributionGrp/ContributorNum03
IRS990ScheduleB/NonCashPropertyContributionGrp/FairMarketValueAmt0523000
IRS990ScheduleB/NonCashPropertyContributionGrp/NoncashPropertyDesc0HOUSE CONTRIBUTION
IRS990ScheduleB/NonCashPropertyContributionGrp/ReceivedDt02017-12-27
IRS990ScheduleB/Organization501c3ExemptPFInd0X
ReturnHeader/BuildTS02018-06-14 16:35:46Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0true
ReturnHeader/BusinessOfficerGrp/PersonNm0ZHIXIN GUAN
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0TRUSTEE
ReturnHeader/BusinessOfficerGrp/PhoneNum04156060197
ReturnHeader/BusinessOfficerGrp/SignatureDt02018-08-24
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0GUAN FOUNDATION
ReturnHeader/Filer/BusinessNameControlTxt0GUAN
ReturnHeader/Filer/EIN0823392969
ReturnHeader/Filer/USAddress/AddressLine1Txt0400 CHEYENNE LN
ReturnHeader/Filer/USAddress/CityNm0CEDAR PARK
ReturnHeader/Filer/USAddress/StateAbbreviationCd0TX
ReturnHeader/Filer/USAddress/ZIPCd078613
ReturnHeader/FilingSecurityInformation/AtSubmissionCreationDeviceId07A695EF8BCE53A8307FC83DD783AB6CCA2AA28F2
ReturnHeader/FilingSecurityInformation/AtSubmissionFilingDeviceId07A695EF8BCE53A8307FC83DD783AB6CCA2AA28F2
ReturnHeader/FilingSecurityInformation/FederalOriginalSubmissionId07074682018263mirmxyp
ReturnHeader/FilingSecurityInformation/FederalOriginalSubmissionIdDt02018-09-20
ReturnHeader/FilingSecurityInformation/FilingLicenseTypeCd0P
ReturnHeader/FilingSecurityInformation/IPAddress/IPv4AddressTxt0216.150.196.119
ReturnHeader/FilingSecurityInformation/IPDt02018-09-20
ReturnHeader/FilingSecurityInformation/IPTm017:36:01
ReturnHeader/PreparerFirmGrp/PreparerFirmEIN0814045863
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0Saicedar LLC dba Mytaxfiler
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt013276 Research Blvd Ste 202
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0Austin
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0TX
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd078750
ReturnHeader/PreparerPersonGrp/PhoneNum05129817991
ReturnHeader/PreparerPersonGrp/PreparationDt02018-09-20
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0Guru Chandrahas Reddy Dorsala
ReturnHeader/ReturnTs02018-09-20T17:35:03-04:00
ReturnHeader/ReturnTypeCd0990PF
ReturnHeader/TaxPeriodBeginDt02017-01-01
ReturnHeader/TaxPeriodEndDt02017-12-31
ReturnHeader/TaxYr02017

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings