E-Commerce Excel Financial Model

Background  The client required a Go-To-Market strategy for their online study assistance business or Educational Platform. The main idea focuses on getting customers to subscribe to their business and avail of the services they have to offer worldwide. A range of strategies and research was put into the creation of this marketing strategy. Objective This project's entire premise lies in creating an optimal Go-To-Market strategy for the client's education-based business. Challenge The main challenge presented was to meet the client's needs for developing the marketing strategy. He had no information regarding what he required, so the project revolved around extensive and hands-on research. All the details and planning were to be done by Oak Business Consultant, and it required stepping into a field that was largely new to the business. However, the client requested additional changes throughout the course of this project. So, much of the planning had to be revamped or re-done from scratch. Research We carried out excessive research to figure out what the students need. As a result, there were high periods of stress, anxiety, and financial limitations for the students when it came to this. Moreover, our main focus was to understand whether online help was something that students required.Key marketing strategies needed to be understood and taken a look at. We used a series of methodologies to conduct the research. These included the following:Secondary Research In-depth Customer Interviews Competitor Analysis Social Media Listening Marketing AgenciesFactual and viable data was generated through research to finalize the marketing strategy for the client.  Solutions For Marketing Strategy Oak Business Consultant offered the client a list of solutions for his Go-To-Market Strategy once presented with the fundamental research. Core Strategies And Branding The first thing that needed to focus on was what the business has to offer students. It means emphasizing on what makes the online study assistant business different. Here, we focused on the development and promotion of slogans, images, colors, and the delivery of the services. Marketing Funnel Strategy Another key aspect and highly researched part of the entire project was to create the marketing funnel. It explores the AIDA principle, which includes the attention, interest, desire, and action of the potential customers. We made sure to go over every aspect revolving this principle that would benefit the client in any way possible.  Website SEO Marketing Strategy A series of research indicated the essence of developing website SEO for the client's business. The strategy put forward by us presented the details of what factors to account for when adding content to the website. The Meta tags, internal linking, keywords, site structure, and CTA buttons were the main focus of the marketing strategy. Content Marketing Strategy For content marketing strategies, competitor analysis was necessary. With data from the analysis, it was easier for us to determine what information is relevant for the website to flourish. Oak Business Consultant studied the articles, case studies, and other relevant content of the competitors to help the client figure out how to create his website's content.Content marketing strategies also showcased how to optimize content for keywords along with promotional aspects of it. Our recommendations included promoting platforms such as Quora and Reddit. Social Media Campaigns Social media is one of the more relevant aspects of marketing in today's time. We made sure to incorporate this into the solutions. It offered the client details of the important stages of using social media for his marketing campaigns.Moreover, our research in this section denoted the various marketing agencies available for the client to use. The details included the cost breakup of each marketing agency as well. Marketing Tools Integration Finally, the assessment of a variety of tools took place to find out the best fit for the marketing strategy and needs of the client. These included Google Analytics, Goal Tracking, and Google Search Console. We further provided the client with social media management such as Hootsuite and email marketing tool setups. Business Plan The business plan for the client's project included the marketing plan, financial plan, marketing strategy, and a sales plan.For the marketing plans, we suggested a series of agencies through which the client could carry out his business's marketing requirement.Now, the financial plan focuses mainly on how much it would cost the client to carry out his marketing strategies. It mainly revolved around seeking help from agencies and their costs. Marketing agencies included Upwork, Stratigia, Freelancer, and Guru. So, he got a clear idea about what all their costs would be like.Moreover, Customer Acquisition Cost (CAC) was a huge part of the financial plan. And, it has very high importance when figuring out how much the customers will offer in return for the costs.The sales plan incorporated attracting students through their regular content on the platform such as an e-newsletter, and then luring the potential clients with a 60-minute free consultation between the tutor and the student. Outcome In conclusion, Oak Business Consultant delivered what the client asked for, the Go-To-Market Strategy for his business. The online study assistance business is now up and running with our input during the developmental stages. Lastly, the client required a few changes and wanted additional strategies covering SEO, Application Marketing, and Sales Bottom funnel. 

