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    $816,000        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,073,600        pasivo + capital    $1,166,500
                        ($92,900)
        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            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,142,611        pasivo + capital    $1,359,889                    $1,098,000                $135,500    $39,000    $36,000    $63,250
                                            $88,888                            $139,250
                        $217,278                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
TrackRec
        Zip            Address    % Owner-ship    Purch Date    Purch Price    Rehab $    Sale Price    Dispstion Date
    2402 Dryden Ln. Charlotte NC    28210    2402 Dryden Ln. Charlotte NC, 28210        2402 Dryden Ln. Charlotte NC, 28210    100%    12/14/17    $215,000    $40,000    $290,000    1/29/21
    7535 Fallow Ln. Charlotte NC    28273    7535 Fallow Ln. Charlotte NC, 28273        7535 Fallow Ln. Charlotte NC, 28273    100%    7/1/10    $81,900    $25,000    $127,500    2/17/17
    109 Kern Ct. & 102 Mintzfield Dr. Lawndale NC    28090    109 Kern Ct. & 102 Mintzfield Dr. Lawndale NC, 28090        109 Kern Ct. & 102 Mintzfield Dr. Lawndale NC, 28090    80%    7/10/20    $40,000        $45,000    10/2/20
    131 8th Ave. NE Hickory NC    28601    131 8th Ave. NE Hickory NC, 28601        131 8th Ave. NE Hickory NC, 28601    80%    12/24/20    $55,000        $85,000    1/20/21
    4114 Malta Pl. Charlotte NC    28215    4114 Malta Pl. Charlotte NC, 28215        4114 Malta Pl. Charlotte NC, 28215    40%    11/27/20    $165,000        $175,000    1/21/21
    1314 Ha
is St. Statesville NC    28677    1314 Ha
is St. Statesville NC, 28677        1314 Ha
is St. Statesville NC, 28677    40%    3/8/21    $10,000        $14,500    4/21/21
    1011 Rickert St. Statesville NC    28677    1011 Rickert St. Statesville NC, 28677        1011 Rickert St. Statesville NC, 28677    10%    3/18/21    $18,000        $24,000    4/22/21
    408 E Park Ave Gastonia NC    28054    408 E Park Ave Gastonia NC, 28054        408 E Park Ave Gastonia NC, 28054    100%    5/7/21    $100,000    $40,000    $200,000    1/27/22
    406 E. Sharpe St. Statesville NC    28677    406 E. Sharpe St. Statesville NC, 28677        406 E. Sharpe St. Statesville NC, 28677    100%    9/28/21    $40,000        $47,000    10/19/21
    35 & 36 Oak St. China Grove NC        35 & 36 Oak St. China Grove NC,         35 & 36 Oak St. China Grove NC,     100%    12/3/21    $150,000    $5,000    $198,000    1/27/22
    10935 Carmel Crossings Charlotte NC    28210    10935 Carmel Crossings Charlotte NC, 28210        10935 Carmel Crossings Charlotte NC, 28210    100%    1/18/22    $150,000        $160,000    1/27/22
    1233 Beave
ook Dr. Gastonia NC    28052    1233 Beave
ook Dr. Gastonia NC, 28052        1233 Beave
ook Dr. Gastonia NC, 28052    100%        $120,000    $34,000    $200,000    10/31/22
    110 6th St. SW Hickory NC        110 6th St. SW Hickory NC,         110 6th St. SW Hickory NC,     100%        $100,000
    321 New Haven Dr. Gastonia NC        321 New Haven Dr. Gastonia NC,         321 New Haven Dr. Gastonia NC,     50%        $60,000        $106,000    10/11/22
    1008 Clanton Rd. Charlotte NC    28217    1008 Clanton Rd. Charlotte NC, 28217        1008 Clanton Rd. Charlotte NC, 28217    100%        $250,000
    701 Johnston Dr. Pineville NC        701 Johnston Dr. Pineville NC,         701 Johnston Dr. Pineville NC,     100%        $105,000
