I am stuck into this case:
I would like to make an opening balance sheet but having some problems .
Here's the case :
Mr. Brentjens is starting a business renting mountain bikes to tourists. After having prepared his business plan it becomes clear that he will need a minimum amount of 500 bikes with a total initial investment value of 400,000 at the projected opening date of 1 January 2008. Furthermore he thinks to need 50,000 for cash balances.
For financing the above mentioned assets Mr. Brentjens will take 150,000 of his savings account being the owners capital investment. The remaining financial needs will be long term borrowed from a local bank at 6% interest rate per annum. The bikes will be rented for one week. For the expected operating year of 2008 the following details are given:
all bikes have been rent during 52 weeks, the rent rate per bike was 6.25 per week and rent was paid at the beginning of each week by the clients.
all bikes are depreciated using the straight line method, within three years. Because Mr. Brentjens expects his clients not to treat the bikes very well, he considers the residual value to be zero at the end of the period.
all interest payments due for 2008 has been paid as per 31/12/2008. No principal payments on the loans have been made.
in 2008 the following costs were incurred and paid for:
maintenance costs bikes 1,000 / month
rent of the garage 1,000 / month
energy costs 800 / year
other costs 5,200 / year
to further expand his operations Mr. Brentjens has decided to invest another 10,000 in his business on 30 December 2008.
profit tax rate is 29 %.
all payments in cash.
dividend payments of 4,555.
QUESTIONS: