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

Profit maximization - objectives of business entity, Profit maximization - ...

Profit maximization - Objectives of Business Entity Conventionally, this was considered to be the main goal of the firm. Profit maximization refers to getting the highest poss

capm model is not suitable in an international setting, Why do several cri...

Why do several critics say the CAPM model is not suitable in an international setting? Please describe a way that the CAPM model could be adapted for international applications.

Binomial and continuous model - mathematics of finance, Consider a binomial...

Consider a binomial model of a risky asset with the parameters r = 0:06, u = 0:059, d = 0:0562, S 0 = 100, T = 1, 4t = 1=12. Note that u and d are monthly effective rates of retur

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

Determinants of working capital needs, Determinants of Working Capital Need...

Determinants of Working Capital Needs There are few factors that determine the firm's working capital needs. These factors are comprehensively enclosed with a Textbook of Busi

Interest rates, why borrow from a country with a high interest rate instead...

why borrow from a country with a high interest rate instead of a country with a low interest rate

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

Unadjusted, $1,000 of insurance had not been used up by January 31. $325 of...

$1,000 of insurance had not been used up by January 31. $325 of insurance had been used up in January

The new cash flows., Tank Industries Washers decides to pay the following d...

Tank Industries Washers decides to pay the following dividends over the next four years: $2.50, $3.20, $4.75 and $5.20 respectively (starting at time 1). a.    After year 4, the

Determine the classification of new issue market, Classification of New Iss...

Classification of New Issue Market New market can be classified as: (i) A market where firms go to public for the first time through initial public offering (IPO). (ii

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