Detailed Notes on Net Present Value and Financial Calculations for Premium Booking System
Chapter 1: Introduction to Net Present Value (NPV)
The video begins with an introduction to a key component of the coursework: the calculation of Net Present Value (NPV) associated with the new premium booking system. It outlines sales revenues projected over five years, starting at £8,800 and increasing through subsequent years. Specific cash flow details, including working capital requirements, expenses, and a corporate tax rate of 25%, are highlighted. The tax depreciation rate of 25% will be critical to tax calculations. Cash flows are to be recognized at the end of each accounting period, which means that the tax implication of profits will manifest in the following year. Consequently, cash flows will span six years instead of five, as taxes for each year will be paid in the subsequent year.
Chapter 2: Revenue Projections
The revenue projections assume a 5% annual increase each year. Consequently, the projected revenue for the first year starts at £8,800, which will increase to £9,240 in the second year, calculated as:
.
The calculations follow similarly for the following years with revenues raised progressively to the power reflecting the year (e.g., for year three, the calculation would be £12,200 multiplied by 1.05 raised to the power of two).
Chapter 3: Cost Adjustments
Costs for components A and B are expected to rise by 4% annually, reflecting inflation. For example, the initial cost of component A is £1,300, hence it will increase as follows:
where k is the year index. It is essential to maintain negative signs for costs. Component costs and overheads should also adhere to these inflation rates as outlined.
Chapter 4: Software Technician Costs
The cost for one software technician is £1.20 per hour, with an expected workload of 1,100 hours. While hourly rates will increase by 4% each year, the total hours worked are projected to decline by 2% annually. Therefore, the calculation for year one expenses is:
Following years will see increases based on these adjustments.
Chapter 5: Working Capital Calculations
The video discusses the cumulative nature of working capital. In year one, the working capital is set at -£2,000, and subsequent adjustments are noted across the years. Movements within the working capital (inflows/outflows) are fundamental, where increases in working capital signify cash inflows. For example, if it moves from -£1,800 to -£2,400, it represents a cash outflow of £600 which is calculated as follows:
Funds recouped at the end of year five total £1,600.
Chapter 6: Capital Allowance Calculations
Capital allowances are introduced, focusing on depreciation for assets over time. Excalibur PS is set a 25% reducing balance method on a £30,000 asset cost. The calculation for depreciation in the first year allows for a claim of:
In subsequent years, 75% of the previous year's claim must be tracked to ensure accurate depreciation. Final claims are to be checked against total assets to ensure correctness before exiting year five.
Chapter 7: Taxation and Non-Cash Items
Understanding the treatment of capital allowances for taxation is crucial. Capital allowances are significant only for tax calculations, and once tax is computed, these allowances should not be added back into cash flow calculations. The corporate tax rate at 26% is applied to taxable income following all deductions including those for capital allowances.
Chapter 8: Conclusion and Guidance
The instructor concludes by emphasizing the complexities and critical areas of focus for successful coursework completion. Students are encouraged to reach out for additional support if needed and to ensure all calculations align with the stipulated methodologies for accuracy. Good luck is wished for the submission process, continuing to foster a learning environment.