Download - Final Financials
Project Investment
Particulars No Per Unit Cost
Units 288 16,065 4,626,694 Cash in Hand 3,000,000 technology 7,626,694
AC expense 2 50,000 100,000 Energy savor 8 1,000 8,000 Fans 5 5,000 25,000 Whiring 1 25,000 25000Furniture #1 115,000 Total 273,000 Security 250,000 Rent 660,000 Paint 20,000 Bikes 4 42,000 168,000 Tablet 5 8,000 40,000 Laptop 2 35,000 70,000 Total 1,208,000 1,481,000 Total Investment 9,107,694
Capital 4,481,000
owner equi 2688600debt eqity 1,792,400
1.1
Particular No Per unit CostBoard 288 2000 576000 #1FurnitureCamera Particular No Per unit Cost5 MP 34.56 800 27648 Counter 1 10000 1000010MP 80.64 1200 96768 Gate 1 10000 1000015MP 120.96 1700 205632 Chairs 6 5000 3000025 MP 51.84 2700 139968 Table Offic 1 20000 20000Bettary Table Stor 1 7000 70001400 Mah 40.32 650 26208 Sofa Office 4 5000 200001600Mah 77.76 800 62208 Sofa Hall 6 3000 180001800Mah 106.56 1000 1065602200Mah 63.36 1350 85536 Total cost 115000Processor
2.6 23.04 3500 806403.1 129.6 3950 5119204.1 40.32 5450 2197444.2 95.04 5900 560736
LCDHD 224.64 4200 9434883D 63.36 8650 548064Assesories 288 549 158112Total 4349232
Fraight charges 60000Import tax 217461.6Total Cost 4626694
Per unit cost 16064.91
2016 2017
Particular No Per unit Cost Particular No Per unit CostBoard 396 2000 792000 Board 576 2000 1152000Camera Camera5 MP 47.52 750 35640 5 MP 69.12 750 5184010MP 110.88 1200 133056 10MP 161.28 1200 19353615MP 166.32 1700 282744 15MP 241.92 1700 41126425 MP 71.28 2700 192456 25 MP 103.68 2700 279936Bettary Bettary1400 Mah 55.44 650 36036 1400 Mah 80.64 650 524161600Mah 106.92 800 85536 1600Mah 155.52 800 1244161800Mah 146.52 1000 146520 1800Mah 213.12 1000 2131202200Mah 87.12 1350 117612 2200Mah 126.72 1350 171072
Processor Processor2.6 31.68 3450 109296 2.6 46.08 3450 1589763.1 178.2 3800 677160 3.1 259.2 3800 9849604.1 55.44 5300 293832 4.1 80.64 5300 4273924.2 130.68 5700 744876 4.2 190.08 5700 1083456
LCD LCDHD 308.88 4000 1235520 HD 449.28 4000 17971203D 87.12 8500 740520 3D 126.72 8500 1077120Assesories 396 500 198000 Assesories 576 500 288000Total+increment 6402884 Total+Increment 9313286
Fraight charges 70000 Fraight charges 80000Import tax 320144.2 Import tax 465664.3Total Cost 6793029 Total Cost 9858951
Per unit cost 17154.11 Per unit cost 17116.23
Pricing2015Expense Rupees Mobile price 15101.5Import Taxes 755.075Transport expense 208.333333333333Marketing&selling 8451.90972222222Total 24516.8180555556
Price 25000
Mark up 0.0193272777777776
Pricing 2017Expense Rupees Mobile price 16168.9Import Taxes 808.445Transport expense 138.888888888889Marketing&selling 4953.67881944444Total 22069.9127083333
Price 26250
Mark up 0.159241420634921
Pricing 2016Expense Rupees Mobile price 16168.9Import Taxes 808.445Transport expense 176.76767677Marketing&selling 6653.7121212Total 23807.824798
Price 26250
Mark up 0.09303524579
Infinity MobilesSales Budget
Amounts in RupeesNote 2015 2016 2017
Sales in units 1 288 396 576 Sale Price/unit 25,000 26,250 27,563 Sales in Rupees 7,200,000 10,395,000 15,876,000
Note 1(Sale)2015 2016 2017
Per day sale 0.8 1.1 1.6Per month sale 24 33 48Per year sale 288 396 576
Sales BudgetAmounts in Rupees
Note 2015 2016 2017Cost in units 1 288 396 576 Cost/unit 16,065 17,154 17,116 Cost in Rupees 4,626,694 6,793,029 9,858,951
Note 1(Sale)2015 2016 2017
Per day sale 1 1.5 2.5Per month sale 30 45 75Per year sale 360 540 900
Depriciation
Notes Bikes Laptops Tablets AC Fan Depreciation Balance as at Jan 2014 168,000 70,000 40,000 100,000 25,000 Deprciation 37,000 8,000 6,000 16,000 4,200 Net Book Value 131,000 62,000 34,000 84,000 20,800
Balance as at Jan 2015 131,000 62,000 34,000 84,000 20,800 Deprciation 37,000 8,000 6,000 16,000 4,200 Net Book Value 94,000 54,000 28,000 68,000 16,600
Balance as at Jan 2016 94,000 54,000 28,000 68,000 16,600 Deprciation 37,000 8,000 6,000 16,000 4,200 Net Book Value 57,000 46,000 22,000 52,000 12,400
if the firm is manufacturing and register Furniture and Fixture Total tech 30%
Furniture, moter 15% 115,000 518,000 building 10% 17,250 88,450 FBR 97,750 429,550 aordinance 2001
section 22 97,750 429,550 17,250 88,450 80,500 341,100
80,500 341,100 17,250 88,450 63,250 252,650
register firmsaordinance 2001
Marketing and saleries expenses
Note 2014 2015Fixed cost:
Salary 6 1,200,000 1,296,000 Selling and admin expense 7 427,150 458,770 Marketing Expense 8 807,000 880,100
Total selling, marketing & admin cost 2,434,150 2,634,870
Cash disbursements for selling & admin 2,434,150 2,634,870
6Salaries FC Per YearWorker 144,000 158,400 Cashier and receptionist 336,000 369,600 Sales Man 720,000 792,000 Total Salary 1,200,000 1,320,000
Payables as reported on closing balance sheet 100,000 108,000
7Over head cost(Selling & Admin) FC Per Year
2015 2016Repair and maintinance 50,000 55,000 Office stationary 40,000 44,000 Depericiation 88,450 88,450 Fuel 96,000 105,600 Utility Bills 5 152,700 165,720 Total Overhead Cost 427,150 458,770
5 2015 2016Unit Consumed 110,000 121,000 sales tax on electricity bill 18,700 20,570 DSL 24,000 24,150 Electric Bill 152,700 165,720 Total utility bill 152,700 165,720 Total utility bill 152,700 165,720
8 2015 2016
FM radio 192,000 211,200 Broushers 2,000 3,000 Social media 240,000 259,200 Road shows 13,000 14,300 Cabel oprator 360,000 392,400 Marketing Expense 807,000 880,100
Marketing and saleries expenses
2016
1,399,680 493,937 959,702 2,853,319
2,853,319
FC Per Year 174,240 406,560 871,200
1452000
116,640
FC Per Year2017
60,500 48,400 88,450 116,160 180,427 493,937
2017 133,100 22,627 24,700 180,427 180,427 180,427
2017
232,320 4,000 279,936 15,730 427,716 959,702
Income Statement
Infinity MobilePro Forma Statement of Comprehensive Income
Amounts in RupeesNote 2015 2016 2017
Sales 7,200,000 10,395,000 15,876,000 COG 4,626,694 6,793,029 9,858,951 Gross Profit 2,573,306 3,601,971 6,017,049 Selling and administrative expenses 2,434,150 2,634,870 2,853,319 Profit before tax 139,156 967,101 3,163,730 Tax 15 - 145,065 474,560 Profit after tax 139,156 822,036 2,689,171
0.0193272778 0.0790799589 0.1693859119
Notes to Pro Forma Comprehensive Income15Income Tax Rates available in Income Tax Ordinance, 2001http://www.softax.com.pk/PDF/ITO/Part%20I%20of%201st%20schedule%20Rate%20of%20Tax.pdf
Income Statement
http://www.softax.com.pk/PDF/ITO/Part%20I%20of%201st%20schedule%20Rate%20of%20Tax.pdf
Cash Flow StatementInfinity Mobile Inc.
2015cash from customers 7,200,000 Cash in hand 3,000,000 EBIT 139,156
Netcash from operating activiies 10,339,156 lessIncone tax - marketing and selling 2434150expense 963000assets 518000Total 3,915,150 Cash at the end of period 6,424,006
Cash Flow StatementInfinity Mobile Inc.
2016 2017 10,395,000 15,876,000 - 822,036 2,689,171 - 11,217,036 - 18,565,171
145,065 474,560 2,634,870 2,853,319 726,000 798,600 - 3,505,935 4,126,479
7,711,101 14,438,692
Infinity MobilesPro Forma Statement of Financial Position
Amounts in RupeesNote 2015 2016 2017
Current Assets:Cash 6,424,006 7,711,101 14,438,692 Securities 250,000 250,000 250,000
6,674,006 7,961,101 14,688,692 Non-current Assets:
Long term assets 429,550 341,100 252,650 429,550 341,100 252,650
Total Assets 7,103,556 8,302,201 14,941,342 Equity and Liabilities:Equity: Capital 4,481,000 4,620,156 5,442,193
Retained Earning 139,156 822,036 2,689,171 4,620,156 5,442,193 8,131,363
Liabilities:Accounts Payables 2,483,400 2,860,008 6,809,979
- - - 2,483,400 2,860,008 6,809,979
Total Equity and Liabilities 7,103,556 8,302,201 14,941,342
Notes to Pro Forma Statement of Financial Position 1,320,000 16Accounts Payable 2015 2016 2017Salaries Payables 1,200,000 1,320,000 1,452,000 Utility Bills Payables 152,700 165,720 45,273 Total Accounts Payables 2,483,400 2,860,008 6,809,979
Discounted Payback Period
Year Cash Flow
- 9,107,694 1 6,424,006 0.85 5,433,942 3,673,751 2 7,711,101 0.72 5,517,400 (1,843,649) 3 14,438,692 0.61 8,738,864 (10,582,513)
Pay Back Period in years 1.7Pay Back Period 1 year 6months
Net Present Value
Year Cash Flow
0 9,107,694 9,107,6941 6,424,006 0.85 5,433,9422 7,711,101 0.72 5,517,4003 14,438,692 0.61 8,738,864
NPV 28,797,900
PV Factor
Discounted Cash Flows
Recoverable Investment
PV Factor
Discounted Cash Flows
Breal Even AnalysisParticulars 2014 2015 2016
Variable cost Per unit 16064.91 17154.11 17116.23
Total Variable Cost 16064.91 17154.11 17116.23
Selling price 25000.00 26250.00 27562.50
C.M 8935.09 9095.89 10446.27
Unit to be Sold 288 396 576
Total Variable exp 4626694 6793028.6 9858950.72
Total Sales 7200000 10395000 15876000
Total C.M 2573306 3601971 6017049
C.M/Unit 8935.09 9095.89 10446.27
C.M Percentage 0.36 0.35 0.38
Total Fixed Expenses 2434150 2634870 2853319
Break even in units 272.425856 289.6770712 273.142476905
Break even in sales 869974.135 913008.786 1081416.03896