Prepare common size comparative profit

Assignment Help Accounting Basics
Reference no: EM131049844

PART A:

Broun Ltd.

Comparative Profit and Loss Statements


$000's 2013 $000's 2014 $000's 2015
Sales 30000 25000 20000
Less Cost Sales 19500 15500 12000
Gross Profit 10500 6500 8000
Operating Expenses 9390 8425 7080
Operating profit befor income tax 1110 1075 920
Income tax expense 510 500 420
Operating Profit after income tax 600 575 500
Includes *Interest Expense 290 275 260
Dividends paid to Shareholders 90 155 135
Cash Dividend per share 2.1c 3.7c 5c
Market Price per share

$1.15
Details of the Cost of Sales are as follows



$000's 2013 $000's 2014 $000's 2015




Beginning Inventory 1000 1060 650
Plus Purchase 19560 15090 12330
Goods available for sale 20560 16150 12980
Less Ending Inventory 1060 650 980
Cost of Sales 19500 15500 12000
*Assume all sales and purchases are on credit.


Broun Ltd.

Comparative Profit and Loss Statements


$000's $000's $000's

2013 2014 2015
Assets


Current Assets 1320 870 1200
Plant and Equipment (Net of Depreciation) 7080 6630 4800
Total Assets 8400 7500 6000
Liabilities


Current Liabilities 738 684 600
Non-Current Liabilities 1572 1236 1200
Total Liabilities 2310 1920 1800
Net Assets 6090 5580 4200
Shareholders Equity


Share Capital (S1 ordinary shares) 4200 4200 2700
Retained Profits 1890 1380 1500
Total Shareholder's Equity 6090 5580 4200

Required

a) Prepare common size comparative profit and .s accounts for the three-year period.

b) Prepare all relevant financial statement ratios for 2014 and 2015 (Cash Flow ratios are not required).

c) Comment on the significant trends and relationships revealed by your analytical computations.

d) Would you consider buying this company's shares if they are now selling for $1.15 per share? Why?

PART B:

Ken Blow is considering going into business by opening a food store. He has found suitable premises. However, before the bank will grant him an overdraft and lending facility, he has been asked to draw up a cash budget for the first three months of trading (February, March and April, 2016).

Ken has $100 000 of his own money that he is able to invest into the business. He will need to rent his premises one month before he opens the store, and he will also have to have his stock (inventory) and his staff on hand two weeks before he opens the doors. He also has the following relevant information:

Expected sales for each of the first three months of trading are February - $75 000, March -$90 000 and April - $110 000 respectively. It is assumed that the sales will be even over each four-week period.

Staff costs are expected to be $1 500 per week; rent is $2 000 per week, payable one month in advance; electricity and phone are expected to be $500 per week, payable a month in arrears; insurance is $10 000 per annum payable a year in advance; equipment of $45 000 will need to be purchased when the store is first rented and will be depreciated, straight line, over ten (10) years with no residual value.

Ken is allowing a 25% mark up on all goods sold. As he is a new customer, all suppliers will require him to pay for goods within seven (7) days. Inventory is ordered three weeks before it is required and there will be a weekly delivery.

The bank is prepared to grant overdraft and lending facilities to the extent of $10 000, if the cash budget indicates that the business should be successful. Interest on the overdraft will be charged at 16% per annum. The bank is also prepared to lend Ken a long-term loan of $50000 with an interest rate of 12% per annum with interest to be paid quarterly. The long-term loan must be taken in full, whether or not Ken requires the whole amount (simple interest calculations only are required).

Ken further estimates that his weekly turnover in twelve (12) months' time will be $175 000 per week.

Some assumptions you may consider

  • Assume 4 weeks a month
  • Assume all sales are cash sales
  • Depreciation will not affect the cash budget

Loan

Assume $50,000 borrowed in first week of January (interest paid quarterly - 12 weeks later)

Wages

Paid weekly

Rent

Paid weekly but payable one month in advance

Electricity/Phone

Assume electricity /phone required when office rented.
Assume paid monthly in arrears
Electricity/ phone will therefore need to be paid from week I in February

Stock

Needs to have stock on hand two weeks before opening

Required

a) A cash budget covering all the information given until the end of April.

b) Do you think the business will be successful, based on the forecasts? Give reasons for your answer.

c) Given Ken's estimation that the turnover will increase within twelve months, what other costs would you expect to increase? Why?

PART C:
Calculate the Net Present Value and Internal Rate of Return relative to the purchase of a new widget making machine.

