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

Dividend policy, Charleston Industrial revised its dividend policy and deci...

Charleston Industrial revised its dividend policy and decided that it wants to maintain a retained earnings account of $1 million. The company''s retained earnings account at the e

Cost of capital, capital structure of 38% common stock and 62% debt. A debt...

capital structure of 38% common stock and 62% debt. A debt issue of 1000 par value, 5.6% bonds that mature in 15 years and pay annual interest will sell for $979.dividends have gro

Dow theory - stock exchange, Dow Theory - Stock Exchange This theory d...

Dow Theory - Stock Exchange This theory depends upon profiting of prices of a chart of secondary movement. The principal objective is to discover whilst there is a change in t

What is debt-equity ratio, Louis Futon Co. is currently an all-equity firm....

Louis Futon Co. is currently an all-equity firm. The current market value of the company is $80 million. The corporate tax rate is 35%. What is the new value of the company if Loui

How are financial trades made on an organized exchange, How are financial t...

How are financial trades made on an organized exchange? Ans: Each exchange-listed security is traded at a fixed location on the trading floor known as the post. The trading is

Cash and marketable securities management, Cash and Marketable Securities M...

Cash and Marketable Securities Management The management of marketable and cash securities is single of the key areas of working capital management. Because cash and marketabl

Describe the transaction structure-financing, Description of the deal, anal...

Description of the deal, analysis of abnormal returns & premium (a)  Describe the transaction structure, mode of payment, and financing.  (b) Give your comment/assessment of

What would be the expected return of the portfolio, A Ltd.'s share gives a ...

A Ltd.'s share gives a return of 20% and B Ltd.'s share gives 32% return. Mr. Gotha invested 25% in A Ltd.'s share and 75% of B Ltd.'s shares. What would be the expected return of

Calculate the monthly payment - annual percentage rate, You have just taken...

You have just taken out a $220,000 loan for your house at an APR of 7.5% and a 30-year term. Payments are to be made monthly . Two years from now, you refinance at an APR of 5.5%

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