Background One of our USA based client working on a startup approached us to build a Financial Model from scratch. When the work got completed and delivered to this client, his friend, and business partner, who is also responsible for running her own separate Events Management and E-Store business, saw our impressive work and decided that she wants a Financial Model just like that. She loved our easy to understand the financial model. Even though she already had a Financial Model and Business plan, she said she wants a new financial model for her business. Problem Her business’s existing business plan was thoroughly made using advanced Excel formulas and too many advanced logical assumptions, which were not easy for her to understand and make changes by herself.After a few months of transforming her business idea into a reality, she found out that she needed to make a few changes to her financial projections. But as the model was hard to understand, she could not do it, and the analyst who made the first financial model was no longer available at that time.It meant that she had to hire another expert to make the required changes for her and encompass extra cost every time she has to make any changes. Solutions Oak Business Consultant became the advisor in this project for financial model and business valuation. The critical part was to analyze the market size and keep it dynamic as inputs so she may able to make future changes easily. Based on the market research, we built a financial model with the following services. Input Assumptions We built input assumptions of initial-investment, followed by Assets and operating expenses to forecast the expected costs. In the event management business, the variable cost increases as the transactions increase, like support staff cost (No. of employees increase when no. of transactions increase.We took the expenses and revenue growth based on the prior data of the company.Revenue Forecast In the first section of the income statement, we forecasted the no. of vendors registered, party planners, wedding planners, party venues, and the expected number of transactions on the E-Store. Along with that, we analyzed the churn rate of customers who are not doing any activity after registering for the client’s platform.After analyzing the no. of customers, we projected the revenue. This company has multiple revenue models. We calculated the income for each model separately.After compiling the revenue and expenses, we calculated the monthly and yearly income statements.Depreciation and Amortization Oak Business Consultant prepared the depreciation schedule because this project requires a significant investment in data security and safety measures. Cash Flow Statement We built cash flow analysis, which was linked with Income Statement and input assumptions. So that there was no need to add in the sheet, and the sheet change instantly. Balance Sheet Then we build a third and last financial statement, i.e., a Balance sheet. This was also linked with Input sheets and cash flow. Break-Even Point Every business has to know its breakeven point. It helps investors and entrepreneurs set the mark to put extra effort to cross this point. Dashboard Graphs speak more than numbers because they help both the investor and Entrepreneur see the graphical representation of the projection.We provide the following graphs in the dashboard sheet. Project Evaluations Being an Investor, you always want the comparison of the equity against the Investment. So, we helped them to determine the company’s worth based on his future earnings. We provided them discount cash flow, NPV, IRR, or free cash flow; also, we provide an analysis of Investment vs. equity comparison.Sensitivity Analysis When the business is in the initial stage, sensitivity analysis can predict the actual market or scenario when the company does lots of marketing. We did a sensitivity analysis for a client, having 3 kinds of situations for sales, i.e., Low, Moderate, and optimistic, and analyzed the outcome in different circumstances. It really helps the client to gain knowledge of what if a business could not achieve its sales target. 

Background - Case Study For TVOD TVOD- Transactional Video on Demand - Case study is about our client having TVOD Business i.e. when users buy content on a pay-per-view-basis. TVOD offers recently released material for a bunch of individuals - friends, and family.The internet has impacted the way we engage with each other and conduct social gatherings. It has led to profound innovation in the way we view content.There has been a worldwide decline in the attendance of the cinema audience. It becomes challenging to get some time for entertainment according to the announced schedule of cinema. Moreover, cinemas are bound to specific locations.The ongoing pandemic worsens the drop in the audience at cinemas to zero. The majority of the cinemas worldwide have closed, putting the global entertainment industry in pause mode.The problems mentioned above presented a market gap, and our Client innovatively countered this to give Pay per View experience On Demand through a platform similar to Netflix yet entirely new to the world. It means subscribers can see content as per their requirement, not when it is aired as per the wish of the broadcaster.Challenges - TVOD Business Since the company is in the growth stage. Hence, they wanted to know the growth rate of the company, its profitability, churn rate of customers, CAC analysis, and how much they have to put into the marketing budget.They use Oak Business Consulting services for:Financial analysis of the Income Statement Projections for 3 to 5 years CAC and CLV analysis Analyze which product is having huge profitability and Demand.“Oak Business Consultant helped Transactional Video on Demand Business by creating financial analysis and forecast their 5 years growth and profit. We also examine the company’s Fixed Cost, Expenses, CAC and CLV and Churn rate and compared to the industry average, so it gives insight about their performance.” Solutions To resolve this issue faced by our Client, we offered the company very logical solutions and delivered the following in this regards:a. Market Research:We conducted market research to find out the expected costs associated with the research and development of this Transactional Video on Demand (TVOD) platform, along with the likely administrative expenses.b. Financial Model:Oak Business Consultant constructed a financial model to predict company-specific revenues realistically projected over the next five years, comparing income and expenses with cash flow expectations to determine the feasibility of the project. Further contents of the financial model are explained below. Input Assumptions Oak Business Consultant has helped the TVOD company build a robust financial model.  OPEX We meticulously designed OPEX by analyzing the operating expenses of the company based on the Client's input. We calculated the predicted variable and fixed costs, including content, administration, marketing, and technical expenses.  Depreciation and Amortization We built the depreciation and amortization schedules. The company had a significant investment in intangible assets like software. The Financials We prepared an income statement and predicted future income in the years to come according to a revenue model that befit Transactional Video on Demand business. Therefore, the revenue model incorporates two separate streams, advertisements, and subscriptions. Moreover, in the case of subscription, we eliminated the churn subscribers to get net revenue.Moreover, we highlighted the present and expected financial position of the company through the balance sheet. Key Metrics We presented vital metrics to portray the operational analysis of the company. Dashboards Since we provided the company with a dashboard, it contains graphs that give a snapshot of the expected financial performance. Explain graphically helps to convey the standings better than the numbers. Project Evaluation The owner wanted to see how feasible his venture could be. We incorporated the equity raised so far, and the expected hurdle rate into the model. Moreover, we conducted a burn rate analysis to determine the total expenses. This helped us to predict the minimum investment that is required for the business to commence operations. Company Valuation Lastly, we predicted the value of the company with the help of all the relevant details. Hence, The valuation helps attract investors. 3. ResultsThey achieve a better insight into the company's product performance, Cost Analysis, Break-even point, and CAC with Payback. We also provide recommendations or steps to take action in the upcoming months for low Fixed cost and Profitability, Average service cost, CAC, CAC Payback Period, and Customer Lifetime Value. Oak Projection Model also helped the management to reduce 30% Cost to be in profit and track the Actual and Projected figures to measure the performance.

Background Restaurant Financial Model could be a daunting task because this industry works on a very different perspective. They require operational efficiencies in order to take maximum profit margin. Our client has a Thai Restaurant in Mexico. He was planning to open. Problem The client was planning to open his another branch in Mexico, so he needs some external capital investment, and require a financial projection for the second branch with consideration of his first branch sales and expenses. Solutions Oak Business shook hands with the client to become the official advisor in the project. Oak business core job is to forecast the restaurant’s capital need, assets requirements, burn rate and profit and loss.Restaurant business has a different perspective to analysis, as we couldn’t apply growth rate in the restaurant because the area is limited, irrespective of the population and demand. We can only serve to limited no. of customers as long as we have space. So in the restaurant model, business acumen open new branches to increase the revenue and profit. Similarly, restaurant business requires more operational efficiencies. If the kitchen gets late to cook cuisine, this means customers will wait until cuisine has been served, the customer will occupy the table and chair, means, for the time being, you cannot serve afterward customers.Oak business consultant provided the following services. Input Assumptions We built input assumptions of investment, followed by restaurant layout, assets, and operating expenses so that we can forecast the expected revenue. The layout is the most crucial element to consider first because restaurant revenue all depends on the design. If the model is efficient, so we could have more chairs and table in that space, means for customers can be served in a time period. Based on the Layout out, we make assumptions of the assets and operational expenses. Revenue Forecast/ Income Statement After getting the sense of layout, we search out the population and demand for the Thai cuisine. Moreover, we assume percentage of customers served based on the design. We calculated the inflow of no. of customers in a day, then weeks and then months. Also, we build design income statement, with the revenue and expenses that we expected to occur. All variable and fixed expenses are calculated in the sheet, including Salaries, Marketing, Content, Utilities, etc. Income StatementBased on the revenue model and cost structure, we build an income statement for 5 years. Cash Flow StatementWe built cash flow analysis, which was linked with Income Statement, input assumptions in a way so that there was no need to add in the sheet, and sheet change instantly. Balance SheetThen we build a third and last financial statement, i.e., Balance sheet, which was also linked with Input sheets and cash flow. Breakeven PointEvery business has to know its breakeven point. It helps investors and entrepreneur to set the mark so that they can put extra effort to cross this point. DashboardGraphs speak more than numbers because it helps both the investor or Entrepreneur to see the graphical representation of the projection.We following graphs in the dashboard sheet Project Evaluation of Restaurant Financial Model  After completion of all the restaurant's projections, investor and, entrepreneur needs to evaluate the forecasting model. This evaluation sheet helps them to check the feasibility and viability of the project.Oak Business Consultant provided NPV, IRR, Free Cash Flow analysis, WACC, and payback period as well. Our report will not help them to evaluate the project but also help them to know the equity that investor should take against the investment. .

Background Since the e-commerce market is booming in Australia, we decide to choose online selling for the list of products. Hence a number of investors based in Australia are wondering to enter into the fashion/ luxury business. Problem Since the client is A series investor, he didn’t get much time for market research. On the other hand, he wants realistic and factual market research and expected growth in the sector as well. Along with that, the client also wants consumer behavior so that we get forecasting of the consumer taste and choice preference. The client has decided on three categories to start with. So he needs to gain insight, which category will be more profitable and the expected return. OpportunityOak Business Consultant provides him with depth market research for each category with the following subheadings. Demand Analysis of E-Commerce Market Since it is the first step, to begin with, hence, we analyzed the current market. Afterward, we did the trend analysis on the market. Also, we identify consumer demographic. We provided the following research in the e-commerce heading.Customer Profile. Consumer Demographics. The reason why people buy from e-commerce in Australia. SWOT analysis. The market in Australia.Categories Research The client want depth research in four categories, following are the listLuxury handbags Woman Scarves Luxury Chocolates Homeware and ApplianceSo in each category, we gave them google trend for each category, along with the market shares of each category and expected return of each category.The following are the subheadings research that Oak Business Consultant provided in each category.Google search trend The potential growth rate analysis Market Demand in Dollar Churn rate analysis Customer demography Monthly or yearly expenditure on each category by families SWOT Analysis Total Market share, (TAM, SAM, SOM) Region-wise sales

SVOD: Background The Case Study is of a company Ten Time that is a Video Streaming company fall under the SVOD industry. SVOD stands for Subscription Video on Demand is a type of service, where you enter into a subscription agreement, which will then grant you access to the service typically to watch until you unsubscribe, that means to watch with no limits. SVOD: Problem Ten-time is in a growing stage, and they are going to expand their reach and looking for fund injection from the investor in the form of equity and bond. Client needs a financial model that depicts his business, growth, and especially its company evaluation so that it gives value to investors. SVOD: Solutions Oak Business accepted this opportunity to build a financial model of the newly growing industry. Oak business consultant provided the following services. Input Assumptions We built input assumptions of investment both from equity and bond, that client was going take from investor and took the real company’s data of CAPX, OPEX, and no. of subscriptions.OPEX and CAPX structure We built a tangible and intangible assets list with the date of inclusion that is required to purchase in order for smooth operations of SVOD business. Along with that, we analyzed the operating expenses base on the data that we took from the client. All variable and fixed expenses are calculated in the sheet, including Salaries, Marketing, Content, Utilities, etc. Depreciation and Amortization Oak Business Consultant prepared the depreciation and amortizations schedule because this project requires a big investment for fixed tangible or intangible assets likes Networking and software. SVOD: Subscription and Revenue model In the SVOD industry, the revenue is based on no. of subscriptions. We build a detailed revenue model for video and music content with the consideration of marketing and subscription on a monthly bases. Along with that, we also made an account for lost subscriptions as well.Income Statement Based on the revenue model and cost structure, we build an income statement for 5 years.Cash Flow Statement We built cash flow analysis, which was linked with Income Statement, input assumptions in a way so that there was no need to add in the sheet, and sheet change instantly.Balance Sheet Then we build a third and last financial statement, i.e. Balance sheet, which was also linked with Input sheets and cash flow.Break even Point Every business has to know its breakeven point. It helps investors and entrepreneur to set the mark so that they can put extra effort to cross this point.Key Metrics We provided him with key metrics, in order to analyze their operational performance.Dashboard Graphs speak more than numbers because it helps both the investor or Entrepreneur to see the graphical representation of the projection. We following graphs in the dashboard sheetProject Evaluation After completion of all the projections, an Investor and, an entrepreneur needs to evaluate the forecasting model. This evaluation sheet helps them to check the feasibility and viability of the project. Oak business consultant provided NPV, IRR, Free Cash Flow analysis, WACC, and payback period as well. Our report will not help them to evaluate the project but also help them to know the equity that investor should take against the investment. Along with that, we provide a proper valuation of the company including Enterprise Value, Market Value, upside value.Intellectual Property Valuation Client needs an extra valuation for his company. He needs to know his intellectual value based on his past and future performance. Oak Business Consultant, also provided him with the detail formulation of his intellectual property valuation.Company Valuation Last but not least, client need, the client also wants his company valuation base on his 5-year future earnings, so that it helps him to in front of an investor.

Background The Africa based company is providing digital payment solutions for the African populations. Although this concept is not new for the world in Africa it is breaking the traditional norms. They are not only providing digital transfer for local currency but also assisting in currency conversion specially for USD to local currency. Along with that, they are providing insurance to clients as well, which is another revenue model. Problem This firm was growing well as their subscription increases day by day. Now planning to get external investment from an investor to reach out to more people. For that purpose, they require a business proposal and financial model that represent the company’s financials and expected future earnings. Solutions Oak Business Consultant became the advisor in this project for financial model and evaluation. The critical part is to analyze the market size as there was no research available before. Based on the market research we built a financial model with the following services. Input Assumptions We built input assumptions of investment, followed by Assets, and operating expenses so that we can forecast the expected revenue. A company like this, increase the variable cost as the transaction increase, like support cost (No. of employees increase when no. of transactions increase. We took the expenses and revenue growth based on the prior data of the company.Revenue Forecast In the first section of the income statement, we forecasted the no. of subscribers sign up, along with that, we analyze the churn rate of customers who are not doing any activity after signing up. After analyzing the no. of customers, we projected the revenue. This company has multiple revenue models. We calculated the income for each model separately based on the no. of subscribers. After compiling the revenue and expenses, we calculated the monthly and yearly income statements.Depreciation and Amortization Oak Business Consultant prepared the depreciation schedule because this project requires a significant investment in data security and safety measures. Cash Flow Statement We built cash flow analysis, which was linked with Income Statement, input assumptions in a way so that there was no need to add in the sheet, and sheet change instantly. Balance Sheet Then we build a third and last financial statement, i.e., Balance sheet, which was also linked with Input sheets and cash flow. Break-Even Point Every business has to know its breakeven point. It helps investors and entrepreneurs to set the mark so that they can put extra effort to cross this point.Dashboard Graphs speak more than numbers because it helps both the investor or Entrepreneur to see the graphical representation of the projection. We provide the following graphs in the dashboard sheet.Project Evaluations Being an Investor, you always want the comparison of the equity against the investment. So, we helped them to determine the company’s worth based on his future earnings. We provided them discount cash flow, NPV, IRR, or free cash flow; also, we provide an analysis of Investment vs equity comparison as well.Sensitivity Analysis When the business is in the initial stage, it is stuff to predict the actual market or scenario when the company do lots of marketing. So we did a sensitivity analysis for a client, having 3 kinds of situation for sales, i.e. Low, Moderate and optimistic and analyzed the outcome in different circumstances. It really helps the client to gain knowledge of what if a business could not achieve their sales target or provide.

Background A Land Development company based in Edmonton, Canada. They are specialised in acquiring real estate such as growing land, build infrastructure for individual, mixed family, corporate, and tenants. Challenge The company was going to start a new project and was planning to acquire another land. But before that, they want proper research and analysis of the cost that is attached to the project and the profitability of the project. They wanted to have depth financial models, through which they can evaluate the project. Solution Oak Business Consultant helped him to build a dynamic and depth financial model so that they can play with the numbers in the forecast model. Real Estate business models have multiple factors to analyse, as the cost structure is very complex and link with many other industries, sectors like Steel, Cement, Engineering, and Plastics. The development cost of Real Estate would vary if any of the raw material cost increases. On the other hand, the land has to capitalise with maximum level, and they will have more houses, apartments, etc. So, real estate has a financial model which is far different and complicated as compared to SaaS or restaurant economic model as there is a lot of input variable to do a depth analysis. We created the model in the following way. Project Structure The first step to creating a project structure, how much percentage of the land area will be used for houses, apartments, and rental offices. We built a chart as an input assumption.Hard Cost We evaluated the hard cost. Hard cost consists of tangible assets that are needed to complete the construction. This means that the thorough analysis of cost that would be incurred in the project. This sheet not only provided the projection input but also provided an option for variance analysis when the project is completed. Following are the hard cost that we analysed.Water Treatment Plant Fire/ Irrigation / recirculation pumping Site Works Storm Water Management / Sewer Community Facilities & Amenities Domestic Water Supply Shallow Utilities Internal Roadway System Trail & Pathway Network landscaping Features Offsite Costs Concrete Work Surface Work Highway Intersection Contingency Allowance Sanitary Sewer Water Mains Fire Protection Mains Lot Services Waste Water Treatment Plant Intensive capital projects like in real estate have to control the cost so that the overall cost per unit would decrease. Similarly, the client needs to calculate the per-unit cost to build one house, apartment, or commercial building in order to determine the cost and the price. Oak business consultant also provided the per-unit cost analysis. Soft Cost Soft costs are the intangible cost, which includes architectural, engineering, financing, and legal fees, and other pre- and post-construction expenses. We created a detailed input chart in order to estimate the soft cost. Following are the head cost that we analysed.Architectural Design & Building Plans Professional Services Engineered Plans Fees Payable To CountyDevelopment Cost Furthermore, after analysing the hard and soft cost, we summarise both to determine the whole project cost.Revenue Model There are many phases of the land like houses for single-family, mixed family, duplex, apartments, and every phase will have different costing and value according to demand. We built a dynamic financial model, having input for every phase. So that we can forecast accurate revenue.Profit and Loss Forecasting After developing the cost structure and the revenue model, we compiled the data and built a profit and loss statement. Furthermore, we also created a sheet for data, so that it would easier for the client to conduct variance analysis. Project Evaluation Project evaluation is conducted with the help of a financial model which helps in checking the feasibility of any given project. After analysing the in-depth analysis of cost structure and expected value, we need to examine the project profitability. Moreover, Oak Business Consultant provided Evaluation tools, i.e. NPV, IRR, Payback period and ROI.Dashboard Last but not least, we provided them with a dashboard, which summarises the whole projection.

Background Our Client is a serial entrepreneur, who has invested in multiple businesses. Now he is willing to invest in e-commerce platform through foreign investment. This platform is a kind of niche market as he was only focused on a specific product.  Challenges Being an Investor Client wants to build a financial model to analyse the investment opportunity. Since he is based in Europe and going to invest in another country, so he had some contrasting demand for the financial model.He wanted a Currency conversion in the model. Deep analysis including transportation cost schedule and multiple sales channels. Sensitivity Analysis with multiple scenarios.Solutions Oak Business Consultant helps him to build a dynamic financial model so that he can play with the numbers in the financial model.We built the input button for Currency conversion and the whole financial model convert in that currency instantly.We provide the following services; Input Assumptions We build a model for 3 years and we put all the assumptions in one sheet so that investor can change the numbers easily.Amortization and Depreciation Schedule A business where there is a need to capitalized into fixed assets like machinery, equipment before commencing of the business. So investor necessarily wants to know the Assets valuations over an interval of time. This help the investor in valuations of the company.Oak Business Consultant provides a proper schedule of Amortization and Depreciation for tangible or non-tangible assets. User Acquisitions This e-commerce plan has many sales channel, i.e. B2C, B2B, Drop Shipping, Ads Space, listing, Client wanted the real projection of Customers from all channels. By taking the marketing budget and divide the portion to SEO, Instagram, Facebook, and Promotions. Then we analyze the customers that come from multiple marketing channels.Through this we were able to calculate the No. of Customers, his CAC and CLV.Three Financial Statements After determining the Customer Acquisition, We built the Income Statement, Cash Flow Statement and Balance Sheet.KPI’s / Key Metrics The next step was to measure the performance of the operations. Every industry has its own metrics to analyze, we build KPI metrics for E-Commerce in order to determine the performance.Oak Business Consultant developed the metrics on the month’s bases so that it gives a deeper analysis.We built Average Order Value for B2C, Average Order Value for B2B, Average Order Value, and Value per Visits, ARPA, Churn Rate, Net MRR, CAC, CLV, and CLA to CAC metrics.Dashboard Dashboards provide an unbiased and a comprehensive snapshot of the company’s performance overall. We provide profitability dashboard, key metrics graphs like CAC, CLV, MRR, Cash Flow graphs and Breakeven analysis. These dashboard helps the investor or management to understand broader view into one single sheet.  Project Evaluations Being an Investor, you always want the comparison of the equity he is taking against the investment. So, an investor wants to determine the company’s worth based on his future earning, Assets based or P/E multiple.We provide investor discounted cash flow, NPV, IRR or free cash flow, also we provide the analysis of Investment vs equity comparison as well.Sensitivity Analysis When the business is in the idea stage, it is stuff to predict the actual market or scenario when a business starts its operations. So we did a sensitivity analysis for a client, having 3 kinds of situation for sales, i.e. Low, Moderate and Optimistic. We also analyzed the outcome in different situations. Furthermore, it really helps the investor to gain insights into its profitability in case the business could not achieve their sales target or provide.

Case Study of VC - Background This Case study is about Narbashiyat who is the Angel and Venture Capitalist firm, based in Kuwait. Therefore, they have a pool of investors, who are keen to invest in and help entrepreneurs to find the business in their thoughts and turn thoughts into functioning technology with the solid business model. Challenges Since the Narbashiyat is the venture capitalist firm, and lots of companies approach them for funding, so they need to analyze every company thoroughly and in-depth before the injection of investment, and Narbashiyat could not able to handle or analyze every company properly as they have to deal with a pool of companies.Narbashiyat has few products in the pipeline, in which they want extensive financial analysis, and to know the current worth of the company/ product, so they can invest in accordingly. So, Oak Business Consultant provides extensive analysis and research with every aspect of the company,  Solution In this case study for VC, Oak business Consultant built financial models and analyzed the company in which Narbashiyat wanna invest, We Built Financial Model of Holding Company. Built Financial Models for Startups Due Diligence report Pitch DeckFollowing are the list of companies.BondiOak Business Consultant also built financial models and calculate their future worth of the company base of the DCF model, NPV and IRR.DuebusOak Business Consultant did extensive market research to test the real potential and develop the financial model including sales forecast, income statement, Cash flow statement, balance sheet, and break-even point. Oak Business Consultant also analyzed its NPV and IRR and compare with other products.  RAFRAF is a job searching platform, which needs a lot of govt data regarding unemployment rate and no. of companies are working inside the Kuwait Oak business did research to analyze the current situation of Kuwait and measure the success rate of RAF. We also built the financial model for RAF and calculate NPV and IRR. Comparison: After analyzing every company rigorously and building financial models of all the ideas/ companies, Oak business consultant did the comparison of all companies. Which provided the insight of products that has the highest NPV, hence, creating maximum wealth.Due Diligence Since these products are startups, so Oak Business Consultant has made due diligence report on these products We analyze the following aspects;Team profile: They have a very diverse team, having strong expertise in their field which makes them competitive for these startups. Technological road map. These products have strong evidence of success, as these products have enough market and seem to sustain their position in the future as well. Product’s architecture and infrastructure: All companies have built their website and Apps effectively, Along with that, Oak Business Consultant analyzed their operation procedure. Market Research: The market is growing and has a hidden demand, which will flourish in the future. Pricing Model: These products provide an effective pricing model and have different pricing according to their solutions.Pitch Deck Oak business develops a pitch deck for Narbashiyat as well. Hence, OBC articulate All companies business, operations and their future investment projects.  Following are the point that included in the pitch deck.Company history Narbashiyat funding process Future project detail Revenue Model and Due diligence prove Market Valuations and Key financials

Case Study of Retail - Background This case study of Retail business is about Threads of Apollo operating, who, as an online Leather brand offers various quality and exceptional design for men and women. It is based in Canada and the best part of this brand is having 2 successful consecutive years of the online campaign, hence became the choice of adults. Challenge Threads of Apollo is in the growth stage, so, now it is planning to launch his third campaign this year. Along with that, they plan to expand their offering & operations. To meet the future expectation, they are going to apply for a bank loan to fulfill their short term investment’s need. ToA needs a business proposal to submit in a bank, along with future sales projection and market research to prove for their business success. Solutions The case study shows how Oak Business Consultant took this opportunity and became the financial advisor of Threads of Apollo and provided the following services. Business Plan Oak Business Consultant writes a whole business plan to submit in a bank, in which we include:Company overview Product Detail Value Chain Analysis Market Research/ Future Outlook Marketing Plan SWOT/ PESTLE Analysis Business Model Canvas Three Financial ProjectionMarket research: Oak business Consultant gathered world Leather Sales and calculated Total Available market, then funnel down to Service Available Market, and Service Obtainable Market, so that there Company get know their market, where they can target.Product’s Revenue Oak Business Consultant Forecast each product sales separately. As ToA is an online business and E-commerce business has multiple occasions to market their product i.e. Black Friday etc, so we keep consider multiple events and also consider expected low sale’s months so that we get the real revenue.Costing Oak business Consultant calculated their Fixed and Variable costing in order to get accurate cost of goods. Financial Statement Oak Business Consultant builds clear and facile financial model, so it would give a comprehensive view of the business. We develop, Income Statement, Cash Flow Statement, Balance sheet, Break-even along with that Oak Business Consultant evaluate their payback period NPV and IRR. Income StatementCash Flow StatementBreakeven PointRecommendation to Bank In the end, the Oak Business Consultant also provides a recommendation letter as financial advisor of Thread of Apollo and give assurance of the business model.

1. Background of the Case Study This Case Study for NGO is about - Hub Care that is an Australian based NGO, that provides a unique and holistic service system to Government for sharing information across Social Service ecosystems, leading to improved outcomes for citizen engagement, increased productivity, compliance for services and improved government oversight.The company has a great contribution to their Society, so now they want extensive market research for their future social plans and for pursuing funds from the Government to initiate. 2. Challenge The case study of NGO will also look into some of the challenges the company was facing. The company was planning to initiate another social program to society, so they need funds from the Government and Investor for getting execute the project;So the need the following data analysis;Extensive Market Research Project Feasibility Analysis Company Current Valuations Financial Modeling Financial Analysis Budgeting Costing Patent Rights Valuations Pitch Deck.Hub Care outsourced this project to Oak Business Consultant, so, we did comprehensive market data and make feasibility,  company’s current, and future project Valuations. Oak Business Consultant also provides financial analysis, budgeting, costing and ROI analysis so that they can give benefit to society and increase standards.” 3. Solutions 3.1 Market Analysis Oak Business Consultant Provides a deep analysis of their Markets and gives the easiest presentation so that it gives clear meaning and insight to their stakeholders.3.2 Cost Benefits Analysis Oak Business Consultant provides a cost-benefit analysis for their future projects. Hence, we gave recommendations regarding a few cost overhead control and gave a plan for future expenditures plans.3.3 ROI Hub Care Provide ROI projections, only for 1 year, but also provide 5 year ROI, 8 year ROI with conventional Revenue and expenses analysis. Run Rate was mentioned especially so that it was easier to make sense of their investment utilization and Investment periods.This section Provides real and factual historical data and gives a clear insight about the future projection.3.3 ROI Oak Business Consultant provides current and predictive analysis for better decision making. Since Victoria is the second largest territory having 18.76% of the total number of substantiation in Australia.Hubcare also helps in Victoria Risk Framework and increases ROI in the investigation process with 77.27%.We provided provide that their solution helpsto reduce cost by 28.29% which means save $30.93 per child as a result total cost saving would be $ 280,704.Our Cost-benefit and Economic Impact analysis report also provides the following analysisThe Hubcare helps to reduce cost up to 50% Increase employee satisfaction 40% And, Increase employee retention up to 40% Increase delivery of reports 90% And, Increase data sensitiveness and reliability 98%.The Government spent a huge amount on consultation cost so our analysis helps Hub Care to reduce these consultation costs by providing analytics reports. Hence, ultimately It helps the Government to reduce expenditures.

Background - Case Study For SaaS This case study for SaaS is about Octopus Cloud that is the SaaS oriented Company based in Switzerland. It is specialized in SPLA tools and Reporting. The Company was growing well in terms of sales and getting new customers, but they faced losses in 2016,17. So, to evaluate the company’s financial health, Octopus Cloud outsources these services to Oak Business Consultant. Challenges - Case Study For SaaS Since the company is in the growth stage. Hence, they wanted to know the growth rate of the company, its profitability, churn rate of customers, CAC analysis, and how much they have to put into the marketing budget.They use Oak Business Consulting services forFinancial analysis of the Income Statement  Projections for 3 to 5 years CAC and CLV analysis Analyze which product is having huge profitability and Demand.“Oak Business Consultant helps Octopus Cloud for their Business and financial analysis and forecasted their 3 years growth and profit. We also examine the company’s Fixed Cost, Expenses, CAC and CLV and Churn rate and compared to the industry average, so it gives insight about their performance.” Solutions We gave Financial Analysis by giving following Metrics 1. Product Analysis Oak Business Consultant carefully analyzes the products/ services sales. So we come to know that 92% of revenue comes from only 8 products/ services out of 23 products services, it means they should focus on their top-line products and eliminate the low contributing product from their portfolio.2. Financial Health Analysis We provided cashback period with Profit and loss Statement with historical data analysis and 2-year forecast. 2.1 CAC Payback PeriodOak Business Consultant creates Break-Even Sheet to calculate their average revenue. We create a financial forecast for 2019 with 10% expected growth in revenue, but with the same average expense. Therefore, Oak Business Consultant recommended to reduce 30% Expenses, Mostly are fixed cost. 2.2 Break-Even Analysis2.3 Customer Lifetime Value Analysis3. ResultsThey achieve a better insight into the company's product performance, Cost Analysis, Break-even point and CAC with Payback. We also provide recommendations or steps to take actions in the upcoming months for low Fixed cost and Profitability, Average service cost, CAC, CAC Payback Period and Customer Lifetime Value. Oak Projection Model also helped the management to reduce 30% Cost to be in profit and track the Actual and Projected figures to measure the performance.