Work book

MARKING GRID
        Marking Grid
        Part 1 Calculations    Maximum Marks    Marks Achieved
        1. Vertical Analysis Balance Sheet Worksheet    8    ERROR:#REF!
        2. Vertical Analysis Income Statement Worksheet    10    ERROR:#REF!
        3. Ratio Analysis Worksheet    14    ERROR:#REF!
        Part 2 Business Report
        4. Income Statement Comparative Analysis    20    0.00
        5. Ratio analysis comments    20    0.00
        6. Industry Specific Performance Indicators    9    0.00
        Overall Strucure and appearance of the Business Report    4    0.00
        Total Marks    85    ERROR:#REF!
    Note    For all Excel marks, you just need to choose Yes or No from the dropdown list next to the values to be calculated.
        When you choose Yes, the system will automatically allocate appropriate marks and it is linked to this Marking Sheet so no manual calculation is needed
        Please note that student files have the marking sheet hidden together with marking columns
        You just need to unhide them and can mark the assessment straight in their file
Gym Equipment Financing
        BUY OPTION                RENT OPTION
        Cost    Discounted Residual Value    Servicing    Total Cost over 3 years    Discounted Value
Year 1    Discounted Value
Year 2    Discounted Value
Year 3    Total Cost over 3 years
    Treadmill (4 pieces)    $24,228    $3,955    $727    $20,999    $7,880    $8,101    $8,328    $24,309
    Elliptical Trainer (3 pieces)    $12,117    $1,978    $364    $10,502    $3,030    $3,115    $3,202    $9,347
    Exercise Bike (5 pieces)    $16,660    $2,720    $500    $14,440    $4,520    $4,647    $4,777    $13,944
    Rowing Machine (2 piece)    $5,452    $890    $164    $4,725    $1,676    $1,723    $1,771    $5,170
    Total...