Prepare a profit statement to show the profit

Assignment Help Financial Management
Reference no: EM131343701

PART ONE

Task 1.1
Always Better Control plc. has the following details as on 1" January 2015:

Particulars Amount
Fixed assets 200,000
Stocks 190,000
Bank Balance 90,000
The Budget for the first quarter are as follows:
Sales for the months:
Jan-15 300,000
Feb-15 600,000
Mar-15 700,000
Gross profit margin 20% of sales
Bad debts 1% of sales
Variable selling overheads 10% of sales
Fixed selling overheads $25,000
Variable administrative overheads 2% on sales
Fixed administrative overheads $15,000
Credit terms for sales, purchase and overheads(there is no outstanding debtors or creditors on 1st january 2015)  1 month credit

Prepare a profit statement to show the profit for the quarter ended 31" March 2015 and prepare a cash budget for January 2015 to March 2015.

Task 1.2
CIMA defines relevant costs as 'costs appropriate to aiding the making of specific management decisions'. With this view explain the importance of relevant information in pricing decisions.

Task 1.3
Consider two projects. Each requires an immediate cash outlay of $10,000. Project A will return $13,000 at the end of two years. Project B will return $6,500 each year at the end of year 1 and 2. Assume the discount rate is 15% and ignore depreciation and taxes. Evaluate the project by using the capital investment appraisal tools. Critically analyse the better project.

PART TWO
SCENARIO
LEG's Financial Statement for the period ending 31" March

(Dollars in thousands)

2016

2015

2014

Assets

 

 

 

Cement Assets:

 

 

 

Cash and Cash Equivalents

$272,640

582,540

$321,390

Receivables

12,090

3,480

7,550

Inventory

738,630

857,090

668,200

Prepaid Expenses

54,880

54,030

39,670

Total Current Assets

1,078,240

997,140

1,036,810

Property. Plant & Equipment (at Cost):

 

 

 

Land and Buildings

531,270

383,350

312,670

Fixtures and equipment

476,460

411,230

251,920

Leasehold improvements

16,460

15,120

12,340

Construction in progress

---

46,370

32,800

Less Accumulated Depreciation

(248,430)

(183,890)

(135,020)

Property, Plant & Equipment, net

775,760

672,180

474,710

Total Assets

$1,854,000

$1,669,320

$1,511,520

liabilities and Stockholders' Equity

 

 

 

Current liabilities:

 

 

 

Accounts Payable

$377,970

$244,150

$259,040

Advance Payment on Orders

4,460

2,030

3,500

Income Tax Payable

70,800

53,020

103,970

Other current obligations

154,510

139,950

148,790

Total Current Liabilities

607,740

439,150

515,300

Long term debt

78,000

84,130

76,740

Stockholders' Equity

 

 

 

Common stock; 20.1M, 20.1M & 20.0M shares, respectively as par

2,010

2,010

2,000

Additional Capital, net

311,360

307,810

293,080

Retained Earnings

983,810

875,160

624,400

Loa Treasury Stock, at cost

(128,920)

(38,940)

--

Total Stockholders' Equity

1,168,260

1,146,040

919,480

Total Liabilities and Equity

$1,854,000

$1.669,320

$1,511,520

Task 2.1
Discuss the Cash flow analysis of LEG Plc. in detail from the given financial statement for the period 2014 to 2016

Task 2.2
You are required to analyse the performance of LEG Plc. for the last 4 years by using Comparative balance sheet analysis for the 3 years period.

Task 2.3
From the financial statement of LEG Plc. calculate the following ratios and comment on their performance throughout the period.
a. Asset coverage ratio
b. Debt ratio
c. Debt to equity ratio
d. Equity ratio
e. Long term debt to Capitalization ratio
f. Long term debt to Total Asset ratio

Reference no: EM131343701

Questions Cloud

