Vicky Ducasse
$15/hr
Accounting, audit and risk advisory
- Reply rate:
- -
- Availability:
- Hourly ($/hour)
- Age:
- 43 years old
- Location:
- Port Louis, Port Louis, Mauritius
- Experience:
- 20 years
Forecast
Forecast Income Statement for the 18 months to 31 December 2019
Actual
Year X0
Year X1
Revenue
Cost of sales
Operating profit
Administrative expenses
Provision for bad debts
Finance costs
Profit before taxation
Tax:
Income tax
30,754,369
(18,835,060)
11,919,309
(4,503,630)
(1,901,238)
(10,964)
(6,415,832)
5,503,478
Profit for the month
5,503,478
Forecast
Year X2
Year X3
3,000,000
(630,000)
2,370,000
(493,000)
4,500,000
(880,000)
3,620,000
(493,000)
6,750,000
(1,405,000)
5,345,000
(493,000)
(15,000)
(508,000)
1,862,000
(15,000)
(508,000)
3,112,000
(15,000)
(508,000)
4,837,000
(150,000)
(150,000)
(150,000)
(150,000)
(150,000)
(150,000)
1,712,000
2,962,000
4,687,000
STATEMENT OF FINANCIAL POSITION
Rupees
ASSETS
Non-current assets
Equipment
Current assets
Trade & other receivables
Inventory
Cash at bank
TOTAL ASSETS
EQUITY
Capital and reserves
Stated capital
Retained surplus
Total equity
Non Current liabilities
Loan
Current liabilities
Trade and other payables
Taxation
TOTAL EQUITY AND RESERVES
Year X1
Year X2
Year X3
1,270,720
1,270,720
1,160,587
1,160,587
928,470
928,470
2,000,000
5,762,897
1,706,861
9,469,758
10,740,477
2,875,000
4,750,030
29,541,861
37,166,891
38,327,478
2,500,000
6,504,147
34,101,861
43,106,008
44,034,477
2,500,000
7,215,478
9,715,478
2,500,000
10,177,478
12,677,478
2,500,000
14,864,478
17,364,478
25,000,000
25,000,000
25,000,000
25,000,000
500,000
150,000
650,000
38,327,478
1,500,000
170,000
1,670,000
44,034,478
875,000
150,000
1,025,000
10,740,478
CASH FLOW FORECAST
INFLOW
Receipt from debtors
Loan
Outflow
Payment of direct cost
Creditors
Sub-contractors
Materials
Payment of administrative cost
Wages & salaries and other staff cost
Motor vehicule running costs
Office utilities & administrative costs
Insurance
Payment of authorities
Payment of taxes
Payment of PAYE & NPS
Payment to MRA - agreed debt scheme
Net cash inflow/(outflow)
Opening cash balance
Finance cost
Closing cash balance
Year 1
3,000,000.00
Year 2
Year 3
3,000,000.00
4,500,-,000,-,500,000.00
6,750,000.00
6,750,000.00
(630,000.00)
(500,000.00)
(30,000.00)
(100,000.00)
(493,000.00)
(360,000.00)
(47,000.00)
(68,000.00)
(18,000.00)
(277,000.00)
(150,000.00)
(27,000.00)
(100,000.00)
(1,400,000.00)
(880,000.00)
(750,000.00)
(30,000.00)
(100,000.00)
(493,000.00)
(360,000.00)
(47,000.00)
(68,000.00)
(18,000.00)
(277,000.00)
(150,000.00)
(27,000.00)
(100,000.00)
(1,650,000.00)
(1,405,000.00)
(1,125,000.00)
(30,000.00)
(250,000.00)
(493,000.00)
(360,000.00)
(47,000.00)
(68,000.00)
(18,000.00)
(277,000.00)
(150,000.00)
(27,000.00)
(100,000.00)
(2,175,000.00)
1,600,-,860.70
(15,000.00)
1,706,860.70
27,850,000.00
1,706,860.70
(15,-,541,860.70
4,575,-,541,860.70
(15,-,101,860.70