- Machine cost $3,400,000
- Useful life: 7 years
- For tax purposes a 30 per cent reducing balance depreciation would be used.
- Maintenance cost per annum: $75,000.
- Maintenance technician sal, per annum: $125,000
- Operator's salary: $90,000, plus 35 per cent on-costs.
- Restructuring cost (First year only): $180,000.
- Employee training costs are projected as follows:

First Year $25,000
Second Year $35,000
Third Year $10,000

- Increase in working capital required: $60,000.
- Salvage value: $75,000.
- Manufacturing cost savings per annum: $1,200,000.

• Sale of now obsolete equipment over the next two years.

Sale of Equipment Year 1 Year 2
Acquisition Cost $170,000 $305,000
Accum Deprecistion $1,013,000 $215.00
Sale Proceeds $30,000 $140,000

o Company cost of capital: 10%

o Tax rate: 30%.

I need your help for accounting assignment.

Reference no: EM131049844

Questions Cloud

What is the historical relevance of the context you selected : Decision Making: Describe the potential for consumption-related decision making given the cultural context in question. Provide three (3) examples of the purchases that might be involved for consumers participating in the context you selected.
Households with a horse : 36% of all U.S. households have a pet dog. 34% of all U.S. households have a pet cat. 2% of all U.S. households have a horse, and interestingly- 80% of households with a horse, also own a dog (of course, households with a horse and a dog would als..
What is a momentum of 1 mev/c in kg•m/s : What is a momentum of 1 MeV/c in kg•m/s
Write on thesis statement for the individual versus society : Who can complete a complete paragraph based on the thesis statement for ‘the individual versus society'? You'll select at least one literary work such as "The Lottery" by Shirley Jackson which is a short story about the dangers of mob mentality
Prepare common size comparative profit : Prepare common size comparative profit and .s accounts for the three-year period - prepare all relevant financial statement ratios for 2014 and 2015 (Cash Flow ratios are not required).
Money spent to buy food : Maria spends $18 on lottery tickets every week and spends $140 per month on food. On an annual basis, the money spent on lottery tickets is what % of the money spent to buy food.
Show that this is not the case in relativistic mechanics : Show that this is not the case in relativistic mechanics. [Hint: Remember that the four-momentum p is supposed to transform like a four-vector.]
Common factor for the coefficients : The student factored 14x^5y^2+7xy as 7xy(2^4y) what went wrong? Factor correctly select the correct choice below and if necessary, fill in the answer box to complete your choice. A. The common factor for the coefficients, 7, is not correct. the cor..
Compose real estate business mission and vision statement : Compose and post your real estate business mission and vision statement for your classmate to review. Discuss which of your core values it incorporates and why you included them in the statement.

Reviews

Write a Review

 

Accounting Basics Questions & Answers

  Wads county maintains an investment pool in which it

wads county maintains an investment pool in which it invests funds both for wads county and for all legally separate

  A company is planning to introduce a new portable tv to its

a company is planning to introduce a new portable tv to its existing product line. management must decide whether to

  Conduct an audit of anorganisation or part of

conduct an audit of anorganisation or part of anorganisation or a process of your choice vis-agrave-vis the provisions

  The cost of the annuity was 46800 and cecil was expected to

cecil c. seymour is a 646-year-old widower. he had income for 2013 as followspension from former employer 39850interest

  What should the calculation of the current ratio

The following financial information, what should the calculation of the current ratio (current assets/current liabilities) be using US GAAP and IFRS?

  Financial year jackson ltd sell inventory to action ltd at

financial year jackson ltd sell inventory to action ltd at a sales price of 700 000. the inventory cost jackson ltd 420

  The adjusting entry to record depreciation

The adjusting entry to record depreciation for the company automobile

  The usual manner and dumped the draft on ted

The mayor applied his red pencil in the usual manner and dumped the draft on Ted, desk. What should Ted do?

  A comparison of the statement with the cash account

On May 31, 2014, Reber Company had a cash balance per books of $7,196.50. The bank statement from New York State Bank on that date showed a balance of $6,819.60. A comparison of the statement with the cash account revealed the following facts.

  Section anbspuse your kills to analyze compare criticize

section anbspuse your kills to analyze compare criticize evaluate and justify the answers in a process to solve the

  Prepare journal entries for the given transactions

Prepare journal entries for the above transactions and post the above transactions to T Accounts.

  Kobyashi moru reports its inventory fixed assets

kobyashi moru reports its inventory fixed assets depreciation and cost of goods sold on a current value basis fair

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