MediumBusinessfinance

Startup Financial Model and Break Even Analysis

Added Jul 2026 3 design docs

A business plan that ends with the line 'we expect ₹15 lakh of revenue in year one' is a wish, not a plan. Thousands of small Indian ventures - cloud kitchens, tiffin services, print shops, two-chair salons - open every month on the strength of a rough feel for pricing and a hope that footfall will cover the rent, and a large share of them shut within eighteen months because nobody ever worked out how many units a day the business has to sell simply to survive. The one number that decides everything, the break-even point, is almost never on the founder's whiteboard.

The intern builds a complete three-year financial model for exactly that kind of venture: Tiffin Tribe, a student tiffin subscription service planning to launch from a rented kitchen in Kothrud, Pune. Working in excel, they construct a bottom-up revenue engine driven by subscriber additions, churn and three plan tiers, a per-meal cost sheet, a fixed cost and headcount schedule, a capex and depreciation table, a monthly profit and loss statement and a separate cash flow, then layer on a scenario switch, a break-even calculation and a two-way sensitivity grid. Every driver is traced back to a dated real price - kitchen rent from public rental listings, cook wages from job postings, container costs from a wholesale market - recorded in an assumption register kept in notion, and the whole argument is compressed into a twelve-slide investor-style deck in powerpoint.

Turning an idea into a defensible set of numbers, and knowing precisely which assumption breaks it, is the most transferable skill in commerce. The intern finishes able to speak fluently about contribution margin, fixed cost absorption, cash runway and sensitivity, which is the working vocabulary of FP&A, investment banking, consulting and startup finance interviews, and walks away with a live model and an evidence trail to open on a laptop rather than a claim on a page.

Related projects

Budget Analysis of a College Event

Every Indian college runs events, and almost none of them are costed properly. The annual fest, the department seminar, the farewell dinner, the inter-college sports meet: the money side usually lives in a WhatsApp group, a diary page and a shoebox of bills. Committees over-order biryani, the printing bill arrives at double the quotation, one sponsor pays in kind instead of cash, and when the event is over nobody can answer the only question the next committee actually needs answered, which is what this thing really costs per head. The intern picks one real event and produces a complete budget analysis of it. They collect bills, quotations, the sanction letter, the registration sheet and the sponsorship summary from the organising committee, interview the people who spent the money, and build a line-item cost model in excel that reconciles what was planned against what was actually paid. From that model they compute cost per attendee, variance by cost head, sponsorship recovery and break-even registration price, compare quotations for the three biggest spends, and package everything into a 14 to 18 page budget dossier, a 12-slide briefing deck in powerpoint for the next committee, and a blank reusable budget template the college can fill in before sanctioning the next event. Completing the project teaches the intern the working core of management accounting: tracing evidence to numbers, building a variance table that explains itself, running scenarios instead of guessing, and turning a messy pile of receipts into a document a faculty coordinator will actually act on. For B.Com, BBA and BA students aiming at finance, audit, operations or consulting roles, a costed post-mortem of a real event with real reconciled rupees is far more convincing in an interview than any coursework case study.

financeexcelgoogle-docspowerpoint

PRD · HLD · LLD includedView

BusinessEasy

Mutual Funds versus Fixed Deposits Comparative Study

In most Indian families the savings conversation ends in the same place it has for forty years: a fixed deposit at the bank where the salary lands. Mutual funds have grown enormously, yet the household argument still runs on two slogans - deposits are safe, funds are risky - and both survive because almost nobody puts them on one page and does the arithmetic. Once tax at your own slab and a few years of inflation are subtracted, a deposit paying 7 percent can quietly return almost nothing in real terms, while a fund that beat it over ten years can still have lost money over any three of them. The intern settles the question with evidence rather than opinion. Working in excel, they assemble ten years of month-end NAV history for nine funds across equity, debt and hybrid categories, plus dated deposit rates from five institutions including a small finance bank and a post office scheme, then compute compounded returns, SIP returns using XIRR, rolling three-year returns across more than eighty start points, volatility, worst twelve-month outcome and drawdown. Every comparison is then rebuilt after tax at three income slabs and after official inflation, which is where most published comparisons quietly stop. The findings become a study report organised around five decision lenses, a working decision calculator, and an eight-slide carousel designed in canva and published on linkedin so the argument reaches people who will never open a spreadsheet. This is the analysis that separates a commerce graduate who has memorised product definitions from one who can actually compare instruments. The intern comes away fluent in CAGR versus XIRR, rolling returns, real returns and the tax treatment that decides most of these arguments, plus the discipline of writing about money without slipping into advice - exactly what wealth management, research and financial content roles test for in the first interview.

financecanvaexcellinkedin

PRD · HLD · LLD includedView

BusinessEasy

Digital Assets and Crypto Awareness Report

Crypto reaches Indian college students long before any classroom does. It arrives as a YouTube pre-roll ad, a screenshot of somebody's 300 percent gain, a WhatsApp forward from a cousin, or an unsolicited add into a Telegram group promising daily calls and guaranteed doubling. What almost never arrives with it is the boring half of the story: that no digital asset is legal tender in India, that gains on transfer are taxed at a flat rate with no set-off of losses, that 1 percent is deducted at source on every transfer, and that the largest category of crypto loss among young Indians is not a bad market call but an outright fraud. Students end up putting exam fee money and festival cash into apps they found through a paid promotion, and the money that goes missing rarely comes back. The intern researches and writes a full awareness report on digital assets for an undergraduate audience, built deliberately as literacy rather than advice. They run an anonymous awareness survey through google-forms across two campuses to measure what students actually know, where they first heard about crypto and who has already lost money, then analyse the responses in excel alongside a transparency scorecard for six well-known assets and a worked tax worksheet that computes the real take-home on a ₹50,000 trade. The findings are written up in google-docs as a 14 to 18 page report with a one-page-per-case scam casebook covering eight documented fraud patterns, and packaged with a printable red-flag card designed in canva plus a self-scoring 10-question literacy quiz in google-forms that any classmate can take in three minutes. Completing the project builds a rare and interviewable combination of skills: reading primary regulatory and tax sources instead of summaries, designing a survey people answer honestly about money they lost, doing spreadsheet work that has to be arithmetically defensible, and communicating financial risk to people who did not ask to be warned. For B.Com, BA Economics, BBA and law-adjacent students, a report on digital asset risk that cites the Income-tax Act, RBI cautions and real enforcement actions is a portfolio piece that holds up in interviews for research, compliance, fintech content and investor-education roles.

financecanvaexcelgoogle-docs+1

PRD · HLD · LLD includedView