Case study (Group)
Kylin
BIZ201Assessment4StudentWorkbook20190710.xlsxMARKING 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) | ||||||||
| Elliptical Trainer (3 pieces) | ||||||||
| Exercise Bike (5 pieces) | ||||||||
| Rowing Machine (2 piece) | ||||||||
| Total Cost | ||||||||
Membership Project
| Membership (Basic $40/month, Full Package $81/month) | |||||||
| Membership Project | Cash Ouflow | Cash Inflow | Net Cash Flow | Tax | After Tax CF | PV Factor | NPV |
| Year 0 | |||||||
| Year 1 | |||||||
| Year 2 | |||||||
| Year 3 | |||||||
| NPV | |||||||
Promotional Budget
| Promotional Budget | |||||
| Item | Price (excluding GST) | GST | Price (including GST) | Quanity Required | Total Budgeted Value |
| TOTAL | |||||
CVP (Marketing)
| CVP ANALYSIS | |
| CM | |
| CMR | |
| Break-even (units) | |
| Break-even ($) | |
| Number of services required to earn a target net profit of $150,000 |
Plant Financing
| BUY OPTION | RENT OPTION | ||||||||
| Cost Year 0 | Discounted Servicing Year 1 | Discounted Servicing Year 2 | Discounted Servicing Year 3 | Total Cost over 3 years | Discounted Value Year 1 | Discounted Value Year 2 | Discounted Value Year 3 | Total Cost over 3 years | |
| Zamioculcas Zamiifolia (20 pieces) | N/A | N/A | N/A | ||||||
| Raphis Excelsa (10 pieces) | N/A | N/A | N/A | ||||||
| Howea Forsteriana (10 pieces) | N/A | N/A | N/A | ||||||
| Chamaedorea Elegans (30 pieces) | N/A | N/A | N/A | ||||||
| Gardener | |||||||||
| TOTAL | |||||||||
Software Project
| Licence | Subscription | |||||
| Membership | Cash Ouflow | PV Factor | PV of Cash outflows | Cash Ouflow | PV Factor | PV of Cash outflows |
| Year 0 | ||||||
| Year 1 | ||||||
| Year 2 | ||||||
| Year 3 | ||||||
| TOTAL | ||||||
Venue Costing
| Promotional Budget | |||||
| Item | Price (excluding GST) | GST | Price (including GST) | Quanity Required | Total Budgeted Value |
| TOTAL | |||||
CVP (Events)
| CVP ANALYSIS | |
| CM | |
| CMR | |
| Break-even (units) | |
| Break-even ($) | |
| Number of services required to earn a target net profit of $65,000 | |
