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

Long term lenders - measuring business performance, Long Term Lenders - Mea...

Long Term Lenders - Measuring Business Performance Long term lenders These involve finances with loans, mortgages and debenture holders.  These have both short and long

Credit score model, The topic taken for this study is "FINANCIAL VIABILITY ...

The topic taken for this study is "FINANCIAL VIABILITY OF X BY APPLYING CREDIT SCORE MODEL".  The study has attempted to analyze the financial viability of the company by applyi

Valuation of share, Valuation of Share A number of parties are interes...

Valuation of Share A number of parties are interested however in the value of shares and securities and that will include: Company shareholders, vendors and directors of

Example of miller-orr model, Example of Miller-Orr Model XYZ's managem...

Example of Miller-Orr Model XYZ's management has put the minimum cash balance to be equivalent to Sh.10, 000. The standard deviation of daily cash flow is of Sh.2, 500 and the

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

determine the benefit - cost and benefit/cost ratios, A City has determine...

A City has determined that building a new water distribution system using a new source of water would have an annual costs of $5,750,000 and annual net benefits of $4,250,000. The

IRR, How to compute the IRR of data

How to compute the IRR of data

Standard ratio analysis-compound growth rates, Standard ratio analysis shou...

Standard ratio analysis should be used to supplement the discussion of strength and weakness. The following ratios are most often used by practitioners: (a) Growth Rates: PEG R

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