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
how can I get?

bond issued $900,000 of 8% on 3/1, they pay interest on 9/1 and mature in 10years case a @ 100, case b @ 92, case c @ 105 wha is total cash outflow thru maturity total borrowing co

Ask question #Minimum what are the challenges that a finance manager may face?

Setting of Optimal Cash Balance Cash is often identified like a non-earning asset since holding cash quite than a revenue-generating asset includes a cost in form of foregone

Compare the three investments below in terms of their riskiness. What is the best way to evaluate the riskiness of an investment given the information you have on them?

Analysis of the bond issue (a) Show that the price of the bond is equal to that of a portfolio which contains i) a long position in an option-free but otherwise identical co

I need a report on Specific Cost. Can you please assist me for Specific Cost report for about 2500 words?

Given the following Present Value Plot for Projects A and B, which are mutually exclusive projects, answer the following questions: (i) What is the DCFROR for Project A? fo

Investment Bank A lending entity is engaged in all the phases of privacy offerings the including managing, underwriting, trading, and the distributing new security issues.

The operating income of H Ltd amounts to Rs. 186000. It pays 35% tax on its income. Its capital structure consists of the following: 14% Debentures