Assignment Tasks
Task 1: You have been appointed as the new Finance Manager of your company from 1st May 2016. Your first task of the position is to analyze the overall financial result and position of the business entity. Use financial statements (Income Statement and Statement of financial position) in 2013/2014 and 2014/2015 of your organization and provide your opinion on the present financial result and position based on the given financial statements. Your opinion should be presented in the form of report to the board of directors.
Your report should contain
- Introduction of the analysis with relevant measures such as Profitability, Short-term Liquidity, Long-term Stability and Efficiency
- Calculation of Relevant Accounting Ratios for each measure in both financial years.
- Comparison of ratios.
- Discussion of each measure with comparison and trend
- Your opinion and conclusion
Please provide income statement and statement of financial position in 2013/2014 and 2014/2015.
Task 2: Mr. Sam is a proprietor who produces garments to the local market. The business firm is carried out in a rented building. The business property is an insured entity and the insurance premium is paid by Mr. Sam as per the building rent agreement. The manager of the business receives a fixed amount of remuneration. Special payment should be made to the municipal council on the production activities carried out by all domestic garment producers. Sam is a member of Domestic Garment Association (DGA) and pays membership fee of Rs.25, 000/- annually. This association provides various services to the members so as to improve their businesses.
Fabric is the main materials used for garments and other raw materials are also used in the production. The factory uses electricity mainly for production activities. Factory labour force plays a vital role in the production process and it accounts for a considerable proportion of the total cost of the production. Special cleaning service is provided by a local cleaning service on every production day. Other cleaning services are done by company cleaning staff. Rs.60/- of special garment Tax must be paid for each unit of garment.
Following additional information is provided for the month of March 2015
Selling Price Rs. 1200
Direct materials Rs.220
Direct Labour Rs.360
Variable overhead Rs. 140
Total Fixed Cost Rs. 240,000
Normal production capacity of the business is 2000 units. Budgeted sales for April-2015 are 2200 units. Fixed cost remains unchanged in each month.
You are required to,
1. Identify Five fixed costs and Five variable cost in the Sam's Business.
2. Determine the break even production level for month of March.
3. Calculate Margin of safety for the month of April-2015.
4. Calculate the budgeted profit for April-2015.
5. Determine sales requirement to achieve a profit of Rs.100,000/- in March-2015.
6. Calculate contribution to sales Ratio.
7. Prepare Income Statement for Sam's Business for the month of March.
8. Explain the difference between Absorption Costing and Marginal Costing
Task 3: ABC Institute has provided following budgeted financial statements of a special project for five years. Initial Investment of the project is Rs.1, 500,000/- and cost of capital is determined as 10%. Ignore all taxes and other government dues.
|
ABC Education Services
|
|
Projected Income Statement
|
|
|
|
|
|
|
|
|
31st Dec-2016
|
31st Dec-2017
|
31st Dec-2018
|
31st Dec-2019
|
31st Dec-2020
|
|
|
|
|
|
|
|
|
Turnover
|
3,600,000.00
|
4,320,000.00
|
5,040,000.00
|
6,300,000.00
|
7,800,000.00
|
|
|
|
|
|
|
|
|
Less: Direct Cost
|
|
|
|
|
|
|
Lecture Fee
|
800,000.00
|
800,000.00
|
1,000,000.00
|
1,000,000.00
|
1,200,000.00
|
|
Tutorial Cost
|
200,000.00
|
250,000.00
|
275,000.00
|
275,000.00
|
400,000.00
|
|
|
|
|
|
|
|
|
Gross Profit
|
2,600,000.00
|
3,270,000.00
|
3,765,000.00
|
5,025,000.00
|
6,200,000.00
|
|
Less : Expenses
|
|
|
|
|
|
|
Staff Salary
|
600,000.00
|
600,000.00
|
720,000.00
|
720,000.00
|
720,000.00
|
|
Building Rent
|
900,000.00
|
900,000.00
|
960,000.00
|
960,000.00
|
960,000.00
|
|
Electricity
|
60,000.00
|
60,000.00
|
72,000.00
|
72,000.00
|
72,000.00
|
|
Telephone
|
60,000.00
|
60,000.00
|
72,000.00
|
72,000.00
|
72,000.00
|
|
Fuel
|
120,000.00
|
120,000.00
|
144,000.00
|
144,000.00
|
144,000.00
|
|
Travelling
|
72,000.00
|
72,000.00
|
72,000.00
|
72,000.00
|
72,000.00
|
|
Postage
|
36,000.00
|
36,000.00
|
60,000.00
|
60,000.00
|
60,000.00
|
|
Advertising expenses
|
300,000.00
|
300,000.00
|
420,000.00
|
420,000.00
|
420,000.00
|
|
Office Maintenance
|
48,000.00
|
48,000.00
|
84,000.00
|
84,000.00
|
84,000.00
|
|
Depreciation
|
185,000.00
|
185,000.00
|
185,000.00
|
185,000.00
|
185,000.00
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Net Profit/Loss
|
?
|
?
|
?
|
?
|
?
|
You are required to,
1. Explain the importance of budgeting in a business organization
2. Calculate Net profit or loss of the institute for next five years
3. Determine Net Cash Flows of each year
4. Calculate following capital budgeting measures
a. Payback period
b. ARR
c. NPV
5. Evaluate the project through the above measures and provide your recommendation for each measure.
Task 4:
1. Prepare a brief report by explaining the differences between Financial Accounting and Management Accounting for Non-accounting Managers of your organization.
2. Discuss the various pricing systems used by different organization according to the nature of the product or service they provide. Provide suitable examples for each system.
3. Identify and explain the difficulties faced by an organization in the process of cost reduction. Provide possible alternative cost reduction techniques in the business environment.
4. Prepare a brief report to the Management of an organization to provide a solution for "Internal conflict between Finance Department and other Non-financial Departments such as Marketing and Human Resource Departments".
Assignment link -
https://www.dropbox.com/s/pewqshz7oylv26w/Assignment.rar?dl=0.