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

Pre-tax cost of debt capital, Current cost of a bond: You know that the aft...

Current cost of a bond: You know that the after-tax cost of debt capital for Bubbles Champagne is 7 percent. If the firm has only one issue of five-year maturity bonds outstanding,

Types of stock markets, Types of Stock Markets 1. Over the Counter or...

Types of Stock Markets 1. Over the Counter or OTC and Organised Exchange market This is whereas the selling and buying of securities is done through sellers and buyers ar

Example of earnings yield valuation, Example of Earnings Yield Valuation ...

Example of Earnings Yield Valuation Estimated maintainable earnings are £240,000 per annum; rate of return required is 25 percent. Calculate the value of the business. V

Aafafa, Ask lajgkjasbgksabgbaskjbaskjbasjgbhjabgjbjgbskjgbkasbgjkabksgbksbg...

Ask lajgkjasbgksabgbaskjbaskjbasjgbhjabgjbjgbskjgbkasbgjkabksgbksbgkabkhvakkvbaoygfyabkbkkye#Minimum 100 words accepted#

Binomial and continuous model - mathematics of finance, Consider a binomial...

Consider a binomial model of a risky asset with the parameters r = 0:06, u = 0:059, d = 0:0562, S 0 = 100, T = 1, 4t = 1=12. Note that u and d are monthly effective rates of retur

Conservative approach - financing current assets, Conservative Approach - F...

Conservative Approach - Financing Current Assets An exact similar of asset life along with the life of the funds required to finance the asset may not be possible. A firm that

T accounts, Accounting Exercise AVM 386 Fall 2014 Misty Mark, an infamous ...

Accounting Exercise AVM 386 Fall 2014 Misty Mark, an infamous archer, decided to open an archery business called Bows and Biceps. The following is a list of transactions for Bows

estimate the price of the bond, Stardusts has 1 debt issue outstanding.  T...

Stardusts has 1 debt issue outstanding.  The debt matures on August 15, 2017, and has a 6.25% coupon.  Coupons are paid semiannually.  The bond is priced to yield 1.61% compound se

Modern methods of capital projects, what are the modern methods of evaluati...

what are the modern methods of evaluating capital projects? how they different from old methods?

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