The startup company plan to use the marketing budget as follows:

Estimated Salaries and wages

Startup expenses for Year 1 and assume Year 2 and 3 will increase variable expenses 10%

How much the variable expenses and fixed expenses for Year 1, 2 & 3?

Expected Cash inflow is as follows:

100800 USD	Year 1
195120 USD	Year 2
291600 USD	Year 3

Prepare the cash flow statement for Year 1, 2, 3?

Please calculate the Financial ratio Payback period, Internal rate of return, Return on Equity, WACC, BEP point, Net profit margin?

How do you think about financial feasibility? and how these ratios tell about the plan?

Estimate Market Budget Year3 Year 1 USD Year2 USD USD Digital Platform/ Digital Communication Facebook page, Website Development Mobile app, Facebook boosting 2,000 700 700 2,000 500 500 400 400 400 Advertising and Promotion Printing of Brochures, Logo stickers, Loyalty cards, Discount cards Promotion Gifts 400 400 400 Free tickets and referral promotion 1,000 1,000 1,000 costs 2,000 1,500 1,500 Public Relations and CSR Promotion Events, Booths, Invitation cost of traveler Bloggers, celebrities, CSR donation Total 7800 4500 4500 Monthly Salary & Wages 39 7,220 Employee Benefit Program (5% on total salary) 361 Total Monthly Salary & Wages 7,581 90,972 Estimated Salary & Wages - Year 1 Estimated Salary & Wages - Year 2 (Additional 10% on year 1) 100,069 Estimated Salary & Wages - Year 2 (Additional 10% on year 2) 110,076 Start-up Assets Amount USD Total USD Vehicles (Tuk Tuk) 54,000 Leasthold Property (Renovation Decoration) 2,000 Furnture & Fixture 800 Other Fixed Assets 2,500 Pre-opeing Salaries and Wages 7,220 Working Capital (Cash on hand) 8,680 Total Startup Assets 75,200 Website, GPS App, Booking Software and other IT facilities 4,000 Prepaid location rental for (12 months) 3,600 Contract with Maintenance Outsources (12 months) 1,200 Liscening/registration fees 3,500 Advertising & Promotion 2,000 Utalities 500 Total Operation Expenses 14,800 Total Required Fund 90,000