Estimate average working capital required

Assignment Help Financial Management
Reference no: EM13499069 , Length: 2788 Words

Task 1

The financial difficulties in 2000 make Citilink understand the importance of financial management. In view of the global financial fragility, Citilink's board of directors would like to take a review on the financial status of the company. As an independent business consultant, you have to write a FORMAL BUSINESS REPORT to the Board to address the following issues:

(a) Identify the sources of short/medium and long term finances available to Citilink now and in near future. You may refer to Appendix I to support your findings, if needed.

(b) Assess the legal, financial, control, and bankruptcy implications of the different sources identified at Task 1(a) above.

(c) Analyse the finance costs of the respective sources of finance, as identified at Task 1(a) above.

Task 2

Citilink has just completed its 2010/11 management accounts. The directors are going to review the financial statements in the next board meeting. You have to prepare a FINANCIAL REVIEW REPORT for presentation at the board in the capacity of the Finance Director of Citilink. In order to have a critical review, you have collected the financial statements of Grayline, the market leader in the bus transportation industry. All the financial statements are at June 30. The report should cover the following issues:

(a) Discuss the formation of financial statements by introducing debit, credit, books of prime entry, accounts and ledgers, trial balance, final accounts.

(b) As the company legal form evolved from sole trader, to partnership, and finally to corporation during the last 10 years, a lot of changes have been made on the format of financial statements. The indigenous founder requests you to explain and compare appropriate formats of financial statements for difference forms of companies.

(c) Explain how different types of finance and their costs appear in the financial statements of Citilink and the interaction of assets and liabilities on the balance sheet, using the financial statements at Appendix I to illustrate.

(d) Explain the structure and purpose of main financial statements, i.e. balance sheet, profit and loss account, cash flow statement, and notes, illustrate with the financial statements at Appendix I as far as possible.

(e) Discuss the changes to reporting requirements under the International Accounting Standards (IAS) e.g. statement of comprehensive income and statement of financial position, illustrate with the financial statements at Appendix I as far as possible

(f) Calculate and interpret with writing the financial statements at Appendix I using appropriate ratios, i.e. profitability, liquidity, efficiency and investment. Comparison should be made with prior year result and externally with Grayline. You should show clearly your working for the computation of ratios.

Task 3

Citilinkhas a business line currently owns and runs 350 sightseeing buses and has a turnover of $10 million per annum.The current system for allocating jobs to drivers is very inefficient. Citilink is considering the implementation of a new computerised tracking system called "DigiLink". This will make the allocation of jobs far more efficient.

You are the financial analyst of the business line. You have been asked to perform somecalculations to help the Finance Director to decide whether DigiLink should be implemented. The project is being appraised over 5 years.

The costs and benefits of the new system are set out below.

i. The central tracking system costs $2,100,000 to implement. This amount will be payable in three equalinstalments: one immediately, the second in one year's time, and the third in two years' time.

ii. Depreciation on the new system will be provided at $420,000 per annum.

iii. Staff will need to be trained how to use the new system. This will cost $425,000 in the first year.

iv. If DigiLink is implemented, revenues will rise to an estimated $11 million this year, thereafter increasing by 5%per annum (i.e. compounded). Even if DigiLink is not implemented, revenues will increase by an estimated$200,000 per annum, from their current level of $10 million per annum.

v. Despite increased revenues, DigiLink will still make overall savings in terms of vehicle running costs. These costsavings are estimated at 1% of the post DigiLink revenues each year (i.e. the $11 million revenue, rising by 5%thereafter, as referred to in note iv).
vi. 6 new operators will be recruited to manage the DigiLink system. Their salaries will cost the business line $120,000 per annum in the first year, $200,000 in the second year, thereafter increasing by 5% per annum(i.e. compounded).

vii. The business line will have to take out a maintenance contract for the DigiLink system. This will cost $75,000 per annum.

viii. Interest on money borrowed to finance the project will cost $150,000 per annum.

ix. The business line's cost of capital is 10% per annum and the maximum allowable payback period is 2.5 years.

x. Ignore taxation.

(a) Assess the viability of the DigiLink project using payback period, accounting rate of return, net present value, and internal rate of return.

(b) Evaluate appropriate sources of finance for the DigiLink project in terms of suitability and their respective advantages and disadvantages.

Task 4

Citilinkwill start a new business line on 1st July, 2011 tomake and sell bus souvenirs. The target sales and production volume are 525,000 in next year. The following projected data is available.

