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

Broker - stock market, Broker - Stock Market 1. A dealer on the ...

Broker - Stock Market 1. A dealer on the market who that sells and buys securities on behalf of the public investors. 2. And he is an agent of investors 3. He is t

Factors to increasing the profitability of a business, Factors contribute t...

Factors contribute to increasing the profitability of a business Several other factors contribute to increasing the profitability of a business. For companies that are highly d

Meaning of a sentence, on this sentence: "all have an interest in understan...

on this sentence: "all have an interest in understanding what drives trade" please explain what''s meaning of "what drives trade"?

Advantages of using debt finance, Advantages of Using Debt Finance ...

Advantages of Using Debt Finance Interest on debt is a tax permit able expense and as that it is reduced via the tax allowance. The cost of debt is fixed regardless of

Calculate average price-earnings ratio, Regan Inc., was founded nine years ...

Regan Inc., was founded nine years ago by brother and sister Carrington and Genevieve Regan. The company manufactures and installs commercial heating, ventilation, and cooling (HVA

Credit standards, Credit Standards A firm may follow a stringent or a ...

Credit Standards A firm may follow a stringent or a lenient credit policy. The firm subsequent of a lenient credit policy tends to sell on credit to customers on extremely lib

Types of partners, Types of Partners 1. General Partners -Unlimited ac...

Types of Partners 1. General Partners -Unlimited active and liability in participation in partnership activities. 2. Limited partners - Limited liability in the management of

Managing financial resources, Two friends, Alan & Tim just graduated from t...

Two friends, Alan & Tim just graduated from the college. They plan to start their own business, of selling health foods for office workers. They have identified a commercial comple

Systems and subsystems, SCENARIO You have just moved out of home and have ...

SCENARIO You have just moved out of home and have a part-time job that pays you $18 per hour after tax (you work 20 hours a week). You also have $5000 in a savings account. You

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