Hi, I only need to Finish the balance sheet of the 2021 and the balance sheet for year to date of 2022. The values of the balance sheets can be modified as your the convenience of the company. And I will need a cash flow for the 2022 year to date. Thanks so much!
Balances 2021$COMPRAcostodownLoanSale DateSaleG. ProfitRehab FeesNet Profit 2402 Dryden Ln. Charlotte NC, 28210$215,000$215,0001/29/21$290,000$75,000$10,0009500$62,000 BALANCE SHEET FOR 2021 TAX YEAR END131 8th Ave. NE Hickory NC, 28601$55,000$55,0001/20/21$85,000$24,000$24,000 40%4114 Malta Pl. Charlotte NC, 28215$165,000$165,0001/21/21$175,000$4,000$4,000 Bank Account$104,800working expenses$41,00040%1314 Harris St. Statesville NC, 28677$10,000$10,0004/21/21$14,500$1,800$1,800 Retained Erningsother expenses$33,6001011 Rickert St. Statesville NC, 28677$18,000$18,0004/22/21$24,000$6,000$6,000 Assets Equity$117,800Private investor$35,000408 E Park Ave Gastonia NC, 28054$100,000$100,000$20,0001/27/22$31,000$8,000 Properties$816,000Lender Loans$816,000 tc={8FED31F3-C418-414D-9FE9-93CB99806900}: [Threaded comment] Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924 Comment: Previous loans + current loans 414 E Park Ave Gastonia NC, 28054$63,000$63,0002/3/22 Office Equipment$5,000Paid Loan Interest$81,600406 E. Sharpe St. Statesville NC, 28677$40,000$40,00010/19/21$47,000$7,000$7,000 Vehicles$30,000Car loan por pagar$30,00035 & 36 Oak St. China Grove NC, $150,000$150,000$15,0002/1/22$6,000 Other Fees$23,50010935 Carmel Crossings Charlotte NC, 28210$0$01/27/22$0 PASIVOS$1,060,700$816,000$35,000$781,000$635,500$117,800$41,000$23,500$104,800 $313,000$145,500 Capital$1,000 Profit $104,800PROPERTY INSURANCE = OTHER EXPENSES ACTIVOS$1,073,600pasivo + capital$1,166,500 ($92,900) BALANCE SHEET FOR YEAR TO DATE 2022 2022PURCHPURCHREHABSALESALE DATEG. ProfitRehab FeesNet Profit Bank Account$11,111working expenses$39,000 Inventoryother expenses$22,222408 E Park Ave Gastonia NC, 28054100%5/7/21$100,000$205,0001/27/22$10,000$40,000 AssetsPrivate investor$88,888414 E Park Ave Gastonia NC, 28054100%12/23/21$63,000$70,0002/3/22$7,000 Properties$1,098,000Lender Loans$627,77735 & 36 Oak St. China Grove NC, 100%12/3/21$150,000$5,000$198,0002/1/22$3,000$10,000$29,000 Office Equipment$4,500Loan Interest$62,778SUBTOTAL$0$3,000$20,000$76,000 Vehicles$29,000Car loan$29,00010935 Carmel Crossings Charlotte NC, 28210100%1/12/22$150,000$160,0001/27/22$10,000$10,000 Other Fees$36,0001233 Beaverbrook Dr. Gastonia NC, 28052100% 4/8/22$120,000$35,000$200,00010/31/22$80,000$35,000$12,000$33,000 PASIVOS$905,665110 6th St. SW Hickory NC, 100% 9/14/22$100,000$0 313000321 New Haven Dr. Gastonia NC, 50% 9/28/22$60,000$105,50010/4/22$45,500$1,000$4,000$20,250 Capital$1,9741008 Clanton Rd. Charlotte NC, 28217100% 9/9/22$250,000$0 Profit $139,250701 Johnston Dr. Pineville NC, 100%9/21/22$105,000$0 ACTIVOS$1,142,611pasivo + capital$1,359,889$1,098,000$135,500$39,000$36,000$63,250 $88,888$139,250 $217,278actual shark loan?$1,009,112oprating expenses PROPERTY INSURANCE = OTHER EXPENSES 1233 Beaverbrook Dr. Gastonia NC, 28052$120,000$35,000$200,00010/31/22 110 6th St. SW Hickory NC, $100,000 321 New Haven Dr. Gastonia NC, $60,000$105,50010/4/22 1008 Clanton Rd. Charlotte NC, 28217$250,000 701 Johnston Dr. Pineville NC, $105,000$105,000$40,000$25,000$40,000 408 E Park Ave Gastonia NC, 28054$100,000$20,0001/27/22$205,000$48,000$5,000$13,000$30,000 35 & 36 Oak St. China Grove NC, $150,000$15,0002/1/22$198,000$10,000$10,000 10935 Carmel Crossings Charlotte NC, 28210$150,0001/27/22$160,000$7,000$7,000 414 E Park Ave Gastonia NC, 28054$63,0002/3/22$70,000 TrackRec ZipAddress% Owner-shipPurch DatePurch PriceRehab $Sale PriceDispstion Date 2402 Dryden Ln. Charlotte NC282102402 Dryden Ln. Charlotte NC, 282102402 Dryden Ln. Charlotte NC, 28210100%12/14/17$215,000$40,000$290,0001/29/21 7535 Fallow Ln. Charlotte NC282737535 Fallow Ln. Charlotte NC, 282737535 Fallow Ln. Charlotte NC, 28273100%7/1/10$81,900$25,000$127,5002/17/17 109 Kern Ct. & 102 Mintzfield Dr. Lawndale NC28090109 Kern Ct. & 102 Mintzfield Dr. Lawndale NC, 28090109 Kern Ct. & 102 Mintzfield Dr. Lawndale NC, 2809080%7/10/20$40,000$45,00010/2/20 131 8th Ave. NE Hickory NC28601131 8th Ave. NE Hickory NC, 28601131 8th Ave. NE Hickory NC, 2860180%12/24/20$55,000$85,0001/20/21 4114 Malta Pl. Charlotte NC282154114 Malta Pl. Charlotte NC, 282154114 Malta Pl. Charlotte NC, 2821540%11/27/20$165,000$175,0001/21/21 1314 Harris St. Statesville NC286771314 Harris St. Statesville NC, 286771314 Harris St. Statesville NC, 2867740%3/8/21$10,000$14,5004/21/21 1011 Rickert St. Statesville NC286771011 Rickert St. Statesville NC, 286771011 Rickert St. Statesville NC, 2867710%3/18/21$18,000$24,0004/22/21 408 E Park Ave Gastonia NC28054408 E Park Ave Gastonia NC, 28054408 E Park Ave Gastonia NC, 28054100%5/7/21$100,000$40,000$200,0001/27/22 406 E. Sharpe St. Statesville NC28677406 E. Sharpe St. Statesville NC, 28677406 E. Sharpe St. Statesville NC, 28677100%9/28/21$40,000$47,00010/19/21 35 & 36 Oak St. China Grove NC35 & 36 Oak St. China Grove NC, 35 & 36 Oak St. China Grove NC, 100%12/3/21$150,000$5,000$198,0001/27/22 10935 Carmel Crossings Charlotte NC2821010935 Carmel Crossings Charlotte NC, 2821010935 Carmel Crossings Charlotte NC, 28210100%1/18/22$150,000$160,0001/27/22 1233 Beaverbrook Dr. Gastonia NC280521233 Beaverbrook Dr. Gastonia NC, 280521233 Beaverbrook Dr. Gastonia NC, 28052100%$120,000$34,000$200,00010/31/22 110 6th St. SW Hickory NC110 6th St. SW Hickory NC, 110 6th St. SW Hickory NC, 100%$100,000 321 New Haven Dr. Gastonia NC321 New Haven Dr. Gastonia NC, 321 New Haven Dr. Gastonia NC, 50%$60,000$106,00010/11/22 1008 Clanton Rd. Charlotte NC282171008 Clanton Rd. Charlotte NC, 282171008 Clanton Rd. Charlotte NC, 28217100%$250,000 701 Johnston Dr. Pineville NC701 Johnston Dr. Pineville NC, 701 Johnston Dr. Pineville NC, 100%$105,000 Sheet2 2021costodownLoanSale DateSaleG. ProfitRehab FeesNet Profit 2402 Dryden Ln. Charlotte NC, 28210$215,0001/29/21$290,000$75,000$40,000$35,000 BALANCE SHEET FOR 2021 TAX YEAR END1314 Harris St. Statesville NC, 28677$10,000$14,500$4,500$4,500 1011 Rickert St. Statesville NC, 28677$18,000$24,000$6,000$6,000 Bank Accountworking expenses$31,000408 E Park Ave Gastonia NC, 28054$100,000$20,0001/27/22$31,000$8,000 414 E Park Ave Gastonia NC, 28054$63,000$70,000$7,000$7,000 AssetsPrivate investor$35,000406 E. Sharpe St. Statesville NC, 28677$40,000$47,000$7,000$7,000 Properties$381,00035 & 36 Oak St. China Grove NC, $150,000$15,0002/1/22$198,000$6,000 Office Equipment$5,000Lender Loans$215,00010935 Carmel Crossings Charlotte NC, 28210$01/27/22$160,000$0 Loan Interest$21,500$381,000$35,000$513,500$24,500$31,000$14,000$24,500 Other Fees$16,500$346,000 PASIVOS$319,000 Capital Profit $24,500 ACTIVOS$386,000pasivo + capital$343,500 $42,500 2022costodown BALANCE SHEET FOR 2022 TAX YEAR END10000010000 250000 Bank Accountworking expenses105000 120000 AssetsLender Loans1233 Beaverbrook Dr. Gastonia NC, 28052$120,000$35,000$200,00010/31/22 Properties$ 575,000.00Loan Interest110 6th St. SW Hickory NC, $100,000 Office Equipment$ 5,000.00321 New Haven Dr. Gastonia NC, $60,000$105,50010/4/22 Capital1008 Clanton Rd. Charlotte NC, 28217$250,000 701 Johnston Dr. Pineville NC, $105,000 408 E Park Ave Gastonia NC, 28054$100,000$20,0001/27/22$205,000$105,000$40,000$25,000$40,000 35 & 36 Oak St. China Grove NC, $150,000$15,0002/1/22$198,000$48,000$5,000$13,000$30,000 10935 Carmel Crossings Charlotte NC, 28210$150,0001/27/22$160,000$10,000$10,000 Cashflow Cash Flow Statement Fiscal year begins: Sheet1 ZipAddress% OwnrshpPurchase DatePurchase PriceRehab $Sale PriceDispstion Date 2402 Dryden Ln. Charlotte NC282102402 Dryden Ln. Charlotte NC, 282102402 Dryden Ln. Charlotte NC, 28210100%12/14/17$215,000.00$40,000.00$290,000.001/29/21 7535 Fallow Ln. Charlotte NC282737535 Fallow Ln. Charlotte NC, 282737535 Fallow Ln. Charlotte NC, 28273100%7/1/10$81,900.00$25,000.00$127,500.002/17/17 109 Kern Ct. & 102 Mintzfield Dr. Lawndale NC28090109 Kern Ct. & 102 Mintzfield Dr. Lawndale NC, 28090109 Kern Ct. & 102 Mintzfield Dr. Lawndale NC, 2809080%7/10/20$40,000.00$45,000.0010/2/20 131 8th Ave. NE Hickory NC28601131 8th Ave. NE Hickory NC, 28601131 8th Ave. NE Hickory NC, 2860180%12/24/20$55,000.00$85,000.001/20/21 4114 Malta Pl. Charlotte NC282154114 Malta Pl. Charlotte NC, 282154114 Malta Pl. Charlotte NC, 2821540%11/27/20$165,000.00$175,000.001/21/21 1314 Harris St. Statesville NC286771314 Harris St. Statesville NC, 286771314 Harris St. Statesville NC, 2867740%3/8/21$10,000.00$14,500.004/21/21 1011 Rickert St. Statesville NC286771011 Rickert St. Statesville NC, 286771011 Rickert St. Statesville NC, 2867710%3/18/21$18,000.00$24,000.004/22/21 408 E Park Ave Gastonia NC28054408 E Park Ave Gastonia NC, 28054408 E Park Ave Gastonia NC, 28054100%5/7/21$100,000.00$40,000.00$200,000.001/27/22 406 E. Sharpe St. Statesville NC28677406 E. Sharpe St. Statesville NC, 28677406 E. Sharpe St. Statesville NC, 28677100%9/28/21$40,000.00$47,000.0010/19/21 35 & 36 Oak St. China Grove NC35 & 36 Oak St. China Grove NC, 35 & 36 Oak St. China Grove NC, 100%12/3/21$150,000.00$5,000.00$198,000.001/27/22 10935 Carmel Crossings Charlotte NC2821010935 Carmel Crossings Charlotte NC, 2821010935 Carmel Crossings Charlotte NC, 28210100%$150,000.00$160,000.001/27/22 1233 Beaverbrook Dr. Gastonia NC280521233 Beaverbrook Dr. Gastonia NC, 280521233 Beaverbrook Dr. Gastonia NC, 28052100%$120,000.00$34,000.00$200,000.0010/31/22 110 6th St. SW Hickory NC110 6th St. SW Hickory NC, 110 6th St. SW Hickory NC, 100%$100,000.00 321 New Haven Dr. Gastonia NC321 New Haven Dr. Gastonia NC, 321 New Haven Dr. Gastonia NC, 50%$60,000.00$106,000.0010/11/22 1008 Clanton Rd. Charlotte NC282171008 Clanton Rd. Charlotte NC, 282171008 Clanton Rd. Charlotte NC, 28217100%$250,000.00 701 Johnston Dr. Pineville NC701 Johnston Dr. Pineville NC, 701 Johnston Dr. Pineville NC, 100%$105,000.00 mktsegpie $40 $320 $35 $10 $10 Residential Community60 Commercial10 Rental30 Marketing Segments of Properties Residential CommunityCommercialRental601030 Sheet1 (2) Street AddressCitySTZip% OwnrshpPurchase DatePrice$KRehb $KSale $KDispstion Date 2402 Dryden Ln.CharlotteNC28210100%12/14/17215402901/29/21 7535 Fallow Ln.CharlotteNC28273100%7/1/1081.925127.52/17/17 109 Kern Ct. & 102 Mintzfield Dr.LawndaleNC2809080%7/10/204004510/2/20 131 8th Ave. NEHickoryNC2860180%12/24/20550851/20/21 4114 Malta Pl.CharlotteNC2821540%11/27/2016501751/21/21 1314 Harris St.StatesvilleNC2867740%3/8/2110014.54/21/21 1011 Rickert St.StatesvilleNC2867710%3/18/21180244/22/21 408 E Park AveGastoniaNC28054100%5/7/21100402001/27/22 406 E. Sharpe St.StatesvilleNC28677100%9/28/214004710/19/21 35 & 36 Oak St.China GroveNC100%12/3/2115051981/27/22 10935 Carmel CrossingsCharlotteNC28210100%15001601/27/22 1233 Beaverbrook Dr.GastoniaNC28052100%1203420010/31/22 110 6th St. SWHickoryNC100%10000 321 New Haven Dr.GastoniaNC50%60010610/11/22 1008 Clanton Rd.CharlotteNC28217100%25000 701 Johnston Dr.PinevilleNC100%10500 Balances 2021$COMPRAcostodownLoanSale DateSaleG. ProfitRehab FeesNet Profit 2402 Dryden Ln. Charlotte NC, 28210$215,000$215,0001/29/21$290,000$75,000$10,0009500$62,000 BALANCE SHEET FOR 2021 TAX YEAR END131 8th Ave. NE Hickory NC, 28601$55,000$55,0001/20/21$85,000$24,000$24,000 40%4114 Malta Pl. Charlotte NC, 28215$165,000$165,0001/21/21$175,000$4,000$4,000 Bank Account$104,800working expenses$41,00040%1314 Harris St. Statesville NC, 28677$10,000$10,0004/21/21$14,500$1,800$1,800 Retained Erningsother expenses$33,6001011 Rickert St. Statesville NC, 28677$18,000$18,0004/22/21$24,000$6,000$6,000 Assets Equity$117,800Private investor$35,000408 E Park Ave Gastonia NC, 28054$100,000$100,000$20,0001/27/22$31,000$8,000 Properties$816,000Lender Loans$816,000 tc={8FED31F3-C418-414D-9FE9-93CB99806900}: [Threaded comment] Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924 Comment: Previous loans + current loans 414 E Park Ave Gastonia NC, 28054$63,000$63,0002/3/22 Office Equipment$5,000Paid Loan Interest$81,600406 E. Sharpe St. Statesville NC, 28677$40,000$40,00010/19/21$47,000$7,000$7,000 Vehicles$30,000Car loan por pagar$30,00035 & 36 Oak St. China Grove NC, $150,000$150,000$15,0002/1/22$6,000 Other Fees$23,50010935 Carmel Crossings Charlotte NC, 28210$0$01/27/22$0 PASIVOS$1,060,700$816,000$35,000$781,000$635,500$117,800$41,000$23,500$104,800 $313,000$145,500 Capital$1,000 Profit $104,800PROPERTY INSURANCE = OTHER EXPENSES ACTIVOS$1,073,600pasivo + capital$1,166,500 ($92,900) BALANCE SHEET FOR