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

Working capital cycle, Working Capital Cycle The Concept of Working C...

Working Capital Cycle The Concept of Working Capital/Cash Operating Cycle Working capital cycle refers to period such elapses between the payment for raw materials bought

Management of account receivable, Management of Account Receivable In ...

Management of Account Receivable In order to keep current customers and attract new ones, most firms find it necessary to offer credit. Accounts receivable represents the exte

Differences between qualitative and quantitative research, Problem: (a)...

Problem: (a) Describe why a critical analysis of the following is important while reading a research article: (i) The author, (ii) The date of publication. (b) What do

Explain the term - giving margin money to broker, Explain the Giving Margi...

Explain the Giving Margin Money to Broker Marin  is  the  amount  of  money  which is provided  by customer to the brokers who have agreed to trade their securities. It may

Project apparisal, challenges your likely to face when apparising a project...

challenges your likely to face when apparising a project on the implemtation stage

What are the factors influencing selection of investment, Investment  Attri...

Investment  Attributes/  Factors  Influencing  Selection  of  Investment In  choosing specific  investments,  investors  would require definite  ideas  regarding  features

Central bank - banking institutions, Central Bank - Banking Institutions ...

Central Bank - Banking Institutions This is a bank which is entrusted along with the responsibility of keeping economic stability and financial soundness of a country.  Theref

Define the term placement - methods of floating new issues, Define the term...

Define the term Placement - Methods of Floating New Issues Under this method, issue houses or brokers purchase the securities outright with the intention of placing them wi

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