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

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

Net present value method - dcf technique, Net Present Value Method - DCF Te...

Net Present Value Method - DCF Technique The method discounts outflows and inflows and ascertains the total present value via deducting discounted outflows from discounted inf

Production, Pick a product of your choice and identify the stages of produc...

Pick a product of your choice and identify the stages of production

Government budget deficit, Government Budget Deficit If the Government...

Government Budget Deficit If the Government spends much more than it gets in from tax revenue, it runs a budget deficit. This deficit should be covered or financed either via

Analysis on capital budgeting npv or eaa, As the Chief Financial Officer fo...

As the Chief Financial Officer for the wholly Australian owned, Australian Stock Exchange listed company, Toy Show Ltd., an importer and manufacturer of a range of quality children

Bank draft, what is bank draft?How it can be prepared?

what is bank draft?How it can be prepared?

Primary markets - financial markets, Primary Markets - Financial Markets ...

Primary Markets - Financial Markets These are markets such deal along with securities that have been issued for the first moment. The money flows directly from transferor or t

Analysis of price and financial leverage , The Bayview Investment Partners...

The Bayview Investment Partners owns an office building near Shoal Creek and Anderson lane in suburban Dallas. The building is ten years old. Bayview is willing to sell the propert

Management money, where can I get money and how can I manage it

where can I get money and how can I manage it

Find the required return, Marbela Corporation's stock had a required return...

Marbela Corporation's stock had a required return of 12.75% last year, when the risk-free rate was 6.4% and the market risk premium was 5.5%.  Now suppose the market risk premium d

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