Ask Question, Ask an Expert

+61-413 786 465

info@mywordsolution.com

Ask Accounting Basics Expert

ASSIGNMENT 

This assignment is to be completed in groups of three and carries 35 per-cent of the marks in this unit.

There are three parts - Part A ; Part B  and Part C

Student work will be assessed in terms of the following criteria:

1.Effectiveness of communication - i.e. readability, legibility, neatness, completeness and presentation will be a minimum threshold requirement for all written work submitted for assessment.

2.Demonstrated understanding of the subject matter covered - This will be evidenced by the student's ability to be analytical and the accuracy of submitted answers.

Note:
Certain aspects of these questions may require some assumptions to be made. Therefore, different answers are very acceptable. For ease of marking I would appreciate you specify these if you think it clarifies your decisions.
PART A: Broun Ltd

Comparative Profit and Loss Statements

 

$000’s

$000’s

$000’s

 

2013

2014

2015

 

 

 

 

Sales

30000

25000

20000

Less Cost of Sales

19500

15500

12000

Gross Profit

10500

9500

8000

Operating Expenses*

9390

8425

7080

Operating profit before 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

$000’s

$000’s

 

2013

2014

2015

 

 

 

 

Beginning Inventory

1000

1060

650

Plus Purchases

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 Balance Sheets

 

$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

 

 

 

 

Shareholder’s Equity

 

 

 

Share Capital ($1 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 loss 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 to 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
Assume rent is paid weekly but payable one month in advance
Electricity / Phone
Assume electricity / phone required when office rented.

Accounting Basics, Accounting

  • Category:- Accounting Basics
  • Reference No.:- M91873509
  • Price:- $30

Priced at Now at $30, Verified Solution

Have any Question?


Related Questions in Accounting Basics

Question - at the end of the year but before an adjustment

Question - At the end of the year, but before an adjustment had been made to close Manufacturing Overhead Control, A-1 Frames had the following account balances: Raw Materials Inventory$126,955Work in Process Inventory$1 ...

Question - at the beginning of the year anderson

Question - At the beginning of the year, Anderson Corporation's assets were $150,000 and its stockholders' equity was $100,000. During the year, assets increased $10,000 and liabilities decreased $10,000. a) What was the ...

Question - your client fred mertz is a calendar-year cash

Question - Your client, Fred Mertz, is a calendar-year, cash method taxpayer. He is the landlord of a building and is looking to sign a three-year lease with Ricky Ricardo. Ricky will move in December 1, 2017 and move ou ...

Question - net income 376557 preferred dividends paid 32735

Question - Net Income $376557: Preferred dividends paid 32735: Common dividends paid 80802: Unrealized holding loss, net of tax 5093: Retained Earnings, beginning balance 286878: Common Stock 176906: Accumulated Other Co ...

Question - on january 4 2017 ivanhoe company leased a

Question - On January 4, 2017, Ivanhoe Company leased a building to Vaughn Manufacturing for a ten-year term at an annual rental of $185000. At inception of the lease, Ivanhoe received $740000 covering the first two year ...

Question - if someone self employed earns 195000 what is

Question - If someone self employed earns $195,000, what is the total self employment tax liability? What is the self employment tax deduction?

Question - what is the present value of 7160 to be received

Question - What is the present value of $7,160 to be received at the end of each of 18 periods, discounted at 5% compound interest?

Question - given2018 pretax accounting income 4000002018

Question - Given 2018 Pretax Accounting Income: $400,000 2018 Municipal Bond Interest Income Included in Pretax Accounting Income: $20,000 2018 Warranty Expense of $70,000 for Accounting Purposes 2018 Actual Warranty Cos ...

Question - hillary clinton is the vice president of finance

Question - Hillary Clinton is the Vice President of Finance for Trump Industries. At a recent finance meeting, Hillary made the following statement: "the managers of a company should use the same information as the share ...

Question - below are three independent situationsa in

Question - Below are three independent situations. a. In August, 2018 a worker was injured in the factory in an accident partially the result of his own negligence. The worker has sued Wesley Co. for $800,000. Counsel be ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As