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
1.) Assume a $1000 face value bond has a coupon rate of 8.5 percent, pays interest semi-annually, and has an eight-year life. If investors are willing to accept a 10.25 percent rat

(a) State the most appropriate drivers for the following direct expenses: (i) New business administration department's salary costs (ii) Medical examinations for temporary life

Stock Exchange Index or SEI Stock Exchange Index is a measure of relative changes in prices of stocks from one duration to another index. Nairobi Stock Exchange twenty (20) -

Last year Nymphe Technologies had $450 million of sales and $270 million of fixed assets, so its FA/Sales ratio was 60%.  However, its fixed assets were used at only 75% of capacit

Acceptance Rule of Payback Period or PBP By using PBP method a company such will accept all those ventures whose payback period is less than to set via the management and will

Advantage and Disadvantage of Sole Proprietorship Advantage of Sole Proprietorship High supervision of employees Income motivate owner Sole trade mostly ski


Discuss business taxes and their importance in financial decisions

You are asked to select three variables for a sensitivity analysis of weighted average cost of capital, what would you choose and why? Weighted average cost of capital is th