Capital Budget Exercise

student
Learning Goal: I’m working on a public service exercise and need an explanation and answer to help me learn.

Directions: In this exercise, your task is to work out the costs and benefits of two competing capital expenditure proposals and determine which proposal would lead to better business performance. The term capital expenditure will have a lasting value on producing income for the tennis club.

Budgeting Exercise

Evaluating Capital Expenditure Proposals

City of Cliffsville Tennis Club

Your Task

In this exercise, your task is to work out the costs and benefits of two competing capital expenditure proposals and determine which proposal would lead to better business performance. The term capital expenditure will have a lasting value on producing income for the tennis club.

This 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.

To use a loan repayment calculator you will need to enter:
The amount to be borrowed (the Principal)
The interest rate
The term of the loan (the number of months in duration)
The payment frequency, for this exercise use monthly

The task of working out which proposal is best has been made easier for you as I have provided an Excel template for you to use. The template will show you one way to set out the problem so that it is easy to read and understand.

The Scenario

A tennis center in southern Cliffsville has four grass courts. The Budget and Finance committee is considering two proposals for improving facilities. Both proposals will have some benefit on the long-term revenue of the club.

Proposal A

The four grass courts will be resurfaced as hard courts. This is estimated to increase court usage by 800 court hours per year. The capital cost will be $80,000.

Proposal B

The four grass courts will be covered with an airdome. It will be the only tennis facility with an airdome in Cliffsville. It is estimated that there will be an increase in court usage of 1,000 court hours per year. The capital cost of this project is $100,000.

Please note that for both options the cost of operating the courts will be the same.

Other details

The income raised per court hour while in use is estimated at $25.00 per hour.

The club will need to take a five-year loan from the bank in either case to raise the capital at 9% interest per annum.

Search for a loan repayments calculator on the Internet to assist you with this problem.
ATTACHMENTS
attachment_1
attachment_2