Cygnet Tennis Club
In this exercise, your task is to work out the costs and benefits of two competing business capital expenditure proposals and determine which proposal would lead to better business performance. The term capital expenditure means that the expenditure goes on assets and will have a lasting value on producing income for the business.
This budgeting exercise will involve using online loan repayment calculators to calculate the required monthly/yearly loan repayments that would be necessary for a certain level of borrowing. There are many such loan repayment calculators available on the Internet. You might try the loan repayment calculator from the St.George bank.
The task of working out which proposal is best has been made easier for you as a template is provided. The template will show how you one way to set out the problem so that it is easy to read and understand.
The time required to complete these exercise using the template is 15 minutes or less depending on the Excel skills of the learner.