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

Cost of retaining finance, Cost of Retaining Finance This will contain...

Cost of Retaining Finance This will contains dividends for share capital and interest for debt finance or can say tax deducted or like effective cost of debt.  Though, when co

Explain financial funds and supply , What does it mean to say that individu...

What does it mean to say that individuals as a group are net suppliers of funds for financial institutions? What do you think the consequences might be in financial markets if indi

Profit maximization - objectives of business entity, Profit maximization - ...

Profit maximization - Objectives of Business Entity Conventionally, this was considered to be the main goal of the firm. Profit maximization refers to getting the highest poss

C.O.L.A., What are some good examples of C.O.L.A?

What are some good examples of C.O.L.A?

Advantages and disadvantage of profitability index, Advantages and Disadvan...

Advantages and Disadvantage of Profitability Index Advantages of profitability index a) Simple to understand and utilize. b) The part of NPV in the venture will show t

Calculate the return on equity, Maghrabi Enclosure follows a moderate curre...

Maghrabi Enclosure follows a moderate current asset investment policy, but it is considering whether to shift to a different strategy.  The firm's annual sales are $500,000; its fi

Differences between debt and preference share capital, Differences between ...

Differences between Debt and Preference Share Capital Differences between Debt and Preference Share Capital are given below:   DEBT

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.

The constant growth model, You have the following information for Stardusts...

You have the following information for Stardusts: Current EPS is $1.79.  The current dividend is $.68 per share.  The return on equity is 24%.  The present price is $49.22. a.

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