Managerial Finance
Sullah-bcu
QUESTION2.xlsxSheet1
| NET PRESENT VALUES | |||||||||
| YEAR 0 | YEAR 1 | YEAR 2 | YEAR3 | TOTAL | |||||
| £ | £ | £ | £ | £ | |||||
| INVERSTMENT | |||||||||
| LAND | 5000 | 5000 | |||||||
| BUILDING AND FITTING | 9480 | 9480 | |||||||
| FITTINGS AND EQUIPMENTS | 2196 | 2196 | |||||||
| CASH INFLOWS | |||||||||
| SALES revenue | 34320 | 35006 | 35707 | 105033 | |||||
| CASH OUTFLOW | |||||||||
| COST OF X | 8004 | 8164 | 8327 | 24495 | |||||
| COST OF Y | 5660 | 5773 | 5889 | 17322 | |||||
| STAFF COST | 1416 | 1444 | 1473 | 4334 | |||||
| LIGHT AND HEAT | 2011 | 2051 | 2002 | 6154 | |||||
| OTHER OVERHEADS | 7708 | 7862 | 8019 | 23590 | |||||
| NET INFLOW/OUTFLOW | 16676 | 9521 | 9711 | 9906 | 12462 | IRR | |||
| DISCOUNT FACTOR | 33.80% | 0.747 | 0.559 | 0.417 | 33.80% | ||||
| NET PRESENT VALUES | 16676 | 7116 | 5425 | 4135 | 0 |
Sheet2
| DISCOUNTED PAYBACK PERIOD | ||||
| £ | £ | |||
| YEAR 0 | 16,676 | |||
| YEAR 1 | 8501 | 8175 | ||
| YEAR 2 | 7742 | 433 | ||
| YEAR 3 | 7051 | 6617 | ||
| TOTAL | ||||
| YEARS | MONTHS | |||
| DISCOUNTED PBP | 2 | 1 |