Total costs $1,428,000
Costs as percentage of sales
Raw materials 15%
Direct labour 20%
Variable production overheads 11%
Fixed production overheads 10%
Other costs 12%
Working capital statistics
Average raw material holding period 4 weeks
Average finished goods holding period 4 weeks
Average debtors' collection period 6 weeks
Average creditors' payment period on:
- Raw materials 4 weeks
- Direct labour 1 week
- Variable production overheads 8 weeks
- Fixed production overheads 5 weeks
- Other costs 12 weeks
Other relevant information
- Assume all operation will start at 1st July, 2011.
- Assume sales are the same every month oncethe souvenirs are available for sales.
- All finished goods inventory values include raw materials, direct labour, variable production overheads andapportioned fixed production overhead costs.
- Assume there are 52 weeks in one year.
- Assume that production and sales volumes are the same.

As an accountant of the new business line, you have to write a BUDGET PROPOSAL to the Finance Director of Citilink. The proposal should include the following issues:

(a) Identify who might be involved in the working capital decision making of the new business line and assess the information needs of them individually.

(b) Calculate with explanation the unit costs of the souvenirs. You should state your assumption, if any.

(c) Determine the priceof the souvenirs and explain any other information that might be relevant for deciding the price

(d) Discuss how sensitivity analysis will help the cost and pricing decision of the new business line

(e) Estimate average working capital required by the new business line for the year. Explain overtrading and analyse whether there is any overtrading problem if the new business line only reserves $150,000 working capital.

(f) Prepare a monthly cash budget for the new business line for the year ended 30th June, 2012. Identify the timing of cash surplus and shortage by assuming zero cash at 1st July, 2011. You should clearly state your assumption, if any.

(g) Identify other budgets that may be helpful to analyse and monitor the new business line. Explain.

Verified Expert

Reference no: EM13499069

Questions Cloud

Acme films produces advertisements for cable television : Acme Films produces advertisements for cable television stations. They have two locations in a large metropolitan area. Building 1 contains the administrative, sales, marketing, human resources, development, and graphics departments
Compute the densities of a hydrogen nucleus : Using the information on the mass of a proton, mass of an electron and the sizes of the nucleus and the atom, calculate the densities of a hydrogen nucleus and hydrogen atom.
Explain the measured quantities were not actual charges : Some of Milikan's oil-drop data are shown in the table. the measured quantities were not actual charges on oil drops but were proportional to these charges.
Design a wan replication topology : Design a WAN Replication Topology
Estimate average working capital required : Calculate with explanation the unit costs of the souvenirs and determine the price of the souvenirs and explain any other information that might be relevant for deciding the price
Explain benzene has a heat of vaporization : Benzene has a heat of vaporization of 30.72 kJ/mol and a normal boiling point of 80.1 degrees Celsius. At what temperature does benzene boil when the external pressure is 460 torr
Risk assessment tools : Risk assessment tools.
Determined total earnings : This following information if for ella dodd for the week ended march 15.Total hours worked:48Rate: $15 per hr, with double time for all hours in excess of 40.federal income tax withheld:$200United fund deductions.
Explain what is the natural abundance of chlorine-37 : Chlorine has two stable isotopes, chlorine-35(34.9688 amu) and chlorine-37 (36.9656 amu). If the average mass of chlorine is 35.4527 amu, what is the natural abundance of chlorine-37

Reviews

Write a Review

Financial Management Questions & Answers

  You are given the following data on three securities a b

you are given the following data on three securities a b and the market mnbspsecurityexpectedreturn r-standard

  Calculate the average return per period for an investor

Calculate the average return per period for an investor who bought 100 shares of the Closed Fund at the initiation and then sold her position at the end of Period 4.

  Calculate the value of your bond relative

Calculate the value of your bond relative to this interest rate using equation 11.2 in the text. Assume that i = 5%. Is your bond selling for a premium or at a discount based on your calculation?

  The discussion board db is part of the core of online

the discussion board db is part of the core of online learning. classroom discussion in an online environment requires

  This paper should be between 1750 ndash 2000 words and

write an apa style paper outlining the effects of financial planning governance and ethical issues in modern economies.

  Prepare an income statement for 2012

Prepare an income statement for 2012 using Microsoft Word or Excel, in good form, starting with income from continuing operations.

  Ques 1i what are the factors affecting the capital

ques 1.i what are the factors affecting the capital structure of the company?ii the company raised preference share

  Which of the following classifications of securities had

1 the practice of not putting all of your eggs in one basket is an illustration of .a varianceb diversificationc

  The most significant challenge to business success you see

in this weekrsquos reading nbspand learning activities you learned aboutthe increasingly competitive global economy.why

  In a three- to five-page paper not including title and

in a three- to five-page paper not including title and reference pages select a service organization to use as an

  Calculate payback period and internal rate of return (irr)

Company has an opportunity to make an investment with the estimated after tax cash flows

  Define what is the coupon rate for a bond

What is the coupon rate for a bond (face value $1,000) with five years until maturity, a price of $957.88, and a yield to maturity of 6%? What is the current yield for this bond?

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