Discuss about the Management Accounting Upper Saddle River.
Items |
2017 |
2016 |
2015 |
2014 |
2013 |
Net Sales |
4,555.20 |
4,350.90 |
3,222.20 |
2,943.70 |
3,080.30 |
Profit After Tax |
966.20 |
1,166.20 |
919.90 |
799.30 |
462.90 |
Increase in Revenue with respect to 2013 |
47.88 |
41.25 |
4.61 |
-4.43 |
– |
Increase in Profit with respect to 2013 |
108.73 |
151.93 |
98.73 |
72.67 |
– |
In the sales for the said company we have witnessed growth. A little dip in sales for the year 2014. After which the sales have shown continuous growth. Sales have grown up to 48% from 2013 to year 2017. Some portion of growth in revenue for the company is related to inflation and most of it belongs to results in operational changes. The sudden growth of sales from 5% to 41% shows that there are some major changes made in the company which have resulted in high growth. The company has then managed maintained this growth rate in 2017. Highest growth in revenue was witnessed in with growth of 48% in sales.
After the year 2013, a high growth in profit margin was witnessed. Even though revenue fell by 4%, the net profit margin increased by 73% approximately. The increase in profit margin may be due to operating efficiency in the organisation. It seems that the company has implemented methods to make the most out of existing resources. This has resulted in increase in profit margin by up to 109% in year 2017. Though the revenue increase was 50%, the profit margin increased by 109%. This shows some serious development on the part of the company.
Formula |
Calculations |
||||||
Profitability Ratios |
2017 |
2016 |
|||||
Operating Profit Margin |
EBIT / Net Sales |
31/890 |
= |
3.48 |
197/1485 |
= |
13.27 |
Return on Assets |
EBIT / Average Total Assets |
31/22078 |
= |
0.14 |
197/19731 |
= |
0.998 |
Net Profit Margin |
Net Profit / Average Total Assets |
93/22078 |
= |
0.42 |
141/19731 |
= |
0.715 |
Return on Equity |
Net Profit / Average Owner’s Equity |
93/1268 |
= |
7.33 |
141/1224 |
= |
11.52 |
Financial Stability |
|||||||
Debt Ratio |
Liabilities / Total Assets |
533/1818 |
= |
0.29 |
18967/20260 |
= |
0.936 |
Debt to Equity |
Liabilities / Equity |
533/1285 |
= |
0.41 |
18967/1293 |
= |
14.67 |
Interest Cover |
EBIT / Interest Expense |
31/6 |
= |
5.17 |
197/27 |
= |
7.296 |
(Times Interest Earned) |
|||||||
Assets Utilization |
|||||||
Assets Turnover Ratio |
Net Sales / Average Total Assets |
890/22078 |
= |
0.04 |
1485/19731 |
= |
0.075 |
Profitability Ratios: the profitability of the company has declined from 13.27 to 3.48 from 2016 to 2017. The net profit margin for the group declined from 0.715 to 0.42. The contributors fro decline in revenue and profit was decline in business. The return in equity also declined from 11.52% to 7.33% in the current. Overall there was decline in business operations which led to low profitability.
Financial Stability: from the ratios above we can see that the balance sheet size of the group has decline drastically. The debt ratio of the company which was 0.936 times has now fallen to 0.29 times. The debt to equity ratio has declined from 14.67 to 0.41. The company has paid off its major debts which have led to decline in both debt and assets. The interest coverage ratio which used to be 7.30 times has now become 5.17 times. This is due to lower profits and lower interest expenses.
Asset utilisation: the company used to have a sale of 0.075 for every dollar spent on asset, now the company earns 0.04 for every dollar invested in asset.
Schedule of expected cash receipts from debtors |
||
Particulars |
January |
Feburary |
Cash received for sale for current month |
16,800 |
15,400 |
Cash received for sale for last month |
– |
25,200 |
Cash received from debtors for sale |
16,800 |
40,600 |
Calculation of Sales |
||
Particulars |
January |
Feburary |
Sales |
60,000 |
55,000 |
– Cash Sales |
18,000 |
16,500 |
– Credit Sales |
42,000 |
38,500 |
Cash Budget |
||
Particulars |
January |
February |
Opening cash balance |
85,000 |
1,06,800 |
Add: Receipts |
||
Cash received from debtors for sale |
16,800 |
40,600 |
Cash Sales |
18,000 |
16,500 |
Less: Payments |
||
Credit purchases |
– |
35,000 |
Office salaries |
10,000 |
12,500 |
Drawings |
3,000 |
3,000 |
Closing Cash balance |
1,06,800 |
1,13,400 |
The company has an instalment of $80000 due at the end of February. From the calculations above we can see that the company has a cash position of $113400 at the end of February. Also, the company requires maintaining a cash balance of $15000 in order to keep its solvency in check. Even if the company pays off its instalment of $80000, it would still have cash of $33400 left to spare.
In case if the company had shortage of cash, then they should opt for short term overdraft facilities. Therefore, the company is expected to have sufficient cash balance at the end of February in order to meet the instalment expense.
Sales Budget |
|||
Particulars |
Oct |
Nov |
Dec |
Sale – units |
22000 |
27000 |
32000 |
Sale – Amount |
121000 |
148500 |
176000 |
Purchases Budget |
|||
Particulars |
Oct |
Nov |
Dec |
Sale |
22,000 |
27,000 |
32,000 |
Add: Closing Stock |
8,100 |
9,600 |
9,000 |
Less: Opening Stock |
6,600 |
8,100 |
9,600 |
Purchases – Unit |
23,500 |
28,500 |
31,400 |
Purchases – Amount |
94000 |
114000 |
125600 |
Cash Budget |
||||
Particulars |
Oct |
Nov |
Dec |
Total |
Opening cash balance |
17,000 |
42,200 |
1,11,150 |
1,70,350 |
Add: Receipts |
||||
Cash received from debtors for sale |
9,900 |
12,100 |
14,850 |
36,850 |
Cash Sales |
1,08,900 |
1,33,650 |
1,58,400 |
4,00,950 |
Less: Payments |
||||
Credit purchases |
93,600 |
76,800 |
94,000 |
2,64,400 |
Closing Cash balance |
42,200 |
1,11,150 |
1,90,400 |
3,43,750 |
Atkinson, A. A. (2012). Management accounting. Upper Saddle River, N.J.: Paerson.
Datar, S. (2016). Horngren’s Cost Accounting: A Managerial Emphasis. Hoboken: Wiley.
Essay Writing Service Features
Our Experience
No matter how complex your assignment is, we can find the right professional for your specific task. Contact Essay is an essay writing company that hires only the smartest minds to help you with your projects. Our expertise allows us to provide students with high-quality academic writing, editing & proofreading services.Free Features
Free revision policy
$10Free bibliography & reference
$8Free title page
$8Free formatting
$8How Our Essay Writing Service Works
First, you will need to complete an order form. It's not difficult but, in case there is anything you find not to be clear, you may always call us so that we can guide you through it. On the order form, you will need to include some basic information concerning your order: subject, topic, number of pages, etc. We also encourage our clients to upload any relevant information or sources that will help.
Complete the order formOnce we have all the information and instructions that we need, we select the most suitable writer for your assignment. While everything seems to be clear, the writer, who has complete knowledge of the subject, may need clarification from you. It is at that point that you would receive a call or email from us.
Writer’s assignmentAs soon as the writer has finished, it will be delivered both to the website and to your email address so that you will not miss it. If your deadline is close at hand, we will place a call to you to make sure that you receive the paper on time.
Completing the order and download