|
Partial Income Statement Year Ending 2014 |
|
|
Sales revenue |
$350,200 |
|
Cost of goods sold |
$141,800 |
|
Fixed costs |
$43,200 |
|
Selling, general, and administrative expenses |
$28,100 |
|
Depreciation |
$45,900 |
|
Partial Balance Sheet 12/31/2013 |
|||
|
ASSETS |
LIABILITIES |
||
|
Cash |
$15,900 |
Notes payable |
$14,100 |
|
Accounts receivable |
$27,900 |
Accounts payable |
$18,900 |
|
Inventories |
$48,000 |
Long-term debt |
$190,100 |
|
Fixed assets |
$368,000 |
OWNERS' EQUITY |
|
|
Accumulated depreciation (-) |
$141,500 |
Retained earnings |
|
|
Intangible assets |
$82,000 |
Common stock |
$131,800 |
|
Partial Balance Sheet 12/31/2014 |
|||
|
ASSETS |
LIABILITIES |
||
|
Cash |
$26,200 |
Notes payable |
$11,800 |
|
Accounts receivable |
$18,900 |
Accounts payable |
$24,100 |
|
Inventories |
$52,800 |
Long-term debt |
$162,000 |
|
Fixed assets |
$447,800 |
OWNERS' EQUITY |
|
|
Accumulated depreciation (-) |
Retained earnings |
||
|
Intangible assets |
$81,800 |
Common stock |
$182,000 |
The company paid interest expense of $18,300 for 2014 and had an overall tax rate of 40% for 2014. Complete the statement of retained earnings for? 2014, and determine the dividends paid last year.
In: Finance
Our company has the following partial Balance Sheet:
|
Cash |
$1,000,000 |
|
Unearned Revenue |
$70,000 |
|
Common Stock $1 par 2,000,000 shares issued |
$2,000,000 |
|
Paid in Capital in excess of par – Common Stock |
$500,000 |
|
Treasury Stock $10 cost |
$150,000 |
|
Paid in Capital in excess of cost basis – Treasury Stock |
$15,000 |
|
Retained Earnings |
$640,000 |
|
Preferred Stock $1000 par 6% |
$600,000 |
|
Paid in Capital in excess of par – Preferred Stock |
$200,000 |
In: Accounting
|
(RM MILLION) |
FOR THE YEAR ENDED 31 DECEMBER 2019 |
|
|
2018 |
2019 |
|
|
INCOME STATEMENT |
||
|
1.Revenue |
10,638 |
11,860 |
|
2.Net total expenses |
9,419 |
11,136 |
|
3.Operating profit |
1,219 |
725 |
|
4.Profit before taxation |
1,335 |
-522 |
|
5.Taxation |
360 |
238 |
|
6.Net profit |
1,695 |
-283 |
|
BALANCE SHEET |
||
|
7.Deposits, cash and bank balances |
3,327 |
2,588 |
|
8.Total assets |
18,550 |
25,595 |
|
9.Net debt (Total debt - Total Cash) |
287 |
-2,159 |
|
10.Shareholders' equity |
6,185 |
2,911 |
|
CASH FLOW STATEMENTS |
||
|
11.Cash flow from operating activities |
353 |
2,081 |
|
12.Cash flow from investing activities |
9,049 |
4,660 |
|
13.Cash flow from financing activities |
-8,087 |
-7,584 |
|
14. Net Cash Flow |
1,316 |
-842 |
|
FINANCIAL PERFORMANCE (%) |
||
|
15. Return on total assets |
9.1 |
-1.1 |
|
16. Return on shareholders' equity |
27.4 |
-9.7 |
|
17. R.O.C.E. (EBIT/(Net Debt + Equity)) |
30.0 |
34.0 |
|
18. Operating profit margin |
11.5 |
6.1 |
|
19. Net profit margin |
15.9 |
-2.4 |
|
20. Overall performance of AirAsia for the year 2019. |
? |
|
In: Finance
Contribution Margin Analysis:
We calculate contribution margin by taking our sales revenue less our variable costs. This basically tells us the portion of our sales that are available to cover the fixed cost of the business.
Contribution margin per unit is especially useful. We compute this by taking our sales revenues per unit less our variable cost per unit. With this, we can easily compute our break-even point.
Dog Day Care
Pricing at $18 per dog per day, you can expect to have 22 dogs per day
Pricing at $20 per dog per day, you can expect to have 15 dogs per day
Pricing at $25 per dog per day, you can expect to have 10 dogs per day
· Overnight Boarding
Pricing at $25 per dog per day, you can expect to have 12 dogs per day
Pricing at $28 per dog per day, you can expect to have 10 dogs per day
Pricing at $430 per dog per day, you can expect to have 7 dogs per day
Basic Groom
Pricing at $25 per dog per day, you can expect to have 5 dogs per day
Pricing at $30 per dog per day, you can expect to have 4 dogs per day
Pricing at $35 per dog per day, you can expect to have 3 dogs per day
Break-Even Analysis:
Break-even analysis is a key element of cost-volume-profit analysis. The technique is helpful for new and small businesses to assess the viability of their start-up. However, it can also be quite beneficial for established businesses when evaluating new and existing product lines.
In this exercise, we are computing not only the break-even point but also the number of units that must be sold in order to earn given levels of target profit.
The break-even formula is:
Fixed Costs / Contribution Margin per Unit
The formula to compute the level required for a target profit is:
(Fixed Costs + Target Profit) / Contribution Margin per Unit
We have already computed fixed costs for each area in our Milestone One. We will be using these figures as follows:
Grooming, fixed costs: 2,367.92
Daycare, fixed costs: 859.39
Boarding, fixed costs: 1,378.99
Our computations would then be as follows:
Grooming
Sales Price $25
Break-even: 158
$1,000 Profit: 225
$1,500 Profit: 258
Sales Price $30
Break-even: 119
$1,000 Profit: 169
$1,500 Profit: 194
Sales Price $35
Break-even: 95
$1,000 Profit: 135
$1,500 Profit: 155
Daycare
Sales Price $18
Break-even: 65
$417 Profit: 97
$667 Profit: 116
Sales Price $20
Break-even: 57
$417 Profit: 84
$667 Profit: 101
Sales Price $25
Break-even: 43
$417 Profit: 64
$667 Profit: 76
Boarding
Sales Price $25
Break-even: 79
$583 Profit: 112
$909 Profit: 130
Sales Price $28
Break-even: 67
$583 Profit: 96
$909 Profit: 111
Sales Price $30
Break-even: 61
$583 Profit: 87
$909 Profit: 102
| Break-Even Analysis | ||||||||||||||||||
| Instructions - Show all steps and calculations to determine the break-even, as well as the break-even for the target profit levels as outlined in the instructions. Round all decimals UP to next whole number | ||||||||||||||||||
| Grooming | Day Care | Boarding | ||||||||||||||||
| Break-even Units= | Break-even Units= | Break-even Units= | ||||||||||||||||
| Fixed Costs | Fixed Costs | Fixed Costs | ||||||||||||||||
| Cont. Margin | Cont. Margin | Cont. Margin | ||||||||||||||||
In: Accounting
| Date | Cash interest | Interest revenue | Amortization of discount | Discount balance | Amortized Cost |
| 7/1/2018 | $ 33,367 | $ 666,633 | |||
| 12/31/2018 | $ 42,000 | $ 46,664 | $ 4,664 | 28,703 | 671,297 |
| 6/30/2019 | $ 42,000 | 46,991 | 4,991 | 23,712 | 676,288 |
| 12/31/2019 | $ 42,000 | 47,340 | 5,340 | 18,372 | 681,628 |
| 6/30/2020 | $ 42,000 | 47,714 | 5,714 | 12,658 | 687,342 |
| 12/31/2020 | $ 42,000 | 48,114 | 6,114 | 6,544 | 693,456 |
| 6/30/2021 | $ 42,000 | 48,542 | 6,542 | 2 | 699,998 |
USING THE TABLE ABOVE PLEASE ENTER USING FORMULAS OR ENTER MANUALLY FOR THE FINANCIAL STATEMENT BELOW.
PLEASE EXPLAIN HOW YOU GOT YOUR ANSWER. THANK YOU
| For year ended | ||||
| Income Statement | 12/31/2018 | 12/31/2019 | 12/31/2020 | 12/31/2021 |
| Other revenue and expense | ||||
| Interest revenue | ||||
| Balance Sheet | 12/31/2018 | 12/31/2019 | 12/31/2020 | |
| Assets | ||||
| Investment in Bonds | $ 700,000 | $ 700,000 | $ 700,000 | |
| Less: Unamortized Discount | ||||
| Investment, net | $ 700,000 | $ 700,000 | $ 700,000 | |
| For year ended | ||||
| Statement of Cash Flows, assuming no other transactions | 12/31/2018 | 12/31/2019 | 12/31/2020 | 12/31/2021 |
| Operating Activities - Direct Method | ||||
| Interest Received | ||||
| Net cash flows from operating activities | ||||
|
Operating Activities - Indirect method, assuming interest revenue was only source of income |
||||
| Net Income | ||||
| Less: amortization of discount on Investment in bonds | ||||
| Net cash flows from operating activities | $ - | $ - | $ - | $ - |
| Investing Activities | ||||
| Purchases of Investments in Bonds | - | - | - | |
| Maturities of Investments in Bonds | - | - | - | |
| Net cash flows from investing activities | $ - | $ - | $ - | $ - |
In: Accounting
E4-16 (Comprehensive Income) C. Reither Co. reports the following information for 2014: sales revenue $700,000; cost of goods sold $500,000; operating expenses $80,000; and an unrealized holding loss on available-for-sale securities for 2014 of $60,000. It declared and paid a cash dividend of $10,000 in 2014.C. Reither Co. has January 1, 2014, balances in common stock $350,000; accumulated other comprehen-sive income $80,000; and retained earnings $90,000. It issued no stock during 2014.Instructions Prepare a statement of stockholders’ equity.
In: Accounting
|
Common Size Income statement |
||||
|
2017 |
2016 |
|||
|
$M |
Percentage |
$M |
Percentage |
|
|
Operating revenue |
2319 |
100% |
2375 |
100% |
|
Operating expenses |
-1666 |
-71.84% |
-1725 |
-72.63% |
|
Earnings before interest, tax, depreciation, amortisation, changes in fair value of hedges and other signifcant items (EBITDAF) |
653 |
28.16% |
650 |
27.37% |
|
Depreciation and amortisation |
-264 |
-11.38% |
-236 |
-9.94% |
|
Impairment of assets |
-10 |
-0.43% |
-4 |
-0.17% |
|
Loss on sale of assets |
-4 |
-0.17% |
-1 |
-0.04% |
|
Net change in fair value of electricity and other hedges |
-76 |
-3.28% |
-15 |
-0.63% |
|
Operating profit |
299 |
12.89% |
402 |
16.93% |
|
Finance Cost |
79 |
3.41% |
80 |
3.37% |
|
Interest Income |
2 |
0.09% |
2 |
0.08% |
|
Net change in fair value of treasury instruments |
55 |
2.37% |
-68 |
-2.86% |
|
Net profit before tax |
277 |
11.94% |
256 |
10.78% |
|
Income tax expense |
-80 |
-3.45% |
-71 |
-2.99% |
|
Net proft after tax attributed to the shareholders of the parent company |
197 |
8.50% |
185 |
7.79% |
|
Earnings per share (EPS) attributed to ordinary equity holders of the parent |
cents |
cents |
||
|
Basic and diluted earnings per share |
7.7 |
0.33% |
7.2 |
0.30% |
COMPREHENSIVE INCOME STATEMENT
|
COMPREHENSIVE INCOME STATEMENT |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
2017 |
2016 |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
$M |
Percentage |
$M |
Percentage |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Net profit after tax |
197 |
8.50% |
185 |
7.79% |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Other comprehensive income |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Intems that will not be reclassifed to profit or loss |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Asset revaluation |
428 |
18.46% |
889 |
37.43% |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Defferred tax on the above item |
-120 |
-5.17% |
-248 |
-10.44% |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Items that may be reclassified to profit or loss |
308 |
641 |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Net gain on cash flow hedges |
2 |
0.09% |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Exchange differences arising from translation of foreign operation |
1 |
0.04% |
-23 |
-0.97% |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Income tax on the above items |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
3 |
0.13% |
-23 |
-0.97% |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Other comprehensive income for the year, net of tax |
311 |
13.41% |
618 |
26.02% |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Total comprehensice income for the year, net of tax attributed to shareholders of parent company |
508 |
21.91% |
803 |
33.81% |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Using the following financial ratios for 2016 and 2017 periods, and other associated information available in the public domain, assess the financial health of MEL from the view of an investor. Liquidity ratios b) Asset management efficiency ratios c) Profitability ratios d) Market ratios Assume you are a banker evaluating a loan request from Meridian Energy Limited (MEL) for $220 million. Considering MEL’s recent earnings announcements and earnings forecast updates, what would be your concerns in deciding on approval or denial of the loan request? Use the company’s capital structure ratios for 2016 and 2017 in your explanation. |
In: Accounting
Trial Balance Transactions Required: 5 Assets, 2 Liabilities, 2 Equity, 1 Revenue, and 5 Expense accounts Jan 1 Owner invested $10,000 and recorded ownership in the company 2 Company paid current month's rent $500 7 Purchased merchandise to sell to customers on account from vendor TicWick Products $3,000 8 Sold to customer Mary Jones merchandise on account $1,600; cost of merchandise was $1,000 10 Signed a contract with a new supplier 15 Paid advertising from checking $100 17 Purchased a new computer from checking $250 20 Mary Jones paid her account balance in full. Amount deposited to checking account. 22 Paid legal fees $200 23 Purchased store equipment on account from Ace Supply $1,000. 25 Paid utilities $140 28 Paid 3 months of insurance $300 for coverage beginning Feb 1. 31 Paid Ace Supply for amount owed
In: Accounting
6. Hernandez Tool and Die has three service? departments:
|
Budgeted Department Costs |
||
|
Cafeteria, revenue of $70,000 less expenses of $210,000 |
$140,000 |
|
|
Engineering |
1,900,000 |
|
|
General factory administration |
850,000 |
|
Cost-allocation bases are budgeted as? follows:
|
Engineering Hours |
||||||
|
Production |
Worked for Production |
Total Labor |
||||
|
Departments |
Employees |
Departments |
Hours |
|||
|
Machining |
126 |
47,600 |
299,000 |
|||
|
Assembly |
455 |
25,500 |
713,000 |
|||
|
Finishing and painting |
119 |
11,900 |
138,000 |
|||
1. Supposed Hernandez allocates all service department costs directly to the production departments without allocation to other service departments. How much of the budgeted costs of each service department are allocated to each production department? Choose the most logical cost-allocation base for each service department. To plan your work, examine number 2 before undertaking this question.
2. The company has decided to use the step-down method of cost allocation. General factory administration would be allocated first, then cafeteria, then engineering. Cafeteria employees work 43,400 labor hours per year. There were 60 engineering employees with 356,600 total labor hours. Recompute the results in number 1, using the step-down method. Show your computations. Compare the results in numbers 1 and 2. Which method of allocation is best? Why?
3. For each type of cost assignment made in number 2 using the step-down method, indicate the assignment type.
In: Accounting
Among the ten accounting principles (measurement principle, revenue recognition principle, matching principle, full disclosure principle, going concern assumption, monetary unit assumption, time period assumption, business entity assumption, materiality constraint, ans cost benefit constraint), which one of these ten do you believe is the most important and why. (answer in 12 sentences)
In: Accounting