Rautamai Consultancy Construction and suppliers pvt. Ltd.
Bhaktapur
Projected Balance Sheet
As on end of ashad 20
Particualrs 2082/2083 2083/2084 2084/2085 2085/2086 2086/2087
Capital and Liabilities (Source of Fund)
Share capital
Authorised Capital 500,000.00 500,000.00 500,000.00 500,000.00 500,000.00
Paid-up Capital 500,000.00 500,000.00 500,000.00 500,000.00 500,000.00
Reserve and Surplus
Accumulated profit (Loss) 1,835,625.00 2,397,356.25 3,046,727.81 3,791,383.64 4,639,900.09
loan
Term Loan
OD 4,000,000.00 4,000,000.00 4,000,000.00 4,000,000.00 4,000,000.00
Current liabilities
Outstanding expenses
Trade & Payable 181,600.00 227,000.00 283,750.00 354,687.50 443,359.38
Provision
Provision for taxation 611,875.00 187,243.75 216,457.19 248,218.61 282,838.82
Total Capital employed 7,129,100.00 7,311,600.00 8,046,935.00 8,894,289.75 9,866,098.29
Asset & Property (Application of fund)
Fixed Asset
Total Fixed Assets 265,500.00 225,675.00 191,823.75 163,050.19 138,592.66
Current Asset
Cash and Bank balances 563,600.00 470,925.00 909,361.25 1,438,202.06 2,069,816.25
Account Receivables 3,500,000.00 3,675,000.00 3,858,750.00 4,051,687.50 4,254,271.88
Closing stock 2,800,000.00 2,940,000.00 3,087,000.00 3,241,350.00 3,403,417.50
Total Assets 7,129,100.00 7,311,600.00 8,046,935.00 8,894,289.75 9,866,098.29
Director
Rautamai Consultancy Construction and suppliers pvt. Ltd.
Bhaktapur
Projected Income Statement
As on end of ashad 20
Particualrs 2082/2083 2083/2084 2084/2085 2085/2086 2086/2087
Income
Sales/Service Charge Income 16,800,000.00 18,480,000.00 20,328,000.00 22,360,800.00 24,596,880.00
Less: cost of Goods sold; (11,760,000.00) (13,675,200.00) (15,042,720.00) (16,546,992.00) (18,201,691.20)
Gross Profit/ Gross margin A-B 5,040,000.00 4,804,800.00 5,285,280.00 5,813,808.00 6,395,188.80
Less:--_Office Expenses & Losses
Administrative Expenses (2,184,000.00) (3,696,000.00) (4,065,600.00) (4,472,160.00) (4,919,376.00)
Depreciation (88,500.00) (39,825.00) (33,851.25) (28,773.56) (24,457.53)
Earning before Interest & Tax (EBIT) 2,767,500.00 1,068,975.00 1,185,828.75 1,312,874.44 1,451,355.27
Less : Interest expenses (OD) (320,000.00) (320,000.00) (320,000.00) (320,000.00) (320,000.00)
Profit(Loss) before tax(EBT) 2,447,500.00 748,975.00 865,828.75 992,874.44 1,131,355.27
Less: Income Tax (611,875.00) (187,243.75) (216,457.19) (248,218.61) (282,838.82)
Profit(Loss) after tax(EAT) 1,835,625.00 561,731.25 649,371.56 744,655.83 848,516.45
Opening profit(Loss) - 1,835,625.00 2,397,356.25 3,046,727.81 3,791,383.64
Less: Drawing
Retined Earning 1,835,625.00 2,397,356.25 3,046,727.81 3,791,383.64 4,639,900.09
Director
Rautamai Consultancy Construction and suppliers pvt. Ltd.
Bhaktapur
Projected Cash Flow Statement
As on end of ashad 20
Particualrs 2082/2083 2083/2084 2084/2085 2085/2086 2086/2087
CASH FLOW FROM OPERATIONS ACTIVITIES
1. CashSales & Collection from Customers :
1.1 Sales revenue 16,800,000.00 18,480,000.00 20,328,000.00 22,360,800.00 24,596,880.00
Increase in Debtors (3,500,000.00) (175,000.00) (183,750.00) (192,937.50) (202,584.38)
Total Cash Collection (a) 13,300,000.00 18,305,000.00 20,144,250.00 22,167,862.50 24,394,295.63
2. Cash Payment ot Suppliers & Services :
2.1 Cost of goods sold (11,760,000.00) (13,675,200.00) (15,042,720.00) (16,546,992.00) (18,201,691.20)
Increase in stock (2,800,000.00) (140,000.00) (147,000.00) (154,350.00) (162,067.50)
Increase in creditors 181,600.00 45,400.00 56,750.00 70,937.50 88,671.88
Total cash payment to suppliers (b) (14,378,400.00) (13,769,800.00) (15,132,970.00) (16,630,404.50) (18,275,086.83)
3. Cash payment to employees & others :
3.1 Administrative Expenses (2,184,000.00) (3,696,000.00) (4,065,600.00) (4,472,160.00) (4,919,376.00)
Intrest Paid (320,000.00) (320,000.00) (320,000.00) (320,000.00) (320,000.00)
Income tax & other expenses - (611,875.00) (187,243.75) (216,457.19) (248,218.61)
Total Cash expenses (c) (2,504,000.00) (4,627,875.00) (4,572,843.75) (5,008,617.19) (5,487,594.61)
A. Net Cash flows from operatings Activities (3,582,400.00) (92,675.00) 438,436.25 528,840.81 631,614.19
(a+b+c)
CASH FLOW FROM INVESTING ACTIVITIES
Increase in Fixed Assets (354,000.00)
Net Cash flows from Investing Activities (B) (354,000.00) - - - -
CASH FLOW FROM FINANCING ACTIVITIES
Increase in Share Capital 500,000.00
Increase in Borrowing -
Increase(Decrease) in Bank loan 4,000,000.00 - - - -
Cash Withdrawn - - - - -
Net Cash flows from Financing Activities (C) 4,500,000.00 - - - -
Net Cash flows for the year (A+B+C) 563,600.00 (92,675.00) 438,436.25 528,840.81 631,614.19
Add: Opening Cash Balance - 563,600.00 470,925.00 909,361.25 1,438,202.06
Cash Balance at the Closing of the year 563,600.00 470,925.00 909,361.25 1,438,202.06 2,069,816.25
Director