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

Describe briefly the term measures of variability, Question: (a) (i)...

Question: (a) (i) Define the term multicollinearity. (ii) Explain why it is important to guard against multicollinearity. (b) (i) Sometimes we encounter missing value

Example of baumol's model, Example of Baumol's Model ABC Ltd. creates ...

Example of Baumol's Model ABC Ltd. creates cash payments of Shs.10, 000 per week.  The interest rate at marketable securities is 12 percent and every moment the company sells

Return on equity, Maghrabi Enclosure follows a moderate current asset inves...

Maghrabi Enclosure follows a moderate current asset investment policy, but it is considering whether to shift to a different strategy. The firm''s annual sales are $500,000; its f

Bureaucratic system of management, "Managerial leadership considers that th...

"Managerial leadership considers that the focus of school leaders ought to be on functions, tasks and behaviours and if these functions are carried out competently the work of othe

Find out operating leverage, (i) Find out operating leverage from the follo...

(i) Find out operating leverage from the following data: Sales                             Rs.50000 Variable Cost               60% Fixed Cost                   Rs.12000

Accounts payable turnover ratio, Accounts Payable Turnover Ratio Ratio...

Accounts Payable Turnover Ratio Ratio for Account Payable Turnover is as Follow: Creditors/accounts payable turnover = Annual credit purchases /Average creditors

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

Stock exchange market, Stock Exchange Market The Idea and improvemen...

Stock Exchange Market The Idea and improvement of a Stock Exchange Stock exchange also identified as stock markets are special "market places" whereas already held bond

Trading mechanism, Trading Mechanism 1. An investor approaches broker...

Trading Mechanism 1. An investor approaches brokers who obtain his bid or prefer to the trading floor. 2. At the trading floor, the selling and buying brokers meet and sea

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