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

Advantages of bonus matter, Advantages of Bonus Matter a) Tax advanta...

Advantages of Bonus Matter a) Tax advantages         Shareholders can sell new shares, and create cash in form of capital gains such is tax exempt unlike cash dividends wh

Valuation of bonds and debentures, Valuation of Bonds and Debentures I...

Valuation of Bonds and Debentures It will depend on expected cash flows consisting of annual interest in additional the principal amount to be obtained at maturity.  The suita

Prepare a schedule of working capital and statement, The Balance Sheet of B...

The Balance Sheet of Bharat Machinery Ltd., as on December 31, 2009 and 2010 are as follows:  Items Dec. 31, 2009 Rs. Dec. 31, 2010 Rs.

Time value of money, One of the projects the US loan would fund is to build...

One of the projects the US loan would fund is to build earthquake-resistant buildings. The project will begin in March 2013, last for two years and is expected to have the followin

Cost of finance - capital structure, Cost of Finance - Capital Structure ...

Cost of Finance - Capital Structure This is the price the company pays to retail and acquire finance. To get finance a company will pay implicit costs that are commonly recogn

Draw a bar chart, The construction of a highway is broken into 14 activitie...

The construction of a highway is broken into 14 activities as shown in the following table. Draw a bar chart of this construction project. Activity ID Desc

Find the policy value after the policy is issued, Question 1: Consider ...

Question 1: Consider a 5-year $10,000 endowment assurance issued to a select life aged 30 under the following bonus schemes:- (a) Simple reversionary bonuses of 5% p.a., 6%i

Calculate the price of a non-zero coupon bond, Question: A non-zero cou...

Question: A non-zero coupon bond carries a coupon rate of 8 percent and has 9 years until maturity. It sells at a yield to maturity of 6 percent. The par value of the bond is

Restrictive bond or debt covenant, Restrictive Bond or Debt Covenant I...

Restrictive Bond or Debt Covenant In this case the debenture holders will impose strict conditions and terms on the borrower. These restrictions may comprise: a) No disposal

What is the role of a broker in security transactions, What is the role of ...

What is the role of a broker in security transactions? How are brokers compensated? Ans: Brokers handle orders to sell or buy securities. Brokers are agents who work in place o

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