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

  Shares of stock through a dutch auction

LC Delivery has decided to sell 1,500 shares of stock through a Dutch auction. The bids received are as follows:300 shares at $36 a share, 500 shares at $35, 1,000 shares at $34, 1,200 shares at $33, and 1,800 shares at $32 a share. How much will LC ..

  Uses leverage in its capital structure

Newtone Company and Oldtone Company are identical in every way except their capital structures. uses leverage in its capital structure.

  The growth rate in dividends is expected to be constant

Shark Inc. just paid a dividend of $3.65 on its stock. The growth rate in dividends is expected to be a constant 7 percent per year indefinitely. Investors require a return of 15 percent for the first three years, a return of 13 percent for the next ..

  What is project year zero net cash flow

Quad Enterprises is considering a new three-year expansion project that requires an initial fixed asset investment of $2.49 million. The fixed asset falls into the three-year MACRS class. The project is estimated to generate $2,010,000 in annual sale..

  Rate of return and without margin rate of return

Suppose you purchase 1,050 shares of stock at $76 per share with an initial cash investment of $30,000. The call money rate is 5 percent and you are charged a 1.5 percent premium over this rate. Calculate your return on investment one year later if t..

  What is principal outstanding after the first loan payment

John Doeber borrowed $150,000 to buy a house. His loan cost was 6% and he promised to repay the loan in 15 equal annual payments. What is the principal outstanding after the first loan payment?

  What would be his total pre-tax net profit

Company’s current price is 22.5. John believes that Company's stock price is going to increase during the next 10 months. A 10-month call option giving the right to buy 100 shares with a strike price of $56 is available. For each option (to buy each ..

  None of the original shares have been sold or redeemed

Three years ago, an ETF was initiated with 1 million shares in 10 stocks each with a market value of $10. The total market value of the ETF was then $100 million (1 million shares * 10 stocks * $10). The ETF issued 20 million shares which originally ..

  Capital structure?- firm times interest earned? ratio

Last year the Rondoelea Products Company had $ 143 million in annual sales and a net profit margin of 9.5 percent. In? addition, Rondoelea's average tax rate was 30 percent. If Rondoelea had $ 36 million of debt outstanding with an average interest r..

  What was return on equity

A fire destroyed a large percentage of the financial records of the Carter Health System. You have the task of piecing together information to prepare a financial report. You have found the profit margin to be 5.4 percent. If sales were $4 million on..

  Calculate accounts receivable period accounts payable period

calculate the accounts receivable period accounts payable period, inventory period and cash conversion cycle for the above firm.

  Right to possess property for an agreed period of time

The right to possess property for an agreed period of time. the present right to own or possess land at some date that has not yet arrived. a temporary, revocable right to be on someone else's property. an irrevocable right to use some portion of ano..

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