Investment Analysis: Source of Funds
Investment Analysis: Source of Funds
Investment Analysis: Source of Funds
Source of Funds
The funds of S&R Casing Company are provided by the business partners of the company. The total amounts
from different sources are as below:
Break-Even Analysis
Marketing Expenses
Newspaper advertisement and online advertisement = RM 3, 600
Production Expenses
Depreciation(RM)
Facilities 12 17, 267
Equipment 12 2,576
Machineries 10 14, 448
Total 34,291
826,091
= 13,324 units
8523
Years
Items
2016 2017 2018
Supplies 607,320 705,120 841,440
Wages 558,000 558,000 601,200
Marketing 3,600 3,600 3,600
Equipment and Machinery 24,000 24,000 24,000
Utilities 37,200 38,200 41,000
Miscellaneous 36,240 36,240 36,240
Other Charges 18,000 18,000 18,000
Total expenses 1,284,360 1,383,160 1,565,480
Sales
Average cost per unit = RM85
Years Annual Sales Total Supplies Sales (RM)
2016 24,000 2,040,000
2017 24,600 2,091,000
2018 25,100 2,133,500
Sales Tax
GST per annual sales = 6%
Contribution per unit = RM 85 - RM 23
= RM 62
Years Sales per Contribution per Annual GST (6%)
Unit Unit(RM) Profit (RM)
2016 24,000 62 1,488,000 89,280
2017 24,600 62 1,525,200 91,512
2018 25,100 62 1,556,200 93,372
Delivery Cost
Years Sales Delivery Cost Total (RM)
per Unit (RM)
2016 24,000 1 24,000
2017 24,600 1 24,600
2018 25,100 1 25,100
Sales Forecast
Year
Product Name 2016 2017 2018
(Units) (Units) (Units)
Iphone Case 3,000 3,600 4,100
Ipad Case 3,000 3,600 4,100
Samsung Case 5,400 6,000 6,500
Samsung Tablet Case 3,000 3,600 4,100
Xiaomi Case 4,200 4,800 5,300
Sony Case 3,000 3,600 4,100
HTC Case 2,400 3,000 3,500
Blackberry Case 1,800 2,400 2,900
Windows Phone Case 1,800 2,400 2,900
Total 27,600 28,200 28,700
Income Forecast
Average Year
Product Name Price per 2016 2017 2018
Unit (RM) (RM) (RM) (RM)
Iphone Case 80 240,000 288,000 328,000
Ipad Case 130 390,000 468,000 533,000
Samsung Case 80 432,000 480,000 520,000
Samsung Tablet Case 130 390,000 468,000 533,000
Xiaomi Case 80 336,000 384,000 424,000
Sony Case 80 240,000 288,000 328,000
HTC Case 80 192,000 240,000 280,000
Blackberry Case 80 144,000 192,000 232,000
Total 2,508,000 3,000,000 3,410,000
Profit Forecast
Income Forecast Establishment Cost Running Cost Profit/Loss
Year
(RM) (RM) (RM) (RM)
2016 2,508,000 3,278,824 1,284,360 (2,055,184)
2017 3,000,000 - 1,383,160 1,616,840
2018 3,410,000 - 1,522,280 1,887,720
Project Viability
Net Cash Flows Cumulative Net Cash
Year Description
(RM) Flows (RM)
Immediate Establishment cost (3,278,824) (3,278,824)
2016 Net profit before depreciation 1,257,931 (2,020,893)
2017 Net profit before depreciation 1,651,131 (369,762)
2018 Net profit before depreciation 1,922,011 1,552,249
Establishment cost can be recovered after S&R Casing Sdn. Bhd. operates for approximate three years. By the
beginning of year 2018, profit can be made since it has positive cumulative net cash. In addition, this project also
has a positive NPV that will increase the wealth of shareholder. The IRR value was also acceptable. Hence, it is
feasible to run this business plan.
Payback Period
2016 2017 2018
Actual Cash Flow (3,278,824) 1,257,931 1,651,131 1,922,011
Cumulative Cash (3,278,824) (2,020,893) (369,762) 1,552,249
Flow
Cash Payback = 2.7 years
Income Statement of S&R Casing Company for the Year 2016, 2017 and 2018
2016 2017 2018
(RM) (RM) (RM)
Sales 2,508,000.00 3,000,000.00 3,410,000.00
Cost of sales (607,320.00) (705,120.00) (841,440.00)
Gross Profit 1,900,680.00 2,294,880.00 2,568,560.00
Expenses
Establishment Costs (3,278,824.00) 0.00 0.00
Marketing (3,600.00) (3,600.00) (3,600.00)
Depreciation (34,291.00) (34,291.00) (34,291.00)
Maintenance (24,000.00) (24,000.00) (24,000.00)
Gross salaries (558,000.00) (558,000.00) (601,200.00)
Licenses 0.00 (25,000.00) (25,000.00)
Insurance (18,000.00) (18,000.00) (18,000.00)
Legal and auditing 0.00 (3,500.00) (3,500.00)
Telephone and internet (4,200.00) (4,200.00) (4,200.00)
Office supplies (12,240.00) (12,240.00) (12,240.00)
Electricity and water (33,000.00) (34,000.00) (36,800.00)
Delivery cost (24,000.00) (24,600.00) (25,100.00)
Interest expenses (5%) (21,875.00) (21,875.00) (21,875.00)
Net profit before tax (2,111,350.00) 1,531,574.00 1,758,754.00
Income tax (89,280.00) (91,512.00) (93,372.00)
Retained profit for the year (2,200,630.00) 1,440,062.00 1,665,382.00
Retained profit brought forward 0.00 (2,200,630.00) (760,568.00)
Retained Profit Carried Forward (2,200,630.00) (760,568.00) 904,814.00
Balance Sheet of S&R Casing Company for the Year 2016, 2017 and 2018
2016 2017 2018
(RM) (RM) (RM)
Assets
Current Assets
Cash at bank 50,000.00 1,450,000.00 2,700,000.00
Inventory(Supplies) 607,320.00 705,120.00 841,440.00
Trade debtors 10,000.00 30,000.00 40,000.00
Non-current Assets
Land purchased 1,700,000.00 1,700,000.00 1,700,000.00
Construction 1,200,000.00 1,200,000.00 1,200,000.00
Machinery 177,473.95 163,025.95 148,577.95
Depreciation (Machinery) (14,448.00) (14,448.00) (14,448.00)
Facilities 143,890.00 126,623.00 109,356.00
Depreciation (Facilities) (17,267.00) (17,267.00) (17,267.00)
Equipment 21,460.00 18,884.00 16,308.00
Depreciation (Equipment) (2,576.00) (2,576.00) (2,576.00)
Total Assets 3,875,852.95 5,359,361.95 6,721,390.95
Liabilities
Current Liabilities
Trade creditors 1,000,000.95 2,350,000.95 3,300,000.95
Tax payable 89,280.00 91,512.00 93,372.00
Bank Overdraft 3,800,000.00 300,000.00 200,000.00
Accruals 147,922.00 158,150.00 463,014.00
Non-current Liabilities
Loan 350,000.00 328,125.00 306,250.00
Total Liabilities 5,387,202.95 3,227,787.95 4,362,636.95
Owner's Equity
Capital 600,000.00 600,000.00 600,000.00
Retained profit (2,111,350.00) 1,531,574.00 1,758,754.00
Total Owner's Equity (1,511,350.00) 2,131,574.00 2,358,754.00
Conclusion
Based on the income statement above, it shows that our business is very potential in current market. As from the
payback period calculated under project viability, our total establishment can be regained within 3 years which is
approximately until March 2018. Since our product is unique and innovative, it will be able to attract the attention
from customers to try something new and increase the annual sales. In order to maintain the sales annually, our
company will make use of price strategy attract more customers. Since our product involved the electronic
components, we will ensured the products produced are perfectly safe to use and with quality guaranteed. Lastly,
S&R Casing Company goal is to produce environmentally friendly products to reduce carbon footprint in earth.
MME40001 Engineering Management II
Research Group 12
Title: Sustainable and Renewable Casing Company
Lecturer : Introduction:
Piraiarasi Chelladorai The general meeting was held on 1st of May 2015 by Chan Su Ming at 8.00a.m. in
Chan Su Mings House
Confirmation of Minutes:
Minutes of meeting was proposed by Lim Beng Hooi.
Tutor: Piraiarasi Meeting Content:
Chelladorai This meeting identified all fixed costs and confirmed all suppliers offered price and
our products prices. Then, we discussed about the source of funds, that we able to
get from loan and relative, and each one of us will contribute RM 200,000 as our
Chairperson: initial capital.
Chan Su Ming
At the end of the meeting, we distributed the workload as below: -
Lim Beng Hooi Establishment costs, Sales forecast,
Income forecast, Profit forecast and
Vice Chairperson: Project viability
Lim Beng Hooi Chan Su Ming Source of funds, Break-even analysis,
NPV, IRR, Payback Period,
Recommendations and Conclusion
Felix Running costs, Income statement,
Secretary: Felix Kok Balance Sheet and Cash flow statement
Closing
This meeting is ended at 9:30a.m.
CHAN SU MING
FELIX KOK
Chairperson
Secretary