EasyBusinessfinance

Budget Analysis of a College Event

Added Jul 2026 3 design docs

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.

Related projects

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

BusinessMedium

Startup Financial Model and Break Even Analysis

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.

financeexcelnotionpowerpoint

PRD · HLD · LLD includedView

BusinessMedium

Pricing Strategy Analysis

Most small Indian service businesses set their price once, at launch, by copying the shop across the road, and then never revisit it. A self-study hall in Mukherjee Nagar charging one flat monthly rate is a clean example of the damage: the aspirant who arrives at six in the morning and leaves at eleven at night pays exactly what the student who drops in twice a week pays, and nobody can say whether the rate is too high, too low, or accidentally correct. Because a price change costs almost nothing to implement and flows straight to the bottom line, pricing is the highest-leverage decision such a business can reopen. The intern runs a full pricing analysis for Studyloft, a fictional 120-seat study hall near Mukherjee Nagar in Delhi that charges a flat ₹2,500 a month and barely clears its costs. They rebuild the cost structure and break-even occupancy in excel, benchmark 20 competing study halls on publicly listed rates and features, run a van Westendorp price sensitivity survey through google-forms with at least 80 exam aspirants, model a three-tier price architecture with contribution margins and a price-versus-occupancy sensitivity grid, and present the recommendation as a 16-to-20 page analysis in google-docs plus a 12-to-14 slide decision deck in powerpoint. The project builds cost accounting, willingness-to-pay research, price architecture design, sensitivity analysis, and the harder skill of naming a number and defending it under questioning. Pricing work is rare on a fresher's resume and immediately recognisable to interviewers in consulting, category management, and revenue roles, because it demands quantitative discipline and commercial judgement at the same time.

business-developmentexcelgoogle-docsgoogle-forms+1

PRD · HLD · LLD includedView