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

Accounting, The Morris Corporation has $ 600,000 of debt outstanding, and i...

The Morris Corporation has $ 600,000 of debt outstanding, and it pays an interest rate of 8% annually. Morris’s annual sales are $# million, its average tax rate is 40% and its net

Calculate total number of ordinary shares, Calculate total number of ordina...

Calculate total number of ordinary shares Example Company XYZ Ltd has sold 10,000 ordinary shares of Shs.30 as partly called up plus 20,000 Shs.45 preference shares, tha

Parties include in central depository system, Parties include In Central De...

Parties include In Central Depository System 1. Government As like for the motive of attracting foreign supporting and investors the infrastructure of capital markets.

Percentage of sales method - financial forecasting, Percentage of Sales Met...

Percentage of Sales Method - Financial Forecasting This method includes expressing various balance sheet items such are directly concerned to sales as a percentage of sales.

Sources of funds - finance, Sources of Funds - Finance Venture capital...

Sources of Funds - Finance Venture capital, with combining risk financing along with marketing assistance and management, could become an effective instrument in fostering dev

Should the short-run effects on eps influence the ch, A firm has a $100 mil...

A firm has a $100 million capital budget. It is considering two project, each costing $100 million. Project A has an IRR of 20%; has an NPV of $9 million; and will be terminated af

Secondary markets - financial markets, Secondary Markets - Financial Market...

Secondary Markets - Financial Markets Economic Benefits or Role of Secondary Markets in the Economy are as: 1. It provides people a chance to buy shares therefore distribut

Determine the net present value and internal rate, Berick Ltd is a relative...

Berick Ltd is a relatively small engineering company that manages to compete effectively with larger companies by adapting to changing market requirements and specialising in innov

Reasons for why ordinary share capital is attractive, Reasons for why Ordin...

Reasons for why Ordinary Share Capital is Attractive Reasons for why ordinary share capital is attractive despite to be risky Shares are used as securities for loans as

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