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

Computing the real rate & flat tax, Quetion1: You are earning 5.2 percent ...

Quetion1: You are earning 5.2 percent on a certificate of deposit. Inflation is running 3.5 percent. What is the real rate of return on your investment? Question2: Search for

Solutions to agency problem, Solutions to agency problem The bondholde...

Solutions to agency problem The bondholders might receive the following procedures to protect themselves from the process of the shareholders that might dilute the value of th

Computation of payback period method, Computation of Payback Period Method ...

Computation of Payback Period Method 1. Under uniform annual incremental cash inflows - if the venture or an asset generates uniform cash inflows then the payback period (PB

Sources of funds - finance, Sources of Funds - Finance Venture capital...

Sources of Funds - Finance Venture capital, with combining risk financing along with marketing assistance and management, could become an effective instrument in fostering dev

Finance applicatios and theory, Zoeckler Mowing & Landscaping''s year-end 2...

Zoeckler Mowing & Landscaping''s year-end 2012 balance sheet lists current assets of $436,500, fixed assets of $551,500, current liabilities of $417,900, and long-term debt of $317

Describe the duties of the financial manager, Describe the duties of the fi...

Describe the duties of the financial manager in a business firm? Financial managers calculate the firm's performance, define what the financial consequences will be if the firm

State about the odd-lot dealer, State about the Odd-lot Dealer He/she...

State about the Odd-lot Dealer He/she specializes in buying and selling in amounts which are less than present trading units. They buy and sell odd lots, make them up into ma

Estimate the present value of benefits, (a) A couple has just celebrated th...

(a) A couple has just celebrated their 25th wedding anniversary. What is the probability of them celebrating their 50th wedding anniversary, if the husband is aged exactly 50, his

Interpolation method, Interpolation method Consequently, r denote...

Interpolation method Consequently, r denotes required rate of return Consequently, r = 14 percent + (15 percent - 14 percent) x 253 .646 /253 .646 + 5.375

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

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