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

Profit analysis, The Audiology Department at Randall Clinic offers many ser...

The Audiology Department at Randall Clinic offers many services to the clinic’s patients. The three most common , along with cost and utilization data, are as follows: Service Var

Question 7.1, Assume the managers of Fort Winston Hospital are setting the ...

Assume the managers of Fort Winston Hospital are setting the price on a new outpatient service. Here are the relevant data estimates. Variable costs $ 5.00 Annual fixed c

What are the types of financial assets, What are the types of financial ass...

What are the types of financial assets? Types of Financial Assets: a. Loans b. Bank Deposits c. Stocks A share of ownership within a company d. Bonds A promis

Investment bank, Investment Bank A lending entity is engaged in all the...

Investment Bank A lending entity is engaged in all the phases of privacy offerings the including managing, underwriting, trading, and the distributing new security issues.

Cash deficit and cash surplus, What is cash deficit?And what is cash surplu...

What is cash deficit?And what is cash surplus?Describe each of them in detail.

Find out weighted average cost of capital, Mermaid Coffee Corporation (MCC)...

Mermaid Coffee Corporation (MCC) has 1,000,000 shares of stock currently trading at $42 per share. The company has issued 20,000 bonds, each with market value $928.59 and yield to

Calculating cost of purchasing & prepare income, The Jacobs company needs t...

The Jacobs company needs to acquire a new lift truck for transporting its final product to the warehouse. One alternative is to purchase the truck for $45,000. Maintenance of th

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

explain the financial planning process in a private limited company

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