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

Advantages of investment in shares, Advantages of Investment in Shares ...

Advantages of Investment in Shares 1. Income in form of dividends When you contain shares of a company then you become a part-owner of such company and hence you will be

Define new issue market, Define New Issue Market New Issue Market OR P...

Define New Issue Market New Issue Market OR Primary Market New issue market is the segment in which new issues are made.

Draw the network diagram, Draw the network diagram of the following project...

Draw the network diagram of the following project according to the activity list and relationships mentioned below Table 1 Activity Du

The return on the preferred stock, BAC is considering an issue of preferred...

BAC is considering an issue of preferred stock.  The dividends are 8.12% of the $25 par value. a.    If the present price is $26.25 per share, what is the return on the preferre

CH 4 Problems, Homework Chapter 4 A mortgage loan in the amount of $100,000...

Homework Chapter 4 A mortgage loan in the amount of $100,000 is made at 12% interest for 20 years. Payments are to be monthly in each part of this problem. a. What will monthly

Drawback of stock repurchases, Drawback of Stock Repurchases 1. High ...

Drawback of Stock Repurchases 1. High price A company may find it not easy to repurchase shares at their recent value and price paid may be higher to the detriment of rem

Business activity cycle, Business Activity Cycle The interest rates al...

Business Activity Cycle The interest rates also depend on business cycles as above. Because the economy moves in the four (4) business cycles, such interest rates will shift l

Depreciation, Which depreciation method would produce the higher NPV and ho...

Which depreciation method would produce the higher NPV and how much higher would it be?

What is a treasury bill, What is a Treasury bill? How risky is it? Trea...

What is a Treasury bill? How risky is it? Treasury bills are short-term debt instruments granted by the U.S. Treasury which are sold at a discount and pay face value at maturit

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