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

Financial planning processes, explain the financial planning process in a p...

explain the financial planning process in a private limited company

Formation of sole proprietorship business, Formation of Sole Proprietorship...

Formation of Sole Proprietorship Business When an individual plans to start a business, his or her main objective is to earn profit but there are a number of factors to take in

Social responsibility - objectives of business entity, Social responsibilit...

Social responsibility - Objectives of Business Entity The firm must decide where to operate strictly in their shareholders' best interests or be responsible to their staff, th

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,

project on financial planning, Financial Planning Project Instructions: ...

Financial Planning Project Instructions: You will serve as a financial advisor for your client to develop a financial plan. You can compile all the worksheets introduced in eac

Project apparisal, challenges your likely to face when apparising a project...

challenges your likely to face when apparising a project on the implemtation stage

investors are risk neutral, At t = 0, a 3-year, 7% coupon corporate bond w...

At t = 0, a 3-year, 7% coupon corporate bond with face value $1,000 is trading at a credit spread of 15%. The risk free rate is constant and equal to 4% for all maturities. The rec

What are potential solutions, Internal finance can avoid the agency costs o...

Internal finance can avoid the agency costs of debt and equity finance. In practice it is the most important source of funding. (a) Discuss potential problems of internal financ

Acceptance rule of irr, Acceptance Rule of IRR IRR will accept a ventu...

Acceptance Rule of IRR IRR will accept a venture if its IRR is higher than or equivalent to the minimum required rate of return such is usually the cost of finance also recogn

State the generalised law of one price, Question: a) An oil well now pr...

Question: a) An oil well now produces 75000 barrels per year. The well will produce for 21 years more, but production will decline by 3.7% per year. Oil prices however, will in

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