Great Deal! Get Instant $10 FREE in Account on First Order + 10% Cashback on Every Order Order Now

Balances 2021 $COMPRA costo down Loan Sale Date Sale G. Profit Rehab Fees Net Profit 2402 Dryden Ln. Charlotte NC,...

1 answer below »
Balances
                                2021    $COMPRA    costo    down    Loan    Sale Date    Sale    G. Profit    Rehab     Fees    Net Profit
                                2402 Dryden Ln. Charlotte NC, 28210    $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 Ha
is 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-93CB XXXXXXXXXX}: [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 + cu
ent 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, 28677    $40,000    $40,000            10/19/21    $47,000    $7,000            $7,000
        Vehicles    $30,000        Car loan por pagar    $30,000        35 & 36 Oak St. China Grove NC,     $150,000    $150,000    $15,000        2/1/22                $6,000
                    Other Fees    $23,500        10935 Carmel Crossings Charlotte NC, 28210    $0    $0            1/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,800        PROPERTY INSURANCE = OTHER EXPENSES
        ACTIVOS    $1,166,500        pasivo + capital    $1,166,500
                        - 0
        BALANCE SHEET FOR YEAR TO DATE 2022
                                2022        PURCH    PURCH    REHAB    SALE    SALE DATE    G. Profit    Rehab     Fees    Net Profit
        Bank Account    $11,111        working expenses    $39,000
        Inventory    $217,278        other expenses    $22,222        408 E Park Ave Gastonia NC, 28054    100%    5/7/21    $100,000        $205,000    1/27/22            $10,000    $40,000
        Assets            Private investor    $88,888        414 E Park Ave Gastonia NC, 28054    100%    12/23/21    $63,000        $70,000    2/3/22                $7,000
        Properties    $1,098,000        Lender Loans    $627,777        35 & 36 Oak St. China Grove NC,     100%    12/3/21    $150,000    $5,000    $198,000    2/1/22        $3,000    $10,000    $29,000
        Office Equipment    $4,500        Loan Interest    $62,778                                SUBTOTAL    $0    $3,000    $20,000    $76,000
        Vehicles    $29,000        Car loan    $29,000        10935 Carmel Crossings Charlotte NC, 28210    100%    1/12/22    $150,000        $160,000    1/27/22    $10,000            $10,000
                    Other Fees    $36,000        1233 Beave
ook Dr. Gastonia NC, 28052    100%    Â 4/8/22    $120,000    $35,000    $200,000    10/31/22    $80,000    $35,000    $12,000    $33,000
                    PASIVOS    $905,665        110 6th St. SW Hickory NC,     100%    Â Â 9/14/22    $100,000                            $0
                        313000        321 New Haven Dr. Gastonia NC,     50%    Â 9/28/22    $60,000        $105,500    10/4/22    $45,500    $1,000    $4,000    $20,250
                    Capital    $1,974        1008 Clanton Rd. Charlotte NC, 28217    100%    Â 9/9/22    $250,000                            $0
                    Profit     $139,250        701 Johnston Dr. Pineville NC,     100%    9/21/22    $105,000                            $0
        ACTIVOS    $1,359,889        pasivo + capital    $1,359,889                    $1,098,000                $135,500    $39,000    $36,000    $63,250
                                            $88,888                            $139,250
                        - 0                actual shark loan?    $1,009,112                    oprating expenses
                                PROPERTY INSURANCE = OTHER EXPENSES
                                1233 Beave
ook Dr. Gastonia NC, 28052        $120,000    $35,000    $200,000        10/31/22
                                110 6th St. SW Hickory NC,         $100,000
                                321 New Haven Dr. Gastonia NC,         $60,000        $105,500        10/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,000        1/27/22    $205,000    $48,000    $5,000    $13,000    $30,000
                                35 & 36 Oak St. China Grove NC,         $150,000    $15,000        2/1/22    $198,000    $10,000            $10,000
                                10935 Carmel Crossings Charlotte NC, 28210        $150,000            1/27/22    $160,000    $7,000            $7,000
                                414 E Park Ave Gastonia NC, 28054        $63,000            2/3/22    $70,000
Cashflow
    Cash Flow Statement
    Fiscal year begins:
    Net Income    $ 34,450
    Add: Depreciation    $ 1,500
    Decrease in Cu
ent 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 After Oct 31, 2022

Solution

Nitish Lath answered on Nov 02 2022
63 Votes
Balances
                                2021    $COMPRA    costo    down    Loan    Sale Date    Sale    G. Profit    Rehab     Fees    Net Profit
                                2402 Dryden Ln. Charlotte NC, 28210    $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 Ha
is 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 + cu
ent 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