Discuss the issues of their under-representation as victim : Typically, minorities in US are over represented in criminal justice system as offenders and underrepresented as victims. Discuss the issue(s) of their under-representation as victims along with the cause(s) of this under-representation.
Capital budgeting rely on analysis of cash flows : Why does capital budgeting rely on analysis of cash flows rather than on net income? What kinds of factors do you want to think about when choosing a benchmark to use? A corporation has already sponsored a soft launch of a new suite of software among..
Projection for the firm operating cash flow : An expansion project will annually generate additional revenues of $2,500,000. It has fixed and variable costs totaling $1,250,000. It will increase depreciation by $620,000. The firm has a marginal tax rate of 34%. What is the projection for the fir..
What is the yield to maturity on the given bonds : Fin 3403- Rockinghouse Corp. plans to issue seven-year zero coupon bonds. It has learned that these bonds will sell today at a price of $369.37. Assuming annual coupon payments, the yield to maturity on these bonds is ___%?
Prepare a profit statement to show the profit : Prepare a profit statement to show the profit for the quarter ended 31" March 2015 and prepare a cash budget for January 2015 to March 2015.
Calculate the free cash flow for cellular access : Cellular Access? Inc., is a cellular telephone service provider that reported net operating profit after tax? (NOPAT) of $256 million for the most recent fiscal year. Calculate the free cash flow for Cellular Access for the most recent fiscal year. T..
Calculate the freezing point of sea water : For this question imagine that sea water is a 3.5 mass % solution of NaCl with a density of 1.00g/mL. Assume full dissociation of the NaCl. a) Calculate the freezing point of sea water. Briefly explain why it is not 0 (degrees Celsius).
Collect some of the current accounts receivable : General hospital has a current ratio of 0.5. Which of the following actions would improve (increase) this ratio? Use cash to pay off current liabilities. Collect some of the current accounts receivable. Use cash to pay off some long term debt.
Present value of an investment future cash flows : The difference between the present value of an investment’s future cash flows and its initial cost is the: What is the net present value of a project with an initial cost of $36,900 and cash inflows of $13,400, $21,600, and $10,000 for Years 1 to 3, ..

Reviews

Write a Review

Financial Management Questions & Answers

  What is the portfolio expected return

A portfolio is invested 26 percent in Stock G, 41 percent in Stock J, and 33 percent in Stock K. The expected returns on these stocks are 9 percent, 11.5 percent, and 16.9 percent, respectively. What is the portfolio’s expected return?

  What should the strike prices of the put options be

A portfolio manager in charge of a portfolio worth $10 million is concerned that the market might decline rapidly during the next six months and would like to use options on the S&P 100 to provide protection against the portfolio falling below$9.5 mi..

  How much money must the company borrow

The treasurer for Chic Man Clothing must decide how much money the company needs to borrow in July. The balance sheet for June 30, 2010 is presented below: Chic Man Clothing Balance Sheet June 30, 2010 Cash $87,000 Accounts payable $550,000 Marketabl..

  What is the net cash flow of swap to financial institution

A financial institution has entered into an interest rate swap in which it receives 10% per year with semiannual compounding and pays 6-month LIBOR on a principal of $10 million for five years. Payments are made every six months. The current 6-month ..

  Firm is considering expanding it household products division

Your firm is considering expanding its household products division. You iden- tify Procter & Gamble (PG) as a firm with comparable investments. Suppose PGs equity has a market capitalization of $144 billion and a beta of 0.57. PG also has $37 billion..

  What is the standard deviation of these returns

A stock had returns of 6 percent, -4 percent, 4 percent, and 16 percent over the past four years. What is the standard deviation of these returns?

  What is the value of the bond if the market rate

A bond's par value is $1,000. It has 5 yrs. until maturity. Its coupon rate is 7%. What is the value of the bond if the market rate is 10%, assuming annual compounding?

  Invest current spot rate of the pound

Assume you have $1,000,000 to invest Current spot rate of the pound = $1.30 90 day forward rate of pound = $1.28 3 month deposit rate in US = 3% 3 month deposit rate in Great Britain = 4% If you use covered interest arbitrage for a 90-day investment,..

  Compute the price of a bond-semiannual interest payments

The Florida Investment Fund buys 86 bonds of the Gator Corporation through a broker. The bonds pay 6 percent annual interest. The yield to maturity (market rate of interest) is 8 percent. The bonds have a 20-year maturity. Using an assumption of semi..

  Role of the health care financial manager

Reflecting on the various topics discussed throughout the course, describe one (1) concept that will be affected most by the latest developments in health reform.

  Corporate bonds-what is the current price of the bond

Even though most corporate bonds in the United States make coupon payments semiannually, bonds issued elsewhere often have annual coupon payments. Suppose a German company issues a bond with a par value of E1,000, 10 years to maturity, and a coupon r..

  What are arithmetic and geometric returns for stock

A stock has had returns of −26 percent, 6 percent, 34 percent, −5 percent, 28 percent, and 19 percent over the last six years. Required: What are the arithmetic and geometric returns for the stock?

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