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

Calculate future value, Your grandparents put $1,000 into a saving account ...

Your grandparents put $1,000 into a saving account for you when you were born 30 years ago. This account has been earning interest at a compound rate of 7%. What is its value today

What are the advantages of placement, What are the Advantages of placement ...

What are the Advantages of placement Placement has the below benefits: (i) Timing of issue is significant for successful floatation of shares. In a depressed market cond

Find the no-arbitrage cost of the european call option, Question: Suppo...

Question: Suppose that a security is presently selling for a price of $65, the nominal interest rate is 8%, and the security volatility is 0.15. a) Determine Delta of a Euro

Dow theory - stock exchange, Dow Theory - Stock Exchange This theory d...

Dow Theory - Stock Exchange This theory depends upon profiting of prices of a chart of secondary movement. The principal objective is to discover whilst there is a change in t

Management of company and directors, Management of company and Directors ...

Management of company and Directors They will consequently be interest in as: a) In generating profits efficiency of the company b) The company's capability to generate

Example of npv method, Example of NPV Method Resolution limited inte...

Example of NPV Method Resolution limited intends to purchase a machine worth Shs.1, 500,000 that will have a residue value Shs.200,000 after 5 years helpful life. The saving

How is finance related to the accounting and economics, How is finance rela...

How is finance related to the disciplines of accounting and economics? Financial management is necessarily a combination of economics and accounting. First, financial managers

Valuation of business, Valuation of Business A business may be valued ...

Valuation of Business A business may be valued for different type of reasons that as for merger, acquisition, or takeover or liquidation or outright sale.  During purchasing a

Bird-in-hand theory, Bird-in-hand Theory Advanced via John Leitner in ...

Bird-in-hand Theory Advanced via John Leitner in year 1962 and furthered with Myron Gordon in year 1963. Argues such shareholders are risk averse and prefer specific. Dividend

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