Determine the approximate payback period, Finance Basics

The business plan for a new company that has obtained a 5 year lease for operating a local bus service is shown below.  Items marked with an asterisk represent continuous cash flows, however it can be assumed that they are made monthly in arrears.

Cashflow Item

Timing

Amount (thousands)

 

 

 

Initial set up costs

Immediate

-150

Fees from advertising contracts

1 month

+200

Purchase of vehicles

3 months

-2,000

Fares from passengers*

From 3 months onwards

+1,200 pa

Staff costs and other operating costs*

From 3 months onwards

-480 pa

Resale value of assets

5 years

+575

You may assume that the project is financed by a loan facility based on an effective annual interest rate of 9% per annum, and interest (and any repayments of capital) is due and paid annually in arrears.

The company has a choice of paying only the interest on the loan or can repay some the loan with the interest payments. Please give a reason for your choice of interest only or with loan repayments.

Any surplus funds that the company has each year, in excess of the interest due on the loan can be invested and earns interest at the rate of 5% per annum payable half yearly.

(a) Set up a spreadsheet using Excel showing all cash flows for the term of the lease. You may want to show cash flow from the business and interest (and loan repayments separately.

(b) What is the approximate payback period?

 

Posted Date: 2/23/2013 7:37:33 AM | Location : United States







Related Discussions:- Determine the approximate payback period, Assignment Help, Ask Question on Determine the approximate payback period, Get Answer, Expert's Help, Determine the approximate payback period Discussions

Write discussion on Determine the approximate payback period
Your posts are moderated
Related Questions
Mortgages - Financial Institutions An arrangement of the property being purchased provides the security for funding. Other assets may be employed like security for funding o

what is the price of the share net sales Rs.120lakhs net profit margin 12.5% no. of equity shares 25,000 cost of equity shares 12% retention ratio 40% rate of interest(ROI) 16%

Creditors Payment Period Ratio Creditors payment period =   365/ Creditors turnover                                           = (365 x Average creditors)/Annual credit pu

Following details are related to three companies which are identical except in terms of ''''r''''. Company ABC Ltd. MNC Ltd. XYZ Ltd. Cost of capital 10% 10% 10% Earn per Share Rs

Using the data provided in Appendix 1 prepare an analysis for the attention of the directors of Meridian Ltd. The analysis should highlight the strategic differences between the co

Define and explain the credit multplier


XYZ is considering a capital restructuring to allow $300 million in debt. Currently, XYZ is an all-equity firm with earnings before interest and taxes of $260 million. Assume unlev

Present Value of an Annuity - DCF Technique An individual investor may not necessarily acquire a lump sum after several years however rather obtain a constant periodic amount

Question 1: (a) What do you meant by the term ‘Life Insurance Contract'? (b) Many people prefer to choose Single life policies compared to Joint life policies. Why is t