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

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

Captive insurance, discuss the meaning and advantage of captive insurance

discuss the meaning and advantage of captive insurance

Significant features of partnership, Significant Features of Partnership ...

Significant Features of Partnership 1) The capital is contributed by the partners and no appeal is made to the public. 2) Like the sole proprietorship, a partnership has a l

Calculate the retrospective gross premium reserve, Question: A deferred...

Question: A deferred annuity policy is sold to a life aged 45 with the following benefits: • Basic payments start at $30,000 from age 65, increasing by $2,000 each year; •

Draw a budget constraint , The price of bread is $0.50 per pound, and the p...

The price of bread is $0.50 per pound, and the price of butter is $0.25 per ounce. Channing spends all of her income, buying 12 pounds of bread, 7 ounces of butter, and nothing els

Management of account receivable, Management of Account Receivable In ...

Management of Account Receivable In order to keep current customers and attract new ones, most firms find it necessary to offer credit. Accounts receivable represents the exte

Fiscal function, should be provied on a centralised or a decentralised basi...

should be provied on a centralised or a decentralised basic?

Investment analysis, Investment Analysis Any type of company will inve...

Investment Analysis Any type of company will invest finance for the sake of deriving a return that is useful for four main purposes as: 1. To reward the owners or shareholder

Assignment, Discuss the applicabilty of an operating cycle to poultry busin...

Discuss the applicabilty of an operating cycle to poultry business(consider broilers)

Operating cycle, Discuss the applicability of an operating cycle in the veg...

Discuss the applicability of an operating cycle in the vegetable growing business

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