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
Sources of Funds - Finance Venture capital, with combining risk financing along with marketing assistance and management, could become an effective instrument in fostering dev

Functions of Central Depository System or CDS 1. Immobilization of securities that is removal of physical movement of securities. 2. Dematerialization that is removal of ph

Risk-Return Trade-Off Most financial decisions comprise alternative courses of action. The choices have different returns and risk.  As like example, must we buy a replacement

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 flow

Development of Lease Finance in Middle Asia Reasons Why Lease Finance Is Not Well Developed In Middle Asia 1. Lease charges are generally prohibitive that is the cost

Competitors and General Public - Measuring Business Performance Competitors These are interested in the company's presentation from the market share point of view and wi

If you inherited $ 45,000 today and invested all of it in a security that paid a 7 percent rate of return, how much would you have in 25 years?

What financial report exactly do? Financial reports tell its intended readers about all the financial information of the company for the period it is reporting. It also contain

Investment  Attributes/  Factors  Influencing  Selection  of  Investment In  choosing specific  investments,  investors  would require definite  ideas  regarding  features

What are the financial intermediaries? Financial Intermediaries: a. Mutual funds b. Pension funds c. Life insurance companies d. Banks