Sheet2
                                2021    costo    down    Loan    Sale Date    Sale    G. Profit    Rehab     Fees    Net Profit
                                2402 Dryden Ln. Charlotte NC, 28210    $215,000            1/29/21    $290,000    $75,000    $40,000        $35,000
        BALANCE SHEET FOR 2021 TAX YEAR END                        1314 Ha
is 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 Account            working expenses    $31,000        408 E Park Ave Gastonia NC, 28054    $100,000    $20,000        1/27/22            $31,000    $8,000
                                414 E Park Ave Gastonia NC, 28054    $63,000                $70,000    $7,000            $7,000
        Assets            Private investor    $35,000        406 E. Sharpe St. Statesville NC, 28677    $40,000                $47,000    $7,000            $7,000
        Properties    $381,000                    35 & 36 Oak St. China Grove NC,     $150,000    $15,000        2/1/22    $198,000            $6,000
        Office Equipment    $5,000        Lender Loans    $215,000        10935 Carmel Crossings Charlotte NC, 28210    $0            1/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,000        pasivo + capital    $343,500
                        $42,500
                                2022    costo    down
        BALANCE SHEET FOR 2022 TAX YEAR END                            100000    10000
                                    250000
        Bank Account            working expenses                105000
                                    120000
        Assets            Lender Loans            1233 Beave
ook Dr. Gastonia NC, 28052    $120,000    $35,000    $200,000        10/31/22
        Properties    $ 575,000.00        Loan Interest            110 6th St. SW Hickory NC,     $100,000
        Office Equipment    $ 5,000.00                    321 New Haven Dr. Gastonia NC,     $60,000        $105,500        10/4/22
                    Capital            1008 Clanton Rd. Charlotte NC, 28217    $250,000
                                701 Johnston Dr. Pineville NC,     $105,000
                                408 E Park Ave Gastonia NC, 28054    $100,000    $20,000        1/27/22    $205,000    $105,000    $40,000    $25,000    $40,000
                                35 & 36 Oak St. China Grove NC,     $150,000    $15,000        2/1/22    $198,000    $48,000    $5,000    $13,000    $30,000
                                10935 Carmel Crossings Charlotte NC, 28210    $150,000            1/27/22    $160,000    $10,000            $10,000
Cashflow
    Cash Flow Statement
    Fiscal year begins:
Sheet1
        Zip        Address    % Ownrshp    Purchase Date    Purchase Price    Rehab $    Sale Price    Dispstion Date
    2402 Dryden Ln. Charlotte NC    28210    2402 Dryden Ln. Charlotte NC, 28210    2402 Dryden Ln. Charlotte NC, 28210    100%    12/14/17    $215,000.00    $40,000.00    $290,000.00    1/29/21
    7535 Fallow Ln. Charlotte NC    28273    7535 Fallow Ln. Charlotte NC, 28273    7535 Fallow Ln. Charlotte NC, 28273    100%    7/1/10    $81,900.00    $25,000.00    $127,500.00    2/17/17
    109 Kern Ct. & 102 Mintzfield Dr. Lawndale NC    28090    109 Kern Ct. & 102 Mintzfield Dr. Lawndale NC, 28090    109 Kern Ct. & 102 Mintzfield Dr. Lawndale NC, 28090    80%    7/10/20    $40,000.00        $45,000.00    10/2/20
    131 8th Ave. NE Hickory NC    28601    131 8th Ave. NE Hickory NC, 28601    131 8th Ave. NE Hickory NC, 28601    80%    12/24/20    $55,000.00        $85,000.00    1/20/21
    4114 Malta Pl. Charlotte NC    28215    4114 Malta Pl. Charlotte NC, 28215    4114 Malta Pl. Charlotte NC, 28215    40%    11/27/20    $165,000.00        $175,000.00    1/21/21
    1314 Ha
is St. Statesville NC    28677    1314 Ha
is St. Statesville NC, 28677    1314 Ha
is St. Statesville NC, 28677    40%    3/8/21    $10,000.00        $14,500.00    4/21/21
    1011 Rickert St. Statesville NC    28677    1011 Rickert St. Statesville NC, 28677    1011 Rickert St. Statesville NC, 28677    10%    3/18/21    $18,000.00        $24,000.00    4/22/21
    408 E Park Ave Gastonia NC    28054    408 E Park Ave Gastonia NC, 28054    408 E Park Ave Gastonia NC, 28054    100%    5/7/21    $100,000.00    $40,000.00    $200,000.00    1/27/22
    406 E. Sharpe St. Statesville NC    28677    406 E. Sharpe St. Statesville NC, 28677    406 E. Sharpe St. Statesville NC, 28677    100%    9/28/21    $40,000.00        $47,000.00    10/19/21
    35 & 36 Oak St. China Grove NC        35 & 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.00    1/27/22
    10935 Carmel Crossings Charlotte NC    28210    10935 Carmel Crossings Charlotte NC, 28210    10935 Carmel Crossings Charlotte NC, 28210    100%        $150,000.00        $160,000.00    1/27/22
    1233 Beave
ook Dr. Gastonia NC    28052    1233 Beave
ook Dr. Gastonia NC, 28052    1233 Beave
ook Dr. Gastonia NC, 28052    100%        $120,000.00    $34,000.00    $200,000.00    10/31/22
    110 6th St. SW Hickory NC        110 6th St. SW Hickory NC,     110 6th St. SW Hickory NC,     100%        $100,000.00
    321 New Haven Dr. Gastonia NC        321 New Haven Dr. Gastonia NC,     321 New Haven Dr. Gastonia NC,     50%        $60,000.00        $106,000.00    10/11/22
    1008 Clanton Rd. Charlotte NC    28217    1008 Clanton Rd. Charlotte NC, 28217    1008 Clanton Rd. Charlotte NC, 28217    100%        $250,000.00
    701 Johnston Dr. Pineville NC        701 Johnston Dr. Pineville NC,     701 Johnston Dr. Pineville NC,     100%        $105,000.00
mktsegpie
    $40
    $320
    $35
    $10
    $10
    Residential Community    60
    Commercial    10
    Rental    30
Marketing Segments of Properties
Residential Community    Commercial    Rental    60    10    30    
Sheet1 (2)
    Street Address    City    ST    Zip    % Ownrshp    Purchase Date    Price$K    Rehb $K    Sale $K    Dispstion Date
    2402 Dryden Ln.    Charlotte    NC    28210    100%    12/14/17    215    40    290    1/29/21
    7535 Fallow Ln.    Charlotte    NC    28273    100%    7/1/10    81.9    25    127.5    2/17/17
    109 Kern Ct. & 102 Mintzfield Dr.    Lawndale    NC    28090    80%    7/10/20    40    0    45    10/2/20
    131 8th Ave. NE    Hickory    NC    28601    80%    12/24/20    55    0    85    1/20/21
    4114 Malta Pl.    Charlotte    NC    28215    40%    11/27/20    165    0    175    1/21/21
    1314 Ha
is St.    Statesville    NC    28677    40%    3/8/21    10    0    14.5    4/21/21
    1011 Rickert St.    Statesville    NC    28677    10%    3/18/21    18    0    24    4/22/21
    408 E Park Ave    Gastonia    NC    28054    100%    5/7/21    100    40    200    1/27/22
    406 E. Sharpe St.    Statesville    NC    28677    100%    9/28/21    40    0    47    10/19/21
    35 & 36 Oak St.    China Grove    NC        100%    12/3/21    150    5    198    1/27/22
    10935 Carmel Crossings    Charlotte    NC    28210    100%        150    0    160    1/27/22
    1233 Beave
ook Dr.    Gastonia    NC    28052    100%        120    34    200    10/31/22
    110 6th St. SW    Hickory    NC        100%        100    0    0
    321 New Haven Dr.    Gastonia    NC        50%        60    0    106    10/11/22
    1008 Clanton Rd.    Charlotte    NC    28217    100%        250    0    0
    701 Johnston Dr.    Pineville    NC        100%        105    0    0

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    $816,000        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,073,600        pasivo + capital    $1,166,500
                        ($92,900)
        BALANCE SHEET FOR
Answered Same Day Oct 30, 2022

Solution

Rochak answered on Oct 30 2022
58 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