Determine the approximate payback period, Finance Basics

Assignment Help:

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?

 


Related Discussions:- Determine the approximate payback period

Different risk-profile - shareholders and management, Different Risk-profil...

Different Risk-profile - Shareholders and Management Shareholders will generally prefer high-risk-high return investments while they are diversified that is they have many inv

Market model - methods of computing cost of capital, Market Model - Methods...

Market Model - Methods of Computing Cost of Capital This model is utilized to establish the percentage cost of ordinary share capital cost of equity (K e ). If an investor is

Finance.., the nominal fee interest rate in your account is 7% your semi-an...

the nominal fee interest rate in your account is 7% your semi-annually rate of interest APY will be?

Financial Institution Regulations, Why are financial institutions heavily r...

Why are financial institutions heavily regulated, with specific focus on their ability to increase or reduce the money supply?

Debentures and bonds, how can debentures be explained in class in term of g...

how can debentures be explained in class in term of game, role play etc....?

Example of theoretical value, Example of Theoretical Value As a result...

Example of Theoretical Value As a result of the purchase of an asset, the income stream will rise by of £1,000 per annum for 25 years.  By assuming a discount rate of 20 perce

Existence of quantity discounts, Existence of Quantity Discounts Recur...

Existence of Quantity Discounts Recurrently, the firm is capable to take benefits of quantity discounts.  Since these discounts affect the price per unit, they influence also

Captive insurance, discuss the meaning and advantage of captive insurance

discuss the meaning and advantage of captive insurance

Inevestments, 1) What happens to the portfolio standard deviations as the i...

1) What happens to the portfolio standard deviations as the investor substitutes the foreign securities for the U.S securities? What combination of U.S and Japanese stock minimizes

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd