Literature Review
Literature Review
Literature Review
Expense
Current Assets
Closing Inventory
Trade and Other Receivables
Cash and cash equivalent
Total Assets
Cash Inflow
Loan 3,500,000.00
Revenue 16,848,000.00
Capital Injection for purchase of other non current assets 682,607.24
Total Cash inflow 21,030,607.24
Cash Outflow
- - -
18,014,400.00 19,271,520.00 20,627,136.00
682,607.24 682,607.24 682,607.24
18,697,007.24 19,954,127.24 21,309,743.24
46,440,847.24
-
22,089,736.80
682,607.24
22,772,344.04
(945,475.80)
(6,049,916.07)
(822,654.52)
-
-
(682,607.24)
(8,500,653.63)
14,271,690.41
60,712,537.65
Wine Food
Purchased
Number of bottles Sold 324.00
Expected no. of glasses/ bottle 5.00
Total no. Of glasses 1,620.00
Sold Sold
Glass
Av. consumption / person 2.50 Expected no. Of people / week
Expected no. Of people / week 180.00
450.00 Expected no. Of people / month
Expected no. Of glass / month 1,800.00
Rs
Selling Price / glass 300.00 Selling Price / plate
Total sales / Month 540,000.00 Total sales / month
Plate
Rs
ng Price / plate 1,200.00
sales / month 864,000.00
Wine
Purchased
Number of bottles Sold 324.00
Expected no. of glasses/ bottle 5.00
Total no. Of glasses 1,620.00
Rs
Av. Purchase price 128.81
3 Dr Salary
Cook 55,000.00
Help Cook 20,000.00
Help Cook 20,000.00
Diver 12,000.00 Yearly *Bonus
Monthly
Somelier 15,000.00 included
Waiter as from 6th mo 12,000.00
134,000.00 1,742,000.00
Cr Bank 134,000.00 1,742,000.00
4 Dr salary
Shareholder 1 50,000.00 600,000.00
Shareholder 2 50,000.00 Monthly 600,000.00 Yearly
Cr Bank 100,000.00 1,200,000.00
11 Travelling
12
Yearly *Bonus
included
14,040.00 5,850.00
600.00
180.00
225.00
180.00
1,500.00
3,510.00
23,400.00
PAYMENT SCHEDULE
LOAN SCENARIO LOAN SUMMARY
START DATE OF LOAN 1/1/2017 SCHEDULED PAYMENT
OPTIONAL EXTRA PAYME Rs 0.00 SCHEDULED # OF PAYMEN
LOAN AMOUNT Rs 3,500,000.00 ACTUAL # OF PAYMENTS
LOAN PERIOD IN YEARS 5 TOTAL EARLY PAYMENTS
PAYMENT FREQUENCY Monthly TOTAL INTEREST
ANNUAL INTEREST 8.50% COST OF LOAN