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

Accounting rate of return method or arr, Accounting Rate of Return Method o...

Accounting Rate of Return Method or ARR This method utilizes accounting profits from financial status to assess the viability of investment proposal via diving the average inc

Cash management techniques, Cash Management Techniques The basic strat...

Cash Management Techniques The basic strategies that must be employed via the business firm in managing its cash are as: i) To pay account payables as behind as possible wi

Determine what is the current market price of the bond, 1.  A company is tr...

1.  A company is trying to decide which one of two projects it should accept. Both projects have similar start-up costs. Project 1 will generate annual cash flows of $52,000 a year

Assumptions underlying percentage of sales method, Assumptions Underlying P...

Assumptions Underlying Percentage of Sales Method The fundamental supposition underlying the use of % of sales method is such, there is no inflation in the economy such is the

A. michael spence, A. Michael Spence An American economist who was awar...

A. Michael Spence An American economist who was awarded by the Nobel Memorial Prize in Economic Sciences. Spence is a lecturer of management at Stanford University in the Gradu

C.O.L.A., What are some good examples of C.O.L.A?

What are some good examples of C.O.L.A?

Required barrels of water per day, In the present case, we need to take a d...

In the present case, we need to take a decision about implementing one of the available two options, based on various factors. The available two options are either to complete a se

Uses and application of ratios, Uses and Application of Ratios Ratios ...

Uses and Application of Ratios Ratios are required in the following ways via managers in different firms. 1. Evaluating the efficiency of assets employment to generate sale

Functions of the stock exchange, Functions of the Stock Exchange The e...

Functions of the Stock Exchange The essential function of a stock exchange is the raising of funds for investment in long-term assets. Whereas this basic function is very sign

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