Week 5 Project Activity: Pro Forma Income Statement and Balance Sheet (Draft) Use the Budget Proposal Workbook.xlsx and Budget Proposal Template.docx to develop pro forma income statements and balance...

Sheet1
    The cutting edge- Landscaping
    C.E.B. Capital Expendiure Budget
    Item Description    Qty    Cost    Total cost     Salvage Value    Depr Base    Useful lifeYrs    Depr Exp
     pickup truck    2    25000    50000    20000    30000    10    3000
     trailer    2    1500    3000    1500    1500    10    150
     large riding lawnmower    2    2500    5000    2500    2500    5    500
    small riding lawnmower    2    1500    3000    1500    1500    5    150
    A push lawn-mower    2    250    500    300    200    5    40
     gas-powered lawn-trimmers     2    200    400    200    200    5    40
     gas-powered lawn edgers    2    200    400    200    200    5    40
     eyes and ear protection    40    100    100    75    25    5    5
    Tools for minor equipment repair     2    200    400    200    200    5    40
     drink cooler    2    25    50    30    20    5    4
    gas powered blowers     2    100    200    100    100    5    20
    tree/hedge trimmers    2    200    400    200    200    5    40
    long ladder    2    300    600    200    400    5    80
    Buck Saws for cutting
anches    2    20    40    20    20    5    4
    desk    1    400    400    200    200    10    40
    computer    1    1000    1000    600    400    5    80
    copie
fax/printer    1    300    300    200    100    5    20
    chairs    10    100    1000    800    200    5    40
                66790    28825    37965        4293
Income statement
        Particulars    1st year    2nd year    3rd year    4th year    5th yea
        Sales revenue    $ 150,000    $ 170,000    $ 180,000    $ 199,000    $ 275,000
         Total revenue    $ 150,000    $ 170,000    $ 180,000    $ 199,000    $ 275,000
        Less: Expenses
        Depreciation expense - Tools for minor equipment repair     $ 40    $ 40    $ 40    $ 40    $ 40
        Depreciation expense - A push lawn-mower    $ 40    $ 40    $ 40    $ 40    $ 40
        Depreciation expense - Gas-powered lawn-trimmers     $ 40    $ 40    $ 40    $ 40    $ 40
        Depreciation expense - Gas-powered lawn edgers    $ 40    $ 40    $ 40    $ 40    $ 40
         Depreciation expense - Eyes and ear protection    $ 5    $ 5    $ 5    $ 5    $ 5
        Depreciation expense - Small riding lawnmower    $ 300    $ 300    $ 300    $ 300    $ 300
        Depreciation expense - Gas powered blowers     $ 20    $ 20    $ 20    $ 20    $ 20
        Depreciation expense - Pickup truck    $ 3,000    $ 3,000    $ 3,000    $ 3,000    $ 3,000
        Depreciation expense - Trailer         $ 150    $ 150    $ 150    $ 150
        Depreciation expense - ...