Balances2021$COMPRAcostodownLoanSale DateSaleG. ProfitRehab FeesNet Profit2402 Dryden Ln. Charlotte NC,...

1 answer below »
I just need the cash flow for the year 2021. Another expert did the cash flow for the 2022 but I need the 2021 too. Thanks


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$908,900Lender 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,166,500pasivo + capital$1,166,500 - 0 BALANCE SHEET FOR YEAR TO DATE 2022 2022PURCHPURCHREHABSALESALE DATEG. ProfitRehab FeesNet Profit Bank Account$11,111working expenses$39,000 Inventory$217,278other 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,359,889pasivo + capital$1,359,889$1,098,000$135,500$39,000$36,000$63,250 $88,888$139,250 - 0actual 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 Cashflow Cash Flow Statement Fiscal year begins: Net Income$ 34,450 Add: Depreciation$ 1,500 Decrease in Current Assets$ 464,962 Less: Increase in Inventory$ 217,278 Increase in Properties$ 189,100 Decrease in Lenders Loan$ 188,223 Cash flow for the year$ (93,689) Beginnig Cash$ 104,800 Cash at the end$ 11,111
Answered 1 days AfterOct 31, 2022

Answer To: Balances2021$COMPRAcostodownLoanSale DateSaleG. ProfitRehab FeesNet...

Nitish Lath answered on Nov 02 2022
62 Votes
Balances
                                2021    $COMPRA    costo    down    Loan    Sale Date    Sale    G. Profit    Rehab     Fees    Net Profit
                                2402 Dryden Ln. Charlotte NC, 282
10    $215,000    $215,000            1/29/21    $290,000    $75,000    $10,000    9500    $62,000
        BALANCE SHEET FOR 2021 TAX YEAR END                        131 8th Ave. NE Hickory NC, 28601    $55,000    $55,000            1/20/21    $85,000    $24,000            $24,000
                            40%    4114 Malta Pl. Charlotte NC, 28215    $165,000    $165,000            1/21/21    $175,000    $4,000            $4,000
        Bank Account    $104,800        working expenses    $41,000    40%    1314 Harris St. Statesville NC, 28677    $10,000    $10,000            4/21/21    $14,500    $1,800            $1,800
        Retained Ernings            other expenses    $33,600        1011 Rickert St. Statesville NC, 28677    $18,000    $18,000            4/22/21    $24,000    $6,000            $6,000
        Assets Equity    $117,800        Private investor    $35,000        408 E Park Ave Gastonia NC, 28054    $100,000    $100,000    $20,000        1/27/22            $31,000    $8,000
        Properties    $908,900        Lender 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,000            2/3/22
        Office Equipment    $5,000        Paid Loan Interest    $81,600        406 E. Sharpe St. Statesville NC,...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here