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

Valuation of share, Valuation of Share A number of parties are interes...

Valuation of Share A number of parties are interested however in the value of shares and securities and that will include: Company shareholders, vendors and directors of

Running own small businesss, how to do basic accountancy and what can i cla...

how to do basic accountancy and what can i claim back

What are the features of stock exchange, What are the Features of Stock Exc...

What are the Features of Stock Exchange The key features of stock exchange are as below: (1) Organised Market: Stock Exchange is an organized market. Each stock exchang

Evaluate the probability, Evaluate the probability of 10 or more customers ...

Evaluate the probability of 10 or more customers arriving within 2 hours if on average 7 customers arrive within one hour. Customers arrive independently.

Identified two mutually exclusive projects, The director of capital budgeti...

The director of capital budgeting for a firm has identified two mutually exclusive projects, A and B, with the following expected net cash flows: Expected Net Cash Flows Year

Calculate the current stock price, The Bim-Bom Company is expected to pay a...

The Bim-Bom Company is expected to pay a dividend of $3.10 per share at the end of the year, and that dividend is expected to grow at a constant rate of 4.00% per annum.  The compa

Assiogment, Ask question #MinimQuestion You are the financial accountant ...

Ask question #MinimQuestion You are the financial accountant of Donald Bhd, a manufacturer and wholesaler of soft drinks. Donald Bhd is in direct competition with Fizz Bhd and Po

Business activity cycle, Business Activity Cycle The interest rates al...

Business Activity Cycle The interest rates also depend on business cycles as above. Because the economy moves in the four (4) business cycles, such interest rates will shift l

#titleMrs.., You own a two-bond portfolio. Each has a par value of $1,000. ...

You own a two-bond portfolio. Each has a par value of $1,000. Bond A matures in five years, has a coupon rate of 8 percent, and has an annual yield to maturity of 9.20 percent. Bon

Optimal Capital Budgeting, Capital Corporation, which has a target capital ...

Capital Corporation, which has a target capital structure of 40 percent debt and 60 percent common equity, is evaluating an expansion project with an 8.5 percent IRR. The project c

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