Accounting assignment

profilempjumah
3_Year_Budget_Template1.xls

Overall Budget

Overall Budget
3-year Budget Sheet
1- P&L
From March 2017 to February 2020
Year - 1 Year - 2 Year -3
Mar-17 Apr-17 May-17 Jun-17 Jul-17 Aug-17 Sep-17 Oct-17 Nov-17 Dec-17 Jan-18 Feb-18 Mar-18 Apr-18 May-18 Jun-18 Jul-18 Aug-18 Sep-18 Oct-18 Nov-18 Dec-18 Jan-19 Feb-19 Mar-19 Apr-19 May-19 Jun-19 Jul-19 Aug-19 Sep-19 Oct-19 Nov-19 Dec-19 Jan-20 Feb-20 Total
Income
Income 0
Other income 0
Total Income 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Less Cost Of Sales
Cost of Sales (Direct) 0
Gross Profit 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Less Operating Expenses
Salaries and Wages 8950 8950 8950 8950 8950 8950 8950 8950 8950 8950 8950 8950 8950 8950 8950 8950 8950 8950 8950 8950 8950 8950 8950 8950 8950 8950 8950 8950 8950 8950 8950 8950 8950 8950 8950 8950 322200
Rent 1170 1170 1170 1170 1170 1170 1170 1170 1170 1170 1170 1170 1170 1170 1170 1170 1170 1170 1170 1170 1170 1170 1170 1170 1170 1170 1170 1170 1170 1170 1170 1170 1170 1170 1170 1170 42120
Advertising *Digital Ads 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 650 650 650 500 500 500 500 500 500 500 500 500 500 500 29450
Oparating Expense 0
Other Expense 0
Interest Expense 0
Depreciation Expense 0
Printing & Stationery 0
Subscriptions 420 420 420 420 420 420 420 420 420 420 420 420 420 420 420 420 420 420 420 420 420 420 420 420 420 420 420 420 420 420 420 420 420 420 420 420 15120
Vehicle Expenses 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200 7200
Repairs and Maintenance 0
Hospitality 0
Insurance 0
Profesional Fees 0
Indemnity 0
Leave 0
Telephone & Internet 300 300 300 300 300 300 300 300 300 300 300 300 300 300 300 300 300 300 300 300 300 400 400 400 400 400 400 400 400 400 400 400 400 400 400 400 12300
Travel 0 0 0 0 0 0 0 0 0 0
Governmental Expenses 0
Transportation 0
Staff Expenses 0
Bank Charges 0
Finance (Interest) Charges 0
Office Expenses 0
IT and Software 0
Miscellaneous Expenses 0
Cleaning Expenses 0
Social Security 0
Total Operating Expenses 11120 11120 11120 11120 11120 11120 11120 11120 11120 11120 11120 11120 11120 11120 11120 11120 11120 11120 11120 11120 11120 11120 10770 10770 10770 10620 10620 10620 10620 10620 10620 10620 10620 10620 10620 10620 428390
Net Profit -11120 -11120 -11120 -11120 -11120 -11120 -11120 -11120 -11120 -11120 -11120 -11120 -11120 -11120 -11120 -11120 -11120 -11120 -11120 -11120 -11120 -11120 -10770 -10770 -10770 -10620 -10620 -10620 -10620 -10620 -10620 -10620 -10620 -10620 -10620 -10620 -428390
2- Capital Expenditures
Construction of Buildings 0 0
Expansion in building 0 0
Computer equipment and electronics 13900 13900
Office Equipment 360 360
Purchase of Furnitures 3980 3980
Intangible assets ( copy rights- trade marks- patents- franchises ) 1500 1500
social media influncer 13500 8500 5500 27500
Software upgrades 240 240
Vehicles 0 0
Grand Opening Event 20000 20000
application development +Maintenance package 19400 19400
Branding and Printing 5580 5580
Total Capital Expenditures -240 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 92460
3- Number of Kuwaitis to be hired during the year 2017 2018 2019 2020