Determine the approximate payback period, Finance Basics

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?

 

Posted Date: 2/23/2013 7:37:33 AM | Location : United States







Related Discussions:- Determine the approximate payback period, Assignment Help, Ask Question on Determine the approximate payback period, Get Answer, Expert's Help, Determine the approximate payback period Discussions

Write discussion on Determine the approximate payback period
Your posts are moderated
Related Questions
Clemson Software is considering a new project whose data are shown below. The required equipment has a 3-year tax life, after which it will be worthless, and it will be depreciate

On the 5 th of March 2009, the Bank of England (BoE) lowered its main interest rate to 0.5%, the lowest on record since the Bank has published rates in 1970, which still remains u

How long until I get the results of my order

Food and Beverages Rooms, Restaurants and Other Services Other Income Total $ $ $ Sale

Rights of Ordinary Shareholders A. Right to vote Choose BOD Purchase/Sales of assets B. Influence decisions as: Right to residual ass

Limitations of Ratio Ratios have weaknesses as following like: 1. They avoid the size of the firm being compared as in cross-sectional analysis; the firm being compared m

Dividend Ratios 1. Dividend per shares (DPS) = Earnings to ordinary shareholders/ Number of ordinary shares Specify cash returns received for all share holders. 2. Di

MRP systems and Functions of MRP systems Where dependent demand exists, for example between finished product and its constituent parts, item forecasting or inventory control t

Y ou are interested in the value of Joes Shoe Corporation and its cost of capital. Suppose you believe that the assumptions of Miller-Modigliani's Proposition 1 (without taxes) are

Cost of Finance - Capital Structure This is the price the company pays to retail and acquire finance. To get finance a company will pay implicit costs that are commonly recogn