paper 6-7 pages

profilejmjapr06
businessmodel.xlsx
Home>Business & Finance homework help>Management homework help>paper 6-7 pages

Sheet1

particulars 1st year 2nd year 3rd year 4th year 5th year
mixers 104,000 104,000 114,400 119,600 124,800
cookers 46800 46800 57200 62,400 67600
purifiesr 36400 36400 41600 46800 5200
fryer 18200 18200 20800 26000 31200
food mixer 10400 10400 13000 15600 20800
freezer 41600 41600 46800 52000 62400
oven 62400 62400 67600 72800 78000
marketing 52000 52000 62400 67600 72800
graphic design 13,000 13,000 15600 20800 26000
mobile app 78,000 78,000 83200 88400 93600
revenue 462,800 462,800 522,600 572,000 582,400
particulars 1st year 2nd year 3rd year 4th year 5th year
total revenue 462,800 462,800 522,600 572,000 582,400
cost ofgoods 1000 2000 3000 4000 5000
gross profit 461,800 460,800 519,600 568,000 577,400
expenses
auditors fee 200 200 300 350 400
advertisement 1600 1600 1600 1800 1800
insurance 1000 1050 1103 1158 1216
F&F 2700 2754 2809 2865 2923
maintanance 600 600 700 700 800
miscellaneous 1800 1800 2200 2300 2700
telephone charge 180 180 190 190 200
internet 200 200 200 200 200
utilities 1000 1000 1000 1000 1000
depreciation 2200 2200 2200 2200 2200
total operating expenses 11480 11584 12302 12763 13439
operating profit 450,320 449,216 507,298 555,237 563,961
particulars year 1 year 2 year 3 year 4 year 5
starting cash 1000 1600 15672 35548 67160
sources
profit -1000 12472 22276 31412 40548
depreciation 2200 2200 2200 2200 2200
changes in inventory supplies -300 -300 -200 -200 -350
changes in accounts payable 400 400 300 300 250
expected new investor proceeds 7500
total sources 8800 14772 24576 33712 42648
uses
capital expenditure 6000 5000 3000 2000
net change in cash 2800 14772 19576 30712 40648
ending cash 3800 16372 35248 66260 107808
particulars 1st year 2nd year 3rd year 4th year 5th year
assets
cash 1000 1600 15672 35548 67160
inventories 200 500 800 1000 1200
total current assets 1200 2100 16472 36548 68360
long-term assets 1000 1050 1103 1158 1216
depreciation 2200 2200 2200 2200 2200
total assts 4400 5350 19775 39906 71776
liabilities and equities
accounts payable 1900 2850 17275 37406 69276
total current liabilities 1900 2850 17275 37406 69276
paid in capital 2500 2500 2500 2500 2500
total liabilties and capital 4400 5350 19775 39906 71776