This project is no longer accepting applications. Subscribe to our newsletter to be notified of new projects!
Learn how to build in Excel an operational and capital expenditure budget for a tech startup.
Wise financial planning is crucial for the success of any business; it becomes especially important for startups that have ambitious growth goals and limited resources. In this Build Project, you'll wear the hat of a Financial Analyst and build a full-year budget that allows a fictional startup to understand its expenses and how much capital is needed to cover all business costs. You will create in Microsoft Excel a budget for employees’ salaries & benefits using dynamic formulas. Also, you’ll create a budget for professional service fees. Under the supervision of an experienced Build Fellow, you'll learn best practices in Financial Planning, specifics of operational and capital expenditure budgeting, and how to use Excel to create solid forecasting schedules. All this will happen in an environment that simulates the operations of a real Financial Planning & Analysis team.
Get to know the Build Fellow and other students, ask questions about the project requirements, prepare your workspace.
Organize your budget template in MS Excel creating and arranging the tabs that will comprise the budget file.
Create in Excel a budget for employees’ salaries & benefits.
Create in Excel a budget for professional service fees.
Design a Budget schedule for Overhead, Travel & Entertainment, and Venture Debt in MS Excel.
Develop a CapEx & Depreciation Budget in Excel.
Consolidate and review each budget schedule from your budget template in MS Excel.
Polish your project deliverables and present them to the Build Fellow and other students in the final group session.
Get access to all of our Build projects, including this one, by creating your Build account!
Get started by submitting your application.
We'll notify you when projects reopen. In the meantime, you can explore our resources and learn more about our Fellows.
Fernando Lemus is a Finance Build Fellow at Open Avenues, where he works with students leading projects in Finance.
Fernando Lemus is a Finance Manager at Insight M Inc. where he works directing and implementing financial planning & analysis process, improving internal controls and accounting processes, managing the company's equity platform and leading the yearly external audit accounting process.
Fernando has over 9 years of experience in finance related positions: 6 years in investment banking and 3 years in corporate financial planning & analysis roles.
He holds a degree in Business Administration with a Major in Finance from the University of Texas at Austin.
A fun fact about Fernando: he is currently training for his second Marathon.