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

Foreign trade balance, Foreign Trade Balance If the Government buys or...

Foreign Trade Balance If the Government buys or imports much more than it sells or exports there will be a trade deficit such will require financing.The most important source

Capital Allocation, Consider the following capital market yielding 1% per y...

Consider the following capital market yielding 1% per year and a mutual fund consisting of 60% stocks and 40% bonds. expected return of stocks 9.75% per year and expected return on

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

Find the ytm and what is its roe, 1. Find the price of the following bonds....

1. Find the price of the following bonds. They are all risk-free, and the risk-free rate is 10%. (a) A fifteen-year zero coupon bond with face value $1,000. (b) A three year

Stock repurchase, Stock Repurchase The company can buy back also sever...

Stock Repurchase The company can buy back also several of its outstanding shares instead of paying cash dividends. This is identified as stock repurchase and or bought back or

Risk-free interest rate-corporate tax rate, XYZ is considering a capital re...

XYZ is considering a capital restructuring to allow $300 million in debt. Currently, XYZ is an all-equity firm with earnings before interest and taxes of $260 million. Assume unlev

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

Roa - return on assets, ROA - Return on Assets The Average of the ...

ROA - Return on Assets The Average of the industry ROA was 10.02% for 2004, 6.81% for 2005, and 7.32% for 2006. The chart showed that Lenovo had a little bit higher ROA